Degnan Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine.
Existing Machine
Cost = $100,000
Purchased 2 years ago
Depreciation using MACRS over 5-year recovery schedule
Current market value = $105,000
Five year usable life remaining
Proposed Machine
Cost = $150,000
Installaion = $20,000
Depreciation - the MACRS a 5-year recovery schedule will be used
Five year usable life expected
Earnings before Depreciation and Taxes
Existing Machine
Year
1 $160,000
2 $150,000
3 $140,000
4 $140,000
5 $140,000
Proposed Machine
1 $170,000
2 $170,000
3 $170,000
4 $170,000
5 $170,000
The firm pays 40% taxes on ordinary income and capital gains
CALCULATE/SUMMARIZE THE INCREMENTAL AFTER-TAX CASH FLOW (RELEVANT CASH FLOWS) FOR YEARS t=0 THROUGH t=5
please show all work and steps to solution. Thanks!
Degnan Dance Company, Inc., a manufacturer of dance and exercise apparel, is considering replacing an existing piece of equipment with a more sophisticated machine.
Existing Machine
Cost = $100,000
Purchased 2 years ago
Depreciation using MACRS over 5-year recovery schedule
Current market value = $105,000
Five year usable life remaining
Proposed Machine
Cost = $150,000
Installaion = $20,000
Depreciation - the MACRS a 5-year recovery schedule will be used
Five year usable life expected
Earnings before Depreciation and Taxes
Existing Machine
Year
1 $160,000
2 $150,000
3 $140,000
4 $140,000
5 $140,000
Proposed Machine
1 $170,000
2 $170,000
3 $170,000
4 $170,000
5 $170,000
The firm pays 40% taxes on ordinary income and capital gains
CALCULATE/SUMMARIZE THE INCREMENTAL AFTER-TAX CASH FLOW (RELEVANT CASH FLOWS) FOR YEARS t=0 THROUGH t=5
please show all work and steps to solution. Thanks!
Related questions
Arnold fitness company a manufacturer of weights and exercise equipment is considering replacing an old workout equipment with a new one. Use the following information: The firm pays 40 perecent taxes on ordinary income and capital gains.
table one:
| existing machine | proposed machine | |
| costs | 150,000.00 | 180,000.00 |
| installation | 10,000.00 | 20,000.00 |
| MACRS | 5 years | 5 years |
| Market Value | 105,000.00 | |
| Purchased | 2 years |
Table Two forecasted Revenues Forecasted expenses (no depreciation)
| year | existing machine old | proposed machine | year | existing machine one | proposed machine |
| 1 | 160,000.00 | 175,000.00 | 1 | 104,000.00 | 110,500.00 |
| 2 | 150,000.00 | 170,000.00 | 2 | 104,000.00 | 110,500.00 |
| 3 | 140,000.00 | 174,000.00 | 3 | 104,000.00 | 110,500.00 |
| 4 | 140,000.00 | 170,000.00 | 4 | 104,000.00 | 110,500.00 |
| 5 | 140,000.00 | 173,000.00 | 5 | 104,000.00 | 110,500.00 |
Question#1 Given the information in table #1 compute the initial investment?
Question#2 Given the infrmation in table #2 compute the incremental annual cash flow?
Question#3 Given information from table#1 assuming 12.5 rate of return what is the NPV on the PROPOSED MACHINE? Which reference table do you use PVIFA-T5 or PVIF T-3 to solve the problem?
IntegrativeâDetermining relevant cash flows Atlantic Dry dock is considering replacing an existing hoist with one of two newer, more efficient pieces of equipment. The existing hoist is 3 years old, cost $31,500, and is being depreciated under MACRS using a 5-year recovery period. Although the existing hoist has only 3 years (years 4, 5, and 6) of depreciation remaining under MACRS, it has a remaining usable life of 5 years. Hoist A, one of the two possible replacement hoists, costs $39,500 to purchase and $8,500 to install. It has a 5-year usable life and will be depreciated under MACRS using a 5-year recovery period. The other hoist, B, costs $54,900 to purchase and $5,800 to install. It also has a 5-year usable life and will be depreciated under MACRS using a 5-year recovery period. Increased investments in net working capital will accompany the decision to acquire hoist A or hoist B. Purchase of hoist A would result in a $4,200 increase in net working capital; hoist B would result in a $5,500 increase in net working capital. The projected profits before depreciation and taxes with each alternative hoist and the existing hoist are given in the following table.
| Earning before depreciation,interest,and taxes | |||
| year | with hoist A | with hoist B | WITH EXISTING HOIST |
| 1 | 20,700 | 21,700 | 14,900 |
| 2 | 20,700 | 24,000 | 14,900 |
| 3 | 20,700 | 25,400 | 14,900 |
| 4 | 20,700 | 25,400 | 14,900 |
| 5 | 20,700 | 25,400 | 14,900 |
The existing hoist can currently be sold for $18,600 and will not incur any removal or cleanup costs. At the end of 5 years, the existing hoist can be sold to net $1,400 before taxes. Hoists A and B can be sold to net $11,500 and $21,000 before taxes, respectively, at the end of the 5-year period. The firm is subject to a 40% tax rate on both ordinary income and capital gains. (Table 3.2 on page 100 contains the applicable MACRS depreciation percentages.)
| Rounded Depreciation Percentages by Recovery Year Using MACRS for | ||||
| Percentage by recovery year* | ||||
| Recovery year | 3 years | 5 years | 7 years | 10 years |
| 1 | 33% | 20% | 14% | 10% |
| 2 | 45% | 32% | 25% | 18% |
| 3 | 15% | 19% | 18% | 14% |
| 4 | 7% | 12% | 12% | 12% |
| 5 | 12% | 9% | 9% | |
| 6 | 5% | 9% | 8% | |
| 7 | 9% | 7% | ||
| 8 | 4% | 6% | ||
| 9 | 6% | |||
| 10 | 6% | |||
| 11 | 4% | |||
| Totals | 100% | 100% | 100% | 100% |
Calculate only Hoist B (Ignore Hoist A).
a) Calculate the NPV, IRR, Payback Period and Discounted Payback Period (the cost of capital of 10%)
b)By using you own assumption or probability of occurring for new machine only (others remain unchanged), prepare a scenario analysis and recalculate the incremental operating cash inflow for year 1 to 5 associated with the proposed replacement.
Please show all the step and calculation (thank you)
