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%
Answer questions 1-18 from the information given. Please help solve with copy of work or provide...
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 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 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 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 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 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 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 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 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 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...