1.

The accompanying Homeownership spreadsheet contains a partially completed spreadsheet model for computing the monthly costs of home ownership. Complete the spreadsheet model by inserting the formulas for monthly mortgage payment (B12), monthly property tax (B13), monthly homeowner insurance premium (B14), monthly maintenance costs (B15), and total (B16) in the appropriate cells. Cick here for the Excel Data File a. Is this a deterministic or stochastic model? b. Which of the following is NOT an input of the spreadsheet moder? Interest rate Monthly mortoage payment Number of years of the loan Annual mointenance cost rate c. What is the monthly total of home ownership using the assumptions stated in the spegeadtheet? Note: Round your answer to 2 decimal places. d. How muchi does the menthy rotal of home ownership ncrease it ewe owner decides to -get a 15 - year moingoge instesd of a 30 -year mencege? Note: Aound your answer to 2 decimal plices