Purchase Solution

Calculate the monthly payment for a car purchase

Not what you're looking for?

Ask Custom Question

Answer the following questions and add the answers to the attached excel workbook please do not delete the contents that are already imputed

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%.

Attachments
Purchase this Solution
Solution Summary

The solution gived detailed steps on calculating the monthly payment for a car purchase using the excel. All formula and calculations are shown and explained.

Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Probability Quiz

Some questions on probability

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

View More Free Quizzes
Related BrainMass Solutions

  • Car Buying Comparison

    The solution computes monthly payment for buying a new or a used car in different scenarios along with amortization schedule. Attached in Excel.

  • Financing Options

    5341 Analysis of financing options in purchasing a car You are considering the purchase of a new car. The choices are: A. Pay $27,500 cash, or B. Pay $650 a month for 4 years, with an up-front service fee of $500, or C.

  • Tim Smith

    202039 Tim Smith used car purchase: calculate payment amount Monthly loan payments Tim Smith is shopping for a used car. He has found one priced at $4,500.

  • Calculate the annual lease payments

    71499 Calculate the annual lease payments A corporation has contracted to provide lease financing for a machine to automate an assembly line. Annual lease payments will start at the beginning of each year.

  • Calculate the annual lease payments

    It is expressed as a multiplier that can be used to calculate your monthly payments. For example, 7.2 percent interest, when expressed as a money factor, is .0033. To convert a money factor to an interest rate, multiply by 2,400.

  • Amortization - Early Payoff: Robert - What will the remaining balance be on the loan after he makes the 36th payment?

    121217 Amortization - Early Payoff Robert recently borrowed $20,000 to purchase a new car. The car loan is fully amortized over 4 years.

  • Calculating the periodic amounts

    Purchase of a flat-screen TV for $2,410.monthly payments are to be made for one year with interest at 24% per annum, compounded monthly. b.

  • Time value of money

    To finance the purchase of a warehouse, you have arranged for a 30-year mortgage loan for 80% of $2,500,000 purchase price. The monthly payment on the loan will be $13,400. What is the APR on this loan? The EAR? 7.

  • Computing Monthly Lease Payment

    594067 Computing Monthly Lease Payment You are thinking about leasing a car. The purchase price of the car is $33000. The residual value (the amount you could pay to keep the car at the end of the lease) is $15000 at the end of 36 months.

View More Related Solutions