Law Week 10 Assignment- Healthcare Finance

USW1_MMHA_6400_Week10_HowToCalculateNPVandIRR.pdf

Home >Law homework help >Law Week 10 Assignment- Healthcare Finance

How to Calculate NPV and IRR Using the Present Value of an Annuity Table to Calculate NPV and IRR

When an organization’s leadership is looking to invest in a project, they need to know the project’s profitability potential. This is measured with net present value (NPV) and the internal rate of return (IRR). In many organizations, the accounting department is responsible for assembling their reports; however, a manager will be tasked with understanding the information gathered in those reports and making decisions based on that information. For this reason, it is crucial to have a solid understanding of accounting terms and concepts to effectively communicate to the financial team. Scenario: For this demonstration, refer to the Present Value of an Annuity, Receivable or Payable table (Table 1), which shows the year-end value of an annuity for years 1–20 with interest rates from 1% to 10%. Use this table to calculate net present value (NPV) using the steps that follow. Table 1. Present Value of an Annuity, Receivable or Payable (Year-End Values) 1%–10%

Periods

(n) Interest rates (r)

1% 2% 3% 4% 5% 6% 7% 8% 9% 10%

1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 2 1.970 1.942 1.913 1.886 1.859 1.833 1.808 1.783 1.759 1.736 3 2.941 2.884 2.829 2.775 2.723 2.673 2.624 2.577 2.531 2.487 4 3.902 3.808 3.717 3.630 3.546 3.465 3.387 3.312 3.240 3.170 5 4.853 4.713 4.580 4.452 4.329 4.212 4.100 3.993 3.890 3.791

6 5.795 5.601 5.417 5.242 5.076 4.917 4.767 4.623 4.486 4.355

7 6.728 6.472 6.230 6.002 5.786 5.582 5.389 5.206 5.033 4.868 8 7.652 7.325 7.020 6.733 6.463 6.210 5.971 5.747 5.535 5.335 9 8.566 8.162 7.786 7.435 7.108 6.802 6.515 6.247 5.995 5.759 10 9.471 8.983 8.530 8.111 7.722 7.360 7.024 6.710 6.418 6.145

11 10.368 9.787 9.253 8.760 8.306 7.887 7.499 7.139 6.805 6.495

12 11.255 10.575 9.954 9.385 8.863 8.384 7.943 7.536 7.161 6.814 13 12.134 11.348 10.635 9.986 9.394 8.853 8.358 7.904 7.487 7.103 14 13.004 12.106 11.296 10.563 9.899 9.295 8.745 8.244 7.786 7.367 15 13.865 12.849 11.938 11.118 10.380 9.712 9.108 8.559 8.061 7.606

16 14.718 13.578 12.561 11.652 10.838 10.106 9.447 8.851 8.313 7.824

17 15.562 14.292 13.166 12.166 11.274 10.477 9.763 9.122 8.544 8.022 18 16.398 14.992 13.754 12.659 11.690 10.828 10.059 9.372 8.756 8.201 19 17.226 15.679 14.324 13.134 12.085 11.158 10.336 9.604 8.950 8.365 20 18.046 16.351 14.878 13.590 12.462 11.470 10.594 9.818 9.129 8.514

First, calculate the net present value (NPV): Step 1: Gather the following information to calculate the net present value:

• Initial Cost (Outlay for Investment)

• Net Annual Cash Flow

• Factor (PV of annual cash flows discounted at interest rate)

• Interest Rate (Discount Rate)

• Useful Life (Period)

Step 2: Apply the following NPV formula for finding the Factor: NPV = Initial Cost + (Net Annual Cash Flow × Factor)

Step 3: Use the Annuity Table (Table 1) to find the intersection of the Cost of Capital (9%) and the Useful Life (20 years). This intersection is the Factor (9.129). Step 4: Input the known values into the formula using the following information:

• Initial Cost (Outlay for Investment) = −5,000,000

• Net Annual Cash Flow = 820,000

• Factor = 9.129 Step 5: Plug the known values into the NPV formula: NPV = Initial Cost (−5,000,000) + (Net Annual Cash Flow of 820,000 × Factor of 9.129) NPV = −5,000,000 + (820,000 × 9.129)

NPV = −5,000,000 + 7,485,780 NPV = 2,485,780 Step 6: Using the Annuity Table (Table 1) and the NPV formula, you can now observe that the Net Present Value for an investment with a Useful Life of 20 years at an annual Interest Rate of 9% and a Factor of 9.129 is $2,485,780. Now, calculate the Internal Rate of Return (IRR) Scenario: For this demonstration, refer to the Present Value of an Annuity, Receivable or Payable table (Table 2), which shows the year-end value of an annuity for years 1–20 with interest rates from 11% to 20%. Use this table to calculate Internal Rate of Return (IRR) using the steps that follow. Table 2. Present Value of an Annuity, Receivable or Payable (Year-End Values) 11%–20%

Periods

(n) Interest rates (r)

11% 12% 13% 14% 15% 16% 17% 18% 19% 20%

1 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.833 2 1.713 1.690 1.668 1.647 1.626 1.605 1.585 1.566 1.547 1.528 3 2.444 2.402 2.361 2.322 2.283 2.246 2.210 2.174 2.140 2.106 4 3.102 3.037 2.974 2.914 2.855 2.798 2.743 2.690 2.639 2.589 5 3.696 3.605 3.517 3.433 3.352 3.274 3.199 3.127 3.058 2.991

6 4.231 4.111 3.998 3.889 3.784 3.685 3.589 3.498 3.410 3.326

7 4.712 4.564 4.423 4.288 4.160 4.039 3.922 3.812 3.706 3.605 8 5.146 4.968 4.799 4.639 4.487 4.344 4.207 4.078 3.954 3.837 9 5.537 5.328 5.132 4.946 4.772 4.607 4.451 4.303 4.163 4.031 10 5.889 5.650 5.426 5.216 5.019 4.833 4.659 4.494 4.339 4.192

11 6.207 5.938 5.687 5.453 5.234 5.029 4.836 4.656 4.486 4.327

12 6.492 6.194 5.918 5.660 5.421 5.197 4.988 7.793 4.611 4.439 13 6.750 6.424 6.122 5.842 5.583 5.342 5.118 4.910 4.715 4.533 14 6.982 6.628 6.302 6.002 5.724 5.468 5.229 5.008 4.802 4.611 15 7.191 6.811 6.462 6.142 5.847 5.575 5.324 5.092 4.876 4.675

16 7.379 6.974 6.604 6.265 5.954 5.668 5.405 5.162 4.938 4.730

17 7.549 7.120 6.729 6.373 6.047 5.749 5.475 5.222 4.990 4.775 18 7.702 7.250 6.840 6.467 6.128 5.818 5.534 5.273 5.033 4.812 19 7.839 7.366 6.938 6.550 6.198 5.877 5.584 5.316 5.070 4.843 20 7.963 7.469 7.025 6.623 6.259 5.929 5.628 5.353 5.101 4.870

Remember: IRR calculations rely on the same formula as NPV does, although the IRR is not the actual dollar value of the project. Instead, it is the annual return that makes the NPV equal to zero. Step 1: Gather the following information to calculate the IRR using the Annuity Table (Table 1):

• Initial Cost (Investment)

• Net Annual Cash Flow

• Factor (PV of annual cash flows discounted at interest rate)

• Useful Life (Period) Step 2: Input the known values using the following information:

• Initial Cost (Outlay for Investment) = −5,000,000

• Net Annual Cash Flow = 820,000

• Factor = Unknown

• Useful Life (Period) = 20 years

Step 4: Divide the Initial Cost (Investment) by the Net Annual Cash Flow to get an Approximate Factor.

• Initial Cost (−5,000,000) / Net Annual Cash Flow (820,000) = Approximate Factor (−6.097)

Step 5: Find the years of service (Periods) row that matches the Useful Life (Period) of 20 years, and then follow this line across until you find an Approximate Factor close to −6.097. The factor closest to −6.097 equals −5.929. Step 6: Scan up the Useful Life of 20 years from the Factor of 5.929 to find the Interest Rate of 16%. This is the IRR.