I only need help with two questions on Smart Loans and Bullet loans as I have completed the 1st section. Can you help with the yellow sections and please provide formulas used? Answers were given by teacher and need the answers to match up.

Questions I need help with (please use chart below):

1. How long would it take the Company to pay off the smart loan using the 30-year mortgage payments? How much interest would the Company save over the traditional 30 yr mortgage?

Answer given: 24.73 years / interest saved: $7,811,121

2) What is the amount of the balloon payment due on the bullet loan at the end of 5 years? How much interest will the Company save over the 30 yr loan?

Answer given: $32,445,919.51 and 28,496,125

Full question:

Sessions Manufacturing Company needs to expand their existing facility and needs to secure $35 million in financing to fund the expansion. Ben Bates, the CFO of Sessions Manufacturing Company, has decided that debt financing is the best option at this time and is meeting with a loan officer of First Trust Capital to discuss loan options.

The first option is a traditional loan with a 30-year term. The loan would be repaid in monthly installments, with no closing costs and an APR of 5.7%. The bank also offers a 20-year mortgage with the same APR.

The second loan option is a "smart loan." The loan is structured as follows: every two weeks a payment is due that is exactly half of the monthly payment due on a 30-year traditional mortgage. The APR of the smart loan is the same as the traditional mortgage listed above.

Another option is a bullet loan, or a balloon payment. The monthly payments of the bullet loan are calculated using a 30-year traditional mortgage. For 5 years, the company would make payments for a 30-year mortgage, but immediately after the 60^thpayment, the remaining balance would be due (a balloon payment). The remaining balance of the loan can be calculated two ways - by constructing an amortization table or by calculating the present value of the remaining 25 years of monthly payments.

Lastly, the Company has an option of an interest only loan. The bank would offer an interest-only loan with term of 10 years and APR of 3.8%. Each month, the Company would make interest payments on the balance of the loan and at the end of 10 years, the Company would repay the $35 million loan in total.

Traditional Mortgage: Smart Loan Bullet Loan 30 yr option 20 yr option PV 35,000,000 35,000,000 PMT PMT Rate 0.48% 0.48% Rate Rate Nper 360 240 m m m 12 12 PV Nper PMT $203,140.15 $244,731.24 Nper PV Number of years: ^^calculate balloon payment as PV of loan if 25 years remain 30 yr option 20 yr option Total cash payments (pmt x number) $73,130,453.87 $58,735,496.77 Total principal $35,000,000.00 $35,000,000.00 Interest paid $38,130,453.87 $23,735,496.77 Total cash payments (pmt x number) Total cash payments (pmt x number) Total principal Principal paid in 5 years Interest paid Interest paid Amortization Schedule: Month Beg Bal PMT Interest Principle End Bal Interest saved Interest saved 1 35,000,000.00 203,140.15 166,250.00 36,890.15 34,963,109.85 34,963,109.85 203,140.15 166,074.77 37,065.38 34,926,044.47 W N 34,926,044.47 203,140.15 165,898.71 37,241.44 34,888,803.03 34,888,803.03 203,140.15 165,721.81 37,418.34 34,851,384.70 34,851,384.70 203,140.15 165,544.08 37,596.07 34,813,788.62 6 34,813,788.62 203,140.15 165,365.50 37,774.65 34,776,013.97