In: Finance
A)
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $509885 is estimated to result in $206540 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value at the end of the project of $91777. The shop's tax rate is 34 percent. What is the OCF for year 4? (Round your final answer to the nearest dollar amount. Omit the "$" sign and commas in your response. For example, $123,456.78 should be entered as 123457.)
Modified ACRS Depreciation Allowances (Table 10.7) | |||
Year | Three-Year | Five-Year | Seven-Year |
1 | 33.33% | 20.00% | 14.29% |
2 | 44.45 | 32.00 | 24.49 |
3 | 14.81 | 19.20 | 17.49 |
4 | 7.41 | 11.52 | 12.49 |
5 | 11.52 | 8.93 | |
6 | 5.76 | 8.92 | |
7 | 8.93 | ||
8 | 4.46 |
B)
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $534819 is estimated to result in some amount of annual pretax cost savings. The press will have an aftertax salvage value at the end of the project of $85560. The OCFs of the project during the 4 years are $173439, $195137, $176990 and $166535, respectively. The press also requires an initial investment in spare parts inventory of $23957, along with an additional $1751 in inventory for each succeeding year of the project. The shop's discount rate is 9 percent. What is the NPV for this project? (Round your final answer to the nearest dollar amount. Omit the "$" sign and commas in your response. For example, $123,456.78 should be entered as 123457.)
A)
Given in Question: | Amount $ | |
a. | Operating Cash Flow (OCF = Earnings Before Interest & Taxes (EBIT) + Depreciation - Taxes) in Year 0 | - |
b. | Increase in Fixed Assets = Basic Price of Machine : | |
Basic Price of Truck | 5,09,885 | |
Total Net Capital Spending | 5,09,885 | |
Since, this is an cash outflow, the sign is negative | -5,09,885 | |
c. | Annual Savings | 2,06,540 |
d. | Salvage Value | 91,777 |
e. | MACRS rates for years 1-5 | |
Year 1 | 20.00% | |
Year 2 | 32.00% | |
Year 3 | 19.20% | |
Year 4 | 11.52% | |
Year 5 | 11.52% | |
Year 6 | 5.76% | |
f. | Tax Rate | 34% |
Operating Cash Flow (OCF) Calculations | Amounts in US $ | |||||
S.No. | Particulars | Cf 0 | Cf1 | Cf2 | Cf3 | Cf4 |
A | Savingsfrom purchase of new machine | - | 2,06,540 | 2,06,540 | 2,06,540 | 2,06,540 |
Less: | ||||||
B. | Additional costs from new machine | - | - | - | - | - |
C. | Depreciation on new machine | - | 1,01,977 | 1,63,163 | 97,898 | 58,739 |
D. | Earnings Before Interest & Taxes (EBIT): A-B-C | - | 1,04,563 | 43,377 | 1,08,642 | 1,47,801 |
E | Taxes @ 34% | - | 35,551 | 14,748 | 36,938 | 50,252 |
F | Net After Tax Savings ( D - E) | - | 69,012 | 28,629 | 71,704 | 97,549 |
G | Add: Depreciation | - | 1,01,977 | 1,63,163 | 97,898 | 58,739 |
H | Operating Cash Flow (OCF) ( F + G) Answer | - | 1,70,989 | 1,91,792 | 1,69,602 | 1,56,288 |
Less: | ||||||
I | Change in Net Fixed Assets (See Note 1) | 5,09,885 | - | - | -90,530 | |
J | Increase in Working Capital | - | - | - | - | |
K | Cash Flow From Assets ( H+I+J) | -5,09,885 | 1,70,989 | 1,91,792 | 1,69,602 | 2,46,817 |
Note 1 | Calculation of Change in Net Fixed Assets ( Salvage Value) in year 4: | |
Amount in US $ | ||
i | Salvage value | 91,777 |
ii | Tax on Salvage Value - See Note 2 | 1,247 |
iii | Working Capital Returned (assumed as project concludes in year 3) | - |
Additional Cash Flow in Year 4 (i-ii+iii) | 90,530 | |
Note 2 | Tax on Salvage value is computed as under: | |
Salvage value | 91,777 | |
Less: | ||
Depreciation @ 11.52% & 5.76% in Year 5 & 6 on Basic Asset price $ 509,885 | 88,108 | |
Salvage Value less Depreciation | 3,669 | |
Tax @ 34% on Salvage Value less Depreciation | 1,247 |
Q B
Given in Question: | Amount $ | |||||
a. | Operating Cash Flow (OCF = Earnings Before Interest & Taxes (EBIT) + Depreciation - Taxes) in Year 0 | - | ||||
b. | Increase in Fixed Assets = Basic Price of Machine : | |||||
Basic Price of Truck | 5,34,819 | |||||
Total Net Capital Spending | 5,34,819 | |||||
Since, this is an cash outflow, the sign is negative | -5,34,819 | |||||
c. | Initial Spares Inventory | 23,957 | ||||
d. | Salvage Value | 91,777 | ||||
f. | Shop's Discount Rate | 9% | ||||
Operating Cash Flow (OCF) Calculations | Amounts in US $ | |||||
S.No. | Particulars | Cf 0 | Cf1 | Cf2 | Cf3 | Cf4 |
H | Operating Cash Flow (OCF) -Given | - | 1,73,439 | 1,95,137 | 1,76,990 | 1,66,535 |
I | Additional working capital required (Spares Inv) | 1,751 | 1,751 | 1,751 | 1,751 | |
J | Net Cash Flow ( H-I) | 1,71,688 | 1,93,386 | 1,75,239 | 1,64,784 | |
Less: | Terminal Cash Flows: | |||||
K | Change in Net Fixed Assets (See Note 1) | 5,34,819 | - | - | -85,560 | |
L. | Increase in Working Capital | 23,957 | -30,961 | |||
M. | Cash Flow From Assets ( H+I+J) | -5,58,776 | 1,73,439 | 1,95,137 | 1,76,990 | 2,83,056 |
N | Discounted Cash Flow | -5,58,776 | 1,59,118 | 1,64,243 | 1,36,669 | 2,00,524 |
O | Net Present Value (Sum of Discounted Cash Flows) | 1,01,778 | Answer |