PLEASE EXPLAIN IN A CONCISE MANNER. Q2 (20 points, Excel – What-If-Analysis) A real estate agent has a client who is purchasing a house for $450,000. They want to give the client options on how changes in interest rate and down payment affect monthly cost. The purchaser wants a 30-year loan (360 payments). If they cannot afford 20% down, they have to pay $100 per month for mortgage insurance. Attach a What-If contingency table that looks at two variables (down payment = 20% down or 0% down) and (interest rate (APR) = 2%, 2.5%, 3.0%, 3.5%. and 4.0%). Hint: Monthly payment, =PMT(rate adjusted for month, payment periods, - loan amount). Remember to use a minus on the loan amount so you show a positive payment.
NO ANSWERS THAT START WITH (ANSWER: A home loan is a drawn out credit intended to assist you with purchasing a house. As well as reimbursing the head, you likewise need to make interest installments to the loan specialist. The home and land around it act as insurance)!!!!!!!!