Question

Last Tuesday, Cold Goose Metal Works Inc. lost a portion of its planning and financial data when both its main and its backup servers crashed. The company's CFO remembers that the internal rate of return (IRR) of Project Lambda is 13.2%, but he can't recall how much Cold Goose originally invested in the project nor the project's net present value (NPV). However, he found a note that detailed the annual net cash flows expected to be generated by Project Lambda. They are: Year Year 1 Year 2 Year 3 Year 4 Cash Flow $2,000,000 $3,750,000 $3,750,000 $3,750,000 The CFO has asked you to compute Project Lambda's initial investment using the information currently available to you. He has offered the following suggestions and observations: • A project's IRR represents the return the project would generate when its NPV is zero or the discounted value of its cash inflows equals the discounted value of its cash outflows-when the cash flows are discounted using the project's IRR. • The level of risk exhibited by Project Lambda is the same as that exhibited by the company's average project, which means that Project Lambda's net cash flows can be discounted using Cold Goose's 9% WACC. , and its NPV is Given the data and hints, Project Lambda's initial investment is (rounded to the nearest whole dollar). A project's IRR will if the project's cash inflows increase, and everything else is unaffected.

Answer 1

Year CF Year ICF Initial $9,562,138 Initial I=NPV(13.2%,B3:36) 1 $ 2,000,000.00 2000000 2 $3,750,000.00 2 3750000 3 $ 3,750,000.00 3750000 4 $ 3.750,000.00 4 3750000 NPV $981,307 NPV =NPV(9%,B3:36)-B2

Increase