ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This is a simple spreadsheet to help you calculate, (a) how much wealth you will need to meet all your personal expenses for the rest of your life (b) how much surplus you will be left with (c) how much you can afford to give away. If that number comes to anything above 40%, we would strongly urge you to consider signing up for #LivingMyPromise!

To use this calculator, you can either DOWNLOAD IT in Excel and then edit it on your computer, OR, if you have access to Google Drive, create a copy of the calculator as a Google Sheet and work with it there. Both options are listed below.
2
3
Please ONLY edit the values given in RED.#REF!#REF!Copy Download
4
Once u click Create a Copy, also click on the words "Philanthropy Calculator" so that you are prompted to make a copy onto your Google DriveOnce u click Download, also click on the words "Philanthropy Calculator" for the download to begin
5
My Expectation of Expenses in future at current prices#REF!
6
ItemINR p.m INR p.a.
7
AMonthly Expenses
8
Food 15,000 180,000
9
House Staff incl drivers 20,000 240,000
10
Clothes 5,000 60,000
11
Entertainment 5,000 60,000
12
Communications 2,000 24,000
13
Medicines 2,000 24,000
14
Car maintenance and petrol 10,000 120,000
15
Education 20,000 240,000
16
Home Improvement 5,000 60,000
17
Rent/Mortgage - -
18
Electricity, Gas, Cable & other bills 10,000 120,000
19
 - -
20
 - -
21
 - -
22
 - -
23
ASub Total Monthly Expenses 94,000 1,128,000
24
25
BPeriodic Expenses -INR p.a.
26
Travel 300,000
27
Festivals 100,000
28
29
BSubTotal Periodic Exp 400,000
30
31
CAnnual Expenses
32
Life Insurance premia 40,000
33
Car Insurance premia 5,000
34
Medical Insurance premia 5,000
35
Miscellaneous Medical Expenses 20,000
36
Others -
37
Others -
38
CSub Annual Exp 70,000
39
40
Total 1,598,000
41
DContingencies10% 159,800
42
43
ETotal Annual Expenditure 1,757,800
44
45
FOne time Expenses to be funded at current prices
46
Children's Marriage 3,000,000
47
Replacement of Car and other assets 1,000,000
48
Medical Emergencies 2,000,000
49
Others
50
Others -
51
Total One Time Expenses 6,000,000
52
53
My Current WealthINR
54
Financial Assets 50,000,000
55
Total Liquidation Value of Real Estate 30,000,000
56
Gold 2,500,000
57
Others -
58
Others -
59
Total 82,500,000
60
61
Amount I want to leave for my family INR Rs
62
Liquidation value of Real Estate Earmarked for heirs 10,000,000
63
Financial Assets 5,000,000
64
Others 500,000
65
Others -
66
Total 15,500,000
67
68
My Expectation of Inflation and Return in future
69
My expectation of p.a.
70
Inflation of my expenses6%
71
Pre Tax return on investment9%
72
Tax slab33%
73
Post tax return6.0%
74
INR p.a.
75
My post tax annual non investment income 3,600,000
76
Annual Increment 10%
77
Balance of working life15years
78
79
80
81
The Outcome All figures are in RUPEES LACS
82
Additional Life expectancy of yourself and/or spouse in years Amount you need in your lifetime at todays prices in additon to non investment income Current Wealth you can use for philantrophy postleaving for heirs % of current wealth you can give today
83
5₹ -35 705 85%
84
10₹ -167 837 101%
85
15₹ -344 1,014 123%
86
20₹ -257 927 112%
87
25₹ -169 839 102%
88
30₹ -82 752 91%
89
35₹ 5 665 81%
90
40₹ 92 578 70%
91
45₹ 179 491 60%
92
50₹ 266 404 49%
93
Note: Red/ Negative figure means that you can afford to spend/give away this much right away!
94
95
Notes
96
This sheet has been developed for livingmypromise.org by LivingMyPromise signatory
97
Please feel free to use and distribute it. The objective of this sheet is encourage you to contribute at least 50 % of your wealth to philanthropy
98
in case, you make enhancements which can be used by others, please email your version to kodela.sushant@gmail.com
99
100