New to accounting but using the balance sheet analysis and business calculations
ID: 2399566 • Letter: N
Question
New to accounting but using the balance sheet analysis and business calculations. Not very good with excel but the homework wants to calculate the the debt ratio in excel. Then calculate the working capital, the last part is what is their net working capital and what issue debt ratio. Using the information provided. Thanks I'm really good once I see how it's done.Best Care Health Maintenance Organization (HMO) Review the folowing information on balance sheet analysis and business calculations Balance Sheet Analysis Calculating Debt Ratio in Excel Calculating Working Capital Current assets 52.737 Net premiums 821 Supplies 5387 Total current assets $3.945 53.945 Net property and 55.924 Total assets $9,869 Llabilities and Net Assets Accounts payable- $2.145 medical services Accrued expenses 5929 Notes payable $382 Total current 53.456 3.456 ablities Long-term debt Total labiibies Total assets 54.295 $7,751 $7,751 $9,869 Niet assets unrestricted fequity Total liabilities and $2.118 $9,869 assets Answer the following questions after your analysis: What is Best Care's net working capital for 2011? Show your work What is Best Care's debt ratio? Show your work.
Explanation / Answer
1 Net Working Capital = Current Assets - Current Liabilities = $3945-3456 $ 489.00 2 Debt's Ratio =it is ratio which measure proportion of debt financing of the organisation = Total debt (liability)/Equity = 7,751/9869 = .785