Calculate Ratios and Make a vistal Details 1. Go to www.sedar.com 2. Download annual reports of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Calculate Ratios and Make a vistal Details 1. Go to www.sedar.com 2. Download annual reports of a company for you will need 7 years of information) 3. 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 4. 5. Select one liquidity and one solvency ratio, create a visual (graphychart) in Excel that communicates the intended information to the reader 6 Submit the Excel sheet and all the Annual Reports in PDF) that were used for creating the Excel sheet in Moodle Marking See Syllabus for the Rubric ACS Trust Statements of Net Assets As at August 31, 2014 and 2013 2014 2013 Assets Cash 299 504 758,724 Short-term investments Investments at fair value (average cost - $100 380,754 2013 - $122,685,708) 316,372 112,490,578 128,858,194 Interest and dividends receivable 1,961,077 2,305,383 114,751,159 132,238,673 Liabilities Accounts payable and accrued liabilities Management fees payable Unrealized loss on foreign currency forwar 18,198 25,990 4,112,925 19,269 39,690 2,187,289 d contracts 4,157,113 2,246,248 Net assets and unitholder's equity 110,594,046 129,992,425 Units outstanding (note 5) 11,170,750 13,711,962 Net assets per unit 9.90 948 Unitholder's equity (note 5) Unit Capital Retained Earnings 108,899 456 1.694 590 129.205,910 786,515 Total Unitholder's equity 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 4. Income Interest income Dividends (net of withholding taxes) 7,609 863 8,699,751 151,555 313,047 7,761418 9,012,798 Еxpenses Management fees (note 7) Harmonized sales tax 306,917 385,186 43,857 54,922 Custodial and other unitholder fees Audit fees 25,782 11,510 19,277 10,721 Interest expense Filing fees Broker commission charges (note 9) Other fees 1,052 2,675 861 2,201 1,326 450 383,135 483,602 Investment income 7,378,283 8,529,196 Unrealized gain (loss) Change in unrealized gain (loss) on investments Change in unrealized gain (loss) on foreign currency forward contracts Change in unrealized gain (los) on foreign exchange 5,937,340 6,907,889 (2,791,293) (1,925,637) 6,856 417 4,018,559 4.117,013 Realized gain (loss) Net realized gain (loss) on investments Net realized gain (loss) on foreign currency forward contracts Net realized gain (los) on foreign exchange 2,152,592 (506,314) (1,027,000) (133.116) 223,945) 992.476 730,259) Net gain on investments 5,011,035 3.386.754 Increase in net assets from operations 12,389,318 11.915,950 Increase in net assets from operations per unit 093 0.72 ACS Trust Statements of Changes in Net Assets and Retained Earnings For the years ended August 31, 2014 and 2013 2014 2013 Increase in net assets from operations 12,389 318 11,915 950 Distributions to unitholder from: (note 6) Net investment income (10.295 223) (15.178,590) Unitholder's transactions (note 5) Proceeds from issue of units Distributions reinvested Payments on redemption of units 380,628 6,226,726 3,639,035 (25.131,509) (32,634,356) (21.492,474) (26,027,002) Change in net assets during the year (19,398,379) (29289,642) Net assets - beginning of year 129,992,425 159,282.067 Net assets - end of year 110,594,046 129.992,425 Retained Earnings, beginning of year 786,515 5,653,993 Increase in net assets from operations Distrabutions to unitholder 12,389,318 11,915,950 (10,295,223) (1,186,020) (15,178,590) (1,604,838) Cost of shares redeemed in excess of average price per unit Retained Earnings, end of year 1,694,590 786,515 Calculate Ratios and Make a vistal Details 1. Go to www.sedar.com 2. Download annual reports of a company for you will need 7 years of information) 3. 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 4. 5. Select one liquidity and one solvency ratio, create a visual (graphychart) in Excel that communicates the intended information to the reader 6 Submit the Excel sheet and all the Annual Reports in PDF) that were used for creating the Excel sheet in Moodle Marking See Syllabus for the Rubric ACS Trust Statements of Net Assets As at August 31, 2014 and 2013 2014 2013 Assets Cash 299 504 758,724 Short-term investments Investments at fair value (average cost - $100 380,754 2013 - $122,685,708) 316,372 112,490,578 128,858,194 Interest and dividends receivable 1,961,077 2,305,383 114,751,159 132,238,673 Liabilities Accounts payable and accrued liabilities Management fees payable Unrealized loss on foreign currency forwar 18,198 25,990 4,112,925 19,269 39,690 2,187,289 d contracts 4,157,113 2,246,248 Net assets and unitholder's equity 110,594,046 129,992,425 Units outstanding (note 5) 11,170,750 13,711,962 Net assets per unit 9.90 948 Unitholder's equity (note 5) Unit Capital Retained Earnings 108,899 456 1.694 590 129.205,910 786,515 Total Unitholder's equity 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 4. Income Interest income Dividends (net of withholding taxes) 7,609 863 8,699,751 151,555 313,047 7,761418 9,012,798 Еxpenses Management fees (note 7) Harmonized sales tax 306,917 385,186 43,857 54,922 Custodial and other unitholder fees Audit fees 25,782 11,510 19,277 10,721 Interest expense Filing fees Broker commission charges (note 9) Other fees 1,052 2,675 861 2,201 1,326 450 383,135 483,602 Investment income 7,378,283 8,529,196 Unrealized gain (loss) Change in unrealized gain (loss) on investments Change in unrealized gain (loss) on foreign currency forward contracts Change in unrealized gain (los) on foreign exchange 5,937,340 6,907,889 (2,791,293) (1,925,637) 6,856 417 4,018,559 4.117,013 Realized gain (loss) Net realized gain (loss) on investments Net realized gain (loss) on foreign currency forward contracts Net realized gain (los) on foreign exchange 2,152,592 (506,314) (1,027,000) (133.116) 223,945) 992.476 730,259) Net gain on investments 5,011,035 3.386.754 Increase in net assets from operations 12,389,318 11.915,950 Increase in net assets from operations per unit 093 0.72 ACS Trust Statements of Changes in Net Assets and Retained Earnings For the years ended August 31, 2014 and 2013 2014 2013 Increase in net assets from operations 12,389 318 11,915 950 Distributions to unitholder from: (note 6) Net investment income (10.295 223) (15.178,590) Unitholder's transactions (note 5) Proceeds from issue of units Distributions reinvested Payments on redemption of units 380,628 6,226,726 3,639,035 (25.131,509) (32,634,356) (21.492,474) (26,027,002) Change in net assets during the year (19,398,379) (29289,642) Net assets - beginning of year 129,992,425 159,282.067 Net assets - end of year 110,594,046 129.992,425 Retained Earnings, beginning of year 786,515 5,653,993 Increase in net assets from operations Distrabutions to unitholder 12,389,318 11,915,950 (10,295,223) (1,186,020) (15,178,590) (1,604,838) Cost of shares redeemed in excess of average price per unit Retained Earnings, end of year 1,694,590 786,515
Expert Answer:
Answer rating: 100% (QA)
2015 2014 2013 2012 2011 Assets Current assets Cash 2304974 299504 758724 699052 1193484 Shortterm investments 316372 Financial assets at fair value through profit or loss 100466340 112490578 12885819... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
For the following findings, indicate the income statement and balance sheet accounts that are affected and whether these accounts are over or understated, and provide an adjusting entry to correct...
-
The income statement and balance sheet for Rollins Company are provided below. Using the DuPont framework, compute the profit margin, asset turnover, assets-to-equity ratio, and resulting return on...
-
The Income Statement and Balance Sheet columns of Braiden Company's work sheet are shown below. Braiden Company Work Sheet (Partial) For Year Ended December 31, 20 Additional information needed to...
-
Please create an IMC (integrated marketing communication) on Pratt&Whitney, mainly on in-person promotion/personal selling, events/meetings it attended(exhibition, military expo, exchange meetings...
-
City Bus Lines is developing an information system that will monitor passenger traffic, peak travel hours, and equipment requirements. The IT manager wants you to document a process called BALANCE...
-
Refer to the information for Kitchenware Inc. in AP5 5. In Problem Required: 1. Prepare a statement of cash flows for Kitchenware Inc. for the year ended December 31, 2015. Use the direct method to...
-
Suppose that the candidate for governor wants to hold rallies around the state but time before the election is very limited. They would like to leave their home in city \(A\), visit cities \(B, C, D,...
-
1. Is this a case of too much dysfunctional conflict and not enough functional conflict? Explain. 2. Which antecedents of conflict are evident in this case? Which one likely caused the most problems?...
-
Axel Company and Rod Company completed the following merchandising transactions in the month of April. Axel Company follows periodic inventory system and Rod Company follows perpetual inventory...
-
Del Conte Construction Company has experienced generally steady growth since its inception in 1976. Management is proud of its record of having maintained or increased its earnings per share in each...
-
Required information (The following information applies to the questions displayed below.) Trey Monson starts a merchandising business on December 1 and enters into the following three inventory...
-
Using Mat Lab 2. Consider Finish writing the function myAtan () that returns (in outarg) an approximation of the arctangent of an input x, using the Taylor Series expansion shown below. Use a while...
-
K Archeologists have studied sizes of Egyptian skulls in an attempt to determine whether breeding occurred between different cultures. Listed below are the widths (mm) of skulls from 150 A.D....
-
Managers consider the organizational goals and mission statement when preparing a budget and for strategic planning purposes. In your initial post, you must respond to each of the following prompts...
-
Many people think that human development means childhood development from birth to adolescence. This assumption had been supported by the developmental theories of Freud and Piaget. However, we will...
-
9. Jenny received two endorsement offers Under Armour offers $50,000 to be paid, in a single payment, in 5 years and Nike negotiated a long-term deal that called for yearly payments to Jenny of...
-
Given A = 0.5 0.1 0 0.5 find the changes in production required to meet an increase in demand of 60 units of Sector 1 products and 70 units of Sector 2 products
-
How does Kant answer Humes bundle theory of self? Do you think he is successful?
-
A company selling life insurance policies is planning to implement the Balanced Scorecard approach. The board of directors is aware that it should consider four aspects of vision and goals: ...
-
The upholstery department of a furniture manufacturing business prepared the following statement of standard costs at the start of the calendar year: Standard cost per unit Direct material...
-
Standard pine benches are assembled and packed in the bench assembly department of Furniture Manufacture Ltd. The department is treated as a cost centre. Control reports prepared every month consist...
-
The Buy-It Design Corporation creates radio and television advertising for local businesses in the twin cities. The following alphabetical list shows Buy-It Designs account balances as of January 31,...
-
Graph \(K . n ightarrow q ightarrow o ightarrow p ightarrow m\) Use the figure shown to determine whether the sequence of vertices in the given graph is a Hamilton path, an Euler trail, both, or...
-
Nomar Parra bid for and won a concession to rent bicycles in the local park during the summer. During the month of June, Parra completed the following transactions for his bicycle rental business:...
Study smarter with the SolutionInn App