Frank Smith Plumbing Part 2: Financial Ratio Calculations
Frank Smith Plumbing Problem Data
Before proceeding, make sure to check out the data in Frank Smith Plumbing Part 1. This data is necessary to perform the cash flow financial ratios below.
Payback Period
Find payback period by first finding the last year with a negative cash flow. In this example, it is year 3. Now take the negative amount in year three and the total amount in year 4. Divide the negative amount in year three (as a positive number) by the total amount in year 4. 31,910 / 47,050, then add it to the base year of 3. This will give you a value of 3.68 years.
Discounted Payback Period
Discounted payback period uses the exact same process, but you need to use the discounted cash flows instead of the nominal cash flows. When you do this, you will find the year 4 is the last year with negative cash flow. Therefore, the calculated value is 5.54 years.
Net Present Value and IRR
Use the NPV and IRR formulas in excel.
Profitibility Index
PI can be found by dividing the NPV in the previous step by the initial outlay of the investment of 215,000. This should result in 10.3%.
Summary of Financial Ratio Results
Pay Back Period | 3.68 |
Discounted Pay Back Period (DPB)** | 5.54 |
Net Present Value | $22,149.25 |
Internal Rate of Return | 15.90% |
Profitability Index | 10.30% |