please give a written answer, please do not use excel as it has to be written out. thank you.
Answer:
Cash flow in Year 1 = $42,180
Working Notes:
Year 1 | Year 2 | Year 3 | Year 4 | ||
Incremental Revenue | [1] | 50,000.00 | 50,000.00 | 50,000.00 | 50,000.00 |
Incremental Cost | [2] | 5,000.00 | 5,000.00 | 5,000.00 | 5,000.00 |
Depreciation | [3] | 37,950.00 | 51,750.00 | 17,250.00 | 8,050.00 |
EBIT | [4] =[ 1-2-3] | 7,050.00 | (6,750.00) | 27,750.00 | 36,950.00 |
Taxes | [5]=[4*40%] | 2,820.00 | - | 11,100.00 | 14,780.00 |
Net Income | [6]=[4-5] | 4,230.00 | (6,750.00) | 16,650.00 | 22,170.00 |
OCF | [7]=[6+3] | 42,180.00 | 45,000.00 | 33,900.00 | 30,220.00 |
Depreciation rate under 5 year MACRS | ||||
Years | Depreciation rate | Equipment Value | Depreciation Expense | Asset Value |
1 | 33% | $ 115,000.00 | $ 37,950.00 | $ 77,050.00 |
2 | 45% | $ 115,000.00 | $ 51,750.00 | $ 25,300.00 |
3 | 15.00% | $ 115,000.00 | $ 17,250.00 | $ 8,050.00 |
4 | 7.00% | $ 115,000.00 | $ 8,050.00 | $ - |
Terminal Non operating cash flow at the end of 3rd Year.
Terminal Cash flow = $15,220/-
Working Note:
Terminal flow (Y3) | |
Salvage value after tax | 12,220.00 |
Add recapture of working capital | 3,000.00 |
Total terminal flow | 15,220.00 |
Tax on salvage value:
Step 1: Ascertain the profit on sale of asset (Profit = salvage value - book value)
Step 2:Calculate tax on the profit
Salvage Value = 15,000
Book Value = 8,050
Profit = 15000-8050 = 6,950
Tax = 6,950*40% = 2,780.
Salvage value after tax = 15000-2780 = 12,220.
please give a written answer, please do not use excel as it has to be written...
please write out answer do not use excel please. Your company is considering expanding operations and buying a new machine to handle the increased volume. The machine's basic price is $100,000, and it will cost another $15,000 to modify it for special use by your firm. The machine falls into the MACRS three-year class, and it will be sold after three years for $15,000. Use of the machine will require an increase in net working capital (inventory) of $3,000. The...
Your company is considering expanding operations and buying a new machine to handle the increased volume. The machine's basic price is $100,000, and it will cost another $15,000 to modify it for special use by your firm. The machine falls into the MACRS three-year class, and it will be sold after three years for $15,000. Use of the machine will require an increase in net working capital (inventory) of $3,000. The machine will increase revenues by $50,000 per year, and...
Please use Excel spreadsheets to analyze problems EI, E2, and E3. On the spreadsheet please show all inputs and work clearly. Attach the spreadsheet output with the rest of your homework. E1) The Harris Company is evaluating the proposed acquisition of a spectrometer for the firm's R&D department. The equipment's base price is $140,000, and it would cost another $30,000 to modify it for special use by the firm. The spectrometer, which falls into the MACRS 3-year class, would be...
13-7 New-Project Analysis The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm's RAD depart- ment. The equipment's basic price is $70,000, and it would cost another $15,000 to modify it for special use by your firm. The chromatograph, mwhich falls into the MACRS 3-year class, would be sold after 3 years for $30,000. The MACRS rates for the first 3 years are 0.3333, 0.4445, and 0.1481....
with work please The president of Real Time Inc. has asked you to evaluate the proposed acquisition of a new computer. The computer's price is $50,000, and it falls into the MACRS 3-year class. Purchase of the computer would require an increase in spare parts inventory of $3,000. Accounts payable will also increase by $2,000 The computer would increase the firm's before-tax revenues by $20,000 per year but would also increase operating costs by $5,000 per year. Annual interest expense...
Problem 11-07 New-Project Analysis The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $150,000, and it would cost another $22,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $52,500. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481....
You are evaluating a potential investment in equipment. The equipment's basic price is $187,000, and shipping costs will be $3,700. It will cost another $22,400 to modify it for special use by your firm, and an additional $9,400 to install it. The equipment falls in the MACRS 3-year class that allows depreciation of 33% the first year, 45% the second year, 15% the third year, and 7% the fourth year. You expect to sell the equipment for 24,500 at the...
The president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm's R&D department. The equipment's basic price is $150,000, and it would cost another $22,500 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year dass, would be sold after 3 years for $37,500. The MACRS rates for the first 3 years are 0.3333, O.4445 and 0.1481. use of the equinet...
You are evaluating a potential investment in equipment. The equipment's basic price is $158,000, and shipping costs will be $6,300. It will cost another $15,800 to modify it for special use by your firm, and an additional $7,900 to install it. The equipment falls in the MACRS 3-year class that allows depreciation of 33% the first year, 45% the second year, 15% the third year, and 7% the fourth year. You expect to sell the equipment for 26,300 at the...
he president of the company you work for has asked you to evaluate the proposed acquisition of a new chromatograph for the firm’s R&D department. The equipment's basic price is $80,000, and it would cost another $20,000 to modify it for special use by your firm. The chromatograph, which falls into the MACRS 3-year class, would be sold after 3 years for $37,000. The MACRS rates for the first 3 years are 0.3333, 0.4445 and 0.1481. Use of the equipment...