Question

In: Finance

QUESTION 1 ABC Inc, a publishing company is considering investing in a new press. For the...

QUESTION 1
ABC Inc, a publishing company is considering investing in a new press. For the purpose of
your valuation, limit the project’s life to 5 years. The press will cost $1’000’000, will required
additional $20’000 in installation fees to bring it to working condition, will have a useful life
of 5 years, salvage value of $100’000, will be depreciated on straight-line basis and sold at
the end of project’s life for an estimated value of $300’000. The press will allow for an
increase in production capacity and thus is expected to increase annual revenue by
$500’000. Additional operating expenses related to the higher volume of production are
estimated to equal $78’000 per year. Net working capital requirements are $55’000, which
are mostly related to the increase in inventory and are expected to be depleted by the end
of project’s life. Tax rate is 35%. Assume that you were able to compute the firm’s WACC
and it is equal 12%. Considering that this project would be an average risk project, meaning
that the computed WACC is applicable, find (simple) payback, discounted payback, IRR, and
NPV for this project.

Solutions

Expert Solution

Based on the given data,pls find below workings:

Computation of IRR: This can be computed using formula in Excel = IRR("range of cashflows", discounting factor%);

Computation of MIRR: This can be computed using formula in Excel = IRR("range of cashflows", discounting factor%, reinvestment factor%); Here, both discounting factor % and reinvestment factor% are considered same.

Computation of Net Present Value (NPV) based on the Discounted Cash flows; The Discounting factor is computed based on the formula: For year 0, the discounting factor is 1; For Year 1, it is computed as = Year 0 factor /(1+discounting factor%) ; Year 2 = Year 1 factor/(1+discounting factor %) and so on;

Next, the cashflows need to be multiplied with the respective years' discounting factor, to arrive at the discounting cash flows;

The total of all the discounted cash flows is equal to its respective Project NPV of the Cash Flows;

Computation of Pay Back Period: Here, the period is computed for each project, based on cumulative discounted cash flows: If the cumulative value is less than or equal to zero, the period is considered as 12 months (it means that the net cumulative cash flow has not yet paid back the initial investment); Once the value turns positive in a particular year, the period for such year is observed at a proportion of actual discounted cash flow to the cumulative CF; This gives the period less than 12 months in such year; Once this is computed, total of all the years is taken and divided by 12, to arrive at the Payback period in no.of years.


Related Solutions

Question 1 ABC company is considering producing a new range of smartphones that will require it...
Question 1 ABC company is considering producing a new range of smartphones that will require it to build a new factory. The project itself will go for 20 years. Feasibility studies have been done on the factory which cost $5 million. The studies have found the following: 1. The factory will cost $25 million and will have a useful life of 25 years. 2. The land where the factory will go is currently used as a carpark for workers and...
Question 1 M & M Printing is considering the purchase of a new printing press. The...
Question 1 M & M Printing is considering the purchase of a new printing press. The cost of the press is $2 million. This outlay will be partially offset by the sale of an existing press The old press has zero net book value, cost $1 million ten years ago and can be sold currently for $0.2 million before taxes. As a result of acquiring the new press, sales in each of the next five years are expected to increase...
*I am seeking an answer to Question 1 B.* ABC company is considering producing a new...
*I am seeking an answer to Question 1 B.* ABC company is considering producing a new range of smartphones that will require it to build a new factory. Feasibility studies have been done on the factory which cost $5 million. The studies have found the following: The factory will cost $25 million and will have a useful life of 20 years. The land where the factory will go is currently used as a carpark for workers and it is assumed...
QUESTION 42 Pennewell Publishing Inc. (PP) Pennewell Publishing Inc. (PP) is a zero growth company. It...
QUESTION 42 Pennewell Publishing Inc. (PP) Pennewell Publishing Inc. (PP) is a zero growth company. It currently has zero debt and its earnings before interest and taxes (EBIT) are $80,000. PP's current cost of equity is 10%, and its tax rate is 25%. The firm has 10,000 shares of common stock outstanding selling at a price per share of $48.00. Refer to the data for Pennewell Publishing Inc. (PP). PP is considering changing its capital structure to one with 30%...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents...
CCNY, Inc. is considering the acquistition of a new left-handed press. The base price of the...
CCNY, Inc. is considering the acquistition of a new left-handed press. The base price of the press is indicated below. In addition there are modification costs, noted below, for CCNY's special use. The press falls into the MACRS 3-year class. The new press is expected to speed up production and result in an increase in gross annual sales and an increase in annual variable costs as noted below. Inventories, accounts payable, and accounts receivable are all expected to increase (as...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT