Question

Your company is considering expanding operations and buying a new machine to handle the increased volume. The machines basic

- $118,000

This is a continuation of the prior problem: Your company is considering expanding operations and buying a new machine to han

$45,000 $4,320 | $42,180 | $27,000

This is a continuation of the prior problem: Your company is considering expanding operations and buying a new machine to han

$12,220 $25,000 $15,000 $15,220

please give a written answer, please do not use excel as it has to be written out. thank you.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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.

Add a comment
Know the answer?
Add Answer to:
please give a written answer, please do not use excel as it has to be written...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • please write out answer do not use excel please. Your company is considering expanding operations and...

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

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

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

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

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

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

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

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

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

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT