For acctachment Case

You will assume the role of auditor at Hartford and Hartford CPA firm will prepare an individual report to address these issues (details below) Report Due : Sunday August 7th at 11:59 pm. The D2L dropbox will be closed at the deadline and late submissions will not be accepted. Submission Method: Assignment reports are to be prepared in Word and uploaded to the D2L dropbox. Your report should be no longer than 8 pages please. Individual assignment: This assignment will be discussed in class. You can work with others on this assignment but students must upload individual submissions. Students caught submitting the same assignment will receive a mark of zero. Grading: This project is worth 7% of your overall grade. Assessment will be as follows: Part I - 3 % Part II - 2% Part III - 2% Formatting requirements: Reports must be typed, using Arial 12 - point font, double - spaced, single sided paper with 1 - inch margins. Also, additional formatting of responses will be required as outlined below. Failure to follow these requirements will result in a 10% reduction in grade. You must identify who you worked with in the body of your response. Part I - Audit risk assessment (3%) Prepare an overall risk assessment for the December 31, 2005 audit of Overlook Video Store. Your risk assessment should include: 1. An assessment of inherent risk 2. An assessment of control risk 3. An assessment of fraud risk 4. A discussion of the audit approach that should be taken 5. A discussion of the vario us levels of materiality and the users 6. An overall conclusion about audit risk, materiality and audit approach. Part II - Financial statement analysis (2%) From an audit planning perspective, prepare a financial statement analysis of Overlook video stores. The analysis could include: 1. Trend analysis 2. Common size analysis 3. Ratio analysis All calculations and assumptions must be shown. After completing the calculated analysis, you will then identify any issues, the risk, the impacted accounts(s) and the audit assertions affected. Please use the following format for your discussion: Issue: Risk: Impacted accounts and Assertions: Your analysis and discussion should include no fewer than 5 items. For example: Issue: Accounts receivable turnover ratio has decreased by 3 times in 2011 compared to 2010 Risk: The Company is not collecting their accounts as fast. Increased risk of bad debts. Impacted accounts and assertions: Accounts Receivable (Valuation); Bad debt expense (Completeness) Part III - Analysis of the Movies by mail internal controls (2%) Refer to Exhibit III of the case. Nick Nightingale has produced a summary of the systems surrounding the new ?Movies by Mail? division. Please analyze these systems and identify the weaknesses in internal control, the implications of the weaknesses and provide a recommendation on how to remedy each weakness identified. You should format your discussion using the following headings: Weakness identified: Implication of the weakness: Recommendation to fix the weakness: Your analysis should consider at least 4 weaknesses.

Overlook Video Stores Inc. Simulation Acknowledgement: 2015 CPA Canada. Paper 2006-III-3 is reproduced here for your use with the permission of the Chartered Professional Accountants of Canada. It should not be copied or distributed in any form as this would cause an infringement of Chartered Professional Accountants of Canada's copyright. OVERLOOK VIDEO STORES INC. (60 minutes) Overlook Video Stores Inc. (OVS) is a privately-held chain of DVD rental stores headquartered in Toronto. The company was incorporated in 1992 and has gone from a single store in Toronto to over 30 stores throughout Ontario. Harford & Harford, LLP (H&H), a mid-sized professional services firm, have been the auditors for OVS since its inception. You, CA, are the audit senior on the OVS audit for the year ending December 31, 2005. On December 1, 2005, Alice Harford, the engagement partner, calls you into her office to explain that the audit will need to begin in early January 2006, because OVS's bank is eager to see the audited financial statements. \"I would like you to prepare the audit planning memo for the OVS audit. OVS has experienced some changes, and I want to make sure we consider those in our audit plan. The controller of OVS has faxed us the interim financial statements for the 11 months ended November 30, 2005 (Exhibit I). These should help you in your audit plan. \"I met with Victor Ziegler, the controlling shareholder of OVS, a few months ago and he told me about OVS's new directions. Here are my notes from that meeting (Exhibit II). In addition, there are some new accounting issues that have arisen since last year end. I would like you to look at them and provide your recommendations on the accounting treatments to adopt. Please also consider these issues when drafting your audit planning memo, and suggest ways to audit them. \"I also met with OVS's Chief Information Officer, Nick Nightingale. He provided a description of OVS's expansion during 2005 into the Internet-based DVD rental market through a program called Movies By Mail. Here are my notes from my meeting with Nick (Exhibit III). Please review them and provide your recommendations for improving the system. I will pass on your comments to our Information Technology (IT) partner so that she can include them in a report she is preparing for Victor. Victor has asked our IT partner to meet with him to discuss the information technology issues related to the Internet-based rental system.\" Page 1 of 6 Overlook Video Stores Inc. Simulation EXHIBIT I OVERLOOK VIDEO STORES INC. EXCERPTS FROM THE BALANCE SHEET (in thousands of dollars) Nov. 30, 2005 (unaudited) Assets Current assets Cash Accounts receivable Inventory - DVDs for rent Inventory - New DVDs for sale Inventory - Previously viewed DVDs for sale Other inventory Prepaid expenses $ Property, plant and equipment Website 21 4,210 7,935 2,315 3,526 598 1,251 19,856 Dec. 31, 2004 (audited) $ - 6,545 2,119 - 412 1,105 10,216 40,780 8,512 Liabilities Current liabilities Accounts payable Current portion of long-term debt 35 31,105 - $ 69,148 $ 41,321 $ 652 2,937 3,589 $ 3,569 Long-term debt Due to shareholders - 3,569 - 26,430 4,532 30,962 6,483 6,483 100 34,497 34,597 100 31,169 31,269 Shareholders' Equity Common Shares Retained earnings $ Page 2 of 6 69,148 $ 41,321 Overlook Video Stores Inc. Simulation EXHIBIT I (continued) OVERLOOK VIDEO STORES INC. EXCERPTS FROM THE INCOME AND RETAINED EARNINGS STATEMENT (in thousands of dollars) Revenues Rentals Sales Movies By Mail No Late Fees Other 11 months ended Nov. 30, 2005 (unaudited) Year ended Dec. 31, 2004 (audited) $ $ Expenses Advertising Amortization Bank charges and interest Business and property tax Cost of movies sold Insurance Professional and consulting fees Rent and office Repairs and maintenance Utilities Wages and benefits Income before taxes Income taxes Net income Retained earnings, beginning of period Retained earnings, end of period Page 3 of 6 $ 15,477 6,321 7,432 4,539 587 34,356 14,613 5,946 - - 419 20,978 3,124 659 1,325 151 8,797 125 691 1,286 569 1,542 10,540 28,809 2,460 450 11 149 4,757 105 710 1,246 498 1,612 8,465 20,463 5,547 2,219 3,328 515 206 309 31,169 34,497 30,860 31,169 $ Overlook Video Stores Inc. Simulation EXHIBIT II NOTES FROM MEETING WITH VICTOR ZIEGLER After years of slow and steady growth, OVS began expanding in two directions. First, OVS opened ten new video stores in 2005. In the past, OVS had only opened one store per year, but Victor felt more rapid expansion was necessary to compete with pay-per-view TV and downloadable movies on the Internet. Second, OVS moved into the Internet-based DVD rental business by launching a new website, www.MoviesByMail.ca. The expansion was financed by a ten-year term loan from OVS's bank. Victor noted that the bank now seems concerned with the profitability of the company. No Late Fees OVS also introduced a new program called \"No Late Fees\" during 2005. Since people are often reluctant to rent movies because they cannot return them on time, OVS eliminated late fees for its customers. However, to prevent abuse of this program, after 30 days if the movie is not returned, the outstanding movie is considered sold to the customer who rented it. The next time the customer comes to the store, there will be a charge of $25, the price of purchasing a new DVD, on the customer's account and they have the right to keep the DVD. The program has been \"tremendously successful,\" according to Victor. It has both increased rental revenue and increased sales of DVDs, since many customers keep their DVDs beyond the 30 days. However, Victor conceded that it has upset some customers who believed that OVS had truly eliminated all forms of late fees. Most customers who were charged for an over-30-day DVD have refused to pay for it and simply returned the DVD to an OVS store. Others have yet to pay for the DVD and have yet to return it. Movies By Mail When customers first subscribe to the Movies By Mail service at the store, they supply their credit card number and agree that it will be charged $30 at the end of each month until they cancel their subscription. To rent a DVD, customers log on to the website using a user ID and password provided to them. Once logged on, customers can browse the over 25,000 titles that OVS has in its DVD rental library. They can choose up to 40 movies to have in their \"wish list.\" If customers really want a certain DVD, they can flag it as urgent. The customer is mailed his or her initial four DVDs from the OVS warehouse in Toronto. These are selected automatically by the system based on availability of DVDs in the rental inventory, while giving priority to those DVDs marked as urgent by the customer. Once the customer is finished watching a particular DVD, he or she returns it by mail in a postage-paid envelope. OVS then sends the customer the next DVD on the list. During the introduction period of Movies By Mail, OVS offered new customers the option of paying $500 up front for three years of DVD rentals by mail. Many customers took advantage of this option due to its substantial savings. Page 4 of 6 Overlook Video Stores Inc. Simulation EXHIBIT II (continued) NOTES FROM MEETING WITH VICTOR ZIEGLER RentPoints In January of 2005, OVS introduced a customer reward program called RentPoints. For every dollar a customer spends with OVS, they get one RentPoint added to their OVS account. The point-ofsale system in OVS's stores automatically tracks the points each time a customer rents or purchases DVDs. Customers can then redeem RentPoints for selected rewards. For example, 100 RentPoints can be redeemed for a new DVD, or 25,000 RentPoints can be redeemed for a trip for two to Hollywood. Although Victor believes the program has been very popular, to date, only 92,000 RentPoints have been redeemed. Victor has faith that more people will eventually redeem their points since the points do not expire. However, he is now wondering if he should continue the program, since so few people have taken advantage of it. Previously viewed DVDs In the past, a wholesaler purchased all of OVS's previously viewed DVDs. Now, due to its expansion, OVS first sells all the previously viewed DVDs it can to the wholesaler. OVS then offers the remaining previously viewed DVDs for sale to its customers at discounted prices. Each of these remaining DVDs is scanned and its cost is transferred from \"Inventory-DVDs for Rent\" to \"Inventory-Previously Viewed DVDs for Sale\". When a new movie is released on DVD, OVS must order at least 20 copies of it for each store, at an average cost of $20 per DVD. Within two months, demand for the movie has diminished so that only five copies per store are necessary. As a result, OVS must sell off 15 copies per store for about $10 each. Page 5 of 6 Overlook Video Stores Inc. Simulation EXHIBIT III NOTES FROM MEETING WITH NICK NIGHTINGALE Nick Nightingale is the Chief Information Officer for OVS, and was responsible for the implementation of the Movies By Mail system. He answers the OVS help desk phone, so he has been extremely busy lately because Movies By Mail customers have been calling for assistance. He said the following: \"The Movies By Mail concept is great, but it has been difficult to get going. Moonwatcher Web Designers (MWD) programmed both the front-end, which is the part the customer sees, and the back-end, which is the database that tracks the DVDs. MWD programmed the website very quickly, but has not been available very much since the website went live six months ago. We have had several crashes of the website, and the only advice MWD has provided is to reboot the server. Considering all the money we paid MWD to develop the site, which at last count was over $8.5 million, I hoped for better service. \"We were able to save money by hosting www.MoviesByMail.ca on an existing server. Because the website needs to transfer credit card sales information daily to the accounting system, we used the same server that runs our accounting system. \"Since MWD also programmed an antivirus component right into the website software, we did not have to purchase separate antivirus software for the server. I have been after MWD to provide us with updates to the antivirus software. MWD keeps promising us that updates will arrive shortly. Thank goodness we have a great firewall, so viruses cannot get access to the system in the first place. \"I am also not too worried because we have a backup that I store off-site, because I know how important that is for disaster recovery. The back up now does both the accounting data and the movie title database. I change the tape every week and whenever I do a backup, it finishes in about 10 seconds, and ejects the tape right away. It used to take much longer to do the back up, but the MWD people must have done more than just tweaking when they installed the website. \"One matter I am a little worried about, though, is the shipping report produced by the new system. Each day, the system generates and prints a shipping report and the addressed envelopes. The report indicates which DVD gets sent to which customer, and there is one envelope for each customer listed on the report. The idea is that the inventory picker can find the DVD, and immediately put it in the matching addressed envelope to be shipped. However, I have noticed that sometimes the customer names that the system prints on the shipping report are different from the names it prints on the envelopes. Usually, it is not a big deal because we can correct the information in the system and just reprint the envelope. However, it causes the shipping people to do additional manual work. \"We were also having a problem with the customer login screen. Customers would be denied access, even if they were using their correct username and password. After repeatedly calling MWD, they dialed in to the system last night and applied a service pack to the website to fix the problem. Today, the login screen seems to be working fine.\" Page 6 of 6