Hello Experts - I need help with the following question please. All the previous
ID: 2735465 • Letter: H
Question
Hello Experts - I need help with the following question please. All the previous answers were incorrect or incomplete.
You are in the process of deciding to buy a car. You found a brand new Hyundai Elantra for $22,000. You read the reviews and they all sound good. You plan to keep it for 5 years. You do some rough calculations on the amount of expenses which includes oil changes three or four times a year, one set of new tires during the 5 year period, one set of breaks, one major change of all the fluids and few other things. It comes to about $150 per month on average or $1800 per year for the 5 years. At the end of 5 years you plan to sell or trade it in for $5000. A friend of yours calls you with great news about a used car that is available for purchase. An elderly woman who used the car only to go back and forth to church and short distances wants to get rid of her car and it has very low mileage. She will sell it to you for a very low price of $12,000. You are now thinking about the $10,000 immediate savings. You also know the maintenance and the repair costs are going to be higher than the $150 per month you projected for the new car. This may need some engine work or transmission work and you estimate $250 per month or $3000 per year. You also estimate that at the end of the 5 year period the car may only be worth $500. On the basis of yearly cost, can you calculate the difference between these two cars and make the best decision. Also. Calculate the present worth.Your TVOM is 10%.
Please provide a detailed, clear and step-by-step answer in Excel and show formulas if possible.
Thank you in advance!
Explanation / Answer
calculation of present cost of first car
22,000 is investment cost and $ 1800 per year is maitaining cost $ 5000 is salvage value of end of 5th year
calculation of present cost of second car
12,000 is investment cost and $ 1800 per year is maitaining cost $ 500 is salvage value of end of 5th year
$ 3000 is engine work transmission per year
in this both options first car is the lowest cost so buy the first car
year cash inflow/outflow discount factor / annuity factor@ 10% discounted cash flows 0 $ (22,000) 1 $ (22,000) 1-5 $ (1800) 3.791 $ (6823.8) 5 $ 5000 0.6209 $ 3,104.5 present value of cost $ ( 25,683.3)Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.