Please also show me the formula you input into the cell, not just the answer

Top't Corn Sales (August) Truck Location Old Bay Truffle Sea Salt and Caramel Total Farragut Square George Washington Georgetown K Street 900 $ 8oo 1,150 525 1,005 S 2,100 1,800 1,225 2,010 3,225 3,030 s5,260 2,500 2,760 3,800 9,o60 s Price Interest (annual) Loan term (in months) 6% 18 () Monthly payment )Total payments (3) Interest paid (4) Average Sales 5) Buy new truck? TAB INSTRUCTIONS: Top't Corn i s considering a new truck purchase 1) Enter a formula using the PMT function to calculate the monthly loan payments. (Be sure to use a negative value for the PV argument.) 2) Enter a formula to calculate the total paid over the life of theloan. Use cell references. 3) Enter a formula to calculate the total interest paid over the life of the loan. Use cell references. 4) Using data from the TruckSales tab, enter a formula to calculate the average sales per month for the truck locations. 5) Enter a formula using the IF function to display Buy It! ifthe monthly payment for the truck loan is less than the average sales per month for the current trucks. Display Pass if it is not