Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Perform balance sheet analysis . show each calculation in excel . show different ratios among quaters ( to analyze ) and also show vertical and

Perform balance sheet analysis . show each calculation in excel . show different ratios among quaters ( to analyze) and also show vertical and horizontal analysis in excel sheet . attach screenshot of excel .
Balance sheet
Fiscal Year ends inDecCADinMillionsexcept per share data YoY %Chg 23-Dec 22-Dec 21-Dec 20-Dec 19-Dec
Total Assets 8.72%79,90273,49568,17723,64022,367
Current Assets 58.92%3,0021,8891,3521,3211,210
Cash Cash Equivalents And Short Term Investments 2.88%46445169147133
Cash And Cash Equivalents 2.88%46445169147133
Cash 2.88%464451
Accounts Receivable 86.94%1,9761,057819825805
Inventory 40.85%400284235208182
Restricted Cash 13
Other Current Assets 81.88%25113821614190
Total Non Current Assets 7.39%76,90071,60666,82522,31921,157
Net PPE 131.15%51,74422,38521,48720,73819,514
Gross PPE 95.03%61,78531,68030,13829,36727,613
Properties 26,422
Land And Improvements 446.27%5,266964
Buildings And Improvements 62.02%1,7321,0691,022937833
Machinery Furniture Equipment 84.80%54,78729,647
Other Properties 3,03829,11628,43026,780
Accumulated Depreciation 8.03%-10,041-9,295-8,651-8,629-8,099
Goodwill And Other Intangible Assets 5263.47%20,703386371366206
Goodwill 5053.78%17,729344328329194
Other Intangible Assets 6980.95%2,97442433712
Investments And Advances -98.82%53345,31442,518199341
Defined Pension Benefit 7.64%3,3383,1012,3178941,003
Other Non Current Assets 38.57%58242013212293
Total Liabilities Net Minority Interest 8.33%37,49134,60934,34816,32115,298
Current Liabilities 77.72%5,7103,2133,1592,6532,292
Payables And Accrued Expenses 50.10%2,2651,5091,3301,1991,325
Payables 31.08%1,3371,020778644708
Accounts Payable 35.19%680503432401453
Total Tax Payable 44.07%255177164115139
Income Tax Payable 44.07%255177
Dividends Payable 177177177127114
Other Payable 38.04%225163512
Current Accrued Expenses 89.78%928489552555617
Interest Payable 141134131
Current Provisions 52.83%8153604662
Current Debt And Capital Lease Obligation 105.64%3,2451,5781,6091,249668
Current Debt 108.15%3,1431,5101,5501,186599
Other Current Borrowings 1,5501,186599
Current Capital Lease Obligation 50.00%10268596369
Current Deferred Liabilities 3438152
Current Deferred Revenue 3438152
Other Current Liabilities 63.01%11973
Total Non Current Liabilities 1.23%31,78131,39631,18913,66813,006
Long Term Provisions 181.69%20071687170
Long Term Debt And Capital Lease Obligation 6.81%19,59318,34318,8018,8338,443
Long Term Debt 6.67%19,35118,14118,5778,5858,158
Long Term Capital Lease Obligation 19.80%242202224248285
Non Current Deferred Liabilities -9.10%11,13612,25111,4133,7233,531
Non Current Deferred Taxes Liabilities -9.39%11,05212,19711,3523,6663,501
Non Current Deferred Revenue 55.56%8454615730
Employee Benefits 11.92%742663843978896
Other Non Current Liabilities 61.76%11068646366
Total E

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

Step: 3

blur-text-image

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

Auditing Cases An Interactive Learning Approach

Authors: Mark S. Beasley, Frank A. Buckless, Steven M. Glover, Douglas F. Prawitt

6th edition

133852105, 978-0133852103

More Books

Students also viewed these Accounting questions