Question: Calculate the following with mathematical formulas using the tables' data of Air Canada company.( The tables are balance sheet and income statement.) *Efficiency Ratios (Inventory

Calculate the following with mathematical formulas using the tables' data of Air Canada company.( The tables are balance sheet and income statement.)

*Efficiency Ratios (Inventory Turnover and Inventory holding period, Receivables Turnover and Average collection period, Account payable turnover ratio and Payable deferral period)

Fiscal year is January-December. All values CAD Millions. Sales/Revenue Sales Growth Cost of Goods Sold

Gross Profit Margin SG&A Expense Other SG&A SGA Growth Other Operating Expense EBIT Unusual Expense Non

Interest Capitalized Pretax Income Pretax Income Growth Pretax Margin Income Tax Income Tax-Current Domestic

Net Income Available to Common EPS (Basic) EPS (Basic) Growth Basic Shares Outstanding EPS (Diluted) EPS

Assets Fiscal year is January-December. All values CAD Millions. Cash & Short Term Investments Cash Only Cash

Inventories Raw Materials Other Current Assets Miscellaneous Current Assets Total Current Assets Net

Accumulated Depreciation Buildings Machinery & Equipment Other Property, Plant & Equipment Total Investments

Other Assets Deferred Charges Tangible Other Assets Total Assets Assets-Total-Growth Asset Turnover Return On

Accounts Payable Accounts Payable Growth Other Current Liabilities Miscellaneous Current Liabilities Total

Provision for Risks & Charges Deferred Taxes Deferred Taxes - Credit Deferred Taxes - Debit Other Liabilities

Common Equity (Total) Common Stock Par/Carry Value Additional Paid-in Capital/Capital Surplus Retained

Fiscal year is January-December. All values CAD Millions. Sales/Revenue Sales Growth Cost of Goods Sold (COGS) incl. D&A COGS excluding D&A Depreciation & Amortization Expense Depreciation Amortization of intangibles COGS Growth Gross income Gross Income Growth 2022 16,556 158.69% 12,850 11,218 1,632 1,507 125 67.34% 3,706 389.76% 2021 6,400 9.72% 7,679 6,077 1,602 1,498 104 0.25% (1,279) 29.99% 2020 5,833 -69.51% 7,660 5,825 1,835 1,733 102 -44.77% (1,827) -134.72%

Step by Step Solution

★★★★★

3.37 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Here are the calculations for the efficiency ratios Inventory Turnover Ratio 2022 ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The following information concerns seven US companies operating solely or mainly restaurants. McDonalds Corporation McDonalds Corporation franchises and operates McDonalds restaurants in the food...

Balance sheet and income statement data for two affiliated companies for the cur rent year appear below. Additional Information ¢ Albeniz acquired an 80% interest in Bach on January 1, Year 1,...

Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...

Calculate the following with mathematical formulas using the tables' data of Air Canada company.( The tables are balance sheet and income statement.) *Efficiency Ratios (Inventory Turnover and...

Calculate the following with mathematical formulas using the tables of Air Canada company: *Liquidity Ratios (Current Ratio, Acid-test Ratio, Cash Ratio) *Solvency Ratios (Debt to Equity Ratio, Debt...

ALL ANSWERS MUST BE IN A FORMULA A E F . This Year ces Cash 54980,000 2.988000 1992.000 10 Inventory 1 Recent financial statements for Zimmer, Inc. are as follows: 2 Zimmer Company Zimmer Company 3...

1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios that managers use for asset management purposes 3. Compute and interpret...

please show the formula to input for each yellow slot. Zimmer, Inc. has provided its recent financial statements. The Controller has asked you to use this information to compute and interpret...

Answer must be in excel form with formulas Chapter 13 Homework i Saved 18 1. Compute and interpret financial ratios that managers use to assess liquidity. 2. Compute and interpret financial ratios...

The answer needs to be in excel form. thank you. This is the updated version. Chapter 13 Homework i Saved 18 1. Compute and interpret financial ratios that managers use to assess liquidity. 2....

A drill that operated satisfactorily for drilling cast iron gave very short life when used for drilling a plastic. What might be the reason for this?

Ex. (13): Apply the Divergence theorem to compute f F. ds, where S is the surface of cylinder x + y = a bounded by the planes z = 0, z = b and F = xi-yj+zk?

The number of women graduating from 4 - yr colleges in a particular country grew from 1 9 3 0 , function that fits the data, and the exponential growth rate. Find an exponential function that fits...

Most top executives and boards of directors are not engaged in the influenza pandemic (COVID-19) planning process and won't give it equal billing to other potential disruptions until at least one of...

GAAP Air Ltd. (GAAP Air) is an airline that was started five years ago to take advantage of the popular brand name associated with The GAAP clothing chain. GAAP Air was incorporated as a separate...

FutureHolding Ltd holds a well-diversified portfolio of shares with a current market value on 1 July 2021 of $3 million. On this date, FutureHolding Ltd decides to hedge the portfolio by taking a...

From the environmental cost perspective, is the Covid-19 pandemic effect in a good or bad way for the economic growth worldwide.

17Maltiple Choice1 pointEmily, Shalonda, and Tomas all work at Terence Butler Lile 6. Auto, an insurance agency. Their boss, Terence, has a very full schedule, but he knows he can rely on his three...

Unilever is a Anglo-Dutch supplier of fast moving consumer goods. The two parent companies, Unilever N.V. and Unilever PLC, together with their group companies, operate as Unilever Group. The...

For over 80 years, the adidas Group has been part of the world of sports on every level, delivering state-of-the-art sports footwear, apparel and accessories.9 Today, the adidas Group, headquartered...

The group China Communications Construction is based in the Peoples Republic of China and principally engaged in infrastructure construction, infrastructure design, dredging and manufacturing of port...

=+(cf. Example 5.8, Section 5.3) and that each component has a .999 probability of functioning without failure. What lower bound can you put on the reliability (i.e., the probability of functioning...

=+12. Suppose that 55% of all adults regularly consume coffee, 45% regularly consume carbonated soda, and 70% regularly consume at least one of these two types of drinks.

=+.01 probability of failing. Find an upper bound on the probability that the entire system fails.