Homework: Cash Investment
Overview
A company's growth and development, and indeed its ability to remain competitive and survive, depends upon a constant flow of new investment ideas. The most common and effective method used to evaluate investments in long-term projects is to determine each project's net present value (NPV). The process of determining whether the future cash flow benefits arising from a long-term project are sufficient to justify the required up-front cash investment is also called capital budgeting. The net present value method uses a discount rate (interest rate) to restate all cash flows in terms of present values, and then makes comparisons on which project has the highest net present value.
In this project you are provided expected cash flows over the course of five years for two alternative long-term projects that XYZ Entertainment Company is considering investing in. XYZ will only invest in one of the projects. XYZ uses a discount rate (interest rate) of 18% to calculate the present value of future cash flows.
Cash Investment at start of project (initial cash outflow) = ($1,000,000)
Year 1: Cash inflow = $350,000
Year 2: Cash inflow = $350,000
Year 3: Cash inflow = $350,000
Year 4: Cash inflow = $350,000
Year 5: Cash inflow = $350,000
• XYZ Long-Term Cash Flow Projection for Project II
Cash Investment at start of project (initial cash outflow) = ($1,000,000)
Year 1: Cash inflow = $450,000
Year 2: Cash inflow = $500,000
Year 3: Cash inflow = $500,000
Year 4: Cash inflow = $150,000
Year 5: Cash inflow = $150,000
The formula to calculate the present value of each year's future cash inflow is:
Present Value = Future Value / (1 + interest rate)Number of Years
Follow these steps to determine each project's net present value (NPV):
a. Calculate the present value of the cash inflows for each of the 5 years.
b. Sum all 5 years of calculated present values.
c. Subtract the cash investment at the start of the project (initial cash outflow).
d. The result will be the projects's net present value.
Create
Use XYZ Entertainment Company's 5-year Cash Flow projections for Project I and Project II to complete the Project III Answer Sheet. Include the following information:
A. The net present value (NPV) of Project I
a. The present value of cash inflow for year 1
b. The present value of cash inflow for year 2
c. The present value of cash inflow for year 3
d. The present value of cash inflow for year 4
e. The present value of cash inflow for year 5
B. The net present value (NPV) of Project II
a. The present value of cash inflow for year 1
b. The present value of cash inflow for year 2
c. The present value of cash inflow for year 3
d. The present value of cash inflow for year 4
e. The present value of cash inflow for year 5
C. Which project has the highest net present value (Project I or Project II)?
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.