please show how to enter into excel

go to 60 periods

3. Amortized Car Loan You want to buy a car for 30,000 and you plan to finance the car at 5.4% over 5 years (monthly payments). You can make a 4,000 down payment. a) What will be your monthly payment (end of month)? b) Set up an amortization schedule