Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Just need help understanding what 1.3 and 1.4 are asking... Thanks SECTION A: Answer all questions in this section. Question 1 A new van for
Just need help understanding what 1.3 and 1.4 are asking... Thanks
SECTION A: Answer all questions in this section. Question 1 A new van for your small delivery shop will cost 27000 to buy and will require ongoing maintenance expenditure of 1500 per year. The new van is far more fuel efficient than your old van and will reduce your consumption of fuel by 2400 litres per year. The fuel price is estimated to be 3 per litre this year, but it is expected to increase by 0.50 for the next 3 years and then to stabilise for the foreseeable future. The van will last for 20 years at which point it will need to be replaced and will have no salvage value. The discount rate is 8%. Answer the following questions 1.1 What is the net present value of investment in the van? (10 Marks) 1.2 What is the payback period? (10 Marks) 1.3 What is the equivalent annual cost of the van? (10 Marks) 14 What are the equivalent annual savings derived from the van? (10 Marks) 1.5 Compare the present value of the difference between the equivalence annual cost and savings over the life of the van, and show that it equals the net present value of the investment in the van (10 Marks) Font Alignment Number Cells Editing Cell Styles x fx A E Initial cost Yr 1 Yr 2 Yr 3 [Yra Yr 5 Yr 6 Yr 7 Yr 8 Yr 9 Yr 10 Yr 11 Yr 12 Yr 13 3 Yr 14 Yr 15 Yr 16 1 Yr 17 2 Yr 18 3 Yr 19 24 Yr 20 25 26 27 28 29 B C D E New Van Discount rate 8% Cashflows Cumulative cashflows Discounted cashflows Discounted c -27000 -27000 5700 -21300 6900 -14400 8100 -6300 9300 3000 9300 12300 9300 21600 9300 30900 9300 40200 9300 49500 9300 58800 9300 68100 9300 77400 9300 86700 9300 96000 9300 105300 9300 114600 9300 123900 9300 133200 9300 142500 9300 151800 NPV 57,965.23 Payback peri 3 years, 8 months 8.129032258 Sheet1 Ready 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