Lifetime Tables: Step-by-Step Guide to Open
Opening a lifetime table is relatively straightforward, but it's crucial to understand the underlying concept to use it effectively. A lifetime table, in the context of finance, is a projection of future cash flows, discounted back to the present. It helps assess the net present value (NPV) of an investment or a project. Here's a comprehensive guide on how to open and use lifetime tables.
Before diving in, ensure you have Microsoft Excel or a compatible spreadsheet software. While you can create lifetime tables using simple functions, specialized add-ins like the Excel Add-in for NPV and IRR can simplify the process. Now, let's start with the basics.
Creating the numbering and discounting periods
Lifetime tables typically span several years, representing the lifespan of an investment or a project. The first step is to set up the periodic numbers and corresponding discount rates. The discount rate, often the weighted average cost of capital (WACC), reflects the riskiness of the project and the cost of capital.
For instance, if you're analyzing a 5-year project with a WACC of 10%, your discount table might look like this:
| Period | Discount Factor (1 + r)^-t |
|---|---|
| 0 | 1.00000 |
| 1 | 0.90909 |
| 2 | 0.82645 |
| 3 | 0.75132 |
| 4 | 0.68301 |
| 5 | 0.62097 |
Calculating discount factors
Discount factors are calculated as (1 + r)^-t, where r is the discount rate (as a decimal), and t is the period number.
To calculate these values, you can use the Excel function =((1+(r))/((1+(r))^period))-1, substituting r with the discount rate and period with the respective year.
Including cash flows
Next, input your projected cash flows for each period. Cash flows might be positive (cash in) or negative (cash out). Remember to consider all relevant inflows and outflows, including initial investments, earnings, expenses, and salvage values.
Once the discount table is set up, you can apply the same principles to other projects or investments with varying lifespans or discount rates by adjusting the period numbers and discount rates accordingly.
Opening lifetime tables: Calculating net present value (NPV)
After setting up the lifetime table, the next step is to calculate the net present value (NPV) of the project or investment. NPV represents the difference between the present value of cash inflows and the present value of cash outflows over a period.
Calculating present values
To calculate the present value (PV) of cash flows, multiply the cash flow by its respective discount factor:
PV = Cash Flow * Discount Factor
For example, if your third-year cash flow is -$10,000 and your third-year discount factor is 0.75132, the present value would be -$7,513.20.
Summing up net present values
Press Ctrl + Shift + & at the same time to add up all the present values, including the initial investment (if negative) and the subsequent cash inflows and outflows. The sum of these values is the net present value (NPV) of the project or investment.
If the NPV is positive, the project is expected to generate value. If it's negative, the project is expected to destroy value. However, NPV is just one aspect of capital budgeting. You should also consider the internal rate of return (IRR), payback period, and other relevant factors when making investment decisions.