Question

 Landcruisers Plus​ (LP) has operated an online retail store selling​ off-road truck parts. As the name​ implies, the firm specializes in parts for the venerable Toyota FJ40 that is known throughout the world for its durability and offroad prowess. The fact that Toyota stopped building and exporting the FJ40 to the U.S. market in 1982 meant that FJ40 owners depended more and more on​ re-manufactured parts to keep their beloved​ off-road vehicles running. More and more FJ40 owners are replacing the original inline​ six-cylinder engines with a modern​ American-built engine. The engine replacement requires mating the new engine with the Toyota drive train. LP's owners had been offering engine adaptor kits for some time but have recently decided to begin building their own units. To make the adaptor kits the firm would need to invest in a variety of machine tools costing a total of $650,000.​LP's management estimates that they will be able to borrow $300,000 from the​ firm's bank and pay 8 percent interest. The remaining funds would have to be supplied by​ LP's owners. The firm estimates that they will be able to sell​ 1,000 units a year for $1,500 each. The units would cost $1,000 each in cash expenses to produce​ (this does not include depreciation expense of $65,000 per year or interest expense of $24,000​) After all​ expenses, the firm expects earnings before interest and taxes of ​$435,000. The firm pays taxes equal to 31 ​percent, which results in net income of $276,150 per year over the 10​-year expected life of the equipment.

a.  What is the annual free cash flow LP should expect to receive from the investment in year 1 assuming that it does not require any other investments in either capital equipment or working capital and the equipment is depreciated over a 10​-year life to a zero salvage and book​ value? How should the financing cost associated with the ​$3300,000 loan be incorporated into the analysis of cash​ flow?

b.  If the​ firm's required rate of return for its investments is 14 percent and the investment has a 10​-year expected​ life, what is the anticipated NPV of the​ investment?

Answer 1

a]

Annual free cash flow = net income + depreciation

Annual free cash flow = $276,150 + $65,000 = $341,150

The financing cost is incorporated into the cost of capital (required return). Hence, it is not considered in calculating free cash flows

b]

NPV is calculated using NPV function in Excel.

NPV is $521,196

A В $650,000 2 Initial Investment 3 Cost of machine tools 4. 5 OCF 6 Revenues 7 - Costs 8 - Depreciation 9 EBIT 10 - Interest 11 EBT 12 - Taxes 13 Net income 14 + Depreciation 15 FCF 16 17 NPV Analysis 18 Project Cash Flows $1,500,000 $1,000,000 $65,000 $435,000 $24,000 $411,000 $134,850 $276,150 $65,000 $341,150 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $65,000 $65,000 $435,000 $435,000 $24,000 $24,000 $411,000 $411,000 $134,850 $134,850 $276,150 $276,150 $65,000 $65,000 $341,150 $341,150 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $65,000 $65,000 $435,000 $435,000 $24,000 $24,000 $411,000 $411,000 $134,850 $134,850 $276,150 $276,150 $65,000 $65,000 $341,150 $341,150 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $65,000 $65,000 $435,000 $435,000 $24,000 $24,000 $411,000 $411,000 $134,850 $134,850 $276,150 $276,150 $65,000 $65,000 $341,150 $341,150 $1,500,000 $1,500,000 $1,000,000 $1,000,000 $65,000 $65,000 $435,000 $435,000 $24,000 $24,000 $411,000 $411,000 $134,850 $134,850 $276,150 $276,150 $65,000 $65,000 $341,150 $341,150 ($650,000) $341,150 $341,150 $341,150 $341,150 $341,150 $341,150 $341,150 $341,150 $341,150 19 20 NPV $521,196

A C D G H 650000 2 Initial Investment 3 Cost of machine tools 4. 5 OCF 6 Revenues 7 - Costs 8 - Depreciation 9 EBIT 10 - Interest 11 EBT 12 - Taxes 13 Net income 14 + Depreciation 15 FCF 16 17 NPV Analysis 18 Project Cash Flows 19 20 NPV =1000*1500 =1000*1500 =1000*1500 =1000*1500 =1000*1500 =1000*1500 =1000*1500 =1000*1500 =1000*1500 =1000*1000 =1000*1000 =1000*1000 =1000*1000 =1000*1000 =1000*1000 =1000*1000 =1000*1000 =1000*1000 65000 65000 65000 65000 65000 65000 65000 65000 65000 =C6-C7-C8 =D6-D7-D8 =E6-E7-E8 =F6-F7-F8 =G6-G7-G8 =H6-H7-H8 =16-17-18 =J6-17-18 =K6-K7-K8 24000 24000 24000 24000 24000 24000 24000 24000 24000 =C9-C10 =D9-D10 =E9-E10 =F9-F10 =G9-G10 =H9-H10 =19-110 =29-J10 =K9-K10 =C9*31% =D9*31% =E9*31% =F9*31% =G9*31% =H9*31% =19*31% =39*31% =K9*31% =C11-C12 =D11-D12 =E11-E12 =F11-F12 =G11-G12 =H11-H12 =111-112 = J11-J12 =K11-K12 =C8 =D8 =E8 =F8 =G8 =18 =J8 =K8 =C13+C14 =D13+D14 =E13+E14 =F13+F14 =G13+G14 =H13+H14 =113+114 = 13+J14 -K13+K14 -H8 --B3 =C15 =D15 =E15 =F15 G15 =H15 -115 =J15 =K15 =NPV(14%,C18:G18)+B18 21