R Copy Paste Format Painter Clipboard (Body) BIUDA Font Wrap Text Merge & Center $ Alignment B XV Accessibility tab summary: The financial information of ASAP Delivery are presented in rows B C D E F ASAP Delivery is a small company that transports business packages between San Francisco and Los Angeles. It operates a fleet of small vans that moves packages to and from a central depot within each city and uses a common carrier to deliver the packages between the depots in the two cities. ASAP recently acquired approximately $4 million of cash capital from its owners, and its president, Alex Cade, is trying to identify the most profitable way to invest these funds. G $4,000,000 H Phil Duvall, the company's operations manager, believes that the money should be used to expand the fleet of city vans at a cost of $3,600,000. He argues that more vans would enable the company to expand its services into new markets, thereby increasing the revenue base. More specifically, he expects cash inflows to increase by $1,400,000 $3,600,000 $1,400,000 per year. The additional vans are expected to have an average useful life of four years and a combined salvage value 5 of $500,000. Operating the vans will require additional working capital of $200,000, which will be recovered at the end of the fourth year. $500,000 $200,000 15 L In contrast, Amber Gomez, the company's chief accountant, believes that the funds should be used to purchase large trucks to deliver the packages between the depots in the two cities. The conversion process would produce continuing improvement in operating savings and reduce cash outflows as follows. B 9 Year 1 Year 2 10 $800,000 $1,600,000 Year 3 $2,000,000 Year 4 $2,200,000 11 13 12 The large trucks are expected to cost $4,000,000 and to have a four-year useful life and a $400,000 salvage value. In addition to the purchase price of the trucks, up-front training costs are expected to amount to $80,000. ASAP Delivery's management has established a 16 percent desired rate of return. $4,000,000 $400,000 $80,000 16% 14 15 Required 16 a. Complete the spreadsheet to calculate the net present value and the present value index for the two investments. 17 b. Include formulas in your spreadsheet to calculate the internal rate of return for each investment alternative. Note: Negative amounts or amounts to be deducted should be input and displayed as negative values. All other answers should be input and displayed as positive values. 18 19 20 Investment in new vans: Investment in new trucks: 21 Desired rate of return 16% Desired rate of return 16% 22 23 Year Cash flow Year Cash flow 24 25 26 27 28 1234O Initial investment $4,000,000 0 Initial investment Net cash flow Net cash flow 1,400,000 1 Net cash flow 2 Net cash flow Net cash flow 3 Net cash flow Net cash flow 4 Net cash flow 29 Net present value (NPV) Net present value (NPV) 30 31 Profitability index 32 Internal rate of return Profitability index Internal rate of return 33 = Graded Worksheet Workbook Statistics 71F High winds soon