Year | MACRS | Depreciation | Book Value |
---|---|---|---|
1 | 33% | 221,100 | 448,900 |
2 | 45 | 301,500 | 147,400 |
3 | 15 | 100,500 | 46,900 |
4 | 7 | 46,900 | 0 |
100 | 670,000 |
See years 1 and 4 as examples in Table 1. In year 1, 3 X 425,000 = 1,275,000 – 637,500 – 221,100 – 20,000 = 396,400 – 158,560 = 237,840 + 221,100 = 458,940 = project NCF = after tax, end-of-year cash inflows, CFt. In year 4, 3 X 425,000 = 1,275,000 – 637,500 – 46,900 – 20,000 = 570,600 – 228,240 = 342,360 + 46,900 = 389,260.
Should the project be undertaken? Fill in X's
Y 0 | Y 1 | Y 2 | Y 3 | Y 4 | |
---|---|---|---|---|---|
Unit Price |
$3 | X | X | $3 | |
Unit Sales | 425,000 | x | x | 425,000 | |
Revenues | 1,275,000 | X | X | 1,275,000 | |
Operating Costs | 637,500 | X | X | 637,500 | |
Depreciation | 221,100 | X | X | 46,900 | |
Other Project Effects | 20,000 | X | X | 20,000 | |
Before tax income | 396,400 | X | X | 570,600 | |
Taxes | 158,560 | X | X | 228,240 | |
Net Income | 237,840 | X | X | 342,360 | |
Plus Depreciation | 221,100 | X | X | 46,900 | |
Net Op Cash Flow | 458,940 | X | X | 389,260 | |
Salvage Value | 100,000 | ||||
SV Tax | X | ||||
Recovery of NWC | X | ||||
Termination CF | X | ||||
Project NCF | X | X | X | X | X |
Particualrs | Year 1 | Year 2 | Year 3 | Year 4 |
Unit price | 3 | 3 | 3 | 3 |
Unit sales | 425000 | 425000 | 425000 | 425000 |
Revenue | 1275000 | 1275000 | 1275000 | 1275000 |
Opearting costs | 637500 | 637500 | 637500 | 637500 |
Depreciation | 221100 | 301500 | 100500 | 46900 |
Other project effect | 20000 | 20000 | 20000 | 20000 |
Before tax income | 396400 | 316000 | 517000 | 570600 |
Tax @ 40%(158560/396400) | 158560 | 126400 | 206800 | 228240 |
Income after tax before depreciation added back | 237840 | 189600 | 310200 | 342360 |
Net income (after deprn added back) | 458940 | 491100 | 410700 | 389260 |
Add salvage value at the end after tax@40%(100000*60%) | 60000 | |||
Projected cash flow | 458940 | 491100 | 410700 | 449260 |
Total cash inflow | 1810000 | |||
Total cash outflow | 670000 | |||
Net cashflow | 1140000 |
Conclusion : Since net cash flow is possitive it is better to accept this proposal
Table 1 Year MACRS Depreciation Book Value 1 33% 221,100 448,900 2 45 301,500 147,400 3...
Production facilities for the lite orange juice product would be set up in an unused section of Indian River's main plant. Although no one has expressed an interest in this portion of the plant, management wants to know how the analysis could incorporate the interest of another citrus in leasing the lite orange juice production site for $25,000 a year. Relatively inexpensive, used machinery with an estimated cost of only $500,000 would be purchased, but shipping costs to move the...
Please help
Year 0 1429% Year 1 24.49% MACRS Depreciation Rate Year 2 17.49% Year 3 12.49% Year 4 893% Year 5 8.92% Year 6 8.93% Year 7 4.46% Massive Amusements, an owner of theme parks, invests 566 million to build a roller coaster This can be depreciated using the MACRS schedule shown above How much less is the depreciation tax shield for year 4 under MACRS depreciation than under 7-year, straight-line depreciation, if the tax rate is 40%? O...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3 4 5 Sales 129,409.00 129,409.00 129,409.00 129,409.00 129,409.00 Cost of Goods 69,540.00 69,540.00 69,540.00 69,540.00 69,540.00 S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 Depreciation 20,465.20 20,465.20 20,465.20 20,465.20 20,465.20 Investment in NWC 1,014.00 582.00 582.00 582.00 582.00 582.00 Investment in Gross PPE 102,326.00 The firm has a capital structure of 41.00% debt and 59.00% equity. The cost of debt is 9.00%, while the cost of...
Consider the following project for Dawg Incorporated: YEAR 0 1 2 3 4 5 Sales $150,000 $150,000 $150,000 $150,000 $150,000 Cost of Goods $75,000 $75,000 $75,000 $75,000 $75,000 S&A $30,000 $30,000 $30,000 $30,000 $30,000 Depreciation $30,000 $30,000 $30,000 $30,000 $30,000 Investment in NWC $1,000 $500 $500 $500 $500 $5001 Investment in Gross PPE $150,000 The project will last 5 years and has the same risk as the typical Dawg Incorporated project. The firm has a capital structure of 40.00% debt...
Consider the following project for Dawg Incorporated: YEAR 0 1 2 3 4 5 Sales $150,000 $150,000 $150,000 $150,000 $150,000 Cost of Goods $65,000 $65,000 $65,000 $65,000 $65,000 S&A $30,000 $30,000 $30,000 $30,000 $30,000 Depreciation $30,000 $30,000 $30,000 $30,000 $30,000 Investment in NWC $1,000 $500 $500 $500 $500 $500 Investment in Gross PPE $150,000 The project will last 5 years and has the same risk as the typical Dawg Incorporated project. The firm has a capital structure of 30.00% debt and...
Consider the following project for Dawg Incorporated: YEAR 0 1 2 3 4 5 Sales $150,000 $150,000 $150,000 $150,000 $150,000 Cost of Goods $65,000 $65,000 $65,000 $65,000 $65,000 S&A $30,000 $30,000 $30,000 $30,000 $30,000 Depreciation $30,000 $30,000 $30,000 $30,000 $30,000 Investment in NWC $1,000 $500 $500 $500 $500 $500 Investment in Gross PPE $150,000 The project will last 5 years and has the same risk as the typical Dawg Incorporated project. The firm has a capital structure of 30.00% debt and...
Consider the following project for Dawg Incorporated: YEAR 0 1 2 3 4 5 Sales $150,000 $150,000 $150,000 $150,000 $150,000 Cost of Goods $70,000 $70,000 $70,000 $70,000 $70,000 S&A $30,000 $30,000 $30,000 $30,000 $30,000 Depreciation $30,000 $30,000 $30,000 $30,000 $30,000 Investment in NWC $1,000 $500 $500 $500 $500 $500 Investment in Gross PPE $150,000 The project will last 5 years and has the same risk as the typical Dawg Incorporated project. The firm has a capital structure of 40.00% debt and...
A firm has projected the following financials for a possible project: YEAR 0 1 2 3 5 4 Sales 134,994.00 134,994.00 134,994.00 134,994.00 134,994.00 Cost of Goods 62,673.00 62,673.00 62,673.00 62,673,00 62,673.00 S&A 30,000.00 30,000.00 30,000.00 30,000.00 30,000.00 Depreciation 21,318.60 21,318.60 21,318.60 21,318.60 21,318.60 Investment in NWC 1,044.00 558.00 558,00 558.00 558.00 558.00 Investment in Gross PPE 106,593.00 The firm has a capital structure of 36.00% debt and 64.00% equity. The cost of debt is 10.00%, while the cost of...
Complete the (4) depreciation tables/caclulations below using the following MACRS table: YEAR 3-YEAR 33.33% 44.45% 14.81% 7.41% 5-YEAR 20.00% 32.00% 19.20% 11.52% 11.52% 5.76% 7-YEAR 14.29% 24.49% 17.49% 12.49% 8.93% 8.92% 8.93% 4.46% 100.00% 100.00% 100.00% 1. During 2012, Axel Corporation purchases new machinery (5-year property) for $200,000 and decides not to take a Section 179 deduction. a. Computer maximum tax depreciation for the machinery for 2012-2017. Year Depreciation calculation Dep. Exp. 2012 2012 2013 2014 2015 2016 2017 Total...
i have doubt that it is given macrs depreciation for 3
years but rates are given for 4 years please clear my doubt thanks
in advance
The president of real-time Inc. has asked you to evaluate the proposed acquisition of a new computer. The computer price is $50,000 and it falls into MACRS-3 year class. The purchase of the computer would require an increase in spare parts inventory of $3,000. Account payables will also increase by $2,000. The computer would...