What would be the total cost to own the vehicle

Assignment Help Accounting Basics

Reference no: EM132753540

Question: Design and create workbook to compare the purchase versus lease of an automobile. The car you wish to purchase is $18,400. Your monthly net income (after taxes) is $3,024. You need to decide whether to lease the car over three years or buy the car with the aid of a bank loan for $18,400. Design and create solution using Excel. Format your workbook attractively and appropriately based on the principles learned in this course. You may need to use the function wizard to explore functions. Be sure your calculations support your conclusions.

The following information is provided:

- If you were to lease the vehicle with zero down, the lease payment would be $355 per month. At the end of the three years, there is an option to buy the vehicle for $12,000. What would be the total cost to own the vehicle at the end of three years?

- If you were to purchase the vehicle with the aid of a bank loan with zero down for three years (interest rate is 7%), what would your monthly payment be? What would be the total cost to own the vehicle at the end of three years?

- How much would you pay, over and above the price of the vehicle, for each option?

Reference no: EM132753540

Questions Cloud

How did the government or the people respond : What was the context in which this person proposed ideas/change - make sure to go beyond the surface information and go into depth about the person

What the contract price for lkld realty : What the contract price is? LKLD Realty recognized gross profit of P42,000 on its long term project which has accumulated costs of P490,000.

How do i calculate the present value of free cash flow : How do I calculate the Present Value of Free Cash Flow? What is the calculation for Present Value of Free Cash Flow? The response must be typed.

What the percentage of completion is : What the percentage of completion is? LKLD Realty recognized gross profit of P42,000 on its long-term project which has accumulated costs of P490,000.

What would be the total cost to own the vehicle : If you were to lease the vehicle with zero down, the lease payment would be $355 per month. At the end of the three years, there is an option to buy the vehicle

Find what the total realized gross profit in year was : What the total realized gross profit in year 2021 was? On January 2, 2020, Peter Realty enters into a contract with a customer for the construction of building.

What the total realized gross profit in year was : What the total realized gross profit in year 2020 was? On January 2, 2020, Peter Realty enters into a contract with a customer for the construction of building.

Calculating a job with overhead applied : Calculating a job with overhead applied? If a steel fabricator has taken a job numbered 100, that consists of producing 500 steel supports for another company.

Find what the percentage of completion for the year was : What the Percentage of Completion for the year 2021 was? On January 2, 2020, Peter Realty enters into a contract with a customer for construction of building.

User Account

All Pages