00:01
To find the economic service life of the vehicle, we need to calculate the net present value of the cash flow associated with the operating cost, one's average cost.
00:36
Npv is calculated by using the formula that is npv is equal to summation of cft divided by 1 plus r to the power t.
00:57
So we have cft is the net cash flow and r is the interest rate, t is the time period.
01:17
Here we can do it in the excel form by using the time period, operating cost, average net cash flow and the npv calculation.
01:27
Here we have the first to find the cash flow.
01:50
In this cash flow, the column will subtract the average value from operating cost of each year and second is to calculate the net present value.
02:32
To calculate the net present value, we have the formula that is npv, t is equal to net cash flow divided by 1 plus r to the power t.
02:47
So we have to use the formula in excel that b2 by 1i plus b summation of 8 to the power cfa247a2 and drag it to the row.
03:24
Here in excel we take the rows that is first one year, a table to be created.
03:48
First is year, operating cost, salvage value, net cash flow, net present value calculations...