EXCEL-SKILLS.
COM
NET DISPOSABLE INCOME TEMPLATE
This template enables users to calculate their monthly net disposable income by simply ente
yellow input cells on the Income sheet.
View all our unique templates!
This free template forms part of our unique range of innovative Excel templates which featu
statements, management accounts, cash flow projections, business valuations, fixed assets, co
and a lot more.
Get more templates!
enable editing to activate the link
TEMPLATE
osable income by simply entering the appropriate values in the
e Excel templates which features accounting in Excel, financial
ss valuations, fixed assets, costing & inventory, monthly payroll
plates!
ate the link
Net Disposable Income Calculation © [Link]
Remuneration Operational Expenses Financing Expenses
Gross Salary 30,000 1 Rent Paid - 18 Bond Repayments - 42
Subsidies Received - 2 Water, Electricity & Services - 19 Personal Loan Instalments - 43
Commission Received - 3 Rates & Taxes - 20 Financing - Motor Vehicles - 44
Total Allowances - 4 Repairs & Maintenance - 21 Financing - Computers - 45
Other - 5 Levies Paid - 22 Financing - Furniture - 46
Total Gross Remuneration 30,000 Telephone / Cell Phone / Internet - 23 Credit Card Repayments - 47
Deductions Insurance - Short Term - 24 Bank Charges - 48
Pension - 6 Insurance - Life - 25 Other - 49
Medical Aid - 7 Medical Costs - 26 Total Financing Expenses -
Retirement Annuity - 8 Investments - Retirement Annuities - 27
Income Tax (PAYE) - 9 Investments - Other - 28 On this sheet:
Unemployment Fund (UIF) - 10 Donations - 29 Simply enter the appropriate values in the yellow input
Skills Development Levy (SDL) - 11 Education - 30 cells in order to calculate your monthly net disposable
Other Deductions - 12 Fuel & Vehicle Maintenance - 31 income. All input values need to be entered as positive
Total Deductions - Television Rental - 32 values and guidance on the user input required in each
Net Remuneration 30,000 13 Memberships - 33 input field can be found from row 39 downwards.
Subscriptions - 34
Other Income Domestic Wages - 35
Dividend Income - 14 Gardening - 36
Rental Income - 15 Groceries - 37
Maintenance - 16 Clothing - 38
Monthly Pension - 17 Entertainment - 39
Total Other Income - Maintenance Payments - 40
Other - 41
Total Operational Expenses -
Net Disposable Income Calculation
Net Remuneration 30,000
Add: Other Income -
Less: Operational Expenses -
Less: Financing Expenses -
Net Disposable Income 30,000
Input Cell Guidance
1 Enter the combined monthly gross household salaries
2 Enter total of all subsidies received as part of remuneration, e.g.. housing subsidy
3 Enter the average monthly commission received
4 Enter the total monthly allowances received as part of remuneration, e.g.. travel allowance, cell phone allowance, etc.
5 Enter the total of any other remuneration received
6 Enter the total monthly pension fund deductions
7 Enter the total monthly medical aid deductions
Page 3 of 4
Net Disposable Income Calculation © [Link]
8 Enter the total monthly retirement annuity contributions
9 Enter the total monthly income tax deducted
10 Enter the total UIF deducted
11 Enter the total SDL deducted
12 Enter the total of all other deductions, e.g.. funeral plan
13 This amount represents the monthly combined net remuneration
14 Enter the average monthly dividend income
15 Enter the monthly average rental income received from existing buy to let properties
16 Enter monthly maintenance amount received from a previous spouse
17 Enter the total monthly pension received
18 Enter the total monthly rent paid. If a primary residence is being acquired and a property is currently being rented, the rent amount should be excluded from the calculation
19 Enter the monthly average for water, electricity and services paid to local government
20 Enter the monthly rates and taxes paid on properties owned
21 Enter the average monthly repairs and maintenance on existing properties
22 Enter the monthly levy payable to a body corporate for properties that form part of a complex
23 Enter the average monthly telephone, cell phone and internet expense
24 Enter the current monthly insurance premium
25 Enter the current monthly life insurance premium
26 Enter the average monthly medical costs that are not covered by a medical aid
27 Enter the total monthly premiums associated with retirement annuities
28 Enter the average monthly payments relating to other investments
29 Enter the average monthly donations amount
30 Enter the average monthly education cost, e.g.. school fees
31 Enter the average monthly vehicle fuel and maintenance costs
32 Enter the monthly subscription fee applicable to television / cable rentals
33 Enter the monthly average membership cost, e.g.. gym membership
34 Enter the total monthly subscription fees applicable to newspapers, magazines, etc.
35 Enter the total monthly domestic wages, e.g.. housekeeper wages, gardener wages, etc.
36 Enter the average monthly cost associated with gardening services / landscaping
37 Enter the average monthly grocery spend
38 Enter the average monthly clothing spend
39 Enter the average monthly cost associated with entertainment, take-outs and restaurants
40 Enter a monthly total for maintenance payments relating to estranged spouses and dependents
41 Enter total monthly cost of any other expense items that do not form part of any of the other categories
42 Enter a monthly total for existing bond repayments
43 Enter a monthly total for personal loan repayments
44 Enter a monthly total for motor finance repayments
45 Enter a monthly total for computer finance repayments
46 Enter a monthly total for furniture finance repayments
47 Enter a monthly total for credit card repayments
48 Enter the average monthly combined bank charges
49 Enter a total for any other financing payments that do not form part of the other financing cost categories
Note: If you're experiencing any difficulty in completing this spreadsheet, we recommend using our Personal Finance template to analyze your monthly household expenses.
Page 4 of 4