Payback Period Calculator for Irregular Cash Flows
Payback Period Calculator for Irregular Cash Flows
Calculation Results
Detailed Cash Flow Analysis
| Time | Cash Flow | Net Cash Flow | Discounted Cash Flow | Net Discounted Cash Flow |
|---|
How to Use This Calculator
Step-by-Step Instructions
- Enter Initial Investment: Input the total amount of money you're investing upfront (in USD).
- Set Discount Rate: Enter the discount rate as a percentage. This represents your required rate of return or cost of capital.
- Input Cash Flows: Enter the expected cash returns for each year. You can:
- Modify existing year values
- Add more years using the "Add More Years" button
- Delete unnecessary years using the "Delete" button
- Calculate: Click "Calculate Payback Period" to see your results.
Understanding Your Results
Payback Period
The time it takes to recover your initial investment using nominal cash flows (not adjusted for time value of money).
Discounted Payback Period
The time it takes to recover your initial investment using discounted cash flows (adjusted for time value of money). This is typically longer than the simple payback period.
Cash Flow Return Rate (IRR)
The internal rate of return - the discount rate that makes the net present value of all cash flows equal to zero. Compare this to your required rate of return.
Detailed Cash Flow Analysis Table
- Cash Flow: The actual cash received each year
- Net Cash Flow: Cumulative cash flow over time
- Discounted Cash Flow: Present value of each year's cash flow
- Net Discounted Cash Flow: Cumulative discounted cash flow
Financial Formulas Used
Simple Payback Period
The simple payback period calculates how long it takes to recover the initial investment without considering the time value of money.
Discounted Payback Period
Where n = number of years
The discounted payback period accounts for the time value of money by discounting future cash flows to their present value.
Internal Rate of Return (IRR)
Where t = time period and NPV = Net Present Value
IRR is the discount rate that makes the net present value of all cash flows equal to zero.
References
- U.S. Small Business Administration - Calculate Your Startup Costs
- U.S. Department of Treasury - Government Bonds Information
- Federal Reserve - Interest Rate Statistics
- U.S. Bureau of Economic Analysis - Economic Data
- SEC.gov - Ten Things to Consider Before You Make Investing Decisions
- Investor.gov - Risk and Return
Write Reply