demonstration problem chapter 16 – exercise 17 calculate npv – compare to irr accounting what...
TRANSCRIPT
![Page 1: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/1.jpg)
Demonstration Problem
Chapter 16 – Exercise 17
Calculate NPV – Compare to IRR
AccountingWhat the Numbers Mean 9e
![Page 2: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/2.jpg)
Problem Definition
• Sun Bay Manufacturing, Ltd. Is considering the investment of $230,000 in a new machine. The machine will generate cash flow of $40,000 per year for each year of its eight-year life and will have a salvage value of $26,000 at the end of its life. The company’s cost of capital is 10%.
![Page 3: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/3.jpg)
Problem Requirements
a. Calculate the net present value of the proposed investment. (Ignore income taxes.)
b. What will the internal rate of return on this investment be relative to the cost of capital? Explain your answer.
![Page 4: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/4.jpg)
Problem Solution
a. Calculate the net present value of the proposed investment. (Ignore income taxes.)
Set up a model for analyzing the timing of cash flows and enter all cash flows generated
by this project.
![Page 5: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/5.jpg)
• Model for analyzing project cash flows:
Problem Solution
Solution Steps:Step 1 – Setup the project years and cash flow items.
![Page 6: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/6.jpg)
• Model for analyzing project cash flows:
Problem Solution
Solution Steps:Step 1 – Setup the project years and cash flow items.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 7: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/7.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment
Solution Steps:Step 1 – Setup the years and cash flow items.
Solution Steps:Step 1 – Setup the project years and cash flow items.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 8: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/8.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment Annual cash flow
Solution Steps:Step 1 – Setup the years and cash flow items.
Solution Steps:Step 1 – Setup the project years and cash flow items.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 9: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/9.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment Annual cash flow Salvage value
Solution Steps:Step 1 – Setup the years and cash flow items.
Solution Steps:Step 1 – Setup the project years and cash flow items.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 10: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/10.jpg)
• Model for analyzing project cash flows:
Problem Solution
InvestmentAnnual cash flow Salvage value
Solution Steps:Step 2 – Enter all cash flow amounts.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 11: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/11.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow Salvage value
Solution Steps:Step 2 – Enter investment amount.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 12: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/12.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value
Solution Steps:Step 2 – Enter annual cash flow amount.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 13: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/13.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
Solution Steps:Step 2 – Enter salvage value amount.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 14: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/14.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
Solution Steps:Step 3 – Calculate the present value of the cash flows.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 15: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/15.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
Present Value:
$(230,000)Solution Steps:Step 3 – Calculate the present value of the cash flows.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 16: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/16.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
x 5.3349Present Value:
$(230,000) 213,396 PV factor – Table 6-5:
8 period row, 10% column
Solution Steps:Step 3 – Calculate the present value of the cash flows.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 17: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/17.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
x 5.3349 x .4665Present Value:
$(230,000) 213,396 12,129 PV factor – Table 6-4:
8 period row, 10% column
Solution Steps:Step 3 – Calculate the present value of the cash flows.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 18: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/18.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
x 5.3349 x .4665Present Value:
$(230,000) 213,396 12,129
Solution Steps:Step 4 – Calculate the net present value of the proposed investment.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 19: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/19.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
x 5.3349 x .4665Present Value:
$(230,000) 213,396 12,129 $ (4,475)
Net Present Value
Solution Steps:Step 4 – Calculate the net present value of the proposed investment.
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 20: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/20.jpg)
• Model for analyzing project cash flows:
Problem Solution
Investment $(230,000)Annual cash flow $40,000Salvage value $26,000
x 5.3349 x .4665Present Value:
$(230,000) 213,396 12,129 $ (4,475)
Solution:Since the NPV is negative, the investment does not earn the 10% cost of capital. Net Present Value
Year: 0 – 1 – 2 – 3 – 4 – 5 – 6
![Page 21: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/21.jpg)
Problem Requirements
a. Calculate the net present value of the proposed investment. (Ignore income taxes.)
b. What will the internal rate of return on this investment be relative to the cost of capital? Explain your answer.
![Page 22: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/22.jpg)
Problem Solution
Because the net present value is negative, the internal rate of return on this project will be lower than the cost
of capital of 10%.
![Page 23: Demonstration Problem Chapter 16 – Exercise 17 Calculate NPV – Compare to IRR Accounting What the Numbers Mean 9e](https://reader035.vdocuments.us/reader035/viewer/2022081414/55147365550346414e8b61d5/html5/thumbnails/23.jpg)
AccountingWhat the Numbers Mean 9e
David H. MarshallWayne W. McManus
Daniel F. Viele
You should now have a better understanding ofnet present value and internal rate of return.
Remember that there is a demonstration problem for each chapter that is here for your learning benefit.