Basic Mortgage Calculations Directions: Fill in the yellow using Excel so that your spreadsheet remains intact when data are changed Assumptions Balloon Payment EOY 6 $ Loan Amt (PV) Interest Rate (0) Term (n) Payments per Year Discount Points Payoff at EOY 800,000.00 6% 25 12 3.50% 6 Effective Borrowing Cost (APR) assuming discount points & loan held to maturity Effective Borrowing Cost assuming discount points & early payoff Periodic Payment interest principal Monthly Loan Amortization Schedule period payment 0 1 2 3 balance 800,000.00 $ 4 5 6 Annual Loan Amortization Schedule Year ADS 0 interest principal balance PMTS Remaining 2 3 4 5