Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 11 From: Principles of Finance with Excel 3rd ed. , Benninga and Mofkadi, 2018, 2011, 2006 Assumptions All costs are incurred at the end
QUESTION 11 From: Principles of Finance with Excel 3rd ed. , Benninga and Mofkadi, 2018, 2011, 2006 Assumptions All costs are incurred at the end of the year A new car costs $10,000 The figures in the table are expect to remain constant in real value Emma's cost of capital is 5% You can ignore the effects of taxes in your analysis. Emma, the CFO of a company, would like to purchase a new car. She intends to replace the car every few years. The annual expected dollar costs of the car are given below: New Car Cost Cost of Capital $10,000.00 5.00% Part A: FIll in the missing values In the blue shaded areas: Year Registration nsurance Fuel Repairs (first 3 years paid by dealer) Market Value of Car at the End of the Year Total Annual Costs PV Annual Costs 100.00$ 600.00$ 600.00$ 100.00$ 500.00$ 650.00 $ 100.00 $ 450.00 $ 700.00 $ 100.00$ 450.00$ 750.00 $ 500.00 $ 100.00 450.00 800.00 600.00 5,400.00 8,500,00 $ 7.500,00 $ 6.700.00 $ 6,000.00 Replace Ever PV of Total Costs (includes purchase) Effective Annuity Cash Flow (EAC) Ranking (lowest cost is best) Part B: How often should Emma replace the car
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started