Spreadsheets

Step-up SIP calculator sheet: raise the amount every year

Build a step-up SIP sheet where the monthly amount rises each year, with year-end balances at an assumed rate and a flat SIP column to compare.

Editorial illustration for Step-up SIP calculator sheet: raise the amount every year

A step-up SIP sheet has one row per year: the monthly amount rises by the percentage in an input cell, and the year-end balance is the old balance grown for 12 months plus this year's 12 instalments. Starting at ₹5,000 a month, raising it 10% every year and assuming 10% a year, the sheet reaches about ₹15,10,340 after 10 years against ₹10,24,225 for a flat ₹5,000. Every figure depends on the rates you type in.

What goes in the input cells

  • B1 Starting monthly amount: 5000.
  • B2 Yearly increase: 10%.
  • B3 Assumed return per year: 10%. This is your what-if, not a forecast.
  • Headings from row 5: A Year, B Monthly amount, C Step-up balance, D Flat balance, E Gap.

The year-by-year formulas

Row 6 is year 1 and row 7 onwards copies downwards. Use absolute references (the dollar signs) for the three input cells so they stay fixed when you drag the formulas.

  1. A6: 1 and A7: =A6+1.
  2. B6: =$B$1 and B7: =B6*(1+$B$2). The amount stays fixed inside a year and jumps at the start of the next.
  3. C6: =FV($B$3/12, 12, -B6). C7: =C6*(1+$B$3/12)^12 + FV($B$3/12, 12, -B7). The first part grows last year's balance for 12 months; the FV part adds this year's instalments.
  4. D6: =FV($B$3/12, 12, -$B$1). D7: =D6*(1+$B$3/12)^12 + FV($B$3/12, 12, -$B$1). Same logic, but the amount never changes.
  5. E6: =C6-D6, copied down.

What does the table look like?

With the inputs above, selected rows come out like this (rounded to the nearest rupee):

YearMonthly amountStep-up balanceFlat balanceGap
1₹5,000₹62,828₹62,828₹0
2₹5,500₹1,38,517₹1,32,235₹6,283
5₹7,321₹4,63,889₹3,87,185₹76,704
10₹11,790₹15,10,340₹10,24,225₹4,86,115

How much more do you actually pay in?

A rising instalment means more of your own money goes in, not only more growth. Over the 10 years the flat plan puts in ₹6,00,000, while the step-up plan puts in ₹9,56,245. Add a total-paid column with =B6*12, summed at the bottom, so the sheet shows both the final balance and what it cost you. Compare the extra balance with the extra payment before deciding the pace feels right.

How do you read the gap column?

The gap is the extra balance bought by the yearly raises. It starts at zero, stays small while the raises are small, and widens as the higher instalments get more months to grow. In this example the step-up plan pays in ₹3,56,245 more over 10 years and ends with ₹4,86,115 more. Dividing one by the other tells you roughly how many rupees of balance each extra rupee of instalment turned into at your assumed rate. Change the rate and watch that ratio move.

Can the increase be in rupees, or happen every second year?

Yes. For a fixed rupee raise, change B7 to =B6+$B$2 and type 500 in B2. For a raise every two years, use =IF(MOD(A7,2)=1, B6*(1+$B$2), B6). The balance formulas in column C need no change because they read whatever amount sits in column B.

Checks before you rely on it

  • Year 1 of the step-up and flat columns should match exactly, so the gap in E6 is zero.
  • If the increase is 0%, the two balance columns must be identical.
  • The return cell is yearly and gets divided by 12 inside the formula, not before.
  • The sheet ignores charges, missed months and changes in the assumed return.

Once a plan is running, compare the sheet with what you really paid. Importing your bank statement into SpendixAI and checking the instalment rows each month is a quick way to notice if the amount you meant to raise never changed.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports