Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help with price-earnings snd market-to-book ratio and how to solve it please 12. Fill in the missing financial ratios in the table below (21) 2021

image text in transcribed
image text in transcribed
help with price-earnings snd market-to-book ratio and how to solve it please
image text in transcribed
image text in transcribed
12. Fill in the missing financial ratios in the table below (21) 2021 2020 Current ratio 2 1.46 Quick ratio 12 0.50 Inventory turnover 3.87 Days sales in inventory V 94.35 Capital intensity Ratio 0.333 Total asset turnover 3.00 Total debt ratio 43.8% 81% Times interest earned ratio 16.283 0.10 Profit margin -1.63% Return on assets -3.30% Return on equity -17.06% Earnings per share (EPS) -0.95 Price-earnings ratio (6.31) total debt ratio = (TA-TE)/TA =.438-7 43.8% times int. earned ratio=EBIT / int. = 6.283 2019 Industry Average 2.33 2.70x 0.85 1.00x 4.00 6.10x 91.15 59.84 days 0.328 0.40 3.05 2.50x 55% 50% 3.35 6.20x 2.56% 4% 5.99% 9% 13.25% 18% 0.88 N/A 9.66 16.20x price-earnings ratio : days sales in invent-365/inventor I.TO=cogs/invent = 1.6895 1365/1.6895= 216.04 P/E - PPS/EPS: 216.047 Market-to-book ratio 1.08 1.28 2.90x Accounts par Notes payable Accruals Tot 4. Fall in the missing information from Kelpie Corp's Income Statements below (10) Kelple Corp Income Statement 2021 2020 2019 Sales 3,432.000 7,035,600 5,834,400 Cost of goods sold 5,800,000 4.980.000 2,864,000 Other expenses 612,960 720,000 340,000 Depreciation 120,000 116,960 18.900 Total operating costs 6,532.960 5,816,960 3.222.900 EBIT 502,640 17.440 209.100 Interest expense 80,000 176,000 62.500 EBT 422,640 - 158.560 146,600 Taxes (40%) 169,056 - 63,424 58.640 Net Income 253,584-95,136 187,960 (2021) Sales - total op costs + EBIT = taxes: EBT*.4 = 169,056 7.035,600 - EBT- 6202 Dentories to a CA-cosh-stin-acc rec. = EBT = EBIT-int. exp= -158,560 LT.deottotoi liitines-toto L = 1.000.000 taxes: EBTX.4 = -63,424 TE-total lab and equity-totas lialo. = 3,954,304 (2019) taxes - EBTX.4 = 58,640 net income: EBT-taxes= -95,136 RE: TE-Csand paid in Surplus=542,432 net income EBT-taxes = 87.969 3. Fill in the missing information from Kelpie Corp's Balance Sheet (10) Kelpie Corp Balance Sheet Assets 2021 2020 2019 Cash 28,000 14,564 18.000 Short term investments 143,264 40,000 97,200 Accounts receivable 1.756,000 1,264,320 702,400 inventories 3432.960 2.574.720 1,430,400 Total current assets 5,360,224 3,893,604 2.248.000 (2020) EBIT = sales - total tax costs=375446 notes payable total cu-acc.pay-accruals 600.000 Net fixed assets 1.673,680 1,879,580 689 600 Total assets 7,033,904 5.773,184 2,937,600 Liabilities and owners' equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities 719,600 648,000 600,000 1,440,000 760,000 569.920 2,079,600 2,657,920 1,000,000 2,000,000 3,079,600 4,657,920 291,200 400,000 272.000 963,200 646,864 1,610,064 Common stock and paid in surplus Retained earnings Total Equity 3,361,872 920,000 1592, 432 195,264 3,954.304 1,115,264 920,000 407,536 1,327,536 5,773,184 2,937,600 Total liabilities and equity 7,033,904 (2020) NFA = TA- total CA = 1,879,580 total CL = acc. pay-notes pay.- accruals = 2,657,920 LT.delot = total vial. - total CL - 2.000.000 (2019) NFA = total liab.and equity-total CA-689,600 ITA=NFA + total CA = 2,937,660 12. Fill in the missing financial ratios in the table below (21) 2021 2020 Current ratio 2 1.46 Quick ratio 12 0.50 Inventory turnover 3.87 Days sales in inventory V 94.35 Capital intensity Ratio 0.333 Total asset turnover 3.00 Total debt ratio 43.8% 81% Times interest earned ratio 16.283 0.10 Profit margin -1.63% Return on assets -3.30% Return on equity -17.06% Earnings per share (EPS) -0.95 Price-earnings ratio (6.31) total debt ratio = (TA-TE)/TA =.438-7 43.8% times int. earned ratio=EBIT / int. = 6.283 2019 Industry Average 2.33 2.70x 0.85 1.00x 4.00 6.10x 91.15 59.84 days 0.328 0.40 3.05 2.50x 55% 50% 3.35 6.20x 2.56% 4% 5.99% 9% 13.25% 18% 0.88 N/A 9.66 16.20x price-earnings ratio : days sales in invent-365/inventor I.TO=cogs/invent = 1.6895 1365/1.6895= 216.04 P/E - PPS/EPS: 216.047 Market-to-book ratio 1.08 1.28 2.90x Accounts par Notes payable Accruals Tot 4. Fall in the missing information from Kelpie Corp's Income Statements below (10) Kelple Corp Income Statement 2021 2020 2019 Sales 3,432.000 7,035,600 5,834,400 Cost of goods sold 5,800,000 4.980.000 2,864,000 Other expenses 612,960 720,000 340,000 Depreciation 120,000 116,960 18.900 Total operating costs 6,532.960 5,816,960 3.222.900 EBIT 502,640 17.440 209.100 Interest expense 80,000 176,000 62.500 EBT 422,640 - 158.560 146,600 Taxes (40%) 169,056 - 63,424 58.640 Net Income 253,584-95,136 187,960 (2021) Sales - total op costs + EBIT = taxes: EBT*.4 = 169,056 7.035,600 - EBT- 6202 Dentories to a CA-cosh-stin-acc rec. = EBT = EBIT-int. exp= -158,560 LT.deottotoi liitines-toto L = 1.000.000 taxes: EBTX.4 = -63,424 TE-total lab and equity-totas lialo. = 3,954,304 (2019) taxes - EBTX.4 = 58,640 net income: EBT-taxes= -95,136 RE: TE-Csand paid in Surplus=542,432 net income EBT-taxes = 87.969 3. Fill in the missing information from Kelpie Corp's Balance Sheet (10) Kelpie Corp Balance Sheet Assets 2021 2020 2019 Cash 28,000 14,564 18.000 Short term investments 143,264 40,000 97,200 Accounts receivable 1.756,000 1,264,320 702,400 inventories 3432.960 2.574.720 1,430,400 Total current assets 5,360,224 3,893,604 2.248.000 (2020) EBIT = sales - total tax costs=375446 notes payable total cu-acc.pay-accruals 600.000 Net fixed assets 1.673,680 1,879,580 689 600 Total assets 7,033,904 5.773,184 2,937,600 Liabilities and owners' equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities 719,600 648,000 600,000 1,440,000 760,000 569.920 2,079,600 2,657,920 1,000,000 2,000,000 3,079,600 4,657,920 291,200 400,000 272.000 963,200 646,864 1,610,064 Common stock and paid in surplus Retained earnings Total Equity 3,361,872 920,000 1592, 432 195,264 3,954.304 1,115,264 920,000 407,536 1,327,536 5,773,184 2,937,600 Total liabilities and equity 7,033,904 (2020) NFA = TA- total CA = 1,879,580 total CL = acc. pay-notes pay.- accruals = 2,657,920 LT.delot = total vial. - total CL - 2.000.000 (2019) NFA = total liab.and equity-total CA-689,600 ITA=NFA + total CA = 2,937,660

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Everything I Touch Turns To Sold Weekly And Montaly 2022 Planner

Authors: Printed Bliss Planners

1st Edition

979-8771975634

More Books

Students also viewed these Finance questions