Please HELP, give answer in Excel Formula

Enter a formula using the PMT function in cell B$4.$ Be sure to use a negative value for the

Pv argument.

In cell A$6,$ type: Total payments

In cell B$6,$ enter a formula to calculate the total paid over the life of the loan $($the monthly payment amount $*$ the number of payments$).$ Use cell references.

In cell A$7,$ type: Interest paid

In cell B$7,$ enter a formula to calculate the total interest paid over the life of the loan $($the total payments $-$ the original price of the truck$).$ Use cell references.

Apply borders using the Thick Outside Borders option around cells A$6$:B$7.$

In cell A$9,$ type: Average sales

In cell B$9,$ enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B$7$:E$7$ from the MobileSales worksheet as the function argument.

Apply the Currency number format to cell B$9.$ Display two digits after the decimal.

In cell A$10,$ type: Buy new truck?

In cell B$10,$ enter a formula using the IF function to display Yes if the monthly payment for the truck loan is less than the average sales per month for the current trucks. Display

No if it is not.