Purpose:

Using spreadsheets to solve complex problems is a key competence $$ in fact a requirement $$ for many middle management positions in the workplace. Corporate finance provides many opportunities to use MS Excel to solve problems that cannot easily be solved manually.

Required:

Using the Globe Investor website $($part of the Globe and Mail newspaper$)($www$.$globeinvestor.com$)$ find the financial information for each of Canadian National Railway $($stock symbol: CNR$-$T$)$ and Canadian Pacific Kansas City Railway $($stock symbol: CP$-$T$).$

From the information provided from each stock quote, find and list the following financial information from their December $31$st$,2022$ year end.

Note $1$:

Under the stock quote, scroll down the page and find the financial information under the headline $$The Company Books$,$ you will find the Income Statement, Balance Sheet and Cash Flow under different tabs$.$ Please make sure you select the $$ANNUAL$$ financial information as opposed to the Quarterly information.

Note $2$:

The Information is posted in Millions of dollars, just write down the numbers as they are posted. The Total number of common shares outstanding can be found at the bottom of the Dec. $31$st Balance Sheet information.

Prepare a report, in MS Word format that will contain your Financial Statement Analysis using the ratio formulas.

Refer to the grading rubric at the end of this document.

$$

$1.$ Basic Share Price and Financial Information $(10$ marks$)$

From each of the companies$$ financial statements assigned to you, please find the following values:

Canadian National Railway $($CNR$)$ Canadian Pacific Kansas City Railway $($CPKS$)$

From the Stock Quote

Current Share Price

Current P$/$E Ratio

From the Income Statement

Total Sales and Revenue

Total Net Income $($or Total Net Earnings$)$

Basic Earnings per common share

$($Diluted Normalized EPS$)$

From the Balance Sheet

Value of Cash and Short$-$Term Investments

Value of Accounts Receivable

Value of Total Current Assets

Value of Total Assets

Value of Total Current Liabilities

Value of Total Liabilities

Value of Total Shareholders$$ Equity

Total number of Common Shares outstanding

From the Statement of Cash Flows

Total value of Cash provided by Operating activities

Total value of Cash provided by Investing activities

Total value of Cash provided by Financing activities