Question

Do the Math 3-3 Ratio Analyses Use the following balance sheet and cash flow statement information...

Do the Math 3-3 Ratio Analyses Use the following balance sheet and cash flow statement information to answer the questions below. Liquid assets: $14,000; home value: $210,000; monthly mortgage payment: $1,450; investment assets: $75,000; personal property: $20,000; total assets: $319,000; short-term debt: $4,200 ($350 a month); long-term debt: $160,000 ($2,200 a month); total debt: $164,200; monthly gross income: $13,000; monthly disposable income: $6,800; monthly expenses: $5,500. Calculate the ratios below. Round your answers to two decimal places. Liquidity ratio. Asset-to-debt ratio. Debt-to-income ratio. % Debt payments-to-disposable income ratio. % Investment assets-to-total assets ratio. %

Homework Answers

Answer #1

Liquidity Ratio = Liquid Assets / Short Term Debt = 14,000/4,200 = 3.33
Asset to Debt ratio = Toatl Assets/ Total debt = 319,000/164,200 = 1.94
Debt to Income ratio = Total Debt/ (Gross Income + Disposable income -expenses) = 164,000/((13,000+6800-5500)*12) = 11.47(If yearly ratio is to be calculated then (11.47/12 = 0.9558 or 95.58%
Debt Payments to disposbable income = (Long term debt payment + short term debt payment)/disposable income =
(2200 + 300)/(6800) = 36.76%
Investment assets to total assets = 75000/319,000 = 23.51%
Best of Luck . God Bless

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following information pertains to Ortiz Company. Assume that all balance sheet amounts represent both average...
The following information pertains to Ortiz Company. Assume that all balance sheet amounts represent both average and ending balance figures. Assume that all sales were on credit. Assets Current assets                                                                                          $ 95,000 Property, plant and equipment                                                                210,000             Total Assets                                                                                 $305,000 Liabilities and Stockholders’ Equity Current liabilities                                                                                    $ 50,000 Long-term liabilities                                                                                    95,000 Stockholders’ equity—common                                                             160,000             Total Liabilities and Stockholders’ Equity                                 $305,000 Income Statement Sales                                                                                                      $ 110,000 Cost of goods sold                                                                                       66,000 Gross profit                                                                                                 44,000 Operating expenses                                                                                     30,000...
USE THE FOLLOWING INFORMATION FOR QUESTION 3: Data for BikeNet Logistics most recent balance sheet and...
USE THE FOLLOWING INFORMATION FOR QUESTION 3: Data for BikeNet Logistics most recent balance sheet and income statement is presented below: Sales $723,000 Cost of goods sold 614,550 Interest expense 33,000 Net income $ 75,450 Cash & Mkt securities $ 120,000 Accts Receivables 210,000 Accounts payable $ 92,000 Inventories 183,000 Long-term debt 100,000 Net fixed assets 320,000 Common equity 641,000 Total assets $833,000 Total liab. and equity $833,000 3. Compute BikeNet’s quick ratio (and times-interest-earned (TIE) ratio: A)   Quick: 1.47,...
Muscarella Inc. has the following balance sheet and income statement data: Cash $ 14,000 Accounts payable...
Muscarella Inc. has the following balance sheet and income statement data: Cash $ 14,000 Accounts payable $ 42,000 Receivables 70,000 Other current liabilities 28,000 Inventories 210,000 Total CL $ 70,000 Total CA $294,000 Long-term debt 70,000 Net fixed assets 126,000 Common equity 280,000 Total assets $420,000 Total liab. and equity $420,000 Sales $280,000 Net income $ 21,000 The new CFO thinks that inventories are excessive and could be lowered sufficiently to cause the current ratio to equal the industry average,...
The balance sheet and income statement for Rocket Corporation are as follows: Balance Sheet as of...
The balance sheet and income statement for Rocket Corporation are as follows: Balance Sheet as of December 31, 2019 ASSETS LIABILITIES & EQUITY Cash & marketable sec. $3,500 Accounts payable $38,000 Accounts Receivable 47,000 Taxes payable 9,000 Inventory 13,000 Short-term borrowings 20,500 Total current assets $63,500 Total current liabilities $67,500 Net P,P & E $452,000 Long-term debt $200,000 Total liabilities $267,500 Common stock at par $80,000 Additional paid-in capital $45,000 Retained earnings $123,000 TOTAL ASSETS $515,500 TOTAL LIABILITIES & EQUITY...
The balance sheet and income statement shown below are for Big D Café: Balance Sheet (millions...
The balance sheet and income statement shown below are for Big D Café: Balance Sheet (millions of $) Assets Cash and securities                                                          2,500 Accounts receivable                                                        11,500 Inventories                                                                        16,000 Total current assets                                                        30,000 Net plant and equipment                                             20,000 Total assets 50,000 Liabilities and Equity Accounts payable                                                             9,500 Notes payable                                                                   7,000 Accruals                                                                               5,500 Total current liabilities                                                    22,000 Long-term debt                                                                15,000 Total liabilities                                                                   37,000 Common stock                                                                  2,000 Retained earnings                                                            11,000 Total common equity                                                     13,000 Total liabilities and equity                                            50,000 Income Statement (millions of $) Sales                                                                                      87,500 Operating costs except...
USE THE INCOME STATEMENT AND BALANCE SHEET SHOWN BELOW TO DEVELOP THE STATEMENT OF CASH FLOW...
USE THE INCOME STATEMENT AND BALANCE SHEET SHOWN BELOW TO DEVELOP THE STATEMENT OF CASH FLOW YEAR T + 1 Revenue $5700 COGS $4560 Gross Profit $1140 Operating expenses $500 Depreciation $27 Ebit $613 Interest Expenses $35 EBT $578 Taxes $231.20 NI $346.80 Dividends $0 CHANGE IN RE $346.80 BALANCE SHEET YEAR T + 1                                 YEAR T CASH AND EQUIVALENTS -                              $714.80.                                       $120 ACCOUNTS RECEIVABLE -                               $500                                               $500 INVENTORY -                                                   $300                                                $340 TOTAL CURRENT ASSETS -                             ...
Use the following items to prepare a balance sheet and a cash flow statement. Determine the...
Use the following items to prepare a balance sheet and a cash flow statement. Determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows. Balance Sheet and Cash Flows Rent for the month $ 1,330 Monthly take-home salary $ 3,900 Cash in checking account 810 Savings account balance 2,740 Spending for food 1,300 Balance of educational loan 2,770 Current value of automobile 8,550 Telephone bill paid for month 119 Credit card balance 320 Loan payment...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash...
Consider the following company’s balance sheet and income statement. Balance Sheet Assets Liabilities and Equity Cash $ 10,000 Accounts payable $ 31,000 Accounts receivable 72,000 Notes payable 25,000 Inventory 53,000 Total current assets 135,000 Total current liabilities 56,000 Fixed assets 81,000 Long-term debt 30,000 Equity 130,000 Total assets $ 216,000 Total liabilities and equity $ 216,000 Income Statement Sales (all on credit) $ 290,000 Cost of goods sold 180,000 Gross margin 110,000 Selling and administrative expenses 43,000 Depreciation 7,000 EBIT...
Use the following items to prepare a balance sheet and a cash flow statement. Determine the...
Use the following items to prepare a balance sheet and a cash flow statement. Determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows. Balance Sheet and Cash Flows Rent for the month $ 1,070 Monthly take-home salary $ 3,730 Cash in checking account 1,310 Savings account balance 1,970 Spending for food 1,250 Balance of educational loan 2,830 Current value of automobile 8,030 Telephone bill paid for month 128 Credit card balance 299 Loan payment...
The balance sheet and income statement shown below. Note that the firm has no amortization charges,...
The balance sheet and income statement shown below. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $) Assets 2019 Cash and securities $ 2,500 Accounts receivable 11,500 Inventories 16,000 Total current assets $30,000 Net plant and equipment $20,000 Total assets $50,000 Liabilities and Equity Accounts payable $ 9,500 Accruals 5,500...