Question

13. Creating an amortization schedule Aa Aa Ian loaned his friend $45,000 to start a new business. He considers this loan to be an investment, and therefore requires his friend to pay him an interest rate of 9% on the loan. He also expects his friend to pay back the loan over the next four years by making annual payments at the end of each year. Ian texted and asked that you help him calculate the annual payments that he should expect to receive so that he can recover his initial investment and earn the agreed-upon 990 on his investment. Calculate the annual payment and complete the following capital recovery schedule: Beginning Amount $45,000.00 Interest Paid Principal Paid Year Payment Ending Balance 1 4 $0.00

Answer 1

Loan+I(1-(1/(1+rAn))/r $13,890.09 45,000[1-(1/(1.09 4))/0.09] Annual payment End of period 1 2 Beginning balance $45,000.00 $35,159.91 $24,434.2:1 $12,743.20 Interest paid $4,050.00 $3,164.39 $2,199.08 $1,146.89 principal paid $9,840.09 $10,725.70$24,434.21 $11,691.01 $12,743.20 $12,743.20 Ending balance Payment $13,890.09 $13,890.09 $13,890.09 $13,890.09 $35,159.91 4 $0.00