Help with Microsoft Excel 2013 Assignment!!!

profilecamlle2
e04g_warehouse_loan.xlsx
Home>Computer Science homework help>Help with Microsoft Excel 2013 Assignment!!!

Warehouse Purchase

Warehouse Purchase in Maine
Amount of Loan $975,000
Period (years) 10
Interest rate (per year) 5.25%
Payment (per month) $10,460.94
Option #1 Reduce the Loan
Amount of Loan $728,802
Period (years) 10
Interest rate (per year) 5.50%
Payment (per month) $8,000.00
Option #2 Increase the Years
Amount of Loan $975,000
Period (years) 15
Interest rate (per year) 5.50%
Payment (per month) $8,000.00

Warehouse Payment Table

Loan Options for Warehouse Purchase: Rates versus Month
Amount of Loan $975,000
Period (months) 120
Interest rate (per year) 5.25%
Payment Options
Number of Monthly Payments
60 120 180 240 300 360
Rates