In: Finance
Renegade Industries is considering the purchase of a new machine for the production of latex. Machine A costs $2.86 million and will last for six years. Variable costs are 34% of sales, and fixed costs are $1,971,998 per year. Machine B costs $5.06 million and will last for nine years. Variable costs for this machine are 24% of sales and fixed costs are $1,287,522 per year. The sales for each machine will be $6.1 million per year. The required return is 7 %, and the tax rate is 38%. Both machines will be depreciated to zero on a straight-line basis. Each project will require an increase in inventory of $372,030, an increase in accounts receivable of $719,471, and an increase in accounts payable of $353,015. Assume a salvage value of $786,221 for both machines.
Calculate the NPV for machine A. (Round answer to 2 decimal places. Do not round intermediate calculations)
NPV of the machine A is $4,262,631
Explanations: -
Step 1. Calculation of Initial investment
Initial investment is $3,598,486
Initial investment = cost of machine + increase in Net working
1. cost of machine = $2,860,000
2. increase in Net working capital = increase in inventory + increase in accounts receivable – increase in accounts payable
= $372,030 + $719,471 - $353,015
=738486
cash flow (year 0) = (2860000 + 738,486) = $3,598,486
Step 2. Calculation of Yearly Operating Cash Flow
Yearly operating Cash Flow is $1454614.7
Yearly operating Cash Flow |
|
Annual sales |
6,100,000 |
Variable costs (34% of sales) |
2,074,000 |
Fixed costs |
$1,971,998 |
Depreciation (2,860,000/ 6) |
(476667) |
Earnings before tax |
1577335 |
Taxes (38%) |
(599387.3) |
Earnings after tax |
977947.7 |
Add Non-cash expenses(depreciation) |
476667 |
Yearly operating Cash Flow |
1454614.7 |
Step 3. Calculation of Terminal cash flow of the project
Terminal cash flow of the project is $1,225,943
Terminal cash flow = NSV of project assets + Recovered Net working capital
NSV of project assets
=Salvage value * (1-tax rate)
= $786,221 * (1-.38)
= $786,221 * .62
= $487,457
Recovered Net working capital = $738486
Therefore, Terminal cash flow =$487,457+ $738486 = $1,225,943
Step 4. Calculation of NPV
NPV of the project is $4,262,631
CALCULATIONS: -
Years |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
cost of equipment |
-$2,860,000 |
||||||
change in net working capital |
-$738,486 |
$738,486 |
|||||
operating cash flow |
$1,454,615 |
$1,454,615 |
$1,454,615 |
$1,454,615 |
$1,454,615 |
$1,454,615 |
|
NSV of new equipment |
$487,457 |
||||||
Total cash flows |
-$3,598,486 |
$1,454,615 |
$1,454,615 |
$2,193,101 |
$1,454,615 |
$1,454,615 |
$1,942,072 |
PVIF @ 7% |
1 |
0.935 |
0.873 |
0.816 |
0.763 |
0.713 |
0.666 |
Discounted cash flows |
-$3,598,486 |
$1,359,453 |
$1,270,517 |
$1,790,224 |
$1,109,719 |
$1,037,120 |
$1,294,084 |
Sum of Discounted cash flows from year 1 to 6 = $7,861,117 |
NPV = PV of future expected net cash inflows – initial investment
Initial investment = $3,598,486
NPV= $7,861,117 - $3,598,486
NPV = $4,262,631