# L1V2 - Mortgage Calculator

.xlsx
Mortgage Payment Calculator Objective: To calculate the mortgage payments given the Loan Amount, number of years, paym To construct an amortization table that automatically changes in size as we change To change the Loan Amount and Interest Rate use the spinner buttons Create two charts: The first showing the payment, interest and principal componen Introduce Data Validaton and Conditional Formatting Name: Mike Inglis Date: 10/26/2023
ment frequency and the interest rate compounded semi-annually. the number of years and payment frequency nts of the payment over the 300 months.
Mortgage Payment Calculator Inputs Loan Amount \$ 500,000 Rate 4.0% per/year (semi-annually) Years 25 Payments per Year 12 Calculations Total Number of Payments 300 Effective Period Rate 0.331% Payment \$2,630.10 Total Interest Paid \$ 289,030 \$ 289,030 Total principal paid 500000 \$ 500,000 Total paid \$ 789,030 \$ 789,030 Amortization Table Period Payment Interest Component 0 1 \$ 2,630 \$ 1,653 2 \$ 2,630 \$ 1,650 3 \$ 2,630 \$ 1,646 4 \$ 2,630 \$ 1,643 5 \$ 2,630 \$ 1,640 6 \$ 2,630 \$ 1,637 7 \$ 2,630 \$ 1,633 8 \$ 2,630 \$ 1,630 9 \$ 2,630 \$ 1,627 10 \$ 2,630 \$ 1,623 11 \$ 2,630 \$ 1,620 12 \$ 2,630 \$ 1,617 13 \$ 2,630 \$ 1,613 14 \$ 2,630 \$ 1,610 15 \$ 2,630 \$ 1,607 16 \$ 2,630 \$ 1,603 17 \$ 2,630 \$ 1,600 18 \$ 2,630 \$ 1,597