Download the Simple Loan Calculator and Amortization Table (XXLX). 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 (E8-E11). Calculate the following for your selected scenario. Car Scenario - 6-year loan - 3-year loan House Scenario - 30-year loan - 15-year loan Interpret, Post \& Reply Interpret the data and include the following in your initial post. - 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 loan's length and save money by not paying interest? Why or why not? - Explain how the data influenced your decision. Simple Loan Calculator \begin{tabular}{r|rrrrrrrrrrrrrr} 1 & 69 & 5/12/28 & $ & 2,261.33 & $ & 571.83 & $ & 561.46 & $ & 10.36 & $ & 1,699.87 \\ 2 & 70 & 6/12/28 & $ & 1,699.87 & $ & 571.83 & $ & 564.03 & $ & 7.79 & $ & 1,135.84 \\ 3 & 71 & 7/12/28 & $ & 1,135.84 & $ & 571.83 & $ & 566.62 & $ & 5.21 & $ & 569.22 \\ 4 & 72 & 8/12/28 & $ & 569.22 & $ & 571.83 & $ & 569.22 & $ & 2.61 & $ & (0.00) \end{tabular} Download the Simple Loan Calculator and Amortization Table (XXLX). 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 (E8-E11). Calculate the following for your selected scenario. Car Scenario - 6-year loan - 3-year loan House Scenario - 30-year loan - 15-year loan Interpret, Post \& Reply Interpret the data and include the following in your initial post. - 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 loan's length and save money by not paying interest? Why or why not? - Explain how the data influenced your decision. Simple Loan Calculator \begin{tabular}{r|rrrrrrrrrrrrrr} 1 & 69 & 5/12/28 & $ & 2,261.33 & $ & 571.83 & $ & 561.46 & $ & 10.36 & $ & 1,699.87 \\ 2 & 70 & 6/12/28 & $ & 1,699.87 & $ & 571.83 & $ & 564.03 & $ & 7.79 & $ & 1,135.84 \\ 3 & 71 & 7/12/28 & $ & 1,135.84 & $ & 571.83 & $ & 566.62 & $ & 5.21 & $ & 569.22 \\ 4 & 72 & 8/12/28 & $ & 569.22 & $ & 571.83 & $ & 569.22 & $ & 2.61 & $ & (0.00) \end{tabular}