Question

18. Problem 12.18 (Scenario Analysis) eBook Your firm, Agrico Products, is considering a tractor that would have a cost of $3

0 0
Add a comment Improve this question Transcribed image text
Answer #1
A] LIFE - 5 YEARS: 0 1 2 3 4 5
Annual cash flows before tax $ 13,000.00 $   13,000.00 $ 13,000.00 $ 13,000.00 $13,000.00
Depreciation $   7,000.00 $     7,000.00 $    7,000.00 $    7,000.00 $   7,000.00
NOI $   6,000.00 $     6,000.00 $    6,000.00 $    6,000.00 $   6,000.00 `
Tax at 40% $   2,400.00 $     2,400.00 $    2,400.00 $    2,400.00 $   2,400.00 `
NOPAT $   3,600.00 $     3,600.00 $    3,600.00 $    3,600.00 $   3,600.00
Add: Depreciation $   7,000.00 $     7,000.00 $    7,000.00 $    7,000.00 $   7,000.00
OCF $ 10,600.00 $   10,600.00 $ 10,600.00 $ 10,600.00 $10,600.00
Capital expenditure $   35,000.00
After tax cash flows $ -35,000.00 $ 10,600.00 $   10,600.00 $ 10,600.00 $ 10,600.00 $10,600.00
PVIF at 12% 1 0.89286 0.79719 0.71178 0.63552 0.56743
PV at 12% $ -35,000.00 $   9,464.29 $     8,450.26 $    7,544.87 $    6,736.49 $   6,014.72 $           3,210.63
NPV $     3,210.63
B] LIFE - 4 YEARS: 0 1 2 3 4
Annual cash flows before tax $ 13,000.00 $   13,000.00 $ 13,000.00 $ 13,000.00
Depreciation $   7,000.00 $     7,000.00 $    7,000.00 $    7,000.00
NOI $   6,000.00 $     6,000.00 $    6,000.00 $    6,000.00
Tax at 40% $   2,400.00 $     2,400.00 $    2,400.00 $    2,400.00
NOPAT $   3,600.00 $     3,600.00 $    3,600.00 $    3,600.00
Add: Depreciation $   7,000.00 $     7,000.00 $    7,000.00 $    7,000.00
OCF $ 10,600.00 $   10,600.00 $ 10,600.00 $ 10,600.00
Capital expenditure $   36,000.00
Tax shield on scapping = 7000*40% = $    2,800.00
After tax cash flows $ -36,000.00 $ 10,600.00 $   10,600.00 $ 10,600.00 $ 13,400.00
PVIF at 12% 1 0.89286 0.79719 0.71178 0.63552
PV at 12% $ -36,000.00 $   9,464.29 $     8,450.26 $    7,544.87 $    8,515.94 $ -2,024.65
NPV $   -2,024.65
C] LIFE - 8 YEARS: 0 1 2 3 4 5 6 7 8
Annual cash flows before tax $ 13,000.00 $   13,000.00 $ 13,000.00 $ 13,000.00 $13,000.00 $        13,000.00 $      13,000.00 $       13,000.00
Depreciation $   7,000.00 $     7,000.00 $    7,000.00 $    7,000.00 $   7,000.00 $                        -   $                     -   $                       -  
NOI $   6,000.00 $     6,000.00 $    6,000.00 $    6,000.00 $   6,000.00 $        13,000.00 $      13,000.00 $       13,000.00
Tax at 40% $   2,400.00 $     2,400.00 $    2,400.00 $    2,400.00 $   2,400.00 $           5,200.00 $        5,200.00 $          5,200.00
NOPAT $   3,600.00 $     3,600.00 $    3,600.00 $    3,600.00 $   3,600.00 $           7,800.00 $        7,800.00 $          7,800.00
Add: Depreciation $   7,000.00 $     7,000.00 $    7,000.00 $    7,000.00 $   7,000.00 $                        -   $                     -   $                       -  
OCF $ 10,600.00 $   10,600.00 $ 10,600.00 $ 10,600.00 $10,600.00 $           7,800.00 $        7,800.00 $          7,800.00
Capital expenditure $   36,000.00
After tax cash flows $ -36,000.00 $ 10,600.00 $   10,600.00 $ 10,600.00 $ 10,600.00 $10,600.00 $           7,800.00 $        7,800.00 $          7,800.00
PVIF at 12% 1 0.89286 0.79719 0.71178 0.63552 0.56743 0.50663 0.45235 0.40388
PV at 12% $ -36,000.00 $   9,464.29 $     8,450.26 $    7,544.87 $    6,736.49 $   6,014.72 $           3,951.72 $        3,528.32 $          3,150.29 $ 12,840.96
NPV $   12,840.96
D] Expected NPV = (3210.63-2024.65+12840.96)/3 = $     4,675.65
Add a comment
Know the answer?
Add Answer to:
18. Problem 12.18 (Scenario Analysis) eBook Your firm, Agrico Products, is considering a tractor that would...
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
  • SCENARIO ANALYSIS Your firm, Agrico Products, is considering a tractor that would have a cost of...

    SCENARIO ANALYSIS Your firm, Agrico Products, is considering a tractor that would have a cost of $36,000, would increase pretax operating cash flows before taking account of depreciation by $11,000 per year, and would be depreciated on a straight-line basis to zero over 5 years at the rate of $7,200 per year beginning the first year. (Thus, annual cash flows would be $11,000 before taxes plus the tax savings that result from $7,200 of depreciation.) The managers disagree about whether...

  • Your firm, Agrico Products, is considering a tractor that would have a cost of $35,000, would...

    Your firm, Agrico Products, is considering a tractor that would have a cost of $35,000, would increase pretax operating cash flows before taking account of depreciation by $12,000 per year, and would be depreciated on a straight-line basis to zero over 5 years at the rate of $7,000 per year beginning the first year. (Thus, annual cash flows would be $12,000 before taxes plus the tax savings that result from $7,000 of depreciation.) The managers disagree about whether the tractor...

  • This is all the info given. Parts A-D were incorrect. SCENARIO ANALYSIS Your firm, Agrico Products,...

    This is all the info given. Parts A-D were incorrect. SCENARIO ANALYSIS Your firm, Agrico Products, is considering a tractor that would have a cost of $37,000, would increase pretax operating cash flows before taking account of depreciation by $11,000 per year, and would be depreciated on a straight-line basis to zero over 5 years at the rate of $7,400 per year beginning the first year. (Thus, annual cash flows would be $11,000 before taxes plus the tax savings that...

  • A farmer has a choice of purchasing three tractors. Tractor A costs $20,000, Tractor B costs...

    A farmer has a choice of purchasing three tractors. Tractor A costs $20,000, Tractor B costs $22,000 and Tractor C costs $25,000. Each tractor has different benefits, as stated below. If the farmer's Minimum Attractive Rate of Return (MARR) is 10%, what is the NPV of the most economic plan? Do a pre-tax analysis using NPV. Tractor A: Benefits of $5,010 per year for 5 years Tractor B: Benefits of $4,000 per year for 4 years and $16,000 at end...

  • Problem 2 Gwynedd Valley Farms purchased a new tractor for $30,000. They estimated the tractor would...

    Problem 2 Gwynedd Valley Farms purchased a new tractor for $30,000. They estimated the tractor would have a useful life of 5 years and would have a salvage value of $5,000. Gwynedd Valley uses the straight line method and the half year convention. Gwynedd Valley sold the tractor during year 3 for $18,000. Required: Compute the amount of depreciation expense to be taken in Years, 1, 2 and 3. Year 1____________ Year 2____________ Year 3____________ Prepare the journal entry to...

  • New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax...

    New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the project's 5-year...

  • nd of Chapter Problem Assignment eBook Problem Walk-Through New-Project Analysis The president of your company, MorChuck...

    nd of Chapter Problem Assignment eBook Problem Walk-Through New-Project Analysis The president of your company, MorChuck Enterprises, 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 $73,000, and it would cost another $18,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 $33,500. The MACRS rates for the first three years...

  • Problem 11-12 New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would...

    Problem 11-12 New-Project Analysis Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the...

  • Problem 11-04 (Replacement Analysis) Question 5 of 9 Check My Work (1 remaining) eBook Replacement Analysis...

    Problem 11-04 (Replacement Analysis) Question 5 of 9 Check My Work (1 remaining) eBook Replacement Analysis Although the Chen Company's milling machine is old, it is still in relatively good working order and would last for another 10 years. It is inefficient compared to modern standards, though, and so the company is considering replacing it. The new milling machine, at a cost of $114,000 delivered and installed, would also last for 10 years and would produce after-tax cash flows (labor...

  • Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs...

    Madison Manufacturing is considering a new machine that costs $350,000 and would reduce pre-tax manufacturing costs by $110,000 annually. Madison would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $33,000 at the end of its 5-year operating life. The applicable depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%. Working capital would increase by $35,000 initially, but it would be recovered at the end of the project's 5-year life. Madison's...

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