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

Answer rating: 100% (QA)

Heres a stepbystep guide to creating the amortization table in Google Sheets 1 Open Google Sheets and create a new blank spreadsheet 2 In cell A1 ente... View the full answer