Create an amortization table for a 25-year mortgage loan that has monthly payments. The values in the
Fantastic news! We've Found the answer you've been seeking!
Question:
Create an amortization table for a 25-year mortgage loan that has monthly payments. The values in the input range should be loan face value ($500,000), APR (4.5%), and monthly prepayment amount ($100). Make sure the spreadsheet is fully interactive, so the entire sheet correctly updates when a change in any input is made
Add a column to the right of the table developed in (a), to keep track of the month that the loan is paid off after taking prepayments into account. Also, just beneath the input range create a cell that automatically updates the payoff time
Related Book For
Essentials Of Corporate Finance
ISBN: 9780073382463
7th Edition
Authors: Stephen Ross, Randolph Westerfield, Bradford Jordan
Posted Date: