lifetime tables how to open

Lifetime Tables: Step-by-Step Guide to Open

By Laura Walker
AD

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.

AD
Lifetime's Fold-in-Half Table Tutorial
Lifetime's Fold-in-Half Table Tutorial
a person standing under a bed with a wooden frame and mattress on it's side
a person standing under a bed with a wooden frame and mattress on it's side
Differences Between Lifetime's 8 Different Picnic Table Models
Differences Between Lifetime's 8 Different Picnic Table Models

For instance, if you're analyzing a 5-year project with a WACC of 10%, your discount table might look like this:

PeriodDiscount Factor (1 + r)^-t
01.00000
10.90909
20.82645
30.75132
40.68301
50.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.

a white table and chairs sitting in front of an outdoor grill
a white table and chairs sitting in front of an outdoor grill
How to Make a Table Bigger for Extra Seating
How to Make a Table Bigger for Extra Seating

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.

AD

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:

AD

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.

AD

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.

AD