Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

Concise 6th Edition

324664559, 978-0324664553

More Books

Students also viewed these Finance questions