Mortgage Calculator Excel Template - Free Download | Page 4
4.8,
2773
votes
Please vote for this template if it helps you.
Page 3 of 11
Net Disposable Income Calculation © www.excel-skills.co.uk
Remuneration Operational Expenses Financing Expenses
Gross Salary 1,800 1 Rent Paid - 18 Mortgage Repayments - 42
Subsidies Received - 2 Water, Electricity & Gas - 19 Personal Loan Instalments - 43
Commission Received - 3 Council Tax - 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 1,800 Telephone / Mobile 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
National Insurance (NI) - 10 Donations - 29
Other Tax Deductions - 11 Education - 30
Other Deductions - 12 Fuel & Vehicle Maintenance - 31
Total Deductions - Television Rental - 32
Net Remuneration 1,800 13 Memberships - 33
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 1,800
Add: Other Income -
Less: Operational Expenses -
Less: Financing Expenses -
Net Disposable Income 1,800
Input Field 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, mobile 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
8 Enter the total monthly retirement annuity contributions
9 Enter the total monthly income tax deducted
10 Enter the total NI deducted
source: dataease.com
