Please write an excel and take a screenshot please .

In order to get full credit, solutions must be clear and in detail. If you solve the questions using a financial calculator, you should show all the steps on the calculator such as PMT= 600, I=10, FV=0, PV=?. If you prefer to use Excel, you should show the functions. For manual calculations, you should show the formula with plugged numbers.

14) You borrow $35,000 to buy a car, and agree to make 72monthly payments of $490 to repay the loan. What annual rate of interest, which is being compounded monthly, are you being charged? 15) Currently, 30-year and 15- year mortgage loans can be taken with 3% and 2.5% annual interest rates, respectively. If you want to purchase a $300,000 value house with a 5% downpayment. What would be your monthly payments for each mortgage loans; 30-year and 15-year mortgages? 26