Answers for first 4 subparts parts:
In this case, project is new. Therefore
Initial Outlay = Fixed Capital Investment + Working Capital
= Cost of New Plant and Equipment + Shipping and installing costs + initial working capital required
= 14,400,000 + 300,000 + 280,000
= 14,980,000 (Answer a)
Free cashflow = Net Income + non-cash expenses – Increase in Working Capital – capex
1) Net Income:
Below Table Summarizes the calculation for Net Income.
Note: all Calculations in ‘000.
Year |
1 |
2 |
3 |
4 |
5 |
Units Sold |
60 |
110 |
110 |
70 |
60 |
Revenue |
24000 |
44000 |
44000 |
28000 |
21000 |
COGS |
9600 |
17600 |
17600 |
11200 |
9600 |
Gross Profit |
14400 |
26400 |
26400 |
16800 |
11400 |
Annual fixed Cost |
900 |
900 |
900 |
900 |
900 |
IBITDA |
13500 |
25500 |
25500 |
15900 |
10500 |
Depreciation |
2940 |
2940 |
2940 |
2940 |
2940 |
IBIT |
10560 |
22560 |
22560 |
12960 |
7560 |
tax(@36%) |
3802 |
8121.6 |
8121.6 |
4665.6 |
2721.6 |
Net Income |
6758 |
14438.4 |
14438.4 |
8294.4 |
4838.4 |
2) Non Cash Expense includes only depreciation
Year |
1 |
2 |
3 |
4 |
5 |
Depreciation |
2940 |
2940 |
2940 |
2940 |
2940 |
Total |
2940 |
2940 |
2940 |
2940 |
2940 |
Note: All figures in ‘000
3) Increase in Working Capital:
Working capital = 15% of Sales
Therefore for 1st Year, Increase in Working capital = 15% of Revenue = 3600 thousands
Therefore using current year Working capital – last year working capital, we can calculate the increase in working capital as follows:
Year |
1 |
2 |
3 |
4 |
5 |
Increase in Working Capital |
3600 |
3000 |
0 |
-2400 |
-4200 |
Year |
1 |
2 |
3 |
4 |
5 |
Increase in Working Capital |
3600 |
3000 |
0 |
-2400 |
-4200 |
Last year includes the liquidating all Working Capital
Therefore Sum of Working Capital = 0 to find 4200 thousands working capital has to be liquidated.
Therefore Free Cash flow:
Year |
1 |
2 |
3 |
4 |
5 |
Net Income |
6758 |
14438.4 |
14438.4 |
8294.4 |
4838.4 |
Non Cash Expense |
2940 |
2940 |
2940 |
2940 |
2940 |
Increase in Working Capital |
3600 |
3000 |
0 |
-2400 |
-4200 |
Free Cash Flow(Net Income + non-cash expenses – Increase in Working Capital – capex) |
6098 |
14378.4 |
17378.4 |
13634.4 |
11978.4 |
Answer B
Free Cash flow,
Year 1 : 6,098,000
Year 2 :14,378,400
Year 3 : 17,378,400
Year 4:13,634,400
Answer C
Year 5: 11,978,400
Answer D
Now using answer of a, b & c
Below is the freecashflows:
Year | 0 | 1 | 2 | 3 | 4 | 5 |
-14980 | 6098 | 14378.4 | 17378.4 | 13634.4 | 11978.4 |
in '000s
Using NPV formula in Financial Calculator, with Rate of Return as 11%
NPV is
$27,910,650 |
Which is positive
Therefore Answer is A, Project should be selected.
5. (Comprehensive problem) Traid Winds Corporation, a firm in the 36 percent marginal tax bracket with...
(NPV, PI, and IRR calculations) Fijisawa Inc. is considering a major expansion of its product line and has estimated the following free cash flows associated with such an expansion. The initial outlay would be $1,800,000, and the project would generate incremental free cash flows of $600,000 per year for 5 years. The appropriate required rate of return is 8 percent. a. Calculate the NPV. b. Calculate the Pl. c. Calculate the IRR. d. Should this project be accepted? a. What...
please include parts a - d , thanks (NPV, PI, and IRR calculations) Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $2,000,000, and the project would generate incremental free cash flows of $550,000 per year for 6 years. The appropriate required rate of return is 9 percent. a. Calculate the NPV b. Calculate the Pl c. Calculate the IRR. d....
(Comprehensive problem) The Shome Corporation, a firm in the 32 percent marginal tax bracket with a required rate of return or cost of capital of 16 percent, is considering a new project. The project involves the introduction of a new product. This project is expected to last 5 years and then, because this is somewhat of a fad product, be terminated. Given the following information, determine the free cash flows associated with the project, the project's net present value, the...
(Related to Checkpoint 12.1) (Comprehensive problem-calculating project cash flows, NPV, PI, and IRR) Traid Winds Corporation, a firm in the 31 percent marginal tax bracket with a required rate of return or discount rate of 12 percent, is considering a new project. This project involves the introduction of a new product. The project is expected to last 5 years and then, because this is somewhat of a fad product, it will be terminated. Given the following information, , determine the...
(Related to Checkpoint 12.1) (Comprehensive problem-calculating project cash flows, NPV, PI, and IRR) Traid Winds Corporation, a firm in the 30 percent marginal tax bracket with a required rate of return or discount rate of 10 percent, is considering a new project. This project involves the introduction of a new product. The project is expected to last 5 years and then, because this is somewhat of a fad product, it will be terminated. Given the following information, determine the free...
(Related to Checkpoint 12.1) (Comprehensive problem-calculating project cash flows, NPV, PI, and IRR) Traid Winds Corporation, a firm in the 30 percent marginal tax bracket with a required rate of return or discount rate of 10 percent, is considering a new project. This project involves the introduction of a new product. The project is expected to last 5 years and then, because this is somewhat of a fad product, it will be terminated. Given the following information, determine the free...
(Related to Checkpoint 12.1) (Comprehensive problem-calculating project cash flows, NPV, PI, and IRR) Traid Winds Corporation, a firm in the 36 percent marginal tax bracket with a required rate of return or discount rate of 13 percent, is considering a new project. This project involves the introduction of a new product. The project is expected to last 5 years and then, because this is somewhat of a fad product, it will be terminated. Given the following information, E, determine the...
(NPV, Pl, and IRR calculations) Fijsawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial ouay would be $1,800,00, and the project would generate icrtal fee cash flows of $500,000 per year tor 7 years. the appropriate required rate of retum is 9 percent aCalculate the NPV b. Calculate the Pl c. Calculate the IRR. d. Should this project be accepted? a. What is the...
4. (Now proiect analysis) The Chung Chemical Corporation is considering the purchase of a chemical analysis machine Although the machine being considered will result in an increase in earnings before interest and taxes of $38.000 per year It has a purchase price of $180,000, and it would cost an additional $8,000 to property install the machine. In addition to properly operate the machine, inventory must be increased by $6.000. This machine has an expected life of 10 years after which...
(NPV,PI, and IRR calculations) Fijisawa Inc. is considering a major expansion of its product line and has estimated the following cash flows associated with such an expansion. The initial outlay would be $1,850,000, and the project would generate incremental free cash flows of $700,000 per year for 7 years. The appropriate required rate of return is 8 percent. a. Calculate the NPV. b. Calculate the PI. c. Calculate the IRR. d. Should this project be accepted? a.What is the project's...