Skip to main content

What is Lump Sum and Multiple Cash Flows ?

Lump Sum Cash Flow: It is a single cash flow on which interest earn for fixed period.

Multiple Cash Flows: It is a fixed or uneven series of cash flows for fixed period.

Formulas for Lump Sum and Multiple Cash Flows:

Variables
Formula
PV
FV/ (1+r) n
FV
PV (1+r) n
N
In(FV / PV)/In (1+r)
R
(FV /PV) 1/n-1

Where,
FV =Future Value
PV =Present Value
N = Number of periods
R = rate of interest

Example 1: Mr. Sharma deposit Rs.20000 for 12 years @7% compounded quarterly into saving a/c. Find out the future value of investment?

FV = PV (1+r) n
= 20000 (1+0.0175) 48
= 45991.97

Example 2: If someone wants to have Rs.10, 00,000 after his retirement then how much amount he would have to invest now @8% per annum compounded annually for 20 years?

PV = FV / (1+r) n
= 10, 00,000 / (1+0.08) 20
= 10, 00,000 / 4.66095714
= 214548.20

Example 3: Nikhil borrow Rs.500, 000 @ 9% compounded monthly and he will have to pay Rs.560, 000 to bank at the end of the loan period. Find out the loan period (n).

N =In (FV/PV) /In (1+r)
= In (560000/500000) / In (1+0.0075)
= In (1.12) /In (1.0075)
= 0.11332/0.00747
=15

Example 4: Mr. A provide loan of Rs.200, 000 to Mr. B for 4 years and after completion of loan period employee have to pay Rs.320, 000.Find out the interest rate charged by Mr. A?

I = (FV/PV) 1/n-1
= (360,000/200,000) 1/4-1
= (1.8) 1/3-1
= 15.8%

Problems of Multiple Cash Flows:

Example 1: suppose Company A purchase machinery at the cost of Rs50, 000 @ 6% compounded half yearly and the machine provides following returns in 5 years: 
1.       25000
2.       22000
3.       10000
4.       5000
5.       2000
Find out the net  present value?

PV = FV/ (1+r) n

Year
Formula
Present  Value
1
25000/(1+0.03) 8
19735.23
2
22000/(1+0.03) 6
18424.65
3
10000/(1+0.03) 4
8884.87
4
5000/(1+0.03) 2
4712.97
5
2000/(1+0.03) 0
2000
TOTAL
53757.72

NPV= present value of investment-Initial investment
= 53757.72-50000
= 3757.72

Example 2: A person deposits Rs.10000, Rs.10000, Rs.20000 and Rs.25000 for 4 years respectively @ 8% compounded annually .Find out the future value?

FV=PV (1+r) n

Year
Formula
Future Value
1
10000(1+0.08) 3
12597.12
2
10000(1+0.08) 2
11664.00
3
20000(1+0.08)1
21600.00
4
25000(1+0.08) 0
25000.00
TOTAL
Rs. 70861.12


*If cash deposits at the end of a year then “n” is 3 and if it deposits at the beginning of a year then “n” is 4. 

Example: Neha wants to invest for his son’s education for 10 years at the beginning of each  year @ 8.2% compounded annually to get Rs. 12, 000 ,Rs.  10, 000 , Rs. 11, 000, Rs. 8, 500, Rs. 7, 600,Rs.  8, 000 , Rs. 13, 000, Rs. 9, 000 , Rs. 12, 100 ,Rs. 6, 000  in the future find out the total present value of future cash flows.
Solution:

Year
Formula = FV / (1+r) n
Present Value
1
12, 000 /(1+0.082) 10
5, 455
2
10, 000 / (1+ 0.082) 9
4, 926
3
11, 000 / (1+ 0.082) 8
5, 851
4
8, 500 / (1+ 0.082) 7
4, 885
5
7, 600 / (1+ 0.082) 6
4, 750
6
8, 000 / (1+ 0.082) 5
5, 405
7
13, 000 / (1+ 0.082) 4
9, 489
8
9, 000 / (1+ 0.082) 3
7, 087
9
12, 000 / (1+ 0.082) 2
10, 256
10
6, 000 / (1+ 0.082) 1
5, 545
Total

Rs. 63, 649



Comments

Post a Comment

Popular posts from this blog

How to calculate Cost of Preference Share Capital?

Cost of Preference Share Capital:  An amount paid by company as dividend to preference shareholder is known as Cost of Preference Share Capital. Preference share is a small unit of a company’s capital which bears fixed rate of dividend and holder of it gets dividend when company earn profit. Dividend payable is not a tax deductible amount. So, there is no tax adjustments required for comparing with cost of debt. Formula for Cost of Preference Share: Irredeemable Preference Share Redeemable Preference Share K p  = Dp/NP K p  = D p +((RV-NP)/n )/ (RV+NP)/2 Where, K p  = Cost of Preference Share D p  = Dividend on preference share NP = Net proceeds from issue of preference share (Issue price – Flotation cost) RV = Redemption Value N = Period of preference share Example:  A company issues 20,000 irredeemable preference share at 8% whose face value is Rs.50 each at 4% discount. Find out the Cost of Preference Share Capital.
87 comments
Read more

What is the difference between Cheque book and Pass book?

 Cheque book is issued by bank in customers / account holder request. With the help of this book account holder can withdraw cash from his/her account. Bank does not charge any fee to issued cheque book to its customer. But afterward bank charges some amount for using bank facility like cheque book, Debit card etc.So, Automatic some definite amount deducted from customer bank account. Pass book is  also issued by bank to its customer. It helps to record all the bank related activity according to date that is withdrawal and deposit. It is recorded by bank but the book is kept by customer to know the current balance of  his /her account.  Point of difference Pass book Cheque book What is the meaning of pass book and cheque book? Passbook is a book in which all withdrawal and deposit against customer account is recorded.   Cheque book is a book of cheques which are used to withdrawal the money to bank account.
Post a Comment
Read more

How to calculate interest on Hire Purchase System?

Interest on hire purchase:  Interest is calculated on Cash value of goods not in instalment value which includes cash value of goods and interest amount. It is calculated on yearly, quarterly and yearly basis. Interest is not calculated on down payment which is paid at delivery of goods. Depreciation is also charged on the hire purchase goods at the end of financial year. The method applies for depreciation is based on the contract between the parties.   Example:  Company V purchased a machine of Rs.70, 000 and paid Rs.5, 000 as down payment. The interest charged @6% and 8% depreciation annually. The instalment value for each year is Rs. 10,000. Find out the interest amount for 5 years. Solution: Interest calculated on Rs. Interest Instalment Cash Value 65, 000 65, 000*0.06 = 3, 900 12, 500 8, 600 56, 400 56, 400*0.06 = 3, 384 12, 500 9, 116 47, 284 47, 284*0.06 = 2, 837 12, 500 9, 6
3 comments
Read more