Financial Statement AnalysisCompute for Activity Ratios/Asset Management Ratios with Analysis for year 2018 - 2020:Average Age of InventoryOperating CycleFixed-Asset Turnover RatioTotal Asset Turnover Equity Attributable to Equity Holders of the Parent CompanyCapital stock (Note 22) :Php 872,124.00200,000.00Php 872,124.00200,000.00CommonPhp 872,124.00200,000.00PreferredAdditional paid -in capitalTreasury shares and Philippine depository receipts convertible to4,745,399.00475,399.004,745,399.00common shares (Note 22)(1,638,719.00)244,980.00(1,638,719.00)550,689.00(1,638,719.00)921,624.00Exchange differences on translation of foreign operationsUnrealized gain on AFS Investments ( Note 13)Fair value reserves on financial assets at FVOCI (Note 13)Retained earnings (Note 22)71,712.00172,920.00205,969.0013,794,643.00271,114,963.0030,291,703.00Equity attributable to equity holders of the Parent Company18,290,139.0032,017,376.0035,598.100.00Noncontrolling Interest (Note 4)(1,091,288.00)(926,171.00)126,348.00Total Equity17,198,851.0031,091,205.0035,724,448.00TOTAL LIABILITIES AND EQUITYPhp 58,926,177.00Php 79,244,536.00Php84,559,217.00ABS-CBN CORPORATION AND SUBSIDIARIESCONSOLIDATED STATEMENTS OF INCOME(Amounts in Thousands, Except Per Share Amounts)Years Ended December 31|202020192018REVENUES (Notes 5, 23, 24 and 31)P21,419,757P42,834,842P40,130,592(12,345,277)(10,785,230)(2,493,359)PRODUCTION COSTS (Notes 10, 12, 23, 25, 30 and 31)COST OF SERVICES (Notes 8, 10, 12, 15, 23, 26, 30 and 31)COT OF SALES (Notes 8, 10, 23, 26, 30 and 31)(10,310,826)(9,136,575)(284,707)(13,135,798)(11,010,926)(2,136,680)GROSS PROFIT1,687,64916,551,43814,506,726GENERAL AND ADMINISTRATIVE EXPENSESFINANCE COSTS (Notes 18, 20 and 28)INTEREST INCOME (Note 6)(Notes 7, 8, 10, 11, 12, 22, 23, 27, 30 and 31) (13,815,768)(1,213,934)201,101(16,113,809)(1,547,422)(12,310,128)(1,124,677)560,421202,801FOREIGN EXCHANGE GAINS (LOSSES) – Net(382,796)(312,254)404,031EQUITY IN NET LOSSES OF ASSOCIATES ANDJOINT VENTURES (Note 14)(47,634)(18,721)(29,706)OTHER INCOME - Net (Notes 15, 21, 28 and 31)92,837530,469331,253INCOME (LOSS) BEFORE INCOME TAX(13,478,545)(349,878)1,980,300PROVISION FOR (BENEFIT FROM) INCOME TAX (Note 29)Current538,985676,294600,791Deferred(486,714)1,618,975(528,732)52,2712,295,26972.059NET INCOME (LOSS)(P13,530,816)(P2,645,147)P1,908,241Net Income Attributable to:Equity holders of the Parent Company (Note 34) (P13,456,161)Noncontrolling interests(P1,624,858)(1,020,289)P2.110,251(74,655)(202,010)(P13,530,816)(P2,645,147)P1,908,241Basic/Diluted Earnings (Loss) Per Share Attributableto Equity Holders of the Parent Company (Note 34) (P16.356)(P1.979)P2.560 ABS-CBN CORPORATION AND SUBSIDIARIESCONSOLIDATED STATEMENT OF FINANCIAL POSITION(Amounts in Thousands)12/31/202012/31/201912/31/2018ASSETSCurrent AssetsCash and cash equivalents (Note 6)Short- term Investments (Note 6)Trade and other receivables (Note 7 and 23)Php 6,429,726.0011,680.00Php 12,169,917.006,998,695.00Php18,104,686.001,804,041.005,563,130.0010,605,433.0010,369,080.00524,905.00675,607.001,286,661.00Inventories680,628.00Program rights and other Intangible assets (Note 12)Other current assets (Note 9,15 and 23)1,011,070.001,359,188.005,142,376.0018,682,887.005,383,138.0037,780,761.005,411,370.00Total Current Assets37,147,683.00Noncurrent AssetsProperty and equipment (Notes 10,18 and 31)26,758,264.0027,473,741.0027,875,625.00Goodwill, program rights, and other intangible assets-net ofcurrent position (Note 12)10,421,284.0011,384,697.0013,310,366.00Financial assets at fair value through other comprehensiveincome (FVOCI) (Note 13)61,846.00263,126.00268,304.00Investment properties (Note 11 and 18)Investments in associates and joint ventures (Note 14)Deferred tax assets (Note 29)141,112.00198,692.00268,304.00161,382.00425,864.00202,763.001,715,052.001,147,107.00495,247.00Other noncurrent assets (Notes 7,16 and 23)984,350.001,203,626.003,020,803.0040,243,290.0058,926,177.00Total Noncurrent Assets42,096,853.0079,244,536.001,685,348.0084,559,217.00TOTAL ASSETSLIABILITIES AND EQUITYCurrent LiabilitiesTrade and other payables (Notes 4, 17, 23 and 30)Php 9,826,832.00Php 11,772,942.00Php13,637,426.00756,876.00Contract Liabilities (Note 9)Income tax payableObligations for program rights (Note 19)Current lease liabilities (Note 31)Interest-bearing loans and borrowings (Notes 10,11, 18)1,064,650.00890,644.00218,521.00302,649.00208,056.00303,440.00302,647.00513,755.00233,560.00441,875.00310,088.0017,053,458.00414,911.00Total Current Liabilities28,399,335.0014,260,065.0015,592,912.00Noncurrent LiabilitiesInterest-bearing loans and borrowings - net of currentportion (Notes 10, 11, and 18)4,433,796.0025,512,844.0027,810,584.00Obligations for program rights -net of current portion(Note 19)360,996.00441,466.00541,548.00Accrued pension obligation and other employee benefits(Note 30)Deferred tax liabilities (Note 29)Noncurrent lease liabilities (Note 31)Convertible note (Note 20)Other noncurrent liabilities (Note 21)6,958,955.004,029,891.00138,271.006,004,432.00353,639.00458,355.00636,234.00780,719.00221,217.00500,346.00243,477.00238,305.00340,894.00457,145.00Total Noncurrent Liabilities13,327,991.0033,893,266.0033,241,857.00Total Liabilities41,727,326.0048,153,331.0048,834,769.00

Financial Statement Analysis Compute for Activity Ratios/Asset Management Ratios with Analysis for year 2018 - 2020: Average Age of Inventory Operating Cycle Fixed-Asset Turnover Ratio Total Asset Turnover

Financial Statement Analysis Compute for Activity Ratios/Asset Management Ratios with Analysis for year 2018 - 2020: Average Age of Inventory Operating Cycle Fixed-Asset Turnover Ratio Total Asset Turnover

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

see below table of Ratios for a company. Comment on the liquidity, profitability, leverage, asset management and market value. Ratio Analysis 2021 Est. 2020 2019 Industry Average Liquidity Ratios Current Ratio (times) 2.34 3.22 3.68 4.2 Quick Ratio (times) 0.91 1.24 1.79 2.1 Asset Management Ratios Average sales/day 10.96 8.22 7.81 9 Inventory Turnover Ratio (times) 4.43 3.74 5.06 9 Days Sales Outstanding (days) 38.32 45.62 40.34 36 Fixed Assets Turnover Ratio (times) 2.12 2.52 3.27 3 Total Asset Turnover Ratio 1.32 1.37 1.69 1.8 Debt Management Ratios Total Debt to Total Assets (%) 59.09 48.58 47.6 40 Times Interest Earned (times) 7.9 6.81 11 6 Debt to Equity Ratio (%) 1.49 0.98 0.95 1 Profitability…
Calculate the ratios of Coles group of Australia for the year 2021: Ratios to calculate: Profitability (ROSF, ROCE, Gross margin, Operating profit margin, Cash flow to Sales*) Efficiency (Inventory turnover period, Average settlement period, Sales revenue to capital employed) Liquidity (Current ratio, Acid test (quick) ratio, Cash flow ratio*). Stability/Capital Structure (Gearing ratio, Interest cover ratio, Debt coverage ratio*) Investment/Market Performance (Earnings per share, Price earnings ratio, Operating cash flow per share*)
Fixed asset turnover ratio : 2015: 7.48x 2016: 6.14x 2017: 7.70x 2018: 4.59x 2019: 6.38x What is the trend analysis from 2015 to 2019
Cullumber Limited competes in the fast food industry with Bramble Limited. Cullumber underwent a major expansion in 2021, borrowing a large amount of money and acquiring a small competitor. The acquisition doubled the number of restaurants that Cullumber has. Bramble, on the other hand, took a more conservative approach and did not buy any new assets, focusing instead on making existing operations more efficient. Data for the two companies are provided below (in thousands of dollars): Cullumber Total assets Sales Net income Bramble Total assets Sales Net income 2021 $1,850 3,161 361 807 1,822 190 2020 $1,099 $1,070 1,490 144 880 1,671 2019 205 1,600 140 1,070 2,000 210
What financial metric measures a company's ability to cover its short-term obligations with its most liquid assets and is calculated by excluding inventory from the current assets? A. Quick ratio B. Current ratio C. Inventory turnover ratio D. Return on assets ratio
Required: (a) You are required to calculate the following ratios:(i) Gross profit margin(ii) Operating profit margin(iii) Expenses to sales(iv) Return on Capital Employed(v) Asset turnover(vi) Non-current asset turnover(vii) Current Ratio(viii) Quick Ratio(ix) Inventory days(x) Receivables days(xi) Payable days(xii) Interest cover (b) In light of your calculations comment on the performance of the company over thelast two years.
Using the financial statements in the image, calculate the following ratios for both the FY 2017 and FY 2018: Current Ratio Quick Ratio Total Asset Turnover Average Collection Total Debt to Total Assets Times Interest Earned Net Profit Margin Return on Assets Return on Equity Modified Du Point Equation for FY 2018 PE Ratio Market to Book Ratio
The ROI formula typically uses O average operating and non-operating assets for the year O end of year operating and non-operating assets O average operating assets for the year O end of year operating assets
Refine Assumptions for PPE ForecastFollowing are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income ($ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income, net (373) Interest expense 1,444 Income (loss) before income taxes 5,197 Income tax provision 547 Net income (loss) 4,650 Net (income) loss attributable to noncontrolling interests (19) Net income (loss) attributable to Medtronic $ 4,631 Consolidated Balance Sheet ($ millions) April 26, 2019 Current assets Cash and cash equivalents $ 4,393 Investments 5,455 Accounts receivable, less…
Calculate the following profitability ratios for 2018 and 2019. a. Gross profit ratio b. Return on assets c. Profit margin d. assets turnover
interpret or compare its results from 2018 to 2019
Below are the ratio results for Abcom for the year 2022. Performance Operating margin -18.66% Asset turnover 0.16 Return on Capital Employed -7.64% Working capital Inventory days 88.88 days Debtor days 46.18 days Trade creditor days 68.11 days Liquidity Current ratio 0.30 Acid test 0.25 Solvency Interest cover -2.56 Shareholder's view Return on equity 7.16% Required; Analyse and interpret the meaning of these results.