BM_FM2_NEP
BM_FM2_NEP
Course Instructor
Dr. B. B. Mohapatra
Department of Commerce
Maharaja Agrasen College
(University of Delhi), Delhi
Unit iv: Mathematics of Finance
& '(
calculated using the formula: ! = # $+' Alternatively,
!
P= $)* + Alternatively # = !($ + *).+
we have to use preset value (PV) table. In fact, like that of compounded
future value table, we can construct one in excel. The PV table will
1% 2% 3% 4% 5% 6% 7% 8% 9% 10%
1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909
2 0.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.842 0.826
3 0.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751
4 0.961 0.924 0.888 0.855 0.823 0.792 0.763 0.735 0.708 0.683
5 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.681 0.650 0.621
6 0.942 0.888 0.837 0.790 0.746 0.705 0.666 0.630 0.596 0.564
7 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.583 0.547 0.513
8 0.923 0.853 0.789 0.731 0.677 0.627 0.582 0.540 0.502 0.467
9 0.914 0.837 0.766 0.703 0.645 0.592 0.544 0.500 0.460 0.424
10 0.905 0.820 0.744 0.676 0.614 0.558 0.508 0.463 0.422 0.386
Let us Solve a Few Examples
! = # $%&
Thus if we know S, r and t we can calculate P as follows;
!
P = %& Alternatively # = !$'%&
$
Thus, given S, r and t, using the above formula we can calculate
300(1.05)1+500(1.05)-4 = x
x = 300(1.05)+500(.8227)
x= 315+411.35
x= 726.35
We can do it in excel by writing the
Formula
Let
C = Original Cost of the Asset/Book Value
S = Estimated Scrap/Salvage Value/Book
Value at nth year
W = Total Depreciation (or C-S)
D = Annual Depreciation
n = Useful life in Years
$%& (
The Annual Depreciation (!) = ' = '
Thus in straight line method the annual depreciation is fixed for all the
years
An Example
A machine costing rupees 50,000 has a life of 5 years. The estimated scrap
value is rupees 10,000. Find the annual depreciation and construct a
schedule of depreciation over the life of the machine.
$%& ( )*,***%,*,***
Ans: The Annual Depreciation (!) = '
= '
= )
= -, ***
Depreciation Schedule
Date of
Year 3 Year 4 Year 5
Purchase (Year Year 1 Year 2
0)
Accumulated Depreciation
(in Rs.) 0 8,000 16,000 24,000 32,000 40,000
42,00
Book Value (in Rs.) 50,000 34,000 26,000 18,000 10,000
0
(b). Sum of the year digit Method
By this method, digits of the year are arranged in
descending order against years in ascending order. The
depreciation for respective years (Annual Depreciation)
is the fraction (f) of the cost of the asset (C) and that
fraction is given by the ratio of digit to sum of digit.
Annual Depreciation=f.C
[f=Digit of the year/Sum of the year]
This method typically assumes higher rates of
depreciation during the initial years.
Further this method assumes a zero scrap value
An Example
A machine which costs rupees 30,000, has a life span of 5
years and its scrap value is zero. Find the annual depreciation
for each year year
C: The Cost of Machine = 30,000
Year Digit of the Fraction (f) Annual Accumulated
Year in Depreciation Depreciation
Reverse (fXC)
Order
1 5 5/15 10,000 10,000
2 4 4/15 8,000 18,000
3 3 3/15 6,000 24,000