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.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How do feel the accounting standards can be modified

Do you believe these statements are true, or do you think that they are too cynical and how do feel the accounting standards can be modified for our modern needs?

  Understanding of the fraud triangle and fraud examination

Make sure your answer demonstrates your understanding of the fraud triangle and fraud examination."

  Define the concept of materiality

Define the concept of materiality. Identify the two levels of materiality that are important in audit planning and indicate the reasons for each level

  Calculate transoceans effective tax rate

Calculate Transocean's effective tax rate for each of the four years (1998, 2000, 2009. 2015). Estimate the dollar amount of the annual reduction in taxes

  Calculate Taxus Corporation tax liability

During the current tax year, Taxus Corporation has ordinary income of $110,000, a long-term capital loss of $20,000, Calculate Taxus Corporation tax liability

  Compute the correct cash balance

A bank reconciliation revealed cash per the bank statement of $1,484, cash per company records of $1,681, The correct cash balance is

  Describe the auditors responsibility

Explain some of precautions below which CPAs can take to minimize the risk of litigation. Describe the auditor's responsibility to report detected illegal acts

  Provide the journal entries required for dec

Provide the journal entries required for Dec 15, 2019, and any entries required in 2020. Label the date of each entry, and be sure to clearly identify

  How do reconcile this statement to the subsidiary ledger

Bevan Wholesalers Statement showed they received $6000 (not $3000) How do reconcile this Statement to the Subsidiary Ledger

  How developments in information technology have changed

Explain how developments in information technology have changed the nature of the workplace and the practice of management?

  Indicate the reporting of the 2012 pension amounts in the

complete the following exercise. submit journal entries in an excel file and written segments in an ms word document.

  What entry should hankco make on june to record the deposit

On June 28, Hankco had $3,300 in Omni Card credit sales. What entry should Hankco make on June 28 to record the deposit

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd