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.

12) JCT Auto Financial loans you $24,000 for four years to buy a car. The loan must be repaid in 48 equal monthly payments. The annual interest rate on the loan is 9 percent. What is the monthly payment? 13) If you wish to accumulate $250,000 in the child's college fund after 18 years, and can invest at a 9% annual rate, how much must you invest at the end of each year if the first deposit is made at the end of the first year