Question

No Instructions 1. Please enter the data from the previous tabs by clicking on the cell and typing = and then clicking on the

Calculate Net Profit Margin 0.2077731380.129955795 Above 8% 4 Basic Earning Power (BEP) EBIT 2018 332,804,000 1138370000 Tota

please let me know if these calculations are correct especially the total debt line. thanks

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Operating income is similar to a company's earnings before interest and taxes (EBIT). Hence EBIT is 318474000 for 2018 & 289653000 for 2017.

2. Time Interest Ratio for 2018 is 6.93722 (318474000/45908000) and 6.43115 for 2017

3. Market Debt Ratio =Total Liabilities/(Total Liabilities + Market Value of Equity)

= 3911996089/(3911996089+3911131200)

= 0.50

4. BEP for 2018 is 0.27976 (318474000/1138370000) and 0.29105 (289653000/995191000) for 2017

Add a comment
Know the answer?
Add Answer to:
please let me know if these calculations are correct especially the total debt line. thanks No Instructions 1. P...
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
  • Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income...

    Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income...

  • can someone please tell me Market Debt Ratio is in Question #2. Thanks. B E С...

    can someone please tell me Market Debt Ratio is in Question #2. Thanks. B E С b. Calculate Times Interest Earned Ratio EBIT/ Interest 7.249368302 Leverage Ratios 2 Market Debt Ratio a. Find Market Value of Equity from "Market Cap" in Yahoo Finance 2018 4,446,000 b. Calculate Total Debt + Market Value of Equity Add: Total Debt Market Value of Equity Total: Total Debt + Market Value of Equity 754,611 4,446,000 5,200,611 c. Calculate Market Debt Ratio Profitability Ratios 3...

  • (use 365 days a year. Round your intermediate calculations and final answers to 1 decimal place.)...

    (use 365 days a year. Round your intermediate calculations and final answers to 1 decimal place.) Problem 12-4A Calculate risk ratios (L012-3) The following income statement and balance sheets for Virtual Gaming Systems are provided. VIRTUAL GAMING SYSTEMS Income Statement For the year ended December 31, 2018 Net sales Cost of goods sold $3,066,000 1,956,000 1.110,000 Gross profit Expenses Operating expenses Depreciation expense Loss on sale of land Interest expense Income tax expense $864.000 30,000 8,600 18,000 54,000 Total expenses...

  • Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory...

    Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...

  • Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory...

    Instructions For 2017 and 2018, calculate current ratio, quick (acid-test) ratio, inventory turnover and days' inventory outstanding (DIO), accounts receivable turnover, days' sales in average receivables or days' sales outstanding (DSO), accounts payable turnover, days' payable outstanding (DPO), and cash conversion cycle (in days). a. Use the cost of goods sold in the formula for accounts payable turnover. b. Use a 365-day year for calculations as needed. c. Use cell references from prior calculations, if applicable. (Always use cell references...

  • Cash Receivables Inventories Total current assets Net fixed assets $ 230,000 1,575,000 1,160,000 $2,965,000 1,320,000 Accounts...

    Cash Receivables Inventories Total current assets Net fixed assets $ 230,000 1,575,000 1,160,000 $2,965,000 1,320,000 Accounts payable Notes payable Other current liabilities Total current liabilities Long-term debt Common equity Total liabilities and equity $ 600,000 100,000 545,000 $1,245,000 400,000 2,640,000 $4,285,000 Total assets $4,285,000 Lozano Chip Company: Income Statement for Year Ended December 31, 2019 (Thousands of Dollars) Sales $7,500,000 Cost of goods sold 6,375,000 Selling, general, and administrative expenses 929,000 Earnings before interest and taxes (EBIT) $ 196,000 Interest...

  • [2] Financial ratios (58 points) Find the missing values on the balance sheet and the income...

    [2] Financial ratios (58 points) Find the missing values on the balance sheet and the income statement of Pensacola Railroads (in S millions). Start with the balance sheet, and then continue with the income statement. You can use the following ratios: NOTE: USE AVERAGE RECEIVABLES AND INVENTORY Debt Ratio loterest Coverage Ratio CurreatRatio Quick Ratio Cash Ratio 0.4 1.4 0.2 Average Collection Period (average receivables) Tax rate 73 das 40% Marks: 28 for balance sheet, 30 for income statement. Balance...

  • how to get the numbers [2] Financial ratios (58 points) Find the missing values on the...

    how to get the numbers [2] Financial ratios (58 points) Find the missing values on the balance sheet and the income statement of Pensacola Railroads (in S millions). Start with the balance sheet, and then continue with the income statement. You can use the following ratios: NOTE: USE AVERAGE RECEIVABLES AND INVENTORY Debt Ratio loterest Coverage Ratio CurreatRatio Quick Ratio Cash Ratio 0.4 1.4 0.2 Average Collection Period (average receivables) Tax rate 73 das 40% Marks: 28 for balance sheet,...

  • I need help please. I forgot the formulas for every part of the question Use the...

    I need help please. I forgot the formulas for every part of the question Use the following financial statements for Lake of Egypt Marino, Inc. 2018 2017 $ 60 72 110 LAKE OF EGYPT MARINA, INC. Balance Sheet as of December 31, 2018 and 2017 (in millions of dollars) 2018 2017 Assets Liabilities and Equity Current assets: Current liabilities: Cash and marketable $ 100 $ 48 Accrued wages and taxes securities Accounts receivable 110 Accounts payable Inventory 301 174 Notes...

  • The following income statement and balance sheets for Virtual Gaming Systems are provided. VIRTUAL GAMING SYSTEMS...

    The following income statement and balance sheets for Virtual Gaming Systems are provided. VIRTUAL GAMING SYSTEMS Income Statement For the year ended December 31, 2018 Net sales $3,076,000 1,958,000 Cost of goods sold Gross profit Expenses: Operating expenses Depreciation expense Loss on sale of land 1,118,000 $866,000 31,000 8,800 19,000 56,000 Interest expense Income tax expense Total expenses 980,800 $ 137,200 Net income VIRTUAL GAMING SYSTEMS Balance Sheets December 31 2018 2017 Assets Current assets Cash $152,000 68,000 143,000 6,960...

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
ADVERTISEMENT