** Round to two (2) decimals as required.

Please use excel only or make writing legible

Case:

You are preparing for your final exams and your instructor is helping you prepare for the exam. She wants you to review the Statement of Financial Position and Statement of Earnings of Telus Inc. as of May 30, 2020 (Exhibits 1 and 2). Prepare a Statement of Cash Flows using the indirect method. The company is a private enterprise and chooses to follow ASPE. The instructor also wants you as part of the preparation process to evaluate the results from the Statement of Cash Flows, specifically identify the changes that occurred, if any. In addition, She wants you to also do an analysis using the analytical tools you have learned in the past. They include the following:

Current Ratio

Debt to Equity Ratio

Accounts Receivable Turnover Ratio

Inventory Turnover Ratio

ROE

Additional Data:

a. Bought equipment for cash $12,000

b. Paid $6,000 on Long Term Debt

c. Issued new shares for $16,000 cash

d. No dividends were declared

e. Other expenses included depreciation, $5,000; wages, $20,000; taxes $6,000; other, $$6,800

f. Accounts Payable includes only inventory purchases made on credit. Because there are no liability accounts relating to taxes or other expenses, assume these expenses were fully paid in cash.

g. Accounts Receivable for 2020 is $35,750, and total shareholders' equity for 2018 is $111,100

Exhibit 1 -

Telus Inc.

Statement of Financial Position

2020-05-30 (in 000's)

[Row #1 - 2020] [Row #2 - 2019]

Exhibit 2 -

Telus Inc.

Statement of Earnings

May 30, 2020

[Row #1 is 2020] [Row #2 is 2019]

Assets \begin{tabular}{llr} Revenue & $120,000 & $115,000 \\ Cost of Goods Sold & 78,00070,000 \\ \cline { 2 } Gross Margin & $50,000 & $37,000 \\ Expenses: & $37,800 & \\ Other Expenses & $24,000 \\ \cline { 2 } Net Income & $12,200 & $13,000 \\ \hline \end{tabular}