Question

In: Accounting

Michele Diaz is the founder of Diaz Manufacturing.  Michele plans to expand her business. Company’s expansion plans...

Michele Diaz is the founder of Diaz Manufacturing.  Michele plans to expand her business. Company’s expansion plans require a significant investment, which she plans to finance with a combination of additional funds from outsiders plus some money borrowed from banks. Company’s financial records are not well maintained. Naturally, the new investors and creditors require organized and detailed financial statements than Michele has previously prepared.  Ms. Diaz has assembled the following information:     

($ millions)

Michele Diaz is ready to meet with Austin Mark, the loan officer for Wells Fargo. She is asking to borrow $30 million.The meeting is to discuss the mortgage options available to the company to finance the new facility.

Austin begins the meeting by discussing a 30-year mortgage. The loan would be repaid in equal monthly installments. Because of the previous relationship between Diaz Manufacturing and the bank, there would be no closing costs for the loan. Austin states that the APR of the loan would be 6.00 percent. Ms. Diaz asks if a shorter mortgage loan is available. Austin says that the bank does have a 20-year mortgage available at the same APR.

Michele decides to ask Austin about a “smart loan” she discussed with a mortgage broker when she was refinancing her home loan. A smart loan works as follows: every two week a mortgage payment is made that is exactly one-half of the traditional monthly mortgage payment. (Hint: To determine how much is bi-weekly payment >>>calculate PMT as if it is 30-year mortgage and then divide by 2). The APR of the smart loan would be the same as the APR of the traditional loan.  

Austin also suggests a bullet loan, or balloon payment, which would result in the greatest interest savings. At Michele’s prompting, he goes on to explain a bullet loan. The monthly payments of a bullet loan would be calculated using a 30-year traditional mortgage. In this case, there would be a 5-year bullet. This would mean that the company would make the mortgage payments for the traditional 30-year mortgage for the first five years, but immediately after the company makes the 60th payment, the bullet payment would be due. The bullet payment is remaining principal of the loan. Ms. Diaz then asks how the bullet payment is calculated. Austin tells her that the remaining principal can be calculated using an amortization table, but it is also the present value of the remaining 25 years of mortgage payments for the 30-year mortgage.

Michele has also heard of an interest-only loan and asks if this loan is available and what the terms would be. Austin says that the bank offers an interest-only loan with a term of 10 years and an APR of 3.9 percent. He goes on to further explain the terms. The company would be responsible for making interest payments each month on the amount borrowed. No principal payments are required. At the end of the 10-year term, the company would repay the $30 million. However, the company can make principal payments at any time. The principal payments would work just like those on a traditional mortgage. Principal payments would reduce the principal of the loan and reduce the interest due on the next payment.

Tony is still unsure of which loan she should choose. She has asked you to answer the following questions to help her choose the correct mortgage.

  1. What are the monthly payments for a 30-year traditional mortgage?
  1. What are the payments for a 20-year tradition mortgage?

  1. Prepare an amortization table for the first six months of the traditional 30-year loan. How much of the second payment is interest?

  1. Assume Diaz Manufacturing takes out a bullet loan under the terms described. What are the payments on the loan?  What is the amount of the last payment of the loan?

  1. What are the payments for the interest-only loan?  

  1. Which mortgage is the best for the company? Are there any potential risks in this action?

Solutions

Expert Solution

solution:

thanks


Related Solutions

Michele Diaz is the founder of Diaz Manufacturing. Michele plans to expand her business. Company’s expansion...
Michele Diaz is the founder of Diaz Manufacturing. Michele plans to expand her business. Company’s expansion plans require a significant investment, which she plans to finance with a combination of additional funds from outsiders plus some money borrowed from banks. Company’s financial records are not well maintained. Naturally, the new investors and creditors require organized and detailed financial statements than Michele has previously prepared. Ms. Diaz has assembled the following information:      ($ millions) Michele Diaz is ready to meet...
Santana Rey created Business Solutions on October 1, 2017. The company has been successful, and Santana plans to expand her business.
Santana Rey created Business Solutions on October 1, 2017. The company has been successful, and Santana plans to expand her business. She believes that an additional $86,000 is needed and is investigating three funding sources.  ⦁ Santana’s sister Cicely is willing to invest $86,000 in the business as a common shareholder. Since Santana currently has about $129,000 invested in the business, Cicely’s investment will mean that Santana will maintain about 60% ownership and Cicely will have 40% ownership of Business...
Zimmer, a manufacturer of modular rooms, plans to expand its operations in Landshut, Germany. The expansion...
Zimmer, a manufacturer of modular rooms, plans to expand its operations in Landshut, Germany. The expansion will cost $14.5 million and is expected to generate annual net cash flows of €2.15 million for a period of 12 years and then the operation will be sold for €1 million (net of taxes). The cost of capital for the project is 14%. Using a spot exchange rate of $1.25/€ as the forecast FX rate for the euro for the term of the...
Division D is considering two possible expansion plans. Plan A would expand a current product line...
Division D is considering two possible expansion plans. Plan A would expand a current product line at a cost of $8,440,000. Expected annual net cash inflows are $1,500,000​, with zero residual value at the end of 10 years. Under Plan​ B, Division D would begin producing a new product at a cost of $8,300,000. This plan is expected to generate net cash inflows of $1,080,000 per year for 10 ​years, the estimated useful life of the product line. Estimated residual...
Ingrid is planning to expand her business by taking on a newlroduct that costs $5.91....
Ingrid is planning to expand her business by taking on a new lroduct that costs $5.91. In order to market this new product, $1354.00 must be spent on advertising. The suggested retail price for the product is $12.65. Answer each of the following questions.   a) If a price is $14.18 is chosen, the number of units she needs to sell to break even is? Round up to the nearest whole number   b) If advertising is increased to $1518.00...
GroundPink Inc. needs $2.7 million to expand its business. To accomplish this, the firm plans to...
GroundPink Inc. needs $2.7 million to expand its business. To accomplish this, the firm plans to sell 20-year, $1,000 face value zero coupon bonds. The bonds will be priced to yield 6.25 percent with interest compounded semiannually. What is the minimum number of bonds the company must sell? Ignore all cost issues.
M/s. Zigzag LLC plans to expand its business in Oman and thinks that the Capital of...
M/s. Zigzag LLC plans to expand its business in Oman and thinks that the Capital of the Partners A, B and C OMR 96,000; OMR 57,600 and OMR 48,000 respectively on 1.1.2019 are not enough for further development. Also the firm wishes to increase the profit of the Partners for the following financial years. For finding their current profit and losses and capital balances, the firm gives the some information which is available in their Partnership Deed. The clauses of...
Lina, a Malaysian citizen, is planning to expand her business of exporting Tupperware into Japan. Kenji,...
Lina, a Malaysian citizen, is planning to expand her business of exporting Tupperware into Japan. Kenji, a Japanese citizen, is very interested to be the distributor for Lina’s good. After nearly one week of negotiation, both of them had agreed for the goods to be delivered through maritime mode of transportation. However, Lina is worried about the payment method and the cost incurred by her if the goods were damaged while in transit. (a) discuss whether the use of bill...
You’re trying to determine whether to expand your business by building a new manufacturing plant. The...
You’re trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $12.6 million, which will be depreciated straight-line to zero over its four-year life. If the plant has projected net income of $1,914,300, $1,967,600, $1,936,000, and $1,389,500 over these four years, respectively, what is the project’s average accounting return (AAR)?
Diana's editorial business was not growing and she sought ways to expand her client list. She...
Diana's editorial business was not growing and she sought ways to expand her client list. She recognized that technology provided opportunities to bring on new customers, so she instituted a training program for her employees. Which factor of production is described here? labor capital knowledge economics #2Juan has many business ideas that could satisfy the unfulfilled needs of people who live in his community. However, there are laws that govern the type of businesses that private citizens can own and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT