Question and content are in the attachment. Please calculate payback period, net present value, internal rate of return, and remaining cash for the three options in the attachment. Also, please tell me the best option or combination of options and the reasons. Thank you very much.

Project 1: Picking Projects Using Capital Budgeting The large publishing company you work for has built up an excess pile of $200M 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 $200M to any remaining after investments) into a stock market index expected to earn 6% per year or distribute to shareholders as a dividend. Please note that your cost of capital to consider for the project(s) you choose is 9%.Write to the CEO in a one page summary explaining why the options (not exceeding $200M 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 $15M researching the technological requirements and possible market reaction. Amazon requires an upfront investment of $90M 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 in addition to the increased sales and costs shown below. Projected cash flows for this investment are as follows: Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Sales $65M $70M $70M $70M $80M $90M Costs ($50M) ($45M) ($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 $35M and invest $120M 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 $15M $15M Costs Savings $10M $10M $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 $5M. Recently the small book store chain gave you their final offer; you can purchase them for $50M 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 $30M $30M $35M $40M $40M Costs ($15M) ($15M) ($20M) ($20M) ($20M) 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