Compute the payback period

Assignment Help Finance Basics
Reference no: EM13831830

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.

Reference no: EM13831830

Questions Cloud

Draw payoff table for game played between two random players : Consider a survival game in which a large population of animals meet and either fight over or share a food source. There are two phenotypes in the population: one always fights, and the other always shares. Draw the payoff table for the game played b..
Set up this game as simultaneous-move game-find equilibrium : Consider a game between a parent and a child. The child can choose to be good (G) or bad (B); the parent can punish the child (P) or not (N). The child gets enjoyment worth a 1 from bad behavior, but hurt worth -2 from punishment. Thus a child who be..
What laws in cuba are restricting them from leaving legally : For the past few years, Cuban baseball players have been leaving their country illegally to play professional baseball in the United States. (Ex. Yasiel Puig, Rusney Castillo, Jose Abreu). What laws in Cuba are restricting them from leaving legally? ..
The classic example of opportunity cost : The classic example of opportunity cost is the costs of going to college. Illustrate the implicit opportunity cost of foregone income as well as tuition, books, etc. Think about whether room and board should be considered a cost of college. Calculate..
Compute the payback period : 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. M..
Strategies outlined in the series of e-mail communications : Prepare a one-page executive summary that addresses the alternative strategies outlined in the series of e-mail communications with Les Dett and others.
Identify search engine optimization principles for an app : Identify search engine optimization (SEO) principles for an app. Identify possible keywords and analysis from an SEO perspective.
Relate to the financial statements of any u.s. public : The class should discuss all of the questions listed below as they relate to the financial statements of any U.S. public company of your choice in its latest annual report. You can find the financial statements of any U.S. public company by visiting ..
What is the primary cause for emotional : What is the primary cause for emotional

Reviews

Write a Review

 

Finance Basics Questions & Answers

  What is a swap market

What is a swap market? How can swap markets help international firms obtain low-cost sources of capital and manage foreign exchange risk?

  What is the capital structure weight of the common stock

The bonds mature in 14 years, have a face value of $825, and sell at 103 of par. What is the capital structure weight of the common stock?

  Multiple performance measures of balanced scorecard

Balanced Scorecard multiple performance measures lead to all of the following except:

  The stock exchanges in regulating the securities industry

Explain the role of the role of the sec, the NASD, and the stock exchanges in regulating the securities industry.

  Calculate a few simple ratios

Do some research on the two companies, Target and JcPenney. In particular, look for their most recent financial statements. Calculate a few simple ratios, like the Book Value Per Share, Current Ratio and Profit Margin on Sales.

  Average company capital structure

If Congress increased the personal tax rate on interest, dividends, and capital gains but simultaneously reduced the rate on corporate income, what effect would this have on the average company's capital structure?

  What is your expected rate of return

The common stock of Zaldi Co. is selling for $32.84 per share. The stock recently pid dividends of $2.94 per share and has a projected constant growth rate of 9.5 percent. If you purchase the stock at the market price, what is your expected rate o..

  Evaluate the cumulative adjustment factor

Evaluate the cumulative adjustment factor and determine the return since you bought the stock

  Suppose the exchange rate between us dollars and swiss

suppose the exchange rate between u.s. dollars and swiss francs is sf 1.41 1.00 and the exchange rate between the u.s.

  Prepare an income statement for stein book

Stein Books Inc. sold 2,000 finance textbooks for $270 each to High Tuition University in 2013. These books cost $240 to produce. Stein Books spent $12,400 (selling expense) to convince the university to buy its books.

  What is the cash ratio

Your firm has cash of $3,800, accounts receivable of $9,600, inventory of $33,100, and net working capital of $1,100. What is the cash ratio?

  What is the internal rate of return for a project that has

what is the internal rate of return for a project that has a net investment of 75000 and the following net cash flows

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd