Purpose Calculate Ratios and Make a visual Details 1. Go to www.sedar.com 3 4. 2. Download annual reports of a company for you will need 7 years of information In an Excel sheet, copy the income statement and balance sheet information for 7 years in 7 columns Calculate all liquidity and solvency ratios of the company for all seven years Select one liquidity and one solvency ratio, create a visual (graph/chart) in Excel that communicates the intended information to the reader Submit the Excel sheet and all the Annual Reports in PDF) that were used for creating the Excel sheet in Moodle Marking 5. 6. See Syllabus for the Rubric 1. Calculate all liquidity and solvency ratios of the company for all seven years Select one liquidity and one solvency ratio, create a visual (graph/chart) in Excel that communicates the intended information to the reader ACS Trust Statements of Net Assets As at August 31, 2014 and 2013 2014 2013 S Assets Cash Short-term investments Investments at fair value (average cost - 5100 380 754 2013 . $122,685,708) Interest and dividends receivable 299 504 112.490,578 1961,077 758,724 316,372 128,858,194 2,305,383 114,751,159 132,238,673 Liabilities Accounts payable and accrued liabilities Management fees payable Unrealired lous on foreign currency forward con d contracts 18,198 25.990 4.112.925 19.269 39,690 2,187,289 4,157 113 2.246.248 110,594,046 129.992425 Net assets and unitholder's equity Units outstanding (note 3) Net assets per unit 11.170.750 13.711.962 9.90 9.48 Unitholder's equity (note 5) Unut Capital Retained Earnings Total Unitholder's equity 108,899 456 1,694,590 129 205910 786,513 110,594 046 129,992,425 Approved on behalf of the Manager, Aston Hill Capital Markets Inc. ACS Trust Statements of Operations For the years ended August 31, 2014 and 2013 2014 2013 $ $ Income Interest income Dividends (net of withholding taxes) 7,609 863 151,555 8.699,751 313,047 7,761418 9.012,798 Expenses Management fees (note 7) Harmonized sales tax Custodial and other unitholder fees Andit fees Interest expense Filing fees Broker commission charges (note 9) Other fees 306,917 43.857 19.277 10,721 1,052 861 385, 186 54,922 25,782 11,510 2,675 2,201 1,326 450 383,135 483,602 7,378,283 8,529,196 Investment income Unrealized gain (loss) Change in unrealized gain (loss) on investments Change in unrealized gain (loss) on foreign currency forward contracts Change in realized yain (los) on foreign exchange 5,937,340 (1.925,637) 6,856 6,907,889 (2,791 293) 417 4,018, 559 4,117,013 Realized gain (loss) Net realized gain (los) on investments Net realized gain (loss) on foreign currency forward contracts Net realized yain (loss) on foreign exchange 2.152.592 (1,027,000) (133,116 (506,314) (23.945) 992.476 (730,259) 5,011,035 3,386,754 Net gain on investments Increase in net assets from operations Increase in net assets from operations per unit 12,389,318 11915.950 0.93 0.72 ACS Trust Statements of Changes in Net Assets and Retained Earnings For the years ended August 31, 2014 and 2013 2014 2013 12.389 318 11.915950 Increase in net assets from operations Distributions to unitholder from: (note 6) Net investment income Unitholder's transactions (note 5) Proceeds from issue of units Distributions reinvested Payments on redemption of its (10.295 223) (15.178.590) 3,639,035 (25.131 509) (21,492,474) 380,628 6,226,726 (32,634,350 (26,027,002) (19,398 379) (29,289,642) Change in net assets during the year Net assets - beginning of year Net assets - end of year 129.992.425 159.282,067 110,594,046 129.992,425 786,515 5,653.993 Retained Earnings, beginning of year Increase in net assets from operations Distributions to unitholder Cost of shares redeemed in excess of average price per unit Retained Earnings, end of year 12,389,318 (10,295,223) (1.186.020) 11,915,950 (15.178,590) (1,604,835) 1.694,590 786,515 Purpose Calculate Ratios and Make a visual Details 1. Go to www.sedar.com 3 4. 2. Download annual reports of a company for you will need 7 years of information In an Excel sheet, copy the income statement and balance sheet information for 7 years in 7 columns Calculate all liquidity and solvency ratios of the company for all seven years Select one liquidity and one solvency ratio, create a visual (graph/chart) in Excel that communicates the intended information to the reader Submit the Excel sheet and all the Annual Reports in PDF) that were used for creating the Excel sheet in Moodle Marking 5. 6. See Syllabus for the Rubric 1. Calculate all liquidity and solvency ratios of the company for all seven years Select one liquidity and one solvency ratio, create a visual (graph/chart) in Excel that communicates the intended information to the reader ACS Trust Statements of Net Assets As at August 31, 2014 and 2013 2014 2013 S Assets Cash Short-term investments Investments at fair value (average cost - 5100 380 754 2013 . $122,685,708) Interest and dividends receivable 299 504 112.490,578 1961,077 758,724 316,372 128,858,194 2,305,383 114,751,159 132,238,673 Liabilities Accounts payable and accrued liabilities Management fees payable Unrealired lous on foreign currency forward con d contracts 18,198 25.990 4.112.925 19.269 39,690 2,187,289 4,157 113 2.246.248 110,594,046 129.992425 Net assets and unitholder's equity Units outstanding (note 3) Net assets per unit 11.170.750 13.711.962 9.90 9.48 Unitholder's equity (note 5) Unut Capital Retained Earnings Total Unitholder's equity 108,899 456 1,694,590 129 205910 786,513 110,594 046 129,992,425 Approved on behalf of the Manager, Aston Hill Capital Markets Inc. ACS Trust Statements of Operations For the years ended August 31, 2014 and 2013 2014 2013 $ $ Income Interest income Dividends (net of withholding taxes) 7,609 863 151,555 8.699,751 313,047 7,761418 9.012,798 Expenses Management fees (note 7) Harmonized sales tax Custodial and other unitholder fees Andit fees Interest expense Filing fees Broker commission charges (note 9) Other fees 306,917 43.857 19.277 10,721 1,052 861 385, 186 54,922 25,782 11,510 2,675 2,201 1,326 450 383,135 483,602 7,378,283 8,529,196 Investment income Unrealized gain (loss) Change in unrealized gain (loss) on investments Change in unrealized gain (loss) on foreign currency forward contracts Change in realized yain (los) on foreign exchange 5,937,340 (1.925,637) 6,856 6,907,889 (2,791 293) 417 4,018, 559 4,117,013 Realized gain (loss) Net realized gain (los) on investments Net realized gain (loss) on foreign currency forward contracts Net realized yain (loss) on foreign exchange 2.152.592 (1,027,000) (133,116 (506,314) (23.945) 992.476 (730,259) 5,011,035 3,386,754 Net gain on investments Increase in net assets from operations Increase in net assets from operations per unit 12,389,318 11915.950 0.93 0.72 ACS Trust Statements of Changes in Net Assets and Retained Earnings For the years ended August 31, 2014 and 2013 2014 2013 12.389 318 11.915950 Increase in net assets from operations Distributions to unitholder from: (note 6) Net investment income Unitholder's transactions (note 5) Proceeds from issue of units Distributions reinvested Payments on redemption of its (10.295 223) (15.178.590) 3,639,035 (25.131 509) (21,492,474) 380,628 6,226,726 (32,634,350 (26,027,002) (19,398 379) (29,289,642) Change in net assets during the year Net assets - beginning of year Net assets - end of year 129.992.425 159.282,067 110,594,046 129.992,425 786,515 5,653.993 Retained Earnings, beginning of year Increase in net assets from operations Distributions to unitholder Cost of shares redeemed in excess of average price per unit Retained Earnings, end of year 12,389,318 (10,295,223) (1.186.020) 11,915,950 (15.178,590) (1,604,835) 1.694,590 786,515