Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please HELP, give answer in Excel Formula Enter a formula using the PMT function in cell B 4 . Be sure to use a negative

Please HELP, give answer in Excel Formula
Enter a formula using the PMT function in cell B4. Be sure to use a negative value for the
Pv argument.
In cell A6, type: Total payments
In cell B6, 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 A7, type: Interest paid
In cell B7, 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 A6:B7.
In cell A9, type: Average sales
In cell B9, enter a formula to calculate the average sales per month for the truck locations. Hint: Use cells B7:E7 from the MobileSales worksheet as the function argument.
Apply the Currency number format to cell B9. Display two digits after the decimal.
In cell A10, type: Buy new truck?
In cell B10, 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.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

3rd Edition

978-1119907466

More Books

Students also viewed these Databases questions

Question

6. Conduct a cost-benefit analysis for a training program.

Answered: 1 week ago