Explore BrainMass

# Calculate the monthly payment for a car purchase

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

1. The area of a triangle is equal to ½ the length of the base times the height of the triangle. Use the capabilities of Excel so that when you input the lengths into O2 and P2, the Area will automatically be calculated in Q2. Work in the O, P and Q columns only.
2. Profit is a function of revenue and expenses. Work in columns S, T and U to set up a formula so that you can input revenues and expenses in S4 and T4 and automatically calculate the profit in U4.
3. Format the worksheet so that all entries are fully legible and then save your worksheet.

Part C.

See the Example in Figure 1.2 of the text. This spreadsheet model calculates the monthly payment for a car purchase. Build that model in columns W, X and Y of your worksheet. Note: you will need to use the payment function, PMT. Calculate the monthly payment for \$ 22,000 car with a \$3,500 down payment and a \$500 trade-in if the term of the loan is 5 years and the annual interest rate is 5%.

https://brainmass.com/math/optimization/calculate-monthly-payment-car-purchase-548747