Question

Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firms average project. Bellingers WACC is 8%. 0 2 3 4 190 240 Project A-1,150 Project B 1,150 650 395 250 330 340 690 What is Project As NPV? Round your answer to the nearest cent. Do not round your intermediate calculations. show All Feedback What is Project Bs NPV? Round your answer to the nearest cent. Do not round your intermediate calculations
0 0
Add a comment Improve this question Transcribed image text
Answer #1

We shall use excel to calculate the same:

Year Project A Project B
0 $ (1,150.00) $ (1,150.00)
1 $       650.00 $       250.00
2 $       395.00 $       330.00
3 $       190.00 $       340.00
4 $       240.00 $       690.00
NPV $       117.74 $       141.48

Also we can use discount factors to calculate the present values and sum them up to get NPV

Year Project A Project B DF PV A PV B
0 $ (1,150.00) $ (1,150.00) 1 $ (1,150.00) $ (1,150.00)
1 $       650.00 $       250.00 0.925926 $       601.85 $       231.48
2 $       395.00 $       330.00 0.857339 $       338.65 $       282.92
3 $       190.00 $       340.00 0.793832 $       150.83 $       269.90
4 $       240.00 $       690.00 0.73503 $       176.41 $       507.17
NPV $       117.74 $       141.48 NPV $       117.74 $       141.48

The discount factors are calculated as:1/(1.08^n) where n is the year: Formula:(1/(1+r)^n). Here r is the WACC

Book1 - Excel Imran Khan File Home Insert Page Layout Formulas Revie View Add-ins HelpTell me what you want to do Share Comments Cut Σ AutoSum . A Merge & Center . | $ . % , Paste Conditional Format as Cell Formatting Table Styles nsert Delete Format ヴFormat Painter | B 1 u.1E- 2-△ Sort & Find & Filter-Select Clear- Clipboard Alignment Number Cells Editing SUM ear Project A Project B DF PVA PV B 1$(1,150.00(1,150.00) 1!$ 650.00|$ 250.00 0.925926 $ 601.85 $ 231.48 2 S 395.00 330.00 0.857339$ 338.65$ 282.92 3 190.00340.00 0.793832$ 150.83 $ 269.90 4 $ 240.00 $ 60.0.73503$176.41 507.17 o$(1,150.00 (1,150.00) 12 13 16 NPV 110+NPV(0.08,111:114) NPV$ 117.74$ 141.48 17 20 Shee O Type here to search S:05 AM rP ^ qxE ENG 1/25/2019Book1 - Excel Imran Khan File Home Insert Page Layout Formulas Revie View Add-ins HelpTell me what you want to do Share Comments Cut Σ AutoSum . A ドA Merge & Center . | $ . % , il Paste Conditional Format as Cell Formatting Table Styles nsert Delete Format Sort & Find & ヴFormat Painter | B 1 u.1E- 2-△ ClearFilter Select Clipboard Alignment Number Cells Editing SUM Yr Project A ect B DF PVA PV B 0 S(L150.00) S(1,150.00) 1$(1,150.00(1,150.00) 1 $ 650.00250.00 0.92592$ 601.85 231.48 2 S 395.00 330.00 0.857339$ 338.65$ 282.92 3 190.00 340.00 0.793832$ 150.83 $ 269.90 4 $ 240.00 $ 690.000.73503$176.41 507.17 12 13 16 NPV $ 117. 741=110+NPV(0.0&J11:J14) $ 141.48 17 Screenshot saved The screenshot was added to your OneDrive. 20 Shee S:05 AM O Type here to search

Add a comment
Know the answer?
Add Answer to:
Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...
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
  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 10%. 0 1 2 3 4 Project A...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 10%. 690 320 Project A Project B -1,100...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 7%. 0 1 2 3 4 Project A...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC IS 7% 320 Project A Project B -1,120 -1,120...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 7%. 3 Project A -1,020 670 310 240...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects after tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC 7. Project A -910 620 335 270 320...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 8%. 330 365 Project A -1,150 700 430...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 7%. 1 2 4. Project A Project B...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the timeline below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 8%. 0 1 2 3 4 Project A -1,140...

  • Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you...

    Quantitative Problem: Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 8%. 0 1 2 3 4 Project A...

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