explain and provide formulas. 27 28 29 Q5 30 31 32 33 34 35 36 Q6 Q7

explain and provide formulas.

Transcribed Image Text:

27 28 29 Q5 30 31 32 33 34 35 36 Q6 Q7 37 38 39 Application Time! Jessica would like to purchase a home-she wants to avoid PM insurance. Don't worry about taxes and insurance for any of these questions, just keep in mind that those would need to be considered as well (!) you will need to pull the data from the "Info Sheet" and (2) solve for the missing information. Jessica makes the down payment and takes out the loan described. what will be the monthly payment? Price Down Pagment NPER RATE PY PMT FY 0 #N/A What was Jessica makes the down payment and takes out the loan described. what will be the total cost of the house? the total payments made over the life of the loan? What was the total cost for the loan? Application Time! Jessica would like to purchase a home-she wants to avoid PMll insurance. Don't worry about taxes and insurance for any of these questions, just keep in mind that those would need to be considered as well (!) you will need to pull the data from the "Info Sheet" and (2) solve for the missing information. What if Jessica can only make a smaller down payment, what would the first monthly payment be for the 30 year mortgage? Price Down Payment NPER RATE PY PMT FY PMI Monthly PMI First Monthly PMT 0 #N/A 27 28 29 Q5 30 31 32 33 34 35 36 Q6 Q7 37 38 39 Application Time! Jessica would like to purchase a home-she wants to avoid PM insurance. Don't worry about taxes and insurance for any of these questions, just keep in mind that those would need to be considered as well (!) you will need to pull the data from the "Info Sheet" and (2) solve for the missing information. Jessica makes the down payment and takes out the loan described. what will be the monthly payment? Price Down Pagment NPER RATE PY PMT FY 0 #N/A What was Jessica makes the down payment and takes out the loan described. what will be the total cost of the house? the total payments made over the life of the loan? What was the total cost for the loan? Application Time! Jessica would like to purchase a home-she wants to avoid PMll insurance. Don't worry about taxes and insurance for any of these questions, just keep in mind that those would need to be considered as well (!) you will need to pull the data from the "Info Sheet" and (2) solve for the missing information. What if Jessica can only make a smaller down payment, what would the first monthly payment be for the 30 year mortgage? Price Down Payment NPER RATE PY PMT FY PMI Monthly PMI First Monthly PMT 0 #N/A