I did it the painful way - one entry for every year of existence.
On top, were the expenses rows.
Under that were the income rows.
The first thing you need to determine is how long you think you will live. I took my parents' average age and added 5 to it for medicine induced longevity.
These are the assumptions:
A. Cost of living expenses go up by 6% YoY if one owns a house and 8% YoY if one does not.
B. Factor in Full time caretaker cost from the age of 75. Take current values and add 12% YoY inflation until you reach the year of turning 75.
C. Some Capex that can be expected if one is retiring alone:
Cremation and inheritance costs
House Maintenance cost every 10 years
D. Assume about 8% YoY growth in the value of your gold bullion.
E. I took 5% as the return from FD and 10% from equity. There are no mutual funds in my investment portfolio.
F. For rentals of properties owned, I assumed a 8% YoY growth and a 60% occupancy rate.
G. For self earning through consulting and other fun stuff, I took a conservative number and gave it at 5-10% YoY growth. Potential age up to which one can earn - 75
The objective:
A. The inflow should be at least 10% higher than the expenses, else the corpus will not be able to keep pace with inflation.
B. There should be some bullion as liquid assets that can be used to deal with unexpected illness.
C. Find out the cost structure of assisted living and start planning for that at the age of 50. I assumed entry into assissted living at the age of 70 or thereabouts.
D. Have a plan to either reverse mortgage or sell any real estate that is not manageable for you after a certain age.
E. Track your portfolio consistently and see if the income and expenses are keeping pace with the retirement strategy.
The excel sheet, by the way, looks like this: