Compute the Payback Period, Net Present Value and Internal Rate of Return for each of the three investment options. Submit the recommendation as a one-page Word document along with an Excel file showing your work as partial credit will be rewarded. My recommendation is to read the description of each option to determine relevant costs and benefits (those that change based on whether you undertake the project or not). Do not consider costs that are incurred regardless of your decision or costs that occurred in the past (sunk costs). Add the relevant costs to the yearly cash flows provided. Explain your reasoning so that I may award you partial credit and offer better feedback.

Project 1: Picking Projects Using Capital Budgeting The large publishing company you work for has built up an excess pile of $150M cash due to better than expected sales and delays in making any new investments in production facilities. As the newly promoted Chief Financial Officer, the CEO has instructed you to find uses of this unneeded cash that will earn the highest return for shareholders; liquidity (ease of convertibility into cash) is not an issue. You may also invest any amount of cash (from $150M to any remaining after investments) into a stock market index expected to earn 8% per year or distribute to shareholders as a dividend (assume they can earn the same 8%). Write to the CEO in a one page summary explaining why the options (not exceeding $150M in cash required) you have chosen are the best. The options are as follows: Option 1: You can team with Amazon in creating your own e-Reader in order to join the movement towards e-books and away from printed copies. Your company has already spent $20M researching the technological requirements and possible market reaction. Amazon requires an upfront investment of $100M to begin design and expects the product to hit the market next year. This will reduce cash flows from traditional book sales by $20M per year. Projected cash flows for this investment are as follows: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Sales $50M $60M $70M $75M $80M $85M Costs ($30M) ($35M) ($40M) ($40M) ($40M) ($40M) Option 2: Much of the company's publishing equipment has become worn down and outdated, and investing in new equipment would result in lower costs and quicker delivery times for special orders. You can sell the old equipment today for an after-tax cash inflow of $25M and invest $75M in new equipment that will generate the following cost savings and extra revenue: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Sales $5M $5M $10M $10M $10M $10M Costs Savings $15M $15M $10M $10M $5M $5M Option 3: There is a small book store chain that would give you a better outlet to sell your books in person while also profiting from the sales of your competitors. You hired an investment bank specializing in acquisitions to help you analyze this possibility and have already paid them $10M for their services. If the acquisition occurs, you will owe the investment bank an additional $10M. Recently the small book store chain gave you their final offer; you can purchase them for $65M in cash. Below are the income effects your firm would realize from acquiring this firm: Year 1 Year 2 Year 3 Year 4 Year 5 Sales $25M $25M $30M $30M $35M Costs ($15M) ($15M) ($20M) ($20M) ($25M) Requirements: Compute the Payback Period, Net Present Value and Internal Rate of Return for each of the three investment options. Submit the recommendation as a one-page Word document along with an Excel file showing your work as partial credit will be rewarded. My recommendation is to read the description of each option to determine relevant costs and benefits (those that change based on whether you undertake the project or not). Do not consider costs that are incurred regardless of your decision or costs that occurred in the past (sunk costs). Add the relevant costs to the yearly cash flows provided. Explain your reasoning so that I may award you partial credit and offer better feedback. Option 1 Year Cash Flows Discount Rate 0 -100 1 0 Pay Back Period Internal Rate of Return NPV 6 Years -5.92% $-47.38 2 5 3 10 4 15 5 20 8% #N/A Months Statement showing calculation of cash inflows Less: Less: Year Sales Costs Loss of Sales Total Cash Flows Year Net Cash Flow Cumulative Cash Flow Initial Investment 1 50 -30 -20 0 2 60 -35 -20 5 3 70 -40 -20 10 4 75 -40 -20 15 5 80 -40 -20 20 6 85 -40 -20 25 1 0 0 2 5 5 3 10 15 4 15 30 5 20 50 6 25 75 100 (Amount in $ Millions) 6 25 Option 2 Year 0 Cash Flows -50 Discount Rate 8% 1 20 Pay Back Period 2 Years Internal Rate of Return 30.46% NPV $35.90 2 20 3 20 4 20 5 15 6.00 Months Statement showing calculation of cash inflows Less: Year 1 Sales 5 Cost Savings 15 Total Cash Flows 20 2 5 15 20 3 10 10 20 4 10 10 20 5 10 5 15 6 10 5 15 Year 1 Net Cash Flow 20 Cumulative Cash Flow 20 2 20 40 3 20 60 4 20 80 5 15 95 6 15 110 Initial Investment 50 (Amount in $ Millions) 6 15 Option 1 (Amount in $ Millions) Year Cash Flows Discount Rate Pay Back Period Internal Rate of Return NPV 0 -75 1 10 2 10 3 10 4 10 8% 5 Years -12.15% $-35.07 #N/A Months Statement showing calculation of cash inflows Less: Year Sales Costs Total Cash Flows 1 25 -15 10 2 25 -15 10 3 30 -20 10 4 30 -20 10 5 35 -25 10 Year Net Cash Flow Cumulative Cash Flow 1 10 10 2 10 20 3 10 30 4 10 40 5 10 50 Initial Investment 75 5 10