Answered step by step
Verified Expert Solution
Question
1 Approved Answer
O AutoSave OFF v . .. De... Q AutoSave OFF v ... 3My Monthly Budget.xlsx Home Insert Draw >> Tell me Share Comments Home Insert
O AutoSave OFF v . .. De... Q AutoSave OFF v ... 3My Monthly Budget.xlsx Home Insert Draw >> Tell me Share Comments Home Insert Draw Page Layout Formulas Data > Tell me A % Conditional Formatting v X A Conditional Formatting v Format as Table v nl Format as Table v Clipboard Font Alignment Number Cell Paste Font Alignment Number Cells i Cell Styles v Cell Styles v Styles Clipboard Styles F23 X V fx Buc F23 X fx 0 A B C Dis G H Determining My Disability Income Insurance Needs (page 338) INCOME EXPENSES FIXED EXPENSES Wages #1 (gross) Rent/Mortgage W N Insert Your Figures Wages #2 (gross) 0 Home Insurance Current Monthly After-tax Income $2, 100 a Interest Income o Real Estate Taxes Previously Established Income Protections 11 Dividend Income 0 Vehicle Loan #1 $750 Sales Commissions o Monthly Social Security Disability Benefits Vehicle Loan #2 o Automobile Insurance Monthly Benefit From Employer Provided Disability Insurance $600 O. C 13 Bonuses Tips Life Insurance 8 Monthly Benefit From Private Disability Insurance $0 15 Gifts o Medical Insurance o 9 Monthly Benefit From Other Government Disability Insurance 16 Tax Refunds o Retirement Fund #1 $1,35 Other o Sub-total of All Existing Benefits Retirement Fund #2 18 Other o Student Loan Payments Estimated Monthly Disability Income Insurance Needs $750 19 TOTAL INCOME Federal Income Tax State Income Taxes City Income Taxes Social Security Taxes Personal Property Taxes Savings #1 Savings #2 Savings #3 Other Other Other Total Fixed Expenses. VARIABLE EXPENSES Food (home) Food (meals away) Food (for entertainment) Entertainment Electricity Natural Gas Water/Sewer Garbage Collection Cable TV Local Telephone Long Distance Cell Phone Medical Clothing Gifts Personal Care Personal Allowances Gasoline Vehicle Maintenance Education Expenses Charitable Contributions - o o o o o O O OOO OOO Other Other Other Other 8 9 8 8 8 9 8 8 2 2 Miscellaneous Total Variable Expenses TOTAL EXPENSES 45 SURPLUS (DEFICIT) 3.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started