Compare the purchase versus lease of an automobile

Assignment Help Basic Computer Science

Reference no: EM133361537

Assignment:

Design and make 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 your 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?

· What do you recommend as the best financial alternative: lease or purchase? If you were to be in this situation right now, which would you pick and why? What other factors would you consider in your decision OTHER THAN cost?

Make an attractive chart to illustrate your financial findings. Be sure to pick an appropriate chart to format it attractively and according to principles learned in this course.

Reference no: EM133361537

Questions Cloud

Why are interested in working at choc childrens : SOS need help answering this question From an IT perspective, Please writee a short paragraph explaining why you are interested in working at CHOC Children's.

Role of scripting in system administration : We did not cover PowerShell in this course; you are tasked to use PowerShell as your scripting language. The role of scripting in system administration.

Identify a high complexity problem : Identify a high complexity problem and justify what makes the problem complex and how it is currently solved.

Research the internet for digital forensics training : Explain how they can help maintain proficiency as a Cyber Forensics Expert. Be sure to provide the link for other students to review and bookmark as a resource.

Compare the purchase versus lease of an automobile : Design and make workbook to compare the purchase versus lease of an automobile. The car you wish to purchase is $18,400.

What is the value of the index register instruction executes : The index register contains the value 1A24 and the following instruction is executed: 07 What is the value of the index register after the instruction executes?

Explain the epidemiology principles and community assessment : explain the epidemiology principles and community assessment including a reflective paragraph answering the following question, How would you apply these

Discuss how you as a health care provider team would raise : Discuss how you as a health care provider team would raise awareness and increase the use of SMBG by brainstorming and suggesting strategies that could be used

Identify the medical sleep problem you think the patient : Identify the medical sleep problem you think the patient is experiencing Identify a potential NANDA diagnosis that is appropriate for the patient

User Account

All Pages