BRIEF EXCEL HOMEWORK

profilebigbadwolf
loan.xlsx

Documentation

Mortgage Analysis
Author:
Date:
Purpose: To calculate the monthly payment and total cost of a mortgage under different conditions

Mortgage

Mortgage Analysis
Loan Amount $250,000
Interest Rate 5.50%
Years 30
Term (Months) 360
Monthly Payment ($1,419.47)
Total ($511,010.10)