Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate Debt Ratio. Show work . AutoSave Off v FinStatementsFA20 (5) - Protected View Search File Home Insert Draw Page Layout Formulas Data Review View
Calculate Debt Ratio. Show work .
AutoSave Off v FinStatementsFA20 (5) - Protected View Search File Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing M16 for B c F G H Column2 1 Financial Da Columnl 2 Assets D E Column Column4 Liabilities Columns - Columns Cash $500 I. 3 $350 $1,200 Current Bills (unpaid balance) Visa Master Card Other Credit Cards $8,000 4 4 5 6 S $500 $90 J. Credit Card Debt $8,000 7 8 A. 9 10 $ $2,290 $5,600 First Mortgage 2nd Home Mortgage Home Equity Loan Other Housing Debt Housing $105.000 $100,000 $9.000 11 K. 12 $214,000 Automobile 1 13 $3,000 Automobile 2 14 15 16 B B. 17 Checking Savings/CDs Money Market Funds Other Monetary Assets Monetary Assets Mutual Funds Stocks $ Bonds Life Insurance (cash- value) Cash Value of Annuities Investment Real Estate (REITS partnerships) Other investments Investments 401(k) and 403(b) Company Pension S Keogh IRA Other Retirement Plans Retirement Plans Primary Residence 2nd Home $ Time Shares/Condominium Balance Sheet Income Statement $5,600 $2,500 $3,000 $4,000 Other Automobile Loans Automobile Loans College Loans Loans on Life Insurance Policies Bank Loans Installment Loans 18 19 20 $8,000 $1.000 Other 21 22 C 23 M. Other Debts $10,500 $170,000 55.000 N. Total Debt (add linea 1 through M) S230, 350 24 Ready Type here to search AutoSave Off v FinStatementsFA20 (5) - Protected View Search File Home Insert Draw - Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing M16 4 A C D E F G H 25 26 Net Worth H. Total Assets $207,390 D. 27 28 29 $170,000 $8,000 $230,350 IN 0. Less: Total Debt Equals: Net Worth ($22,9601 30 31 E. 32 B Time- Shares/Condominium S Other Housing Housing (market value) Automobile 1 Automobile 2 $ Other Automobiles Automobiles Collectibles 1 Boats Furniture Other Personal Property Personal Property Money Owed You Market Value of Your Business Other Other Assets $- $8,000 33 34 $11,000 $11,000 35 36 F. 37 38 39 40 G. 41 $207,390 H. 42 43 Total Assets (add lines A through G) 45 46 47 48 49 50 51 52 53 54 Balance Sheet Income Statement Ready
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