Question Answered step-by-step Excel use Freddie runs a medium sized business “Freddie’s Delivery… Excel use Freddie runs a medium sized business “Freddie’s Delivery Service” (FDS), delivering parcels. He is considering purchasing a new fleet of vehicles as part of his business expansion. Freddie has negotiated a purchase price of $515,000 for this fleet. Using data from his existing vehicles, he estimates the following running costs for the new fleet of cars he is considering purchasing:Insurance for the new fleet will cost $8,000 per year, payable at the start of each yearBased on mileage estimates, petrol will cost $960 per week, payable at the end of each weekHiring extra employees to drive the new vehicles will cost $11,000 per fortnight, payable at the end of each fortnightFor the purposes of this question, assume that these are the only expenses involved in the purchase and operation of these vehicles. Freddie believes that this new fleet can be used for 8 years before the vehicles are no longer reliable. When this happens, he believes he can resell the vehicles for one fifth of the initial purchase price. Freddie also has a business account that lets him borrow or invest at 3.103% per annum effective. (a) Calculate the present value of the eventual sales price. Give your answer in dollars, to the nearest cent. (1 mark) (b) Calculate the total present value of the running costs (i.e. the insurance, petrol, and employee wages described above). Give your answer in dollars, to the nearest cent. (1 mark) (c) What is the total cost of buying and running this fleet, in today’s dollars? Give your answer in dollars, to the nearest cent. (1 mark) Accounting Business Financial Accounting ACST 1001 Share QuestionEmailCopy link Comments (0)