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
Other questions on the subject: Business
Business, 22.06.2019 13:10, princessgabbee8452
Paid-in-capital in excess of par represents the amount of proceeds a. from the original sale of common stock b. in excess of the par value from the original sale of common stock c. at the current market value of the common stock d. at the curent book value of the common stock
Answers: 1
Business, 22.06.2019 15:30, gracerich
University hero is considering expanding operations beyond its healthy sandwiches. jim axelrod, vice president of marketing, would like to add a line of smoothies with a similar health emphasis. each smoothie would include two free health supplements such as vitamins, antioxidants, and protein. jim believes smoothie sales should fill the slow mid-afternoon period. adding the line of smoothies would require purchasing additional freezer space, machinery, and equipment. jim provides the following projections of net sales, net income, and average total assets in support of his proposal. sandwichesonly sandwiches and smoothies net sales $ 750,000 $ 1,350,000 net income 120,000 210,000 average total assets 350,000 750,000 return on assetschoose numerator ÷ choose denominator = return on assets÷ = return on assets÷ = profit margin÷ = profit margin÷ = asset turnover÷ = asset turnover÷ = times
Answers: 2
Business, 22.06.2019 19:00, Anonymouslizard
All of the following led to the collapse of the soviet economy except a. a lack of worker incentives. c. inadequate supply of consumer goods. b. a reliance on production quotas. d. the introduction of a market economy.
Answers: 1
Business, 22.06.2019 19:10, crzyemo865
Calculating and interpreting eps information wells fargo reports the following information in its 2015 form 10-k. in millions 2015 2014 wells fargo net income $24,005 $24,168 preferred stock dividends $1,535 $1,347 common stock dividends $7,400 $6,908 average common shares outstanding 5,136.5 5,237.2 diluted average common shares outstanding 5,209.8 5,324.4 determine wells fargo's basic eps for fiscal 2015 and for fiscal 2014. round answers to two decimal places.
Answers: 3
You know the right answer?
Part i. design and make a workbook in excel to compare the purchase versus lease of an automobile....
Questions in other subjects:
Mathematics, 18.12.2020 19:50
Mathematics, 18.12.2020 20:00
Mathematics, 18.12.2020 20:00
Mathematics, 18.12.2020 20:00
