Question
how to find current ratio (excluding cash), Debt to Equity, ROE and Forward internal growth rate
% of Sales Method Growth 28.6% Financial Statements: Sales Expenses Taxes Net Earnings Actual 2017 500,000 350,000 50,000 100
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Current ratio = Current assets/Current liabilities = Accounts receivable + Inventory/Accounts payable = 50,000+25,000/50,000 = 75,000/50,000 = 1.50 (excluding cash)

2. Debt to equity ratio is calculated by dividing total debt by total equity.

Total debt is long term debt = 1.25,000, equity is calculated by adding common stock and retained earnings i.e. 75000 + 150000=225000

D/E=125000/225000=0.556

3. ROE = Return on equity = Net income / Equity = 100,000/(75,000+150000)*100 = (100,000/225,000)*100 = 44.4%

Equity is calculated by adding common stock and retained earnings i.e. 75000 + 150000=225000

4. Retention rate is the left amount after dividends are paid, here 50% of net income is paid as dividends and hence retention ratio is 50% means 50% of net income is paid as dividends and 50% is retained by the company

Hence RR=50%

ROE =44.4%

Forward internal growth rate = (ROE x RR) / [1 – (ROE x RR)]

= 44.4% *(50%)/(1-44.4%*50%) = 28.6%

Add a comment
Know the answer?
Add Answer to:
how to find current ratio (excluding cash), Debt to Equity, ROE and Forward internal growth rate...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Calculate the current ratio, quick ratio, long-term debt/total assets, times interest earned, and fixed cost coverage...

    Calculate the current ratio, quick ratio, long-term debt/total assets, times interest earned, and fixed cost coverage using the picture below. X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS...

  • Your firm has an ROE of 11 7%, a payout ratio of 26%. S629, 700 of stockholders' equity, and S430,000 of debt sustainable growth rate this year, how much additional debt will you need to issu...

    Your firm has an ROE of 11 7%, a payout ratio of 26%. S629, 700 of stockholders' equity, and S430,000 of debt sustainable growth rate this year, how much additional debt will you need to issue? t you grow at your The Tax cuts and Jobs Act of 2017 temporarily allows 100% bonus depreciation (effectively expensing capital expenditures However, we will still include depreciation forecasting in this chapter and in these problems in anticipation of the return of standard depreciation...

  • Find the profit margin, ROA, and ROE for each period. X2 X3 X4 $2,500,000 3.200,000 3,500,000...

    Find the profit margin, ROA, and ROE for each period. X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS RETAINED EARNINGS 125,000 87,000 56,550 7,850 50,000 40,000 CASH ACCOUNTS...

  • Using spread sheets above: 1) What is the Sustainable Growth Rate? 2) What is the Internal...

    Using spread sheets above: 1) What is the Sustainable Growth Rate? 2) What is the Internal Growth Rate? 3) What is the ROE? 4) What is the ROA? 5) What is the Profit Margin? 2019 2,570 2018 2,820 Current Assets Cash Accounts Receivable Inventory Total 8,100 7,875 Balance Sheet ($ in millions) 2019 2018 Current Liabilities 405 310 3,055 2,640 Long-term Debt 3,850 3,275 Owner's Equity 7,310 6.225 Common Stock 10,670 10,960 Retained Earnings Total 17,980 17,185 Total Liabilities and...

  • What is the current year's cash balance? What is the current year's return on equity (ROE)?...

    What is the current year's cash balance? What is the current year's return on equity (ROE)? What is the current year's entry for long term debt on a common-sized balance sheet? THIS IS ALL THE INFORMATION GIVEN Category Accounts payable 41,400 45,000 Accounts receivable 115,200 122,400 Accruals 16,200 13,500 Additional paid in capital 200,000 216,660 Cash 777 772 Common Stock @ par value 37,600 42,000 COGS 131,400 178,243.00 Depreciation expense 21,600 22,453.00 Interest expense 16,200 16,617.00 Inventories 111,600 115.200 Long-term...

  • NWC ratio and Debt-equity ratio? Birtle Corporation reports the following statement of financial position information for...

    NWC ratio and Debt-equity ratio? Birtle Corporation reports the following statement of financial position information for 2017 and 2018. Assets 2018 Current assets Cash Accounts receivable Inventory Total $ 43,805 16,843 BIRTLE CORPORATION 2017 and 2018 Statement of Financial Position Liabilities and Owners' Equity 2017 2018 2017 Current liabilities $ 9,279 $ 11,173 Accounts payable $ 41,060 23,683 25,760 Notes payable 16,157 42,636 46,915 $ 75,598 $ 83, 848 Total $ 57,217 Long-term debt $ 40,000 Owners' equity $272,047 $297,967...

  • A corporation reports the following year-end balance sheet data. The company's debt-to-equity ratio equals: $ 56,000...

    A corporation reports the following year-end balance sheet data. The company's debt-to-equity ratio equals: $ 56,000 Current liabilities 72,000 Long-term llabilities 77,000 Common stock 162,000 Retained earnings $ 92,000 25,000 117,000 133,000 Cash Accounts recelvable Inventory Equipment $367,000 Total liabilities and equity $367,000 Total assets 1.39 O 223 0.47 0.68 0.32

  • 3. Calculate the internal growth rate and sustainable growth rate for S&S Air. What do these...

    3. Calculate the internal growth rate and sustainable growth rate for S&S Air. What do these numbers mean? 4. S&S Air is planning for a growth rate of 12 percent next year. Calculate the EFN for the company assuming the company is operating at full capacity (Hint: beside sales also assume that Costs of goods sold, Other expenses, all company assets and Accounts payable grow with 12%). Can the company's sales increase at this growth rate? S&S AIR, INC. 2012...

  • 1) the times interest earned ratio 2) the debt to equity ratio 3) the gross margin...

    1) the times interest earned ratio 2) the debt to equity ratio 3) the gross margin percentage 4) the return on total assets (total assets at the beginning of last hear were 13,070,000) 5) the return on equity(stockholders equity at the beginning of last year totaled 7,990,250) no change in common stock over two years 6) ks the companys financial leverage positive ir negative? $ 960.000 2,700.000 3.600.000 260.000 7.520.000 9.520.000 $17,040,000 $ 1.200.000 300,000 1.800.000 2.000.000 200.000 5,500,000 9.050.000...

  • Long-term debt ratio Times interest earned Current ratio Quick ratio Cash ratio Inventory turnover Average collection...

    Long-term debt ratio Times interest earned Current ratio Quick ratio Cash ratio Inventory turnover Average collection period 0.6 5.0 73 days Use the above information from the tables to work out the following missing entries, and then calculate the company's return on equity. Note: Turnover and the average collection period are calculated using start-of-year, not average, values. (Enter your answers in millions. Round intermediate calculations and final answers to 2 decimal places.) INCOME STATEMENT (Figures in $ millions) Net sales...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT