Must use the best option of the functions: PMT; FV; NPER; PV; & or RATE!

Design and create a worksheet to aid you in the following decision regarding a home purchase. Format your workbook attractively and appropriately. Assumptions: 1. Mortgage payment maximum of 25% of net income 2. Mortgage rates: - 6.5% with a minimum 10% down OR - 6.25% with a minimum 15% down 3. You don't want to use all of your savings on your down payment HINT: Don't forget to deduct your down payment from the amount you're financing! Create a worksheet to analyze this information and that provides answers to the following questions: 1. What would your monthly payment be for a 20,25 , and 30 year loan? Show analysis for both rates mentioned above. 2. Would you be able to afford a 20 or 25 year loan? Why or why not? What are your options? 3. What is the total cost of the home for each scenario (payments including interest)? 4. What is the difference in the costs of the financing options for each of the scenarios? 5. What factors would contribute to taking a 20,25 or 30 year loan? 6. Which would you choose? Why? What are some additional options you see to making the best situation 'work'? List at least two