Question

TUNC = = 6 Calibri (Body) - 12 A- B IUBIⓇA Paste aste Office Update To keep up-to-date with security updates, fixes, and impr
1. Calibri (Body) - 12 A- A B IUEA este DO Office Update To keep up-to-date with security updates, fixes, and improvements 5x
Calibri (Body) BI U Office Update To keep up-to-date with security updates, fixes, and improvements, cho x & fox CDE н Income
Callum (boy) 12 A A Paste B I U Office Update To keep up-to-date with security updates, fixes, and improvement 25 A fx A B C

Answer questions 1-18 from the information given. Please help solve with copy of work or provide equations. Thank you!
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer:

Current Ratio = Current Assets / Current Liabilities

20X4 = 47500 / 48000 = 0.989

20X5 = 45500 / 46000 = 0.989

Acid Test Ratio = Quick Assets / Current Liabilities

20X4 = (36500 + 3400 ) / 48000 = 0.831

20X5 = (34000 + 4000 ) / 46000 = 0.826

Debt Equity Ratio = Total Liabilities / Total Equity

20X4 = (48000 + 940000 ) / (150000 + 15000 + 115500 ) = 988000 / 280500 = 3.52

20X5 = (46000 + 934000 ) / ( 150000 + 15000 + 131500 ) = 980000 / 296500 = 3.31

Food Inventory Turnover 20X5 = Cost of goods sold / Avg. Inventory = 500000 / ( 5000 + 5500 ) / 2 = 500000 / 5250 = 95.24

Accounts Receivable Turnover 20X5 = Net Sales / Avg.Accounts Receivable

                                                    = 1790000 / ( 3400 + 4000 ) / 2 = 1790000 / 3700 = 483.78

Avg. Collection Period 20X5 = 365 / Accounts Receivable Turnover = 365 / 483.78 = 0.7544 Days

Long Term Debt to Total Capitalization = Long Term Debt / Total Capital

20X4 = 940000 / ( 940000 + 150000 + 115500 + 15000) = 940000 / 1220500 = 0.77

20X5 = 934000 / ( 934000 + 150000 + 15000 + 131500 ) = 934000 / 1230500 = 0.759

Asset Turnover 20X5 = Net Sales / Avg. Total Assets = 1790000 / ( 1268500 + 1276500 ) / 2

                                                                             = 1790000 / 1272500 = 1.41

Return on Assets = Net Income / Avg. Total Assets = 186000 / ( 1268500 + 1276500 ) / 2 = 186000 / 1272500 = 14.62%

Return on Owner's Equity = Net Income / Avg. Total Equity = 186000 / ( 280500 + 296500 ) / 2 = 186000 / 288500 = 64.47%

Times Interest earned 20X5 = EBIT / Interest Expense = (422000 - 20000-10000-5000-20000) / 80000

                                                                               = 367000 / 80000 = 4.59

Fixed Charge Coverage Ratio 20X5 = EBIT + Fixed charges before Taxes / Fixed charges before Taxes + Interest

                                                    = (367000 + 55000 ) / (55000 + 80000) = 422000 / 135000 = 3.13

Profit Margin for 20X5 = Net Income / Net Sales = 186000 / 1790000 = 10.39%

Earning per share = Net Income / Outstanding shares = 186000 / 25000 = $7.44

Average Food service 20X5 = Net Sales / No. of meals = 1790000 / 164000 = 10.91

Food Cost percentage = cost of food sold / Net sales = 500000 / 1790000 = 27.93%

Labour cost percentage 20X5 = (600000 + 80000 ) / 1790000 = 37.99%

Operating Cash flow to Current Liabilities = 203500 / 46000 = 4.42

Operating Cash flow to Total Liabilities = 203500 / ( 46000 + 934000 ) = 203500 / 980000 = 20.77%

Add a comment
Know the answer?
Add Answer to:
Answer questions 1-18 from the information given. Please help solve with copy of work or provide...
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
  • My question is how to solve the answers for the yellow blocks? Is there any possible...

    My question is how to solve the answers for the yellow blocks? Is there any possible way I could get some help with this question. AutoSave OFF Unit 2 Ratio Data Home Insert Draw Page Layout Formulas Data Review View Tell me e Share O Comments X Arial 10 AA General Σν Comments HH 23 Insert Delete y Paste B I AY Y % Ideas Conditional Format Formatting as Table Cell Styles Format Sort & Filter Find & Select v...

  • X Calor Pane Check f Update To keep up-to-date with security updates, fixes, and improvements, choose...

    X Calor Pane Check f Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates Balance sheet data for Silver Corporation are presented here. Using Comparative Analysis SILVERT CORPORATION Balance Sheet December 31 Different % Change 2012 2011 ASSET Cash Receivable (net) Other current assets Long-term investment Plant and equipment (net) Total Assets 28,000 20 70,000 90,000 62,000 510,000 20,000 62,000 73,000 60,000 470,000 $760,000 685,000 IABILITIES AND STOCKHOLDERS' EQUITY Current liabilities Long-term debt Common stock...

  • please solve correclty use this spreadsheet this is an example of how to do with difffent...

    please solve correclty use this spreadsheet this is an example of how to do with difffent imformation, please follow this example to complete the excercise RHIM 4322 * Homework 3* Ratio Analysis Please complete and show work in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. However, no need to show the explanatory notes like what is being provided in the Demo Exercise. Submit the Homework spreadsheet using this filename "RHIM4322-Last Name-Homework 3"...

  • Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income...

    Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income Stmt info: less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000$ 1,100,000 424,000 676,000 65,750 310,250 25,500 284,750 600,000 350,000 250,000 25,000 12 225,000 13 Net Income 135,000$ 170,850 15 16 17 18 19 Inventory 20 Total Current Assets 21 Fixed Assets (Net) 22 Total Assets Balance Sheet info Cash Accounts...

  • Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income...

    Cell Styles Office Update To keep up-to-date with security updates, fixes, and impro... Che C37 Income Stmt info: less Cost of Goods Sold: Gross Profit Operating Expenses Earnings before Interest & Taxes Interest exp earnings before Taxes Taxes Sales 1,000,000$ 1,100,000 424,000 676,000 65,750 310,250 25,500 284,750 600,000 350,000 250,000 25,000 12 225,000 13 Net Income 135,000$ 170,850 15 16 17 18 19 Inventory 20 Total Current Assets 21 Fixed Assets (Net) 22 Total Assets Balance Sheet info Cash Accounts...

  • Help me solve for the red blanks Problem 18-02A (Video Your answer is partially correct. Try...

    Help me solve for the red blanks Problem 18-02A (Video Your answer is partially correct. Try again. The comparative statements of Wahlberg Company are presented here. Wahlberg Company ncome Statement For the Years Ended December 31 2020 2019 Net sales Cost of goods solod Gross profit Selling and administrative expenses Income from operations Other expenses and losses $1,816,600 1,010,700 805,900 518,600 287,300 $1,750,100 982,000 768,100 475,600 292,500 Interest expense Income before income taxes Income tax expense Net income 19,000 268,300...

  • Need help on the numerator & denominator Required information [The following information applies to the questions...

    Need help on the numerator & denominator Required information [The following information applies to the questions displayed below.] The following financial statements and additional information are reported. IKIBAN INC Comparative Balance Sheets June 30, 2019 and 2018 2019 2018 Assets $ 94,300 $ 66,000 73,000 119,500 9,800 268,300 137,000 Cash Accounts receivable, net Inventory Prepaid expenses 98,000 85,800 6,600 284,700 146,000 (38,000) Total current assets Equipment Accum. depreciation-Equipment (20,000) $385,300 $392,700 Total assets Liabilities and Equity Accounts payable Wages payable...

  • Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets...

    Required information [The following information applies to the questions displayed below.] Simon Company’s year-end balance sheets follow. At December 31 Current Yr 1 Yr Ago 2 Yrs Ago Assets Cash $ 36,426 $ 41,743 $ 43,048 Accounts receivable, net 101,432 73,781 55,709 Merchandise inventory 132,737 94,601 59,324 Prepaid expenses 11,615 10,958 4,736 Plant assets, net 323,068 300,708 263,483 Total assets $ 605,278 $ 521,791 $ 426,300 Liabilities and Equity Accounts payable $ 153,729 $ 88,183 $ 57,960 Long-term notes payable...

  • Problem # 1 (50 points) Given the Income Statement and Balance Sheet Compute: Current Ratio Acid-Test...

    Problem # 1 (50 points) Given the Income Statement and Balance Sheet Compute: Current Ratio Acid-Test Ratio Days in Receivable Days in Inventory Operating Profit Margin Total Asset Tumover Fixed-asset turnover Debt Ratio Times Interest Earned Return on Equity Income Statement Balance Sheet Assets Cash Accounts Receivable Inventory Prepaid Expenses Total Current Assets Gross Plant and Equipment Accumulated Depreciation Net Fixed Assets Total Assets $200,000 $60,000 $100,000 $20,000 $380,000 $802,000 -$132,000 $670,000 $1,050,000 Sales (all credit) Cost of Goods Sold...

  • Formatting as Table Styles Update To k to-date with security updates, fixes, and improvements, choose Check...

    Formatting as Table Styles Update To k to-date with security updates, fixes, and improvements, choose Check for Updates C D E F TABLE 1 INCOME STATEMENT Use the financlal statements in TABLE 1 below to calculate the values shown below: Sales COGS Other expenses Depreciation EBIT Interest Taxable Income Taxes (40 % ) Net income 24,092,400 17,982,000 2,878,800 Total Debt ratio total debf 2 points total liabl 2 points Inet incon 2 points 786,000 2,445,600 434.400 2,011,200 804,480 1,206,720 Debt...

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