Business, 23.11.2019 00:31 CheerA170

Part i. design and make a workbook in excel to compare the purchase versus lease of an automobile. the car the company wishes to purchase is $18,400. 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 make your solution using excel. format your workbook attractively and appropriately based on professional design principles learned in this course. you must use proper functions and formulas for all calculations. name the worksheet vehicle purchase analysis. be sure your calculations support your conclusions. save your file as exam iii item 1.
the following information is provided:
a. if the company was 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?
b. if the company was to purchase the vehicle with the aid of a bank loan with zero down for three years (interest rate is 7%), what would the monthly payment be? what would be the total cost to own the vehicle at the end of three years?
c. how much would the company pay, over and above the price of the vehicle, for each option?
d. what do you recommend as the best financial alternative: purchase or lease? which option would you recommend the company choose and why? what other factors should be considered in the decision other than cost?
make an attractive chart to illustrate your financial findings. be sure to use appropriate labels. which chart type did you choose and why?

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 18:30

You should typically prepare at least questions for the people who will host you during a job shadow. a. 3 b. 4 c. 5 d. 2

Answers: 1

Answer

Business, 22.06.2019 19:00

Which of the following is likely not a benefit of requiring a grand jury to listen to and examine all of the evidence against a person suspected of committing a serious crime and then independently deciding whether or not to hand down an indictment? 1.the grand jury system provides the accused another safeguard against being sent to trial and facing conviction based on flawed evidence. 2.the members of the grand jury are drawn from the community and are empowered to render independent decisions about whether or not the government has collected enough evidence to bring an individual to trial. 3.the grand jury’s decision can provide prosecutors insight into what is necessary to build a sufficient case if a similar crime is presented later. 4.the grand jury is impaneled to rubber-stamp prosecutors’ cases, which makes it possible for more cases to reach trial.

Answers: 2

Answer

Business, 23.06.2019 01:30

Bmw receives data transmitted by each new vehicle it sells to employees understand how customers use the products and when service may be needed. this use of technology aids in bmw's efforts to interact in an ongoing basis with its customers.

Answers: 1

Answer

Business, 23.06.2019 04:00

How do i make quick money as a 13 year.old with no alouence.

Answers: 1

Answer

You know the right answer?

Part i. design and make a workbook in excel to compare the purchase versus lease of an automobile....

Questions