Please help solve this scenario, thank you

l I Now. think about a significant purchase that you have made in your life. Did you use data to help make an informed decision? In this discussion' you'll use a spreadsheet to calculate data associated with financing the purchase of a car or a house. To get started, decide whether you want to buy a car or a house and then identify the item's cost and the expected interest rate. Use reliable sources to estimate the actual price in the area you expect to buy. Calculate the Data Download the _S_i_rn_ple Loan Calculator and Amortization Table (XLSX); In cell E3, add the expected cost of your car or house. In cell E4, enter the annual interest rate. Review the updated results in cells (ES-E11). Calculate the following for your selected scenario. Car Scenario 0 6year loan 0 3-year loan House Scenario 0 30-year loan 0 15year loan Interpret, Post & Reply Interpret the data and include the following in your initial post. 0 identify your scenario - either car or house. Analyze the interest amount you will pay for each loan term. How much interest will you pay? How much money and time will you save if you go with a shorter loan term? Discuss whether you would be inclined to increase your monthly payment to shorten the ioan's length and save money by not paying interest? Why or why not? 0 Explain how the data influenced your decision