Tag Archives: Amortization Schedule

Calculate the property taxes for the first ten years assuming they are $2000 for year 1 and rise by 3% each year.

Mortgage Analysis Part I (10 points) Type your name in the title and fill in the terms for each scenario in sheet 1 and 2. Cells- A6:D6  (10 points)Calculate the monthly payment using the equation for both terms. Cell- E6  (10 points)Use the built in PMT function in Excel to verify the payment is correct. […]