Question

In: Finance

A) Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying...

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.)

Solutions

Expert Solution

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

Related Solutions

Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a...
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $490,847 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 $86,695. The OCFs of the project during the 4 years are $175,493, $191,453, $170,805 and $167,265, respectively. The press also requires an initial investment in spare parts inventory of $25,940, along with...
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a...
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $530,000 is estimated to result in $220,000 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 $89,000. The press also requires an initial investment in spare parts inventory of $26,000, along with an additional $3,100 in inventory for each succeeding year of...
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a...
Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $589,114 is estimated to result in $190,416 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 $109,288. The shop's tax rate is 29 percent. What is the OCF for year 4? (Round your final answer to the nearest dollar amount. Omit the...
Massey Machine Shop is considering a four year project to improve its production efficiency. Buying a...
Massey Machine Shop is considering a four year project to improve its production efficiency. Buying a new machine press for $730,000 is estimated to result in $220,000 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 $89,000. The press also requires an initial investment in spare parts inventory of $26,000, along with an additional $3,000 in inventory for each succeeding year...
Massey Machine Shop is considering a four year project to improve its production efficiency. Buying a...
Massey Machine Shop is considering a four year project to improve its production efficiency. Buying a new machine press for $730,000 is estimated to result in $220,000 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 $89,000. The press also requires an initial investment in spare parts inventory of $26,000, along with an additional $3,000 in inventory for each succeeding year...
CMS Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
CMS Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $545,000 is estimated to result in $97,000 in annual pretax cost savings. The press falls in the MACRS five-year class, and it will have a salvage value of $70,000. The press also requires an initial working capital of $21,000, along with an additional $3,000 in working capital for each succeeding years of project. The tax rate is 34%, and the company's...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $390,000 is estimated to result in $150,000 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 $66,000. The press also requires an initial investment in spare parts inventory of $12,000, along with an additional $1,700 in inventory for each succeeding year of the...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $1,132,800 is estimated to result in $377,600 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $165,200. The press also requires an initial investment in spare parts inventory of $47,200, along with an additional $7,080 in inventory for each succeeding year...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geller Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $480,000 is estimated to result in $195,000 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 $81,000. The press also requires an initial investment in spare parts inventory of $21,000, along with an additional $2,600 in inventory for each succeeding year of the...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new...
Geary Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $950,400 is estimated to result in $316,800 in annual pretax cost savings. The press falls in the MACRS five-year class (MACRS Table), and it will have a salvage value at the end of the project of $138,600. The press also requires an initial investment in spare parts inventory of $39,600, along with an additional $5,940 in inventory for each succeeding year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT