Page 3 What would be we estimated Down payment Use your estimated actual selling price Mortgage Calculation Subtracting the downpayment from your estimated sales price for 4101 Moraga Street, San Francisco CA will give you the overall mortgage amount What is the overall mortgage loan amount? (PV) Assume the following Annual Interest Rate (fixed) 496 Monthly Payments # of years 30 FV (paying off the mortgage) 0 What is your monthly mortgage payment? Use the PMT function (remember to convert the annual interest rate to monthly and to find the # of months to get the NPER) Please write the 30-year (360 month) mortgage amortization schedule below. At a minimum show the principal remaining, interest expense, cash payment and principal reduction every month. Total Cost of Ownership Page 3 What would be we estimated Down payment Use your estimated actual selling price Mortgage Calculation Subtracting the downpayment from your estimated sales price for 4101 Moraga Street, San Francisco CA will give you the overall mortgage amount What is the overall mortgage loan amount? (PV) Assume the following Annual Interest Rate (fixed) 496 Monthly Payments # of years 30 FV (paying off the mortgage) 0 What is your monthly mortgage payment? Use the PMT function (remember to convert the annual interest rate to monthly and to find the # of months to get the NPER) Please write the 30-year (360 month) mortgage amortization schedule below. At a minimum show the principal remaining, interest expense, cash payment and principal reduction every month. Total Cost of Ownership