NPV, and Equivalent annuity for each type of car.
Not what you're looking for?
You are put in charge of replacing the fleet of sales and executive automobiles for your company. Three types of cars have been identified. The first type would cost less upfront, have higher maintenance cost, and lower salvage values after shorter lives. The second type would cost a little more upfront, have slightly lower maintenance cost, and slightly higher salvage values after slightly longer operating lives. The third type would cost more upfront, have lower maintenance cost, and higher salvage values after longer operating lives. The cash flow estimates for each type is given below:
Type one: Purchase price per car $16,000; Annual operating expense per car $4,000; Disposition value per car $4,000; Estimated useful life of the car 4 years
Type two: Purchase price per car $32,000; Annual operating expense per car $3,600; Disposition value per car $5,500; Estimated useful life of the car 6 years
Type three: Purchase price $48,000; Annual operating expense $2,800; Disposition value $8,000; Estimated useful life of the asset 8 years
All cars can be replaced at the end of their asset lives. Using a 6.5 percent discount rate and the equivalent annuity method, which car is the better investment? Please show the NPV, and Equivalent annuity for each type of car.
NPV Equivalent Annuity
Car Type One ____________________ _____________
Car Type Two ____________________ _____________
Car Type Three ____________________ _____________
Purchase this Solution
Solution Summary
Your tutorial is in Excel, attached. You use NPV and PMT in Excel to solve for these. In the last year, the cost is netted by the proceeds from disposal.
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Basics of corporate finance
These questions will test you on your knowledge of finance.