In an Excel spreadsheet file
1. Calculate the nominal and discounted payback periods for this proposed project.
2. Calculate the net present value and internal rate of return of the proposed project.
In a Word document, 1250 words (5 pages) not including title, executive summary and references
1. Referring to your analysis in parts (1) and (2), what is your recommendation regarding the proposed project under the following three scenarios? (Note: comment on any similarities or differences in your recommendations across these three scenarios.)
a. If BCI was a private company, owned entirely by Kelly Shay?
b. If BCI was a publicly owned company, with shares owned by a large number of small investors, and Shay purely a salaried administrator?
c. If BCI was a wholly owned subsidiary of a much larger company and Shay expected to be a candidate to succeed one of the parent company's top executives who will retire from the company in about two years from now?
Kelly Shay, President of Best Cookies, Inc (BCI),was trying to decide whether to expand the company by adding a new product line. The proposal seemed likely to be profitable, and adequate funds to finance it could be obtained from outside investors.
BCI had long been regarded as a well-managed company. It had succeeded in keeping its present product lines up-to-date and had maintained a small but profitable position in a highly competitive industry.
The amount of capital presently employed by the company was approximately $4,000,000, and was expected to remain at this level whether the proposal for the new product line was accepted or rejected. Net income from existing operations amounted to about $400,000 a year, and Shay’s best forecast was that this would continue to be the income from present operations.
Introduction of the new product line would require an immediate start-up investment of $400,000 in equipment and $275,000 in working capital. A further investment of $290,000 in additional working capital would be required during the first year.
Sales of the new product line would be relatively low during the first year, but would increase sporadically until the end of the seventh year. After eight years, the product line would probably be withdrawn from the market—causing extremely high sales during the eighth year as remaining cookie inventories are discounted.
At the end of eight years, the company would dispose of the equipment and liquidate the working capital. This final step will take place during the final days of year eight. The net cash value to close the product line’s facility at that time would be about $500,000.
The low initial sales volume, combined with heavy promotional outlays, would lead to heavy losses in the first two years, and no net income would be reported until the fourth year. The profit forecasts for the new product line are summarized in Exhibit 1.
Shay was concerned about the effect this project would have on BCI's overall reported profitability over the next three years. On the other hand, "eyeballing" the figures in Exhibit 1 led Shay to guess that ifthe proposal were analyzed using after-tax cash flows discounted at 10 percent, the project might well show a positive net present value, and hence could be a worthwhile investment opportunity
Exhibit 1 - Income Forecast for New Product Line
1. In this column, numbers in parentheses indicate cash outflow.
2.In this column, numbers in parentheses indicate an expense (i.e., something that reduces profits). For the purpose of this analysis, we may use these depreciation figures for the determination of both Net Income and Income Tax that will be paid to the government.
3.When forecasted incremental income before taxes is negative, the firm is entitled to a tax rebate at 45%, either from taxes paid in previous years or from taxes currently due on other company operations. Therefore, in this column, numbers in parentheses indicate taxes paid to the government and numbers not in parentheses indicates tax rebates received from the government.
4.In this column, numbers in parentheses indicate a net loss produced by the new product line and numbers not in parentheses indicate a net profit made by this new product line.
Purchase the answer to view it
review the document and confirm you can help with as you have the necessary understanding about accounting.