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 10:30

You meet that special person and get married. amazingly your spouse has exactly the same income you do 47,810. if your tax status is now married filing jointly what is your tax liability

Answers: 2

Answer

Business, 22.06.2019 11:40

If kroger had whole foods’ number of days’ sales in inventory, how much additional cash flow would have been generated from the smaller inventory relative to its actual average inventory position? round interim calculations to one decimal place and your final answer to the nearest million.

Answers: 2

Answer

Business, 22.06.2019 14:00

Wallace company provides the following data for next year: month budgeted sales january $120,000 february 108,000 march 140,000 april 147,000 the gross profit rate is 35% of sales. inventory at the end of december is $29,600 and target ending inventory levels are 10% of next month's sales, stated at cost. what is the amount of purchases budgeted for january?

Answers: 1

Answer

Business, 22.06.2019 20:40

Which one of the following statements is correct? process costing systems use periodic inventory systems. process costing systems assign costs to departments or processes for a time period. companies that produce many different products or services are more likely to use process costing systems. production is continuous when a job-order costing is used to ensure that adequate quantities are on hand.

Answers: 2

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