Need ONLY an answer to Part C, step 1, questions 1 and 3.

Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most recent annual report online for the Canadian public company assigned to the last 2 digits of your student number as per the table provided below. The annual report obtained from SEDAR must contain audited financial statements and the MDA (management's discussion and analysis). Example: if your student number is 1234567, the last 2 digits of your student number are 6 and 7 and the company assigned to you is Metro Inc. Last 2 digits of your student # 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 Company Assigned Last 2 digits of your student # Absolute Software Corporation 50 Acadian Timber Corp. 51 Aecon Group Inc. 52 AEterna Zentaris Inc. 53 Ag Growth International Inc. 54 Agrium Inc. 55 Air Canada 56 AlarmForce Industries Inc. 57 Alimentation Couche-Tard Inc. 58 AltaGas Ltd. 59 Bank of Montreal 60 Bank of Nova Scotia, The 61 Barrick Gold Corporation 62 BCE Inc. 63 Big Rock Brewery Inc. 64 BlackBerry Limited 65 Bombardier Inc. 66 Brookfield Asset Mgmt Inc 67 Buhler Industries Inc. 68 Canadian National Railway Co. 69 Canadian Imperial Bank of 70 Commerce 71 Canadian Pacific Railway Limited Canadian Tire Corporation, Ltd 72 Company Assigned Fission Uranium Corp. Gildan Activewear Inc. Glencore Canada Corporation Great-West Lifeco Inc. Helix BioPharma Corp. High Liner Foods Incorporated IMAX Corporation Imperial Oil Limited Inovio Pharmaceuticals, Inc. Leon's Furniture Limited Linamar Corporation Loblaw Companies Limited Lojack Corporation lululemon athletica inc. Magna International Inc. Maple Leaf Foods Inc. Martinrea International Inc. Metro inc. Molson Coors Brewing Company National Bank of Canada Potash Corporation of Saskatchewan Inc. Sleep Country Canada Holdings Inc. Rare Element Resources Ltd. 1 Last 2 digits of your student # 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Company Assigned Last 2 digits of your student # Canadian Western Bank 73 Cara Operations Limited 74 Cargojet Inc. 75 Cascades Inc. 76 Catalyst Paper Corporation 77 Celestica Inc. 78 Celestica Inc. 79 Cenovus Energy Inc. 80 Cervus Equipment Corporation 81 Cineplex Inc. 82 Clean Harbors, Inc. 83 Clearwater Seafoods Inc. 84 Cogeco Cable Inc. 85 Contact Minerals Corp. 86 Continental Energy Corporation 87 88 Co-operators General Insurance Company Corus Entertainment Inc. 89 90 Destiny Media Technologies Inc. DiagnoCure Inc. 91 Domtar Corporation 92 Eldorado Gold Corporation 93 Emera Incorporated 94 Enbridge Inc. 95 Encana Corporation 96 Exco Technologies Limited 97 Fennec Pharmaceuticals Inc. 98 Fortis Inc. 99 Company Assigned Reitmans (Canada) Limited Richelieu Hardware Ltd. Rogers Communications Inc. RONA inc. Royal Bank of Canada Saputo Inc. Shaw Communications Inc. Shopify Inc. Sirius XM Canada Holdings Inc. Progressive Waste Solutions Ltd. SNC-Lavalin Group Inc. Spin Master Corp. Student Transportation Inc. Suncor Energy Inc. TELUS Corporation The Toronto-Dominion Bank theScore, Inc. Valeant Pharmaceuticals International, Inc. Toromont Industries Ltd. Torstar Corporation Tyco International plc Thomson Reuters Corporation Visa Inc. WestJet Airlines Ltd. Xerox Corporation Yellow Pages Limited ZCL Composites Inc. STEP 2: Write the cover of your report Indicate: a. the name of the Company b. its exact website address (URL) c. the industry of the assigned company d. describe the business of the assigned company (minimum 200 words, maximum 300 words) e. properly identify the period of the annual report or financial statements f. indicate what are you reading: annual report, financial statements or proxy g. provide your name, student number, course, section, and any other piece of data that allows identifying who is making the submission. 2 STEP 3: Write the report In your report it is required to copy the questions listed below, provide the answer to each question, and indicate in which page number of the annual report or proxy document the answer you provide is found. Questions: 1. What amount was reported for revenue (net revenue before Gross Profit) for the year and what was the change in revenue during the year from the preceding year? 2. What was a main reason given in management's discussion and analysis for this change in revenue? 3. When was the MD&A dated? 4. When was the auditor's report dated? 5. Who was the auditor? 6. Who signed off the financial statements? 7. Who was the Chair of the Board of Directors at the time the annual report was issued? 8. Who was the Chair of the Compensation Committee at the time the annual report was issued? rd Items 9 and 10 depend on the 3 digit of your student number counting from the right (the last 2 digits were used to identify your company, the third, must be used to identify the following 2 questions). Example: if your student number is 1234567, the digit to be identified for this task is 5. Digi Question 9 t What amount was reported for total 1 assets? 2 What amount was reported for gross income/earnings? 3 What was the total of retained earnings at the beginning of the year? 4 What was the total of Accumulated Depreciation at the end of the year? 5 What was the total of depreciation for the year? 6 What was the total of interest accrued for the year? 7 Which is the account with the largest ending balance in assets? 8 Which is the account with the largest ending balance in liabilities? 9 What is the amount of basic earnings per share of the year? 10 What was the total change in current assets during the year? Question 10 What amount was reported for net income/earnings? What was the total of non-current liabilities at the end of the year? Which is the expense account with the largest amount? What was the total of retained earnings at the end of the year? What amount was reported for total liabilities? What was the total change in current liabilities during the year? The Disclosure Controls and Procedures (DC&P) is included? What is amount of diluted earnings per share of the year? The Internal Control over Financial Reporting (ICFR) is included? What was the total of expenses for the year? STEP 4: Submit the report as a Word Document 3 Part B: Bookkeeping using Accounting Software The objective of this part is to afford students the opportunity to use accounting software so you appreciate the extent to which technology has completely transformed accounting. While the need for judgment and decisions will never disappear, the bookkeeping aspects of accounting have been largely automated. The term project requirements just scratch the surface in terms of showing the capabilities of accounting software. We hope you will take the time to view all the tutorials and do some clicking around to try out even more features. STEP 1: Acquire access to any commercial accounting software package that you don't have to purchase. STEP 2: Use your software to create a set of books for a fictional company that includes your st name and student number with the fiscal year end of December 31 of the current year. Many products have 'wizards' or tutorials to lead you through this process. STEP 3: Post the following transactions using the 'general journal entry' option rather than 'specialized journal' option. Hint: If you being prompted to enter customer or supplier name and address information, you are not using the 'general journal entry' option, and are doing more than is required in this assignment. 1. A cash sale for an amount equal to the last 5 digits of your student number. Example: if your student number is 1234567, the cash sale must be made for $34,567.00 2.A payment to a landlord for rent equal to the last 3 digits of your student number. 3. A purchase in cash of office supplies for an amount equal to the last 2 digits of your student number. 4.Accrue utilities used for an amount equal to half of the last 3 digits of your student number. 5. Advanced payment made in cash by a customer for a future sale equal to the last 5 digits of your student number. 6.At the end of the period noticed that half of the office supplies purchased have been used. 7. Got a pick-up truck when issuing a long term note for an amount equal to the last 4 digits of your student number. 8.Declared dividends for an amount equal to the last digit of your student number. 9. Purchase merchandise on account for an amount equal to the last five digits of your student number. The last 4 digits of your student number were used to generate sales. 10. Depreciation of non-current asset for an amount equal to one third of the acquisition cost. STEP 4: Prepare and print the Income Statement and Balance Sheet for the period and also your general journal showing your journal entries. STEP 5: Submit the document as a PDF document. 4 Part C: Advanced Bookkeeping CycleTO (Version A) Robb Dufferin has had a long-standing love affair with bicycles of all types, 1 shapes and colors . Robb learned how to fix bikes like every other good mechanic, by getting his hands greasy. His second passion is to be his own boss, so when he was 10 he set up something of a small business in the garage of the home where he grew up. His business was to fix bikes for neighbours and friends for a fee. As an adult he did a bike ride across Canada by himself and he recalls from that trip that \"you learn about your bike very quickly\". Robb is a mechanical engineering technician by training and has successfully worked in the field. As an employee he has repaired different types and kinds of mechanical systems, including also bikes. Robb is convinced that the best way to merge his passions, be a bike mechanic and a businessman, is to open up his own bike repair shop and he started informal operations as a side job two years ago. His reputation is impeccable and every week he gets new people asking for his services. So impressive is his reputation that several local media has interviewed him. In one of those interviews the following was commented: \"Besides technical proficiency, Robb focuses on customer service: he does careful intake to be sure customers know exactly what repairs they need, and gives a precise quote on the spot. If the final repair is going to be more than the quote, even by $10, he calls.\" Also Robb is active in non-traditional ways to market his services: \"On Saturdays, the studio hosts the Parkdale Flea and customers can easily come in and bring their bikes down to Robb's shop.\" 1 Although this is a fictional business situation, the setup is based on an article that appeared in the Toronto Star, Monday April 20th, 2015, Business Section, page S8. A shorter version was available on May 12th 2015 at http://www.thestar.com/business/2015/04/19/openshut metrocycleto.html 5 Note: the project document files that accompany this project contain the information needed to complete the project After running the business from the basement of his home for almost 2 years, in st April 1 2014 he decided to work full time on it. The first decision made was to set up the operation as a corporation named CycleTO, the second decision was to quit his job so he can fully devote to this new endeavor and make it successful and the third decision was to contract the required insurance with RiskIt Insurance. The business prospect - Starting up Robb projected major profits, provided most of the interactions with customers were managed through a dedicated and secure website (also available for mobile devices). It was essential for him that the costs of operating the website could be kept to a minimum. When Robb found an e-business service firm which was willing to provide both the website design and webhosting service for a percentage of the sales, without any upfront cost, Robb felt certain the business would be a success. Armed with a business plan, Robb visited WebWonder, an e-business service firm that had agreed to work with him to design and maintain CycleTO e-biz site for a percentage of the sales revenue. An on-line booking and payment system was central to the business plan. When booking a standardized maintenance or repair assessment appointment, customers would prepay on-line by completing a form and entering their credit card number or the number of an e-card (a pre-paid card like a phone card which can be purchased at banks and used for web purchases). Once the service was completed Robb would access the customer account and charge the remaining portion once the service was provided. This last step would be done in front of the customer. However, not all sales were paid through the website. Visits to his basement and drops in at the Parkdale Flea were paid in cash and st deposits made weekly in the bank as shown in the sample deposit slip of April 1 2014. WebWonder's fee of 10% of total revenues on the month covered the cost of all WebWonder's services. WebWonder was responsible for paying all charged card and ecard fees and ensured the e-commerce features of the site could securely handle payments. WebWonder agreed to do the following: 6 Daily: Maintain CycleTO website; Schedule an appointment close to the closest customer that already scheduled an appointment and update a web-accessible schedule of bookings; Provide an on-line invoice which could be printed by the customer if they wished; Process credit card and e-card payment at the time of booking using appropriate on-line security and control procedures; Automate e-mailing the customer with details of the date, time and address the messages are received as text messages on the customer's cell phone. Weekly: Report bookings and deposits weekly showing, the customer's name and address, the day each booking was made, and the date for which the appointment was scheduled and the total customer payments for the week. Credit card and e-card information was not provided to CycleTO; Deposit the total customer payments for the week, less WebWonder's 10% fee, in CycleTO's bank account. Monthly: Provide a monthly summary report showing: weekly deposits; pre-authorized 10% fee debits; number and amount collected from appointments booked; amount received from customers for which appointments have not yet been attended; amount owed to customers (based on bookings not appointment attended); amount collected by WebWonder not yet deposited in CycleTO's account. The first year of operations as a corporation was very demanding as Robb worked on average 60 hours per week. Half of the time was invested in the mobile service he provides to wealthy customers outside the city of Toronto. Robb gets in his van and travels to clients in the suburbs that have very few if any reliable bike shop. The mobile service represents 80% of his business during the spring rush and it will decline to 40% during the summer. This service contributes significantly to revenues because the bikes serviced are high end that cost CAD$10,000 and above; their owners can afford an expensive bike mechanic that will tune them up for 'bike season'. The first year of operations was quite successful; Robb was able to live with the proceeds from the business ($2,000 per month) and was recognized as the best bike mechanic by NOW magazine in 2014. In the first week of April 2015 Robb is thinking of moving away from his basement and opening a shop, but is unsure if the business will be able to afford it. The story and evolution of the first year of operations is as follows: 7 Robb had $10,000 in accumulated savings and also his wife can loan him an equivalent amount if he needed start-up capital. Robb has a business plan that shows the potential of making $3,000 clean per month after all normal and regular expenses and related costs are taken in consideration. st In April 1 2014 he contacted a lawyer for advice about the legal form to give to his new business. The legal firm De Rosa Barristers and Solicitors provided the necessary 2 legal advice and did all the necessary paper work to incorporate as a Canada Business Corporation. Initial capitalization allowed for 20,000 par value shares. Robb, his lawyer and his wife were named as Directors of the Corporation which was called CycleTO Bike Repair Shop Ltd. The lawyer also checked that the name was not already registered and he paid an additional $500 to register the Internet domain website URL as www.cycleTO.ca. Robb contributed $10,000 in exchange for 10,000 shares. This was deposited into a st new corporate bank account he set up with TBC Bank on April 1 , 2014. The bank account was a standard commercial chequing account that gave cheques returned with monthly statements for a fee of $50/month. The summary annual statement (April 2014 to March 2015) is included. Robb negotiated with RiskIt Insurance an all perils, two-year insurance policy, effective twelve months per year beginning April 1, 2014. Robb felt this expensive insurance was necessary even though customers needed to click their agreement to an on-line waiver form as part of the booking procedure. Although Robb knew that there was no need to have a formal office and repair shop outside of his house, he decided to lease part of his house. He signed a 1 year lease on st April 1 2014 for a total of $6,000. The payment for the rent will be done in 2 th opportunities, the first 6 months will be paid on September 30 2014 and the second 6 st months will be paid on March 31 2015. The van was dedicated to the business most of the time, therefore Robb decided to contribute it to the corporation. The fair market value of the van was $4,800. Although it is an old van it still works fine and Robb estimates that it will continue to roll for 4 more years and then it could be scrapped. Now that Robb has a corporation he can formalize the agreement with Bike Canada Outlet for the equipment and specialized tools he rents. A professional full set of repair tools is expensive, so Robb rents it for $50 per month (rental agreement covers st th April 1 to September 30 2014). When the rental agreement expired in September 2014 he decided to exercise the option to buy them for $500. With good maintenance and care they can last 2 more years. 2 Hint: startup costs can be capitalized as an intangible asset \"Organization Costs\" and are assumed to have an indefinite life for amortization purposes. You may want to read the segment in Module 10 on intangibles for further clarification. Internet domain names would be afforded similar treatment. 8 Robb will continue to use a metal frame to mount the bikes while repairing them, the metal frame is already set up in his house and fits in his van when servicing clients in their locations. However, since that equipment now will be used for the newly established company, in the books it has to be reflected as his capital contribution with shop floor equipment for a value of $200. For accounting purposes, the equipment would be depreciated in five years with no residual value. In January 2015 CycleTO was running out of cash, so Robb asked her wife for a 5 months loan of $5,000 with the purpose of paying the bills during the winter and repay her back with interest in the Spring when business will be flourishing. Robb's th wife handed in the $5,000 dollars on January 15 2015 and expects to be repaid on th June 15 2015 the full amount plus 10% of interest. Next step for Robb was to clearly state the pricing for the diverse services. 1) Spring tune up of high end bicycles: minimum of $200. 2) Spring tune up of bicycles (not high end): minimum of $45. 3) Repair: $50 per hour of labour plus replaced parts. 4) Mobile service: $0.50 per Km of distance between Robb's operations (his house) and the customer's location. Distance is calculated for one way using a very popular maps app. Revenues were recognized when the service was provided. Occasionally customers will not be available for the scheduled appointment so Robb would wait 20 minutes and then leave. In those cases the payment made online was recognized as revenue; some of those customers will latter on contact Robb for a rescheduling with plausible sob stories. Robb would reschedule the appointment adding a $100 processing fee to the new billing. The business operations - Marketing, Promotion and Growth Robb was particularly proud of the specially designed T-shirts and backpacks he wears regularly to meet customers, which prominently displayed CycleTO's web address. The backpacks were designed to carry some tools, a last generation cell-phone and a water bottle. The cost to purchase and print the backpacks and T-shirts is expensed, along with other promotion expenses, even though Robb recognizes they may last longer than a bike season. In addition to the advertising on backpacks and T-shirts, Robb paid QuickPrint for a small initial supply of business cards, flyers and posters. Robb distributed the flyers and posters to bike shops and parks and handed out the business cards at every opportunity. The majority of the printed material and business cards had been used up by the end of March 2015. 9 Robb paid amounts due using pre-numbered cheques and kept the carbon copy of each cheque as a record of the payment. If the expenditure was expected to benefit more than one year, CycleTO capitalized the amount and amortized it over those future periods. The date of payment and the cheque number were written on the supplier invoice to cross-reference payments and supplier invoices. CycleTO received a monthly bank statement showing the deposits made directly by WebWonder, the pre-authorized debits for WebWonder's fees, the cheques which had been cashed by CycleTO's suppliers and the bank's service charges. It took Robb a few minutes to figure out why the bank statement showed deposits in the credit column and cheques in the debit column: cash deposited in the bank, while an asset of CycleTO, is an obligation for the bank as it owes CycleTO the money. Hence CycleTO's deposits are recorded in the credit column of the bank statement. Conversely, when a supplier cashes a cheque the bank balance is reduced, the bank's obligations are reduced and the amount is shown as a debit on the bank statement. A bank reconciliation was prepared. Robb compared the bank statement to CycleTO's Cash Account balance and adjusted for timing differences between when cheques were issued to suppliers and when they actually 'cleared' the bank, i.e., when the suppliers deposited them in their accounts and the cash was taken from CycleTO's bank account. While Robb reconciled the bank to check CycleTO's Cash records, he knew the financial statements should reflect a reduction in cash on the day the cheque was written, even if it had not 'cleared' the bank when the financial statements were prepared. The business operations - Accounting Records Accounts: Robb posted the information from the various source documents (the WebWonder summary, the supplier invoices, the cheque copies and the bank statement) to the accounts. [Note: The accounts can be represented by simple T-accounts for this practice set. The T-account form is most frequently used by students to solve practice problems in the course. In an actual business the accounts would contain more complete information about transactions and the dates upon which they occurred.] Journal Entries: Robb took the time to prepare journal entries for all transactions first rather than entering the amounts directly into the accounts. The journal entries provided a chronological view of the accounting transactions and showed both sides of the transaction in one place. Robb realized that if the system were computerized there would be no need to enter everything twice, first in the journal and then again in the accounts, because most accounting software is designed to construct a complete, chronological view of data entered regardless of how it is initially entered. However, CycleTO's system wasn't yet computerized so Robb took the extra time to journalize the transactions. Adjusting Entries: After Robb had posted the accounting transactions triggered by a specific event, e.g., receipt of the WebWonder summary or a suppliers invoice. Robb 10 looked at payments and thought about the work that had been done by CycleTO and the resources used during the period, and recorded adjusting entries to accrue revenue and expenses and adjust previously deferred amounts to recognize revenue only for all services provided and to match expenses to the revenue earned. Dividends: Robb called a Board of Director's meeting and declared a Dividend of st $0.80 per share on March 31 2015. Trial Balance: Robb prepared a trial balance before drafting the financial statements: there was lots of room for error in the manual posting of the transactions to the accounts. Robb knew that a trial balance would not detect an error made posting an incorrect, balanced entry. Robb also knew that trial balances were not required in computerized systems, which wouldn't allow a person to input an unbalanced entry, but Robb prepared one since CycleTO's was a manual system and it helped to organize the information for preparation of the financial statements, even if there were no posting errors. Before preparing the financial statements, Robb examined again the balances of the assets and liabilities. Did they reconcile to the actual assets (e.g., cash in the bank, and the unexpired insurance coverage)? Were all liabilities recorded? It was only after reconciling the bank and reconciling to the statements provided by WebWonder and the other suppliers that Robb was comfortable preparing the financial statements, beginning with the Income Statement. Financial Statements: At the end of his first year of operations he decided to st prepare a complete set of financial statements (Balance Sheet as of March 31 2015, st st Income Statement for the period April 1 2014 to March 31 2015, and Statement of st Retained Earnings as of March 31 2015... but no Cash Flow Statement). It was a truly exciting moment when Robb put down the pen and admired the financial statements for CycleTO's first year of operation as a corporation. Robb marveled at how the numbers on the page reflected all that had happened in the new business. Looking at the financial statements, Robb understood clearly that accounting was the language of business! 11 Require d: STEP 1: Prepare the accounting records by doing the following: 1. Set up the Chart of Accounts. st 2. Prepare the cash reconciliation for March 31 2015. 3. Prepare the General Journal entries for the year (summary entries can be used, for instance all sales made in the year can be recognized in one journal entry). Each General Journal entry should have an explanation under it. 4. Post all transactions to the T-accounts. STEP 2: Prepare the financial statements by doing the following: 5. 6. 7. 8. st Prepare the Adjusting Journal Entries for the end of the year on March 31 2015. Post all AJE transactions to the T-accounts. st Prepare a trial balance for the year ending on March 31 2015. st Prepare the Financial Statements in good form for the year ending on March 31 2015 including footnotes for a Summary of Significant Accounting Policies and for contingency disclosures only if needed. 9. After preparing the financial statements answer the following questions: Indicate if the net income of the year is in line with Robb's expectations? Make one clear suggestions of how the business can be improved so Robb can achieve and surpass his target. Indicate if Robb will be able to set up a shop to scale up his operations in a location that is available to rent for $1,000 per month. STEP 3: Submit all the 9 items in one PDF document. Before submitting check that the files have been printed as desired and that the PDF file generated can be read. 12 DeRosa- Barristers & Solicitors INVOICE To: CycleTO From: Perry Mason Terms 365 days Date: April 1, 2014 Re: Professional Services For services rendered in connection with the incorporation of CycleTO Ltd. including but not limited to : Filing application for articles of incorporation as a Canada Business Corporation Securing trademark protection on the name CycleTO Filing necessary documents with the Canadian Registrar of Companies Filing appropriate documents as required under the Ontario Directors' Act to name corporate directors Various legal advice on these and other matters The amount of $1,500 DeRosa - Barristers & Solicitors INVOICE To: CycleTO From: Perry Mason Terms 30 days Date: April 1, 2014 Re: Professional Services For services rendered in connection with the incorporation of CycleTO Ltd. including but not limited to : Registering the Internet domain name ( www.CycleTO.ca) Various legal advice on these and other matters The amount of $500 TBC Bank 02912 950 Fast Lane Toronto ON M3J 1P7 Branch Statement of Account Summary for 12 month period 02912 CycleTO p.o. Box 98357 987 Fast Lane Toronto, ON M3J 1P8 Date Description April 1 2014 DEPOSIT April 3 2014 April 7 2014 ... May 14 2014 ... Sep 15 2014 Sep 19 2014 Sep 22 2014 Sep 23 2015 Sep 29 2014 Sep 30 2014 Oct 3 2014 Oct 6 2014 ... Mar 30 2015 Mar 31 2015 Account 234-567-12 Current Account Statement Date March 31, 2015 Debits 10,205.00 CHEQUE 1 500.00 CHEQUE 2 4,800.00 CHEQUE 3 300.00 CHEQUE 4 499.00 DEPOSIT Web Wonder . . . . . . . . . . . . . .. . . . . . . DEPOSIT Web Wonder . . . . . . . . . . . . . .. . . . . . . DEPOSIT Web Wonder CHEQUE 10 500.00 DEPOSIT Web Wonder DEPOSIT DEPOSIT Web Wonder CHEQUE 11 2,000.00 CHEQUE 12 3,000.00 DEPOSIT Web Wonder DEPOSIT PRE-AUTHORIZED DEBIT 44.00 CHEQUE 13 11,150.00 . . . . . . . . . . . . . .. . . . . . . DEPOSIT Web Wonder CHEQUE 19 2,000.00 BANK ANNUAL SERVICE CHARGE 600.00 TOTALS Credits 45,833.00 Balance 10,205.00 9,705.00 4,905.00 4,605.00 4,106.00 1,679.40 5,785.40 . . . . . . . . . . . . 2,206.80 17,498.20 . . . . . . . . . . . . 789.30 26,574.70 26,074.70 396.90 26,471.60 107.00 26,578.60 189.90 26,768.50 24,768.50 21,768.50 209.70 21,978.20 147.00 22,125.20 22,081.20 10,931.20 . . . . . . . . . . . . 540.00 26,331.70 24,331.70 23,731.70 69,564.70 1 P.O. Box 98357 987 Fast Lane April 1, 2014 Toronto, ON M3J 1P8 PAY TO THE DeRosa Law ORDER OF five hundreds $ 500.00 DOLLARS PER TBC Bank 950 Fast Lane Robb Dufferin per internet Domain Toronto ON M3J 1P7 11 P.O. Box 98357 987 Fast Lane Sep 30 2014 Toronto, ON M3J 1P8 PAY TO THE Robb Dufferin ORDER OF Two Thousands ---------------------00/100 $ 2,000.00 DOLLARS PER TBC Bank 950 Fast Lane Robb Dufferin advances of dividends Toronto ON M3J 1P7 2 P.O. Box 98357 987 Fast Lane April 1, 2014 Toronto, ON M3J 1P8 PAY TO THE 12 P.O. Box 98357 987 Fast Lane Sep 30 2014 Toronto, ON M3J 1P8 PAY TO THE Riskit Insurance Group ORDER OF Robb Dufferin ORDER OF Four Thousands Eight Hundreds ------------------------00/100 $ 4,800.00 Three Thousands -----------------------------00/100 DOLLARS PER TBC Bank 950 Fast Lane Robb Dufferin PER TBC Bank 950 Fast Lane insurance premium for 2 years Toronto ON M3J 1P7 13 P.O. Box 98357 987 Fast Lane April 1, 2014 PAY TO THE Robb Dufferin rent for Robb house 6 months Toronto ON M3J 1P7 3 P.O. Box 98357 987 Fast Lane Toronto, ON M3J 1P8 $ 3,000.00 DOLLARS Oct 3 2014 Toronto, ON M3J 1P8 PAY TO THE Bike Canada Outlet ORDER OF Five Cycles ORDER OF Three Hundreds ----------------------------------------00/100 Eleven Thousands one Hundred and Fifty----------------00/100 $ 11,150.00 $ 300.00 DOLLARS PER TBC Bank 950 Fast Lane DOLLARS Robb Dufferin 950 Fast Lane rent for six months Toronto ON M3J 1P7 PER TBC Bank PAY TO THE 14 P.O. Box 98357 987 Fast Lane April 3, 2014 Toronto, ON M3J 1P8 payment of parts used in repairs Toronto ON M3J 1P7 4 P.O. Box 98357 987 Fast Lane Robb Dufferin Oct 30 2014 Toronto, ON M3J 1P8 PAY TO THE Quickprint ORDER OF Toronto, ON M3J 1P8 950 Fast Lane PER Toronto ON M3J 1P7 PAY TO THE Robb Dufferin April 30 2014 promotional material Robb Dufferin ORDER OF Two Thousands ---------------------00/100 5 DOLLARS P.O. Box 98357 987 Fast Lane TBC Bank Robb Dufferin ORDER OF Four hundred Ninety Nine---------------------------------00/100 $ 499.00 TBC Bank Toronto, ON M3J 1P8 950 Fast Lane PER Toronto ON M3J 1P7 PAY TO THE DOLLARS TBC Bank 950 Fast Lane Toronto ON M3J 1P7 PER Robb Dufferin advances of dividends Robb Dufferin Nov 30 2014 advances of dividends Two Thousands ---------------------00/100 $ 2,000.00 15 Robb Dufferin ORDER OF Two Thousands ---------------------00/100 $ 2,000.00 DOLLARS P.O. Box 98357 987 Fast Lane $ 2,000.00 DOLLARS TBC Bank 950 Fast Lane Toronto ON M3J 1P7 PER Robb Dufferin advances of dividends 7 P.O. Box 98357 987 Fast Lane June 30 2014 Toronto, ON M3J 1P8 PAY TO THE Robb Dufferin ORDER OF Two Thousands ---------------------00/100 $ 2,000.00 DOLLARS TBC Bank 950 Fast Lane Toronto ON M3J 1P7 PER Robb Dufferin advances of dividends 6 P.O. Box 98357 987 Fast Lane May 30 2014 Toronto, ON M3J 1P8 PAY TO THE Robb Dufferin ORDER OF Two Thousands ---------------------00/100 $ 2,000.00 DOLLARS PER TBC Bank 950 Fast Lane Robb Dufferin advances of dividends Toronto ON M3J 1P7 17 P.O. Box 98357 987 Fast Lane Jan 30 2015 Toronto, ON M3J 1P8 PAY TO THE Robb Dufferin ORDER OF Two Thousands ---------------------00/100 $ 2,000.00 DOLLARS PER TBC Bank 950 Fast Lane advances of dividends Toronto ON M3J 1P7 8 P.O. Box 98357 987 Fast Lane 18 P.O. Box 98357 987 Fast Lane July 30 2014 Toronto, ON M3J 1P8 Robb Dufferin Feb 28 Toronto, ON M3J 1P8 2015 PAY TO THE Robb Dufferin ORDER OF PAY TO THE Two Thousands ---------------------00/100 $ 2,000.00 PER TBC Bank 950 Fast Lane Two Thousands ---------------------00/100 Robb Dufferin 950 Fast Lane 19 P.O. Box 98357 987 Fast Lane Aug 30 2014 Toronto, ON M3J 1P8 advances of dividends Toronto ON M3J 1P7 9 P.O. Box 98357 987 Fast Lane $ 2,000.00 DOLLARS advances of dividends Toronto ON M3J 1P7 Robb Dufferin ORDER OF DOLLARS Mar 30 Toronto, ON M3J 1P8 2015 PAY TO THE Robb Dufferin ORDER OF PAY TO THE Two Thousands ---------------------00/100 $ 2,000.00 PER TBC Bank 950 Fast Lane Two Thousands ---------------------00/100 Robb Dufferin 950 Fast Lane 20 P.O. Box 98357 987 Fast Lane Sep 19 2014 Toronto, ON M3J 1P8 advances of dividends Toronto ON M3J 1P7 10 P.O. Box 98357 987 Fast Lane $ 2,000.00 DOLLARS advances of dividends Toronto ON M3J 1P7 Robb Dufferin ORDER OF DOLLARS Mar 31 2015 Toronto, ON M3J 1P8 PAY TO THE Bike Canada Outlet ORDER OF PAY TO THE Five hundreds ---------------------00/100 $ 500.00 TBC Bank 950 Fast Lane Toronto ON M3J 1P7 PER Robb Dufferin ORDER OF Three Thousands ---------------------00/100 DOLLARS Robb Dufferin purchase tools $ 3,000.00 DOLLARS 950 Fast Lane Toronto ON M3J 1P7 rent for Robb house 6 months 16 P.O. Box 98357 987 Fast Lane Dec 30 Toronto, ON M3J 1P8 2015 PAY TO THE Robb Dufferin ORDER OF Two Thousands ---------------------00/100 $ 2,000.00 DOLLARS 950 Fast Lane Toronto ON M3J 1P7 advances of dividends WebWonder your e-business solution provider www.webwonder.com Annual Summary of CycleTO Account for the period between April 1st 2014 and March 31st 2015 Weeks 1 2 3 4 5 6 April 1 to April 6 April 7 to April 13 April 14 to April 20 April 21 to April 27 April 28 to May 4 May 5 to May 11 ........... ................ 48 February 23 to March 1 49 March 2 to March 8 50 March 9 to March 15 51 March 16 to March 22 52 March 23 to March 29 Extra half week March 30 to March 31 Appointments booked and paid Bookings High End Bookings Regular Processing fee for rescheduling $210.00 $55.00 $0.00 $655.00 $81.00 $0.00 $408.00 $47.00 $0.00 $244.00 $49.00 $0.00 $894.00 $106.00 $200.00 $851.00 $148.00 $100.00 52 weeks Summary Appointments served Appointments not served Total Paid appointments $0.00 $0.00 $0.00 $0.00 $251.00 $223.00 $42,312.00 Appointments 565 2 567 Bank Transaction Summary: Collections for Appointments Booked: Number of Appointments Booked Deposited to CycleTO #234-567-12 WebWonder 10% Fee Collected by WebWonder: 566 $50,564.70 $5,618.30 $56,183.00 $0.00 $0.00 $46.00 $0.00 $0.00 $0.00 $10,494.00 $0.00 $0.00 $0.00 $0.00 $100.00 $0.00 $3,600.00 $55,932.00 $474.00 $56,406.00 ClearTel tomorrow is today @ Oct 2, 2014 Sold to: CycleTO Services provided: Sep 1 -30 2014 Account No. 21-389-47 $44.00 cleartel.com Payment is automatically deducted from the bank account you have identified. If funds are not available on October 6th Cleartel will continue to attempt the automatic debit in two more occasions in a 48 hs lapse. If all unsuccessful the Amount is past due and interest charges of 1.25% per month will apply. Note: this flat rate did not change between April 1st 2014 and April 1st 2015. Cycle TO did not make use of any additional service. QuickPrint Bill To: CycleTO Invoice # Invoice Date TOR2014-0105 April 1, 2014 Quantity 2 5 500 100 1000 Description Backpacks Tshirts business cards posters flyers Amount 24.00 25.00 75.00 200.00 175.00 499.00 Balance Due Please make cheque payable to: QuickPrint 48 Burgess Ave. Scarborough, ON M7Z 1W9 $ Paid April 3 Cheque #4 499.00 The RiskIt Insurance Group 120 North Town Centre Blvd. Markam, ON W6G 1C5 Ask For: INVOICE ACCT: Date: TERM POLICY David Yu 2 YR 864378 All Perils Limit of Liability EFFECTIVE PREMIUM 98123 CycleTO April 1, 2014 April 1, 2014 $4,800 $5,000,000 YOUR PREMIUM IS DUE AND PAYABLE ON EFFECTIVE DATE OF POLICY Coverage is cancelled if not paid within 30 days Paid April 1 Cheque # 2 Five Cycles Custom bicicles and parts in steel, titanium and ti/carbon mix 45 Walkerton Road Perth, Ontario L1H OF8 Paid October 3 Cheque #13 Bill To: CycleTO p.o. Box 98357 Toronto ON M3J 1P8 Invoice #: 2014-1958 Invoice Date: Sep 30, 2014 987 Fast Lane $4,300 Parts for high end bicycles (Cervelo, S-Works, Felt, Cannondale) $4,700 Parts for specialty bikes (Peugeot, Porsche, Mercedes Benz) $2,150 Regular parts Parts delivered in the period of April 1st 2015 and September 30 2014. Previous Balance $0 Payments and Adjustments $0 Overdue Balance $0 New Charges $11,150 Total Amount Due $11,150 ************************************************************************************************************** Five Cycles Paid April 3 Cheque #21 Custom bicicles and parts in steel, titanium and ti/carbon mix 45 Walkerton Road Perth, Ontario L1H OF8 Bill To: CycleTO p.o. Box 98357 Toronto ON M3J 1P8 Invoice #: 2015-0182 Invoice Date: Mar 30, 2015 987 Fast Lane $630 Parts for high end bicycles (Cervelo, S-Works, Felt, Cannondale) $0 Parts for specialty bikes (Peugeot, Porsche, Mercedes Benz) $see note 1 Regular parts Parts delivered in the period of October 1st 2014 and March 30th 2015. Previous Balance $0 Payments and Adjustments $0 Overdue Balance $0 New Charges $630 + note1 Total Amount Due $630 + note 1 Note 1: the amount used and purchased of regular parts to perform repairs in the period October 1st 2014 to March 31st 2015 is equal to tha last 3 digits of your student number. May 2014 - Week 2 - Bookings Name 5th 6th 7th 8th 9th Monday Tuesday 3 - 4pm Jessica Stone 4 - 5pm 5 - 6pm Zack Gardzinski 6 - 7pm 7- 8 reg pm 3 - 4pm 4 - 5pm Carols Stomp 5 - ma 6pm Carmen Dias 6 - 7pm Carmen Dias 7- 8 pm Wednesday 3 - 4pm Philip Crouton 4 - 5pm 5 - 6pm Isabella Cataneo 6 - 7pm tun pm 7- 8 Thursday Friday Address Phone # Special Instructions 123 Lakeshore 416-123-4567 879 King 416-867-2547 30 year bike - maintenance front wheel axis is off first time visit ular bike 297 Queen St. 416-378-7878 Regular bike - intenance $53 3879 Yonge 416-488-1234 Cannondale SuperSix EVO no concerns repor ted $251 6500 Highway 7 905-555-0001 $266 3312 Pine Valey 905-551-0010 Cervelo R5ca - tuneup front wheel needs attention Peugeot bike eup no concerns reported Porsche bike - neup gears not stable Regular bike intenance $251 Louis Kattan 2114 Hallibut Dr. 416-338-3321 3 - 4pm tu 5pm 4Richard Eperman 33 North Promenad 905-221-5578 5 - 6pm ma 7pm 6pm Frank Mark 151 Main Street 905-112-8435 7- 8 Prepaid $212 $51 $261 $58 S-Works Tarmac tuneup SL4 $302 (non Di2) no conc reported intenance erns Regular bike - ma $55 Trek Madone 6.9 SSL $266 no concerns reported Felt DA1 Di2 - tuneup $261 rear wheel not stable 3 - 4pm 4 - 5pm 5 - 6pm 6 - 7pm 7- 8 pm Sandy Munchen Tom Brot 2224 Bathurts St 315 Kingsway 416-555-0120 647-557-5422 Carolyn Messes 3811 Maple Dr. 905-221-3344 Trini Thompson 315 Adelaide St. Regular bike - maintenance Regular bike Mark Manclar 197 Front St. Bob Burlington 101 Richmond St. Regular bike - maintenance maintenance No appointments taken. Parkdale Flea mount a mobile shop. 10th Saturday 8 - 9am 9 - 10am 10 - 11am 11am-5pm 11th Sunday 8am- 12pm No appointments taken. All morning available at the shop (house) for drop in. Total booked $55 $55 $55 $2,452 TBC Bank Cheques/Cash Date April 1, 2014 Account 02912-234-567-12 Account Name: CycleTO Current Account Deposit Account 02912-234-567-12 Particulars Robb Dufferin Repair Mary L. Repair Lucas N. April 1, 2014 Date 10,000 00 125 00 80 Account Name: CycleTO 00 x x x x x 5 10 20 50 100 5 00 10 00 40 00 150 00 10,000 00 10,000 00 10,205 00 Coin Total CDN Cash Total CDN Cheques Total Credit Card Subtotal Foreign Cash Foreign Cheques Bank Use Only Total Deposited By Robb Dufferin Total Cheques 10,205 00 WebWonder your e-business solution provider www.webwonder.com Account Summary of Bookings and Deposits for CycleTO May 12, 2014 Previous amount due Payment Received Balance $0.00 0.00 Current charges summary Sessions booked May 5 - 11 $2,452.00 Charges 10% of bookings $245.20 Total Current Charges $245.20 A deposit for the difference $2,206.80 will be made in your bank account on or before May 14th. Current Charges - Detail Customer High end bike Payment Amount Appointment booked Jessica Stone Yes $212.00 5th Monday 46pm Zack Gardzinski No $51.00 5th Monday 67pm Stomp Carols No $53.00 6th Tuesday 4 - 5pm Carmen Dias Yes $251.00 6th Tuesday 6 - 8pm Philip Crouton Yes $266.00 7th Wednesday 4 - 6pm Isabella Cataneo Yes $261.00 7th Wednesday 6 - 8pm Louis Kattan Yes $251.00 8th Thursday 3 - 5pm Richard Eperman No $58.00 8th Thursday 5 - 6pm Frank Mark Yes $302.00 8th Thursday 6 - 8pm Sandy Munchen No $55.00 9th Friday 3 - 4pm Tom Brot Yes $266.00 9th Friday 4 - 6pm Carolyn Messes Yes $261.00 9th Friday 6 - 8pm Trini Thompson No $55.00 10th Saturday 8 - 9am Mark Manclar No $55.00 10th Saturday 9 - 10am Bob Burlington No $55.00 10th Saturday 10 - 11am Deposited to CycleTO (90%) Account # 234-567-12 May 14th $2,206.80 Total hours 23 P.O. Box 98357 987 Fast Lane Toronto, ON M3J 1P8 416-983-5764 www.cycleTO.ca Invoice Number: 2014- -#1 05-05 Sold To: Jessica Stone 123 Lakeshore Blvd. 2014 Toronto, ON M4X 1Z6 Invoice Date: May 5, Tune up appoitnment Cost Transportation cost for house calls $200.00 $ 12.00 $212.00 One tuneup appointment booked for: May 5, 2014 4 - 5 pm Tools, equipment and spare parts will be provided by CycleTO Waiver: On-line payment for this appointment included clicking 'yes' to agree to save harmless and keep indemnified CycleTO and its respective agents, officials, servants and representatives, from and against all claims, actions, costs, expenses and demands in respect of death, injury, loss or damage to your person or property, howsoever caused arising out of or in connection with CycleTO services provided in their premisses or mobile operations. Term Project Part A: Understanding Financial Statements Locate and use an annual report STEP 1: The Company Assigned to you Find the most recent annual report online for the Canadian public company assigned to the last 2 digits of your student number as per the table provided below. The annual report obtained from SEDAR must contain audited financial statements and the MDA (management's discussion and analysis). Example: if your student number is 1234567, the last 2 digits of your student number are 6 and 7 and the company assigned to you is Metro Inc. Last\t2 digits\tof your student\t# 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 Company\tAssigned Last\t2 digits\tof your student\t# Absolute Software Corporation 50 Acadian Timber Corp. 51 Aecon Group Inc. 52 AEterna Zentaris Inc. 53 Ag Growth International Inc. 54 Agrium Inc. 55 Air Canada 56 AlarmForce Industries Inc. 57 Alimentation Couche-Tard Inc. 58 AltaGas Ltd. 59 Bank of Montreal 60 Bank of Nova Scotia, The 61 Barrick Gold Corporation 62 BCE Inc. 63 Big Rock Brewery Inc. 64 BlackBerry Limited 65 Bombardier Inc. 66 Brookfield Asset Mgmt Inc 67 Buhler Industries Inc. 68 Canadian National Railway Co. 69 Canadian Imperial Bank of 70 Commerce Canadian Pacific Railway 71 Limited Canadian Tire Corporation, Ltd 72 Company\tAssigned Fission Uranium Corp. Gildan Activewear Inc. Glencore Canada Corporation Great-West Lifeco Inc. Helix BioPharma Corp. High Liner Foods Incorporated IMAX Corporation Imperial Oil Limited Inovio Pharmaceuticals, Inc. Leon's Furniture Limited Linamar Corporation Loblaw Companies Limited Lojack Corporation lululemon athletica inc. Magna International Inc. Maple Leaf Foods Inc. Martinrea International Inc. Metro inc. Molson Coors Brewing Company National Bank of Canada Potash Corporation of Saskatchewan Inc. Sleep Country Canada Holdings Inc. Rare Element Resources Ltd. 1 Last\t2 digits\tof your student\t# 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 Company\tAssigned Last\t2 digits\tof your student\t# Canadian Western Bank 73 Cara Operations Limited 74 Cargojet Inc. 75 Cascades Inc. 76 Catalyst Paper Corporation 77 Celestica Inc. 78 Celestica Inc. 79 Cenovus Energy Inc. 80 Cervus Equipment Corporation 81 Cineplex Inc. 82 Clean Harbors, Inc. 83 Clearwater Seafoods Inc. 84 Cogeco Cable Inc. 85 Contact Minerals Corp. 86 Continental Energy Corporation 87 Co-operators General Insurance 88 Company Corus Entertainment Inc. 89 Destiny Media Technologies 90 Inc. DiagnoCure Inc. 91 Domtar Corporation 92 Eldorado Gold Corporation 93 Emera Incorporated 94 Enbridge Inc. 95 Encana Corporation 96 Exco Technologies Limited 97 Fennec Pharmaceuticals Inc. 98 Fortis Inc. 99 Company\tAssigned Reitmans (Canada) Limited Richelieu Hardware Ltd. Rogers Communications Inc. RONA inc. Royal Bank of Canada Saputo Inc. Shaw Communications Inc. Shopify Inc. Sirius XM Canada Holdings Inc. Progressive Waste Solutions Ltd. SNC-Lavalin Group Inc. Spin Master Corp. Student Transportation Inc. Suncor Energy Inc. TELUS Corporation The Toronto-Dominion Bank theScore, Inc. Valeant Pharmaceuticals International, Inc. Toromont Industries Ltd. Torstar Corporation Tyco International plc Thomson Reuters Corporation Visa Inc. WestJet Airlines Ltd. Xerox Corporation Yellow Pages Limited ZCL Composites Inc. STEP 2: Write the cover of your report Indicate: a. the name of the Company b. its exact website address (URL) c. the industry of the assigned company d. describe the business of the assigned company (minimum 200 words, maximum 300 words) e. properly identify the period of the annual report or financial statements f. indicate what are you reading: annual report, financial statements or proxy g. provide your name, student number, course, section, and any other piece of data that allows identifying who is making the submission. 2 STEP 3: Write the report In your report it is required to copy the questions listed below, provide the answer to each question, and indicate in which page number of the annual report or proxy document the answer you provide is found. Questions: 1. What amount was reported for revenue (net revenue before Gross Profit) for the year and what was the change in revenue during the year from the preceding year? 2. What was a main reason given in management's discussion and analysis for this change in revenue? 3. When was the MD&A dated? 4. When was the auditor's report dated? 5. Who was the auditor? 6. Who signed off the financial statements? 7. Who was the Chair of the Board of Directors at the time the annual report was issued? 8. Who was the Chair of the Compensation Committee at the time the annual report was issued? Items 9 and 10 depend on the 3rd digit of your student number counting from the right (the last 2 digits were used to identify your company, the third, must be used to identify the following 2 questions). Example: if your student number is 1234567, the digit to be identified for this task is 5. Digit Question 9 Question 10 1 What amount was reported for total What amount was reported for net assets? income/earnings? 2 What amount was reported for gross What was the total of non-current income/earnings? liabilities at the end of the year? 3 What was the total of retained earningsWhich is the expense account with the at the beginning of the year? largest amount? 4 What was the total of Accumulated What was the total of retained earnings Depreciation at the end of the year? at the end of the year? 5 What was the total of depreciation for What amount was reported for total the year? liabilities? 6 What was the total of interest accrued What was the total change in current for the year? liabilities during the year? 7 Which is the account with the largest The Disclosure Controls and Procedures ending balance in assets? (DC&P) is included? 8 Which is the account with the largest What is amount of diluted earnings per ending balance in liabilities? share of the year? 9 What is the amount of basic earnings The Internal Control over Financial per share of the year? Reporting (ICFR) is included? 10 What was the total change in current What was the total of expenses for the assets during the year? year? STEP 4: Submit the report as a Word Document 3 Part B: Bookkeeping using Accounting Software The objective of this part is to afford students the opportunity to use accounting software so you appreciate the extent to which technology has completely transformed accounting. While the need for judgment and decisions will never disappear, the bookkeeping aspects of accounting have been largely automated. The term project requirements just scratch the surface in terms of showing the capabilities of accounting software. We hope you will take the time to view all the tutorials and do some clicking around to try out even more features. STEP 1: Acquire access to any commercial accounting software package that you don't have to purchase. STEP 2: Use your software to create a set of books for a fictional company that includes your name and student number with the fiscal year end of December 31st of the current year. Many products have 'wizards' or tutorials to lead you through this process. STEP 3: Post the following transactions using the 'general journal entry' option rather than 'specialized journal' option. Hint: If you being prompted to enter customer or supplier name and address information, you are not using the 'general journal entry' option, and are doing more than is required in this assignment. 1. A cash sale for an amount equal to the last 5 digits of your student number. Example: if your student number is 1234567, the cash sale must be made for $34,567.00 2. A payment to a landlord for rent equal to the last 3 digits of your student number. 3. A purchase in cash of office supplies for an amount equal to the last 2 digits of your student number. 4. Accrue utilities used for an amount equal to half of the last 3 digits of your student number. 5. Advanced payment made in cash by a customer for a future sale equal to the last 5 digits of your student number. 6. At the end of the period noticed that half of the office supplies purchased have been used. 7. Got a pick-up truck when issuing a long term note for an amount equal to the last 4 digits of your student number. 8. Declared dividends for an amount equal to the last digit of your student number. 9. Purchase merchandise on account for an amount equal to the last five digits of your student number. The last 4 digits of your student number were used to generate sales. 10. Depreciation of non-current asset for an amount equal to one third of the acquisition cost. STEP 4: Prepare and print the Income Statement and Balance Sheet for the period and also your general journal showing your journal entries. STEP 5: Submit the document as a PDF document. 4 Part C: Advanced Bookkeeping CycleTO (Version A) Robb Dufferin has had a long-standing love affair with bicycles of all types, shapes and colors1. Robb learned how to fix bikes like every other good mechanic, by getting his hands greasy. His second passion is to be his own boss, so when he was 10 he set up something of a small business in the garage of the home where he grew up. His business was to fix bikes for neighbours and friends for a fee. As an adult he did a bike ride across Canada by himself and he recalls from that trip that \"you learn about your bike very quickly\". Robb is a mechanical engineering technician by training and has successfully worked in the field. As an employee he has repaired different types and kinds of mechanical systems, including also bikes. Robb is convinced that the best way to merge his passions, be a bike mechanic and a businessman, is to open up his own bike repair shop and he started informal operations as a side job two years ago. His reputation is impeccable and every week he gets new people asking for his services. So impressive is his reputation that several local media has interviewed him. In one of those interviews the following was commented: \"Besides technical proficiency, Robb focuses on customer service: he does careful intake to be sure customers know exactly what repairs they need, and gives a precise quote on the spot. If the final repair is going to be more than the quote, even by $10, he calls.\" Also Robb is active in non-traditional ways to market his services: \"On Saturdays, the studio hosts the Parkdale Flea and customers can easily come in and bring their bikes down to Robb's shop.\" 1\tAlthough\tthis\tis\ta\tfictional\tbusiness\tsituation,\tthe\tsetup\tis\tbased\ton\tan\tarticle\tthat\tappeared\tin\tthe Toronto\tStar,\tMonday\tApril\t20th,\t2015,\tBusiness\tSection,\tpage\tS8.\tA\tshorter\tversion\twas\tavailable\ton May\t12th\t2015\tat\thttp://www.thestar.com/business/2015/04/19/openshutmetrocycleto.html 5 Note: the project document files that accompany this project contain the information needed to complete the project After running the business from the basement of his home for almost 2 years, in April 1 2014 he decided to work full time on it. The first decision made was to set up the operation as a corporation named CycleTO, the second decision was to quit his job so he can fully devote to this new endeavor and make it successful and the third decision was to contract the required insurance with RiskIt Insurance. st The business prospect - Starting up Robb projected major profits, provided most of the interactions with customers were managed through a dedicated and secure website (also available for mobile devices). It was essential for him that the costs of operating the website could be kept to a minimum. When Robb found an e-business service firm which was willing to provide both the website design and webhosting service for a percentage of the sales, without any upfront cost, Robb felt certain the business would be a success. Armed with a business plan, Robb visited WebWonder, an e-business service firm that had agreed to work with him to design and maintain CycleTO e-biz site for a percentage of the sales revenue. An on-line booking and payment system was central to the business plan. When booking a standardized maintenance or repair assessment appointment, customers would prepay on-line by completing a form and entering their credit card number or the number of an e-card (a pre-paid card like a phone card which can be purchased at banks and used for web purchases). Once the service was completed Robb would access the customer account and charge the remaining portion once the service was provided. This last step would be done in front of the customer. However, not all sales were paid through the website. Visits to his basement and drops in at the Parkdale Flea were paid in cash and deposits made weekly in the bank as shown in the sample deposit slip of April 1st 2014. WebWonder's fee of 10% of total revenues on the month covered the cost of all WebWonder's services. WebWonder was responsible for paying all charged card and ecard fees and ensured the e-commerce features of the site could securely handle payments. WebWonder agreed to do the following: 6 Daily: Maintain CycleTO website; Schedule an appointment close to the closest customer that already scheduled an appointment and update a web-accessible schedule of bookings; Provide an on-line invoice which could be printed by the customer if they wished; Process credit card and e-card payment at the time of booking using appropriate on-line security and control procedures; Automate e-mailing the customer with details of the date, time and address the messages are received as text messages on the customer's cell phone. Weekly: Report bookings and deposits weekly showing, the customer's name and address, the day each booking was made, and the date for which the appointment was scheduled and the total customer payments for the week. Credit card and e-card information was not provided to CycleTO; Deposit the total customer payments for the week, less WebWonder's 10% fee, in CycleTO's bank account. Monthly: Provide a monthly summary report showing: weekly deposits; pre-authorized 10% fee debits; number and amount collected from appointments booked; amount received from customers for which appointments have not yet been attended; amount owed to customers (based on bookings not appointment attended); amount collected by WebWonder not yet deposited in CycleTO's account. The first year of operations as a corporation was very demanding as Robb worked on average 60 hours per week. Half of the time was invested in the mobile service he provides to wealthy customers outside the city of Toronto. Robb gets in his van and travels to clients in the suburbs that have very few if any reliable bike shop. The mobile service represents 80% of his business during the spring rush and it will decline to 40% during the summer. This service contributes significantly to revenues because the bikes serviced are high end that cost CAD$10,000 and above; their owners can afford an expensive bike mechanic that will tune them up for 'bike season'. The first year of operations was quite successful; Robb was able to live with the proceeds from the business ($2,000 per month) and was recognized as the best bike mechanic by NOW magazine in 2014. In the first week of April 2015 Robb is thinking of moving away from his basement and opening a shop, but is unsure if the business will be able to afford it. The story and evolution of the first year of operations is as follows: 7 Robb had $10,000 in accumulated savings and also his wife can loan him an equivalent amount if he needed start-up capital. Robb has a business plan that shows the potential of making $3,000 clean per month after all normal and regular expenses and related costs are taken in consideration. In April 1st 2014 he contacted a lawyer for advice about the legal form to give to his new business. The legal firm De Rosa Barristers and Solicitors provided the necessary legal advice and did all the necessary paper work to incorporate2 as a Canada Business Corporation. Initial capitalization allowed for 20,000 par value shares. Robb, his lawyer and his wife were named as Directors of the Corporation which was called CycleTO Bike Repair Shop Ltd. The lawyer also checked that the name was not already registered and he paid an additional $500 to register the Internet domain website URL as www.cycleTO.ca. Robb contributed $10,000 in exchange for 10,000 shares. This was deposited into a new corporate bank account he set up with TBC Bank on April 1st, 2014. The bank account was a standard commercial chequing account that gave cheques returned with monthly statements for a fee of $50/month. The summary annual statement (April 2014 to March 2015) is included. Robb negotiated with RiskIt Insurance an all perils, two-year insurance policy, effective twelve months per year beginning April 1, 2014. Robb felt this expensive insurance was necessary even though customers needed to click their agreement to an on-line waiver form as part of the booking procedure. Although Robb knew that there was no need to have a formal office and repair shop outside of his house, he decided to lease part of his house. He signed a 1 year lease on April 1st 2014 for a total of $6,000. The payment for the rent will be done in 2 opportunities, the first 6 months will be paid on September 30th 2014 and the second 6 months will be paid on March 31st 2015. The van was dedicated to the business most of the time, therefore Robb decided to contribute it to the corporation. The fair market value of the van was $4,800. Although it is an old van it still works fine and Robb estimates that it will continue to roll for 4 more years and then it could be scrapped. Now that Robb has a corporation he can formalize the agreement with Bike Canada Outlet for the equipment and specialized tools he rents. A professional full set of repair tools is expensive, so Robb rents it for $50 per month (rental agreement covers April 1st to September 30th 2014). When the rental agreement expired in September 2014 he decided to exercise the option to buy them for $500. With good maintenance and care they can last 2 more years. 2 Hint: startup costs can be capitalized as an intangible asset \"Organization Costs\" and are assumed to have an indefinite life for amortization purposes. You may want to read the segment in Module 10 on intangibles for further clarification. Internet domain names would be afforded similar treatment. 8 Robb will continue to use a metal frame to mount the bikes while repairing them, the metal frame is already set up in his house and fits in his van when servicing clients in their locations. However, since that equipment now will be used for the newly established company, in the books it has to be reflected as his capital contribution with shop floor equipment for a value of $200. For accounting purposes, the equipment would be depreciated in five years with no residual value. In January 2015 CycleTO was running out of cash, so Robb asked her wife for a 5 months loan of $5,000 with the purpose of paying the bills during the winter and repay her back with interest in the Spring when business will be flourishing. Robb's wife handed in the $5,000 dollars on January 15th 2015 and expects to be repaid on June 15th 2015 the full amount plus 10% of interest. Next step for Robb was to clearly state the pricing for the diverse services. 1) Spring tune up of high end bicycles: minimum of $200. 2) Spring tune up of bicycles (not high end): minimum of $45. 3) Repair: $50 per hour of labour plus replaced parts. 4) Mobile service: $0.50 per Km of distance between Robb's operations (his house) and the customer's location. Distance is calculated for one way using a very popular maps app. Revenues were recognized when the service was provided. Occasionally customers will not be available for the scheduled appointment so Robb would wait 20 minutes and then leave. In those cases the payment made online was recognized as revenue; some of those customers will latter on contact Robb for a rescheduling with plausible sob stories. Robb would reschedule the appointment adding a $100 processing fee to the new billing. The business operations - Marketing, Promotion and Growth Robb was particularly proud of the specially designed T-shirts and backpacks he wears regularly to meet customers, which prominently displayed CycleTO's web address. The backpacks were designed to carry some tools, a last generation cell-phone and a water bottle. The cost to purchase and print the backpacks and T-shirts is expensed, along with other promotion expenses, even though Robb recognizes they may last longer than a bike season. In addition to the advertising on backpacks and T-shirts, Robb paid QuickPrint for a small initial supply of business cards, flyers and posters. Robb distributed the flyers and posters to bike shops and parks and handed out the business cards at every opportunity. The majority of the printed material and business cards had been used up by the end of March 2015. 9 Robb paid amounts due using pre-numbered cheques and kept the carbon copy of each cheque as a record of the payment. If the expenditure was expected to benefit more than one year, CycleTO capitalized the amount and amortized it over those future periods. The date of payment and the cheque number were written on the supplier invoice to cross-reference payments and supplier invoices. CycleTO received a monthly bank statement showing the deposits made directly by WebWonder, the pre-authorized debits for WebWonder's fees, the cheques which had been cashed by CycleTO's suppliers and the bank's service charges. It took Robb a few minutes to figure out why the bank statement showed deposits in the credit column and cheques in the debit column: cash deposited in the bank, while an asset of CycleTO, is an obligation for the bank as it owes CycleTO the money