aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%,
Fantastic news! We've Found the answer you've been seeking!
Question:
aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments.
A. Calculate the mortgage payment using the Excel function
Rate | Nper | PV | FV | Payment |
B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the lender
Year | Begin Ammount | Payment | Interest Paid | Principal PAid | Ending Balance |
1 | |||||
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | |||||
7 | |||||
8 | |||||
9 | |||||
10 |
Related Book For
Corporate Finance A Focused Approach
ISBN: 978-1305637108
6th edition
Authors: Michael C. Ehrhardt, Eugene F. Brigham
Posted Date: