Question

In: Finance

Briarcliff Stove Company is considering a new product line to supplement its range line. It is...

Briarcliff Stove Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at time 0 and $1.0 million in year 1. After tax cash inflows of $250,000 are expected in year 2, $300,000 in year 3, $350,000 in year 4, and $400,000 each year thereafter through year 6. Though the product line might be viable after year 6, the company prefers to be conservative and end all calculations at that time.

a) If the required rate of return is 15 percent, what is the net present value of the project? Is it acceptable?

b) Calculate Accounting Rate of Return

c) What is the project’s payback period?

d) What is the project’s profitability index?

e) What would be the case if the required rate of return was 10 percent?

 

Solutions

Expert Solution

Qa)

An excel sheet is used here to calculate the PV.

Steps:

1. All the investments are entered in in first row.

2. All the cash flows are entered in the in the next row for all the years. Since the values given in the question are after tax cash inflows, it is assumed that the depreciation is already deducted while calculating these cash inflows.

3. The net cash inflow in all the years is calculated in the next row. It is the value obtained by subtracting the investment in each year from the after tax cash inflows.

4. The assumed Resale value / Scrap value of the investments made, at the end of year 6 is nil.

5.   The NPV formula available in excel is used to calculate NPV by using 15% RR. .Here it goes.

Year

0

1

2

3

4

5

6

investment

700000

1000000

0

0

0

0

0

After tax cash inflow

250000

300000

350000

400000

400000

NET CASH INFLOW

-700000

-1000000

250000

300000

350000

400000

400000

NPV

($531,616.58)

Since the NPV of the investment is negative, it is not acceptable.

Q b)

Accounting rate of return (also known as simple rate of return) is the ratio of estimated accounting profit of a project to the average investment made in the project. ARR is used in investment appraisal.

Formula

Accounting Rate of Return is calculated using the following formula:

ARR =

Average Accounting Profit

Average Investment

Average accounting profit is the arithmetic mean of accounting income expected to be earned during each year of the project's life time. Average investment may be calculated as the sum of the beginning and ending book value of the project divided by 2. Another variation of ARR formula uses initial investment instead of average investment.

Solution
Initial investment                     = (70000+1000000) = 1700000

Total Accounting Income              = 250000 + 300000 +350000 + 400000 + 400000

                                                       = 1700000

Average Accounting Income = 1700000 = 242857

                                                       7

                                                      
Accounting Rate of Return = 242857 ÷ $1700000 ≈ 14.28 %

Decision Rule

Accept the project only if its ARR is equal to or greater than the required accounting rate of return. Since the ARR of 14.28% is less than the required RR of 15%, this investment is not acceptable.

Q c)

Payback Period

Payback period is the time in which the initial cash outflow of an investment is expected to be recovered from the cash inflows generated by the investment.

Formula

The formula to calculate payback period of a project depends on whether the cash flow per period from the project is even or uneven. In case they are even, the formula to calculate payback period is:

Payback Period =

Initial Investment

Cash Inflow per Period

When cash inflows are uneven, we need to calculate the cumulative net cash flow for each period and then use the following formula for payback period:

Payback Period = A +

B

C

                             
In the above formula,
A is the last period with a negative cumulative cash flow;
B is the absolute value of cumulative cash flow at the end of the period A;
C is the total cash flow during the period after A

     The problem here is a case of uneven cash flows. So the cumulative cashflow is calculated as given below:

    

Payback Period
= 4 + (|-170000| ÷ 400000)
= 4 + (170000 ÷ 400000)
≈ 4 + 0.425
≈ 4.425 years

Q d)

Profitability index is an investment appraisal technique calculated by dividing the present value of future cash flows of a project by the initial investment required for the project.

Formula:

Profitability Index

=

Present Value of Future Cash Flows

Initial Investment Required

=

1 +

Net Present Value

Initial Investment Required

Explanation:                                     

Profitability index is actually a modification of the net present value method. While present value is an absolute measure (i.e. it gives as the total dollar figure for a project), the profibality index is a relative measure (i.e. it gives as the figure as a ratio).

Decision Rule

Accept a project if the profitability index is greater than 1, stay indifferent if the profitability index is zero and don't accept a project if the profitability index is below 1.

In this given problem,

Profitability Index = PV of Future Net Cash Flows / Initial Investment Required
Profitability Index = 531617 / 1700000 = 0.31

Since Profitability index is less than 1, this project cannot be accepted.

Q e)

The same method shown in Q a) above is used, except that RR is taken as 10%.

Year

0

1

2

3

4

5

6

investment

700000

1000000

0

0

0

0

0

After tax cash inflows

250000

300000

350000

400000

400000

NET CASH INFLOW

-700000

-1000000

250000

300000

350000

400000

400000

NPV

($421,701.90)

Since the NPV of the investment is negative, it is not acceptable.


Related Solutions

A Company is considering a new product line to supplement its range line. It is anticipated...
A Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at time 0 and $1.0 million in year 1. After-tax cash inflows of $500,000 are expected in year 2, $300,000 in year 3, $700,000 in year 4, and $400,000 each year thereafter through year 10. Though the product line might be viable after year 10, the company prefers to be conservative and end...
Zachary Company is considering the addition of a new product to its cosmetics line. The company...
Zachary Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 140,000 220,000 100,000 Expected sales price (b) $ 7 $ 7 $ 15 Variable costs per unit (c) $ 2 $ 4...
Walton Company is considering the addition of a new product to its cosmetics line. The company...
Walton Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 138,000 218,000 98,000 Expected sales price (b) $ 10 $ 9 $ 16 Variable costs per unit (c) $ 2 $ 4...
Zachary Company is considering the addition of a new product to its cosmetics line. The company...
Zachary Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 140,000 220,000 100,000 Expected sales price (b) $ 7 $ 7 $ 15 Variable costs per unit (c) $ 2 $ 4...
Vernon Company is considering the addition of a new product to its cosmetics line. The company...
Vernon Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 136,000 216,000 96,000 Expected sales price (b) $ 9 $ 7 $ 15 Variable costs per unit (c) $ 2 $ 4...
Solomon Company is considering the addition of a new product to its cosmetics line. The company...
Solomon Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 130,000 210,000 90,000 Expected sales price (b) $ 10 $ 9 $ 15 Variable costs per unit (c) $ 2 $ 4...
Baird Company is considering the addition of a new product to its cosmetics line. The company...
Baird Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 104,000 184,000 64,000 Expected sales price (b) $ 9 $ 4 $ 11 Variable costs per unit (c) $ 2 $ 1...
Rooney Company is considering the addition of a new product to its cosmetics line. The company...
Rooney Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 128,000 208,000 88,000 Expected sales price (b) $ 9 $ 7 $ 14 Variable costs per unit (c) $ 2 $ 4...
Rundle Company is considering the addition of a new product to its cosmetics line. The company...
Rundle Company is considering the addition of a new product to its cosmetics line. The company has three distinctly different options: a skin cream, a bath oil, or a hair coloring gel. Relevant information and budgeted annual income statements for each of the products follow. Relevant Information Skin Cream Bath Oil Color Gel Budgeted sales in units (a) 126,000 206,000 86,000 Expected sales price (b) $ 8 $ 6 $ 13 Variable costs per unit (c) $ 2 $ 4...
Shrieves Casting Company is considering adding a new line to its product mix, and the company...
Shrieves Casting Company is considering adding a new line to its product mix, and the company hires you, a recently business school graduate, to conduct capital budgeting analysis. The production line would be set up in unused space in Shrieves' main plant. The machinery’s invoice price would be approximately $200,000; another $10,000 in shipping charges would be required; and it would cost an additional $30,000 to install the equipment. The machinery has an economic life of 4 years, and would...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT