Cost Of Funds Calculator

  • April 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Cost Of Funds Calculator as PDF for free.

More details

  • Words: 400
  • Pages: 2
COST OF FUNDS WORKSHEET How much money do I need for a particular requirement? Ser. No. Period of requirement of funds 1

In how many years do you expect to require the funds?

2

Estimated period these funds will be needed for For example, if it is for your post-graduate course, it may be two years. This example is for a child's four year under-graduate course, ten years hence.

Future Cost after the above period 3

What is the requirement of Funds at present cost?

4

Estimated Inflation Level

5

Inflation Factor based on number of years left until your expenditure and the estimated Inflation level

6 7

Your Future Cost

Income in this period 8

How much money do you expect to receive from your EPF/ PPF/ DSOPF/ Pension Plan/ Gratuity/ Other Investment during this period for this particular purpose

9

What amount are you keeping aside annually - for this purpose alone?

10

Total funds accumulated

11

Any other fund sources (such as loans, gifts, etc.)

12

Total funds available

Expenditure Goal 13

Your funds goal

How much money do I need to put aside each year from now onwards to reach my goal? 14

What are your current investments made exclusively for this expenditure?

15

What return do you expect on these investments (not adjusted for inflation)? It would typically range from 2% for Savings Bank to 18% for equity(over 20-25 year periods)

16

Actual return after adjusting for estimated inflation

17

Assumed Rate of Return Factor based on number of years until your expenditure

18

Projected values of current investment

19

Shortfall :your expenditure goal shortfall

20

Discount Factor based on expected rates of return & inflation and years to expenditure

21

The additional ANNUAL savings you need to make to reach your expenditure goal

21

The additional MONTHLY savings you need to make to reach your expenditure goal

Example

Yourself

10

22

4

1

Rs. 500,000

Rs. 4,000,000

6%

7%

1.79 (10 yrs & 6% inflation)

4.43

Rs. 895,000

Rs. 17,720,000

Rs. 3,580,000

Rs. 17,720,000

Rs. 500,000

Rs. 100,000

Rs. 200,000

Rs. 100,000

Rs. 800,000

Rs. 2,200,000 Rs. 2,100,000

Rs. 1,300,000

Rs. 4,400,000

Rs. 2,280,000

Rs. 13,320,000

Rs. 100,000

Rs. 100,000

12%

12%

6%

5%

1.79 (6% returns for 10 years)

1.03

Rs. 179,000

Rs. 103,000

Rs. 2,101,000

Rs. 13,217,000

0.076 (6% returns for 10 years) Rs. 79,116

Rs. 13,217,000

Rs. 6,593

Rs. 50,064

1

Related Documents