Question

Complete the following tables using the following Item Value Current assets $40,000 Current liabilities $20,000 Assets...

Complete the following tables using the following

Item

Value

Current assets

$40,000

Current liabilities

$20,000

Assets

$500,000

Liabilities

$100,000

Equity

$400,000

Ratios

Formula

Calculations

Is it in red or green zone?

Current ratio

Debt-to-asset ratio

Item

Value

Gross revenue

$100,000

Operating expenses

$30,000

Depreciation

$4,000

Interest expense

$0

NFIO

$70,000

Nonbusiness income

$30,000

Taxes

$5,000

Principal

$5,000

Interest

$4,000

Family living expenses

$30,000

Ratios

Formula

Calculations

Is it in red or green zone?

Return on assets

Operating profit margin

Asset turnover ratio

Term debt coverage ratio

How would you summarize the financial position of this farmer?

If you are a loan officer, will you give him/her a loan?

Show that the Dupont identity for ROA holds. Show calculations please

Homework Answers

Answer #1

1 current ratio = current assets / current liabilities idle good indicator is 2:1

= $ 40000 / $ 20000 = 2 current ratio is in green zone

2. debt to asset ration = debt / total assets idle is less the ratio lesser the risk

= $1,20,000 / $540000 = 0.22 the ratio is in green zone

3. return on total assets = net income / total assets

net income = gross revenue - operating expenses- depriciation

= $1,00,000 - 34,000 = $66,000   

total assets = fixed assets + current assets = $ 5,40,000

ROA = $66,000 / 5,40,000 = 0.12 it is in gren zone

4. operating profit margin = operating profit / total income  

operating profit = gross revenue - operating expenses

= 1,00,000 - 30,000 = 70,000

= $70,000 / $66.000 = 1.06 it is in red zone

5. term debt coverage ratio = net oprating income / total debt

= 66000 / 120000 = 0.55 it is in green zone

if iam loan officer i will give loan

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
Question 1 Sales $500,000 Liabilities $150,000 Assets $250,000 Equity $100,000 Net Income $20,000 Profit before Tax...
Question 1 Sales $500,000 Liabilities $150,000 Assets $250,000 Equity $100,000 Net Income $20,000 Profit before Tax $40,000 Calculate the Return on Equity and Asset Turnover Ratio: A)  40% and 2 B)  40% and 1/2 C)  20% and   1/4 D)  20% and 2 Question 2 2018 2019 Sales 100 110 Cost of Goods Sold 50 60 Net Income 10 14 Equity 50 60 Inventory 15 20 Current Assets 20 15 Current Liabilities 22 20 Total Liabilities 40 60 Total Assets 90 120 Calculate Return on Equity...
2018 2017 Balance Sheet: Current Assets Current Liabilities Net Fixed Assets Long-Term Debt Common Stock Income...
2018 2017 Balance Sheet: Current Assets Current Liabilities Net Fixed Assets Long-Term Debt Common Stock Income Statement/Other: Depreciation Expense EBIT Interest Expense Taxes Net Income Dividends $ 5,000     2,000   10,000   11,000     7,500 $ 1,000     4,000     2,000        500      1,500        600 $ 7,000     4,500     8,000     9,500     7,400 Calculate the following Cash Flow from Assets Questions: 1. Operating Cash Flow 2. Net Capital Spending 3. Changes in Net Working Capital 4. Cash...
A firm had current assets of $50,000, net fixed assets of $250,000, current liabilities of $...
A firm had current assets of $50,000, net fixed assets of $250,000, current liabilities of $ 30,000, and long-term debt of $100,000 What is the firm’s stockholder equity? What is the net working capital? If its current liabilities consist of $20,000 in accounts payable and $10,000 in short-term debt (notes payable), what is the firm’s net working capital? Your submission must include and indicate clearly which EQUATIONS from the textbook that you have used, and must show steps in details...
Consider the following balance sheet: BestCare HMO Balance Sheet June 30, 2011 (in thousands) Assets Current...
Consider the following balance sheet: BestCare HMO Balance Sheet June 30, 2011 (in thousands) Assets Current Assets: Cash                                        $2,737 Net premiums receivable        821 Supplies                                  387 Total current assets    $3,945 Net property and equipment             $5,924 Total assets                                         $9,869 Liabilities and Net Assets Accounts payable—medical Services                                   $2,145 Accrued expenses                               929 Notes payable                                     382             Total current liabilities            $3,456 Long-term debt                                   $4,295 Total liabilities                        $7,751 Net assets—unrestricted (equity)                                   $2,118 Total liabilities and net Assets                                     $9,869 Consider the following financial statements...
CCC - Balance sheets 31 December 2018, 2017 assets 2018 2017 Fixed assets, net 600,000 500,000...
CCC - Balance sheets 31 December 2018, 2017 assets 2018 2017 Fixed assets, net 600,000 500,000 Inventory 70,000 50,000 Accounts receivable, net 100,000 150,000 Cash 30,000 50,000 Total current assets € 200,000 € 250,000 Total assets € 800,000 € 750,000 Equity and liabilities 2018 2017 Share capital 300,000 200,000 Retained earnings 80,000 100,000 Total equity € 380,000 € 300,000 Payable bonds 200,000 250,000 Accounts payable 150,000 120,000 Income taxes payable 70,000 80,000 Total current liabilities € 220,000 € 200,000 Total...
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...
Complete the following: You will need financial statements and information to make the required calculations. Click...
Complete the following: You will need financial statements and information to make the required calculations. Click on the link below to access the handout with the necessary information. INCOME STATEMENT – Fiction, INC. Sales 2,000,000 Cost of goods sold 1,400,000 Gross profit 600,000 Operating expenses Selling & marketing 100,000 Administrative 80,000 Depreciation 50,000 Total operating expenses 230,000 Operating income (operating profits) 370,000 Interest expense 50,000 Earnings before tax 320,000 Income taxes 80,000 Net income 240,000 Total number of shares outstanding...
Current Ratio = Current Assets / Current Liabilities                                   &
Current Ratio = Current Assets / Current Liabilities                                    = 1,53 Total Debt to Equity = Total Liabilities / Shareholder’s Equity                                               = 112.52% Long Term Debt to Equity = Long Term Liabilities / Shareholder’s Equity                                                         = 70.25% Return on Assets = [Net Income + Interest Expense*(1-Tax Rate)] / Average Total Assets                                           = 5.66%     Return on Common Equity = Net Income / Average Shareholder’s Equity                                                         = 14.57% Gross Profit Margin = (Sales – Cost of Sales) /...
SHOW YOUR WORK FOR CALCULATION PROBLEMS Given the following information, calculate: (a) current ratio, (b) quick/acid-test...
SHOW YOUR WORK FOR CALCULATION PROBLEMS Given the following information, calculate: (a) current ratio, (b) quick/acid-test ratio, (c) Total debt or leverage ratio, (d) Return on Assets, (e) Net Margin, (f) Return on Equity, (g) Asset Turnover, (h) Earnings Retention Ratio SUMMARY BALANCE SHEET ASSETS                                   LIABILITIES & SH EQUITY Cash & Equivalents $2,000    Accounts Payable $6,000 Accounts Receivable 7,000    Notes Payable         4,000 Inventory                  5,000     Current Liabilities $10,000 Current Assets      $14,000      Prepaid Expense $2,000         Long-term Debt   $9,000      P, P & E (net)     $20,000        SH Equity           $17,000           Total Assets        $36,000       Total Liab & SH Eq...
1. A business has $4,000 current liability and a total assets equal $30,000. What is the...
1. A business has $4,000 current liability and a total assets equal $30,000. What is the equity for the firm if long-term debt is $7,500? 2. Zena corp. has $1,000 current asset, $2,000 fixed asset, $800 current liability, $1,000 long-term debt. What is its current ratio? 3. Dola company has sales of $26,000, depreciation of $2,000, interest expense of $800, cost of goods sold of $15,000, other costs of $5,000, and a tax rate of 34 percent. What is Dola...