[go: up one dir, main page]
Scribd
Upload
95 views9 pages

Savings Goal Tracker: Saving Targets

The document contains tables tracking monthly and yearly savings goals, incomes, expenses, and actual savings amounts for various categories over a 12 month period. It shows targets for long term savings, emergencies, holidays, birthdays, festivals, pension, and a piggy bank. Charts at the end visualize the yearly totals saved in each category.

Uploaded by

Leo Marbeda Feigenbaum
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
95 views9 pages

Savings Goal Tracker: Saving Targets

The document contains tables tracking monthly and yearly savings goals, incomes, expenses, and actual savings amounts for various categories over a 12 month period. It shows targets for long term savings, emergencies, holidays, birthdays, festivals, pension, and a piggy bank. Charts at the end visualize the yearly totals saved in each category.

Uploaded by

Leo Marbeda Feigenbaum
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

www.

Ex
Savin

Savings Purpose Long Term Emergencies Holidays


Monthly ₹ 5,000 ₹ 3,000 ₹ 5,000
Yearly ₹ 60,000 ₹ 36,000 ₹ 60,000

Source Jan Feb Mar


Salary ₹ 25,000 ₹ 25,000 ₹ 25,000

External Project 1 ₹ 3,000 ₹ 3,000 ₹ 3,000

External Project 2 ₹ 5,000 ₹ 5,000 ₹ 5,000

External Project 3 - - -

External Project 4 - - -

Interest ₹ 3,500 ₹ 3,500 ₹ 3,500

- - -

- - -

- - -

- - -

Totals ₹ 36,500 ₹ 36,500 ₹ 36,500

Expense Jan Feb Mar


Grocery ₹ 10,000 ₹ 10,000 ₹ 10,000

Utility Bills ₹ 2,500 ₹ 2,200 ₹ 2,500

Telephone ₹ 500 ₹ 500 ₹ 500

Fuel ₹ 700 ₹ 700 ₹ 700


Beautification ₹ 650 ₹ 650 ₹ 650

Clothes ₹ 1,500 ₹ 1,500 ₹ 1,500

Miscellaneous ₹ 15,000 ₹ 600 ₹ 600

Credit Card ₹ 5,000 ₹ 3,000 ₹ 3,000

EMI For A ₹ 2,386 ₹ 2,386 ₹ 2,386

EMI For B - - -

- - -

- - -

- - -

- - -

Totals ₹ 38,236 ₹ 21,536 ₹ 21,836


Difference (Inc-Exp) ₹ -1,736 ₹ 14,964 ₹ 14,664

Purpose Jan Feb Mar


Long Term - ₹ 5,000 ₹ 5,000

Emergencies - ₹ 3,000 ₹ 3,000

Holidays - ₹ 2,400 ₹ 2,600

Birthdays - ₹ 500 ₹ 500

Festivals - ₹ 500 ₹ 500

Pension - ₹ 2,000 ₹ 2,000

Piggy Bank - ₹ 500 ₹ 500

Other - ₹ 1,000 ₹ 500

Totals ₹0 ₹ 14,900 ₹ 14,600

₹ 180...

₹ 160...

₹ 140...
₹ 180...

₹ 160...

₹ 140...

₹ 120...

₹ 100...

₹ 80...

₹ 60...

₹ 40...

₹ 20...

₹0
Savings C
www.ExcelDataPro.com
Savings Goal Tracker
Saving Targets
Birthdays Festivals Pension Piggy Bank Other
₹ 200 ₹ 500 ₹ 2,000 ₹ 500 ₹0
₹ 2,400 ₹ 6,000 ₹ 24,000 ₹ 6,000 ₹0

Incomes
Apr May Jun Jul Aug
₹ 25,000 ₹ 25,000 ₹ 25,000 ₹ 25,000 ₹ 25,000

₹ 3,000 ₹ 3,000 ₹ 3,000 ₹ 3,000 ₹ 3,000

₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000

- - - - -

- - - - -

₹ 3,500 ₹ 3,500 ₹ 3,500 ₹ 3,500 ₹ 3,500

- - - - -

- - - - -

- - - - -

- - - - -

₹ 36,500 ₹ 36,500 ₹ 36,500 ₹ 36,500 ₹ 36,500

Expenses
Apr May Jun Jul Aug
₹ 10,000 ₹ 10,000 ₹ 10,000 ₹ 10,000 ₹ 10,000

₹ 2,500 ₹ 2,500 ₹ 2,500 ₹ 2,500 ₹ 2,500

₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 500

₹ 700 ₹ 700 ₹ 700 ₹ 700 ₹ 700


₹ 650 ₹ 650 ₹ 650 ₹ 650 ₹ 650

₹ 1,500 ₹ 1,500 ₹ 1,500 ₹ 1,500 ₹ 1,500

₹ 600 ₹ 600 ₹ 600 ₹ 600 ₹ 600

₹ 2,000 ₹ 1,000 ₹ 5,000 ₹0 ₹0

₹ 2,386 ₹ 2,386 ₹ 2,386 ₹ 2,386 ₹ 2,386

- - - - -

- - - - -

- - - - -

- - - - -

- - - - -

₹ 20,836 ₹ 19,836 ₹ 23,836 ₹ 18,836 ₹ 18,836


₹ 15,664 ₹ 16,664 ₹ 12,664 ₹ 17,664 ₹ 17,664

Actual Savings
Apr May Jun Jul Aug
₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000

₹ 3,000 ₹ 4,000 ₹ 3,000 ₹ 4,000 ₹ 4,000

₹ 3,600 ₹ 3,600 ₹ 600 ₹ 4,600 ₹ 4,600

₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 500

₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 500

₹ 2,000 ₹ 2,000 ₹ 2,000 ₹ 2,000 ₹ 2,000

₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 500

₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 500

₹ 15,600 ₹ 16,600 ₹ 12,600 ₹ 17,600 ₹ 17,600

Charts

₹ 6,300
₹ 5,800
₹ 22,000

₹ 6,100
₹ 5,500
₹ 6,300
₹ 5,800
₹ 22,000

₹ 6,100
₹ 5,500

₹ 37,700

₹ 38,000

₹ 55,000

Savings Category-wise
Other Additional Additional Additional Yearly Total
₹0 ₹0 ₹0 ₹0 ₹ 16,200
₹0 ₹0 ₹0 ₹0 ₹ 194,400

Sep Oct Nov Dec Yearly Total


₹ 25,000 ₹ 25,000 ₹ 25,000 ₹ 25,000 ₹ 300,000
₹ 3,000 ₹ 3,000 ₹ 3,000 ₹ 3,000 ₹ 36,000
₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 60,000
- - - - ₹0
- - - - ₹0
₹ 3,500 ₹ 3,500 ₹ 3,500 ₹ 3,500 ₹ 42,000
- - - - ₹0
- - - - ₹0
- - - - ₹0
- - - - ₹0
₹ 36,500 ₹ 36,500 ₹ 36,500 ₹ 36,500 ₹ 438,000

Sep Oct Nov Dec Yearly Total


₹ 10,000 ₹ 10,000 ₹ 10,000 ₹ 10,000 ₹ 120,000
₹ 2,500 ₹ 2,500 ₹ 2,500 ₹ 2,500 ₹ 29,700
₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 6,000
₹ 700 ₹ 700 ₹ 700 ₹ 700 ₹ 8,400
₹ 650 ₹ 650 ₹ 650 ₹ 650 ₹ 7,800
₹ 1,500 ₹ 1,500 ₹ 1,500 ₹ 1,500 ₹ 18,000
₹ 600 ₹ 600 ₹ 600 ₹ 600 ₹ 21,600
₹ 1,500 ₹ 2,000 ₹0 ₹0 ₹ 22,500
₹ 2,386 ₹ 2,386 ₹ 2,386 ₹ 2,386 ₹ 28,632
- - - - ₹0
- - - - ₹0
- - - - ₹0
- - - - ₹0
- - - - ₹0
₹ 20,336 ₹ 20,836 ₹ 18,836 ₹ 18,836 ₹ 262,632
₹ 16,164 ₹ 15,664 ₹ 17,664 ₹ 17,664 ₹ 175,368

Sep Oct Nov Dec Yearly Total


₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 5,000 ₹ 55,000
₹ 3,000 ₹ 3,000 ₹ 4,000 ₹ 4,000 ₹ 38,000
₹ 4,100 ₹ 3,600 ₹ 4,300 ₹ 3,700 ₹ 37,700
₹ 500 ₹ 500 ₹ 500 ₹ 500 ₹ 5,500
₹ 500 ₹ 500 ₹ 800 ₹ 800 ₹ 6,100
₹ 2,000 ₹ 2,000 ₹ 2,000 ₹ 2,000 ₹ 22,000
₹ 500 ₹ 500 ₹ 500 ₹ 800 ₹ 5,800
₹ 500 ₹ 500 ₹ 500 ₹ 800 ₹ 6,300

₹ 16,100 ₹ 15,600 ₹ 17,600 ₹ 17,600 ₹ 176,400

Other Piggy Bank


Other Piggy Bank

Pension Festivals

Birthdays Holidays

Emergencies Long Term

You might also like