Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve in Excel showing all the formulas A loan of 50,000 is taken out at 11% per year effective. Repay- ment is by the

please solve in Excel showing all the formulas image text in transcribed
A loan of 50,000 is taken out at 11% per year effective. Repay- ment is by the amortization method, with equal payments at the end of each year for the next 20 years. Immediately after the 10th payment, the borrower renegotiates with the lender, and they agree that the remainder of the loan will be repaid by the sinking fund method, where the interest rate on the loan increases to 12% per year and the sinking fund earns interest at 14% per year. Interest payments and sinking fund deposits will still be annual and continue for 10 more years. Find the sinking fund deposit, and compare the borrower's new total payment with his old one

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance And Public Policy

Authors: Jonathan Gruber

7th Edition

1319281109, 9781319281106

More Books

Students also viewed these Finance questions