Oct 7, 2019

Tutorial Excel - Personal Budgeting



Key in this data in Excel. Go to Excel, click NEW.


A1
Personal Budgeting

B2



 2019
2020
B3 – I3
September
October
November
December

A4
Income
Allowance from parent
PTPTN
Part-time job
Total Income

A10
Expenses
Food
Assignment
Telecommunication
Transportation
Personal care
Total Expenses

A19
Balance (








In 2020
all income is increased by 10%
Certain expenses are increased   by 20% (due to inflation)
Insurance
Telecommunication
Entertainment
Utilities
Food
Buy a new car  - RM1000 monthly
Buy new insurance policy - RM300 monthly

Tutorial Excel - Personal Budgeting



Key in this data in Excel. Go to Excel, click NEW.


A1
Personal Budgeting

B2



 2019
2020
B3 – I3
September
October
November
December

A4
Income
Allowance from parent
PTPTN
Part-time job
Total Income

A10
Expenses
Food
Assignment
Telecommunication
Transportation
Personal care
Total Expenses

A19
Balance (








In 2020
all income is increased by 10%
Certain expenses are increased   by 20% (due to inflation)
Insurance
Telecommunication
Entertainment
Utilities
Food
Buy a new car  - RM1000 monthly
Buy new insurance policy - RM300 monthly