{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["Audit","Main Menu","Instructions","Academic Integrity","Transactions","Products","Chart of Accounts GL","Chart of Accounts AR Ledger","Chart of Accounts AP Ledger","Sales Journal","Purchases Journal","Cash Receipts Journal","Cash Payments Journal","General Journal","General Journal ADJ","General Journal CLOSING","General Ledger","AR Ledger","AP Ledger","Worksheet June 2013","IS June 2013","Stmt RE June 2013","BS June 2013","Post Closing Trial Balance","Adjusted Trial Balances","IS Comparative","BS Comparative","Ratios Historical","Inventory Control","Data","Data - ADJ JE","Change Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Audit","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["User Name","Computer Name","Open Time","Close Time","Open WB Name","Close WB Name"]
["Andrew","ANDREW-PC","2014-01-08T12:25:43","2014-01-08T19:34:23","C:\\Users\\Andrew\\AppData\\Local\\Temp\\ACCT202ProjectSolutionNEW-2.xlsm","C:\\Users\\Andrew\\Desktop\\ACCT202ProjectSolutionNEW-2 Combined.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-01-09T12:17:21","2014-01-09T14:15:10","D:\\Users\\tbergsma\\Downloads\\ACCT202ProjectSolutionNEW-2 Combined.xlsm","D:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202ProjectSolutionNEW-2 Combined_Rev1.xlsm"]
["Tim","PCTIMBASEMENT","2014-01-10T16:20:39","2014-01-11T17:02:26","C:\\Users\\Tim\\Dropbox\\ACCT202 PS W14\\ACCT202ProjectSolutionNEW-2 Combined_Rev1.xlsm","C:\\Users\\Tim\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["Tim","PCTIMBASEMENT","2014-01-11T16:20:19","2014-01-15T15:52:08","C:\\Users\\Tim\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-01-15T14:51:29","2014-01-15T16:11:00","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-01-15T15:03:55","2014-02-11T17:56:54","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-01-15T15:52:42","2014-02-12T11:44:39","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-01-15T15:53:11","2014-02-12T16:06:53","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-02-11T17:22:06","2014-02-21T10:32:55","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","C:\\Users\\Tim\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-02-12T08:34:04","2014-09-03T11:37:41","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","https://d.docs.live.net/213637fca0d9e955/Documents/DU Teaching/ACCT202PS/ACCT202 PS F14/ACCT202_PracticeSet_F14_Solution.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-02-12T15:29:58","2014-09-03T15:39:33","d:\\Users\\tbergsma\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","d:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS F14\\ACCT202_PracticeSet_F14_Solution.xlsm"]
["Tim","PCTIMBASEMENT","2014-02-21T09:54:51","2014-09-04T13:42:03","C:\\Users\\Tim\\Dropbox\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","https://d.docs.live.net/213637fca0d9e955/Documents/DU Teaching/ACCT202PS/ACCT202 PS F14/ACCT202_PracticeSet_F14_StudentFile_DU.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-09-03T09:41:41","2014-09-04T13:42:29","d:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS W14\\ACCT202_PracticeSet_W14_Solution.xlsm","https://d.docs.live.net/213637fca0d9e955/Documents/DU Teaching/ACCT202PS/ACCT202 PS F14/ACCT202_PracticeSet_F14_StudentFile_DU.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-09-03T14:37:44","2016-01-26T14:33:16","d:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS F14\\ACCT202_PracticeSet_F14_Solution.xlsm","D:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS F14\\ACCT202_PracticeSet_F14_StudentFile_DU.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-09-04T12:38:43","2016-01-26T14:45:00","d:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS F14\\ACCT202_PracticeSet_F14_Solution.xlsm","D:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\W16\\ACCT202_PracticeSet_W16_StudentFile_DU.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2014-09-04T13:42:15",null,"https://d.docs.live.net/213637fca0d9e955/Documents/DU Teaching/ACCT202PS/ACCT202 PS F14/ACCT202_PracticeSet_F14_StudentFile_DU.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2016-01-26T14:17:48",null,"D:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS F14\\ACCT202_PracticeSet_F14_StudentFile_DU.xlsm"]
["tbergsma","LTFACDDTBERGSMA","2016-01-26T14:44:05",null,"d:\\Users\\tbergsma\\OneDrive\\Documents\\DU Teaching\\ACCT202PS\\ACCT202 PS F14\\ACCT202_PracticeSet_F14_StudentFile_DU.xlsm"]

{"sheet":"Main Menu","index":1,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Davenport University"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ACCT202 Practice Set"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Winter: 2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Student File"]
[]
[]
[]
[]
["Student Name:"]
["CRN:"]
["Professor:"]

{"sheet":"Instructions","index":2,"n_rows":51,"n_cols":1,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Company Background & Scenario"]
["The AC Speed Company is a well-established, publicly-held corporation, operating as a wholesaler in the auto parts industry.  Specifically, AC Speed purchases auto parts from manufacturers and sells them to large business customers.  Most purchases and sales are on account, with trade credit terms (specified below)."]
["You’re a Davenport University student pursuing a bachelor’s degree in business and employed at the AC Speed Company this semester as an intern.  You’ve worked in various departments and on several projects so far, learning a lot about the company’s business operations.  Management seems impressed with your enthusiasm and the quality of your work."]
["The company’s accountant has just been called away for a family emergency and will likely be absent for a month or so.  The General Manager asks you to take over the accountant’s regular duties on an interim basis.  You’re nervous about doing so, but are confident that what you’ve learned in accounting class, plus your personal problem-solving skills, will make this a successful experience.  What a great learning opportunity, not to mention an enhancement to your resume!"]
["Project Overview & Instructions"]
["A. Overview"]
["a. Part 1 is a financial accounting activity that requires you to record various business transactions during the month, close the accounting records at the end of the month, and prepare the financial statements.  These tasks relate to the steps in the accounting cycle that you learned in your first accounting course.`"]
["b. Part 2 is an activity that requires you to analyze the company’s year-end financial statements to assist management in assessing the company’s position and making decisions about its future direction."]
["c. This is an individual, not a team, project.  While you may discuss this project with others, you must prepare and submit your own work.  Refer to the academic integrity statement in the project workbook."]
["d. Before starting work, review the entire project:  all instructions, business transactions descriptions, workbook sections, check figures, due dates, and submission requirements."]
["B. General Instructions"]
["a. The parts of this project, including specific business transactions and steps in the accounting cycle, must be completed in sequence.  This is particularly important with business transactions relating to purchases and sales of inventory."]
["b. You are encouraged to use your textbook’s table of contents (front) or index (back) to locate helpful references."]
["c. These project instructions will not address every detail of every task.  If you have questions, ask your instructor."]
["d. Most of your work for this project will be accomplished in Excel.  A basic skill level in this application is expected.  That is, you should be able to such things as move around in a workbook, enter data in cells, use the sum function, compose basic formulas, and save your work."]
["e. If rounding is required, round to the nearest cent.  For example, $96.835 would be entered as $96.84."]
["f. Use the check figures provided to check your work as you progress through the project.  Investigate any discrepancies and correct them as you go along."]
["g. Refer to the project rubric to determine how components of the project will be assessed."]
["h. Appearance counts!  Pay attention to the format, to spelling, and to other details of appearance.  This reflects on management’s perception of you as a professional."]
["C. Submission Requirements"]
["a. Final submission of all parts of this project must be in electronic (not paper) form.  That is, you will submit your completed work via an assignment link in a Blackboard course site or via an email attachment.  Follow your instructor’s directions."]
["b. Save backup copies of your work.  If you have multiple versions of the project, clearly label them for your own reference and to ensure that you submit the appropriate version to your instructor."]
["c. You must read the academic integrity statement in the project workbook and enter your student ID number on the form to signify your agreement with and adherence to that statement.  Final project submissions will not be accepted without this."]
["d. Due dates for the parts of this project will be provided by your instructor in the course syllabus, in the Blackboard course site, or in a designated handout.  Be sure to enter these on your personal calendar and plan your work on this project accordingly."]
["D. Credit Terms & Inventory Accounting"]
["a. When AC Speed purchases merchandise from a supplier or vendor on account, they receive credit terms of 2/15, net 30."]
["b. When AC Speed sells merchandise to a customer on account, they offer that customer credit terms of 2/20, net 30"]
["c. AC Speed accounts for the specific types of merchandise in their inventory with a set of subsidiary ledgers (inventory control cards).  The balances in these subsidiary ledger records, in total, must equal the balance in the Merchandise Inventory account in the general ledger."]
["d. AC Speed uses a perpetual inventory accounting system and a last-in, first-out (LIFO) inventory costing method."]
["E. Financial Accounting Steps:"]
["a. Record each business transaction, in sequence by date, in the appropriate special journal or the general journal.  Also, immediately record any transaction involving inventory, a customer, or a vendor in the appropriate subsidiary ledger record."]
["b. At the end of the month, post each entry in the general journal to the general ledger."]
["c. At the end of the month, total each column in each special journal and post that total to the general ledger.  EXCEPT for entries in the “Other” columns, which must be posted individually to the general ledger."]
["d. When posting is completed, bring the balance in each general ledger account up to date."]
["e. When posting is completed, bring the balance in each subsidiary ledger account up to date."]
["f. At this point in the closing process, the balances of all subsidiary ledger accounts would be totaled and that total compared to the balance of the corresponding control account in the general ledger.  That is, the total of inventory control cards would be compared to the Merchandise Inventory balance; the customer subsidiary ledger total to the Accounts Receivable balance; and the vendor subsidiary ledger total to the Accounts Payable balance.  Any discrepancies would be investigated and corrected.  Given the limited scope of this project scenario, reconciliation between subsidiary ledgers and control accounts is not possible."]
["g. List all general ledger account balances in the unadjusted trial balance columns of the worksheet.  Use the sum function in Excel to total the debit and credit columns.  These totals should be equal."]
["h. Prepare the end-of-month adjusting entries.  Record these entries in the general journal and post them to the general ledger.  Also record the adjusting entries in the designated columns in the worksheet and total the debit and credit columns.  These totals should be equal."]
["i. Update general ledger account balances after posting adjusting journal entries.  "]
["j. Complete the unadjusted trial balance columns on the worksheet.  Use Excel formulas to carry balances from the unadjusted trial balance columns, adjusting as necessary by entries in the adjustments columns.  Check your results against the balances recorded in the general ledger."]
["k. Sort the dollars recorded in the adjusted trial balance columns into either the income statement or the balance sheet columns.  Total these columns.  The entry of net income should cause the debit and credit columns to equal one another.  "]
["l. Use the income statement information on the worksheet to prepare a multi-step income statement in good form.   Look at examples of this income statement format in your textbook."]
["m. Prepare a statement of retained earnings in good form.   Look at examples of this statement in your textbook.  Remember that net income from your just-completed income statement is a necessary component of this statement."]
["n. Use the balance sheet information on the worksheet to prepare a classified balance sheet.  Remember that the ending retained earnings balance from the just-completed statement is a necessary component of the equity section of the balance sheet."]
["o. Prepare the end-of-month closing entries.  Record these entries in the general journal and post them to the general ledger.   Update balances in the general ledger accounts."]
["p. List the general ledger accounts that have balances other than zero on the post-closing trial balance.  The totals of the debit column and the credit column should be equal."]
["F. Part 2 of this project requires you to analyze the company’s year-end financial statements to assist the management of AC Speed in assessing the company’s financial position and making decisions about its future direction."]
["a. Before beginning this part of the project, you will find it helpful to review Chapter 17 on financial statement analysis.  Page 707, a summary of ratios, will be particularly useful."]
["b. Tabs in the project workbook provide trial balance data for the current and two preceding years for AC Speed and a location to calculation a selection of ratios.  Use the trial balance data and the formulas in Chapter 17 to compute the ratios listed for each of the three years.  YOU MUST STRUCTURE YOUR RATIO CALCULATIONS AS FORMULAS AND LINKS TO APPROPRIATE CELLS ON THE TRIAL BALANCE TAB.  You will lose points by simply typing the final ratio numbers or percentages."]
["c. After you calculate the ratios, consider whether there is a trend over the three-year period.  Also compare the ratios you calculated for AC Speed with those listed as industry averages.  Review the information in Chapter 17 to help you determine what the ratios are telling you about various aspects of AC Speed’s business operations."]
["d. Use Word to prepare a memo (minimum 500 words) to AC Speed’s general manager, addressing the three questions listed at the bottom of the ratios tab.  This should be formatted as a business memo, not an APA paper.  Be sure to include a brief introduction and conclusion in the memo.  Each question should be addressed in one or two paragraphs in the body of the memo.  Remember that the general manager will expect details/facts/ratios to support statements you may make about the status of the business.  Your writing should be concise, clear, and readable, with a fairly formal tone (since it’s addressed to AC Speed’s general manager, who is likely to share it with other members of management).   Your instructor will provide the due date and submission requirements for this part of the project.  "]

{"sheet":"Academic Integrity","index":3,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[4,1,4,2],[6,1,6,2],[8,1,8,2],[10,1,10,2],[12,1,12,2]]}
[]
[]
[null,null,"Project Academic Integrity Statement"]
[]
[null,"I understand that this is an individual, not a team, project; that I am expected to do my own work on the project. I may discuss project requirements in general terms with others, but I am not permitted to collaborate with anyone or copy anyone's work, manually or electronically, in full or in part."]
[]
[null,"I also understand that I am not permitted to supply anyone with the results of my work or to provide them with any assistance that compromises another student's completion of the project through his or her own efforts. "]
[]
[null,"If I have any questions about these requirements, I will promptly ask my instructor for clarification"]
[]
[null,"I understand that any violation of this project academic integrity statement will lead, at minimum, to a failing grade for the project."]
[]
[null,"By entering my name and student ID number below, I am attesting that I have read, understood, and will personally adhere to this project's academic integrity statement. "]
[]
[null,"Student Name:"]
[]
[null,"Student ID Number:"]
[]
[null,"Date:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2016-06-16"}]

{"sheet":"Transactions","index":4,"n_rows":105,"n_cols":2,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["JUNE JOURNAL TRANSACTIONS"]
[]
["June 1",{"$f":"Data!AA2","v":"Signed a 3 year 7.1% , $210000 note payable with First Bank."}]
[]
["June 1",{"$f":"Data!AA3","v":"Purchased 3100 GPS units on credit from Navistar for $35.5 per unit. "}]
[]
["June 1","Issued 5,000 shares of common stock for $10 per share (Refer to General ledger for description of common stock). "]
[]
["June 1",{"$f":"Data!AA4","v":"Sold 1983 DVD players on account to Toyota for $75 per unit, Invoice #5555 "}]
[]
["June 2",{"$f":"Data!AA6","v":"Sold 3400 GPS units on account to Kia for $58 per unit, Invoice #5556. "}]
[]
["June 2",{"$f":"Data!AA5","v":"Purchased office supplies from Office Max on credit for $1150    "}]
[]
["June 2",{"$f":"Data!AA7","v":"Sold 975 docking stations for $66 per unit and 1925  GPS units for $82 per unit on account to Nissan, Invoice #5557."}]
[]
["June 3","The Board of Directors declared a cash dividend of $5 per share for shareholders of record on June 5th, payable on June 12th. "]
[]
["June 4",{"$f":"Data!AA9","v":"Received payment from Toyota for May 11th sale.        "}]
[]
["June 4",{"$f":"'Data - ADJ JE'!E3","v":"Rented part of the warehouse to a new tenant and received $5400 for three months rent starting in June"}]
[]
["June 5","Paid $2,100 to Michigan Utility Co. for utilities bill that was recorded in May as an Account Payable, Check #5278. "]
[]
["June 7",{"$f":"Data!AA10","v":"Received and paid expense reports for travel and entertainment totaling  $900 , Check #5279.      "}]
[]
["June 8",{"$f":"Data!AA11","v":"Paid for office supplies purchased on June 2nd, Check #5280.        "}]
[]
["June 11",{"$f":"Data!AA12","v":"Paid in full for the June 1 purchase from Navistar, Check #5281.        "}]
[]
["June 11",{"$f":"Data!AA13","v":"Received a bill from the law firm of Larry, Moe & Curly for  $5400 , payable upon receipt, for bond consulting fees, Check #5282.      "}]
[]
["June 12","Paid the dividend that was declared on June 3, Check #5283."]
[]
["June 13",{"$f":"Data!AA14","v":"Took advantage of a special deal to purchase  3250 DVD players on account from JVC for  $48 per unit.    "}]
[]
["June 13",{"$f":"Data!AA15","v":"Purchased 850 GPS units on credit from Magellan for $33 per unit.    "}]
[]
["June 15",{"$f":"Data!AA18","v":"Sold 2000 DVD players on credit to Ford Motor Co. for  $89 per unit, Invoice 5558.     "}]
[]
["June 15",{"$f":"Data!AA16","v":"Check # 5284 was issued for payroll:  $14500 for salaried and $4750 for wages (wage expense)    "}]
[]
["June 16",{"$f":"Data!AA19","v":"Purchased  1800 docking stations on credit from Samsung for  $42 per unit.    "}]
[]
["June 17","Issued a credit to Kia for the return of 350 defective units from the June 2nd sale. These units has a cost basis of $36 per unit."]
[]
["June 17","Returned the 350 defective units received from Kia to Navistar."]
[]
["June 18",{"$f":"Data!AA20","v":"Received  payment in full from Toyota for the June 1st sale.        "}]
[]
["June 20","While inspecting the June 13th purchase, it was discovered that the GPS units were programmed for South America instead of North America. AC Speed returned the entire order to Magellan."]
[]
["June 20","A bankruptcy judge disallowed AC Speed's claim for $5,000 due from General Motors. Management Decided to write off this accounts receivable. "]
[]
["June 22",{"$f":"Data!AA21","v":"Sold  1650 docking stations on credit to Kia for 64.5 per unit, Invoice #5559.    "}]
[]
["June 23",{"$f":"Data!AA22","v":"Paid $75000 of the $162500 owed to JVC from May 25, Check #5285.    "}]
[]
["June 23",{"$f":"Data!AA23","v":"Received payment from Ford Motor Co. for $175000 of the $300000 owed from May 5.    "}]
[]
["June 24",{"$f":"Data!AA24","v":"Purchased a $100 international phone card for one of the sales representative's upcoming European business trip, Check #5286.      "}]
[]
["June 25",{"$f":"Data!AA25","v":"Paid in full for the purchase from JVC on June 13, Check #5287        "}]
[]
["June 26",{"$f":"Data!AA26","v":"Purchased 1250 docking station from Samsung for $41 per unit paying in cash, Check #5288    "}]
[]
["June 27",{"$f":"Data!AA27","v":"Sold 1500 docking stations on credit to Honda for $61 per unit, Invoice 5560.    "}]
[]
["June 27",{"$f":"Data!AA28","v":"Hired and paid a consultant $75000 to devise a marketing plan. AC Speed's management felt this was necessary to develop brand awareness. Check #5289.      "}]
[]
["June 28",{"$f":"Data!AA29","v":"AC Speed is behind in its mortgage payments to Bank of America. Paid a total of $10000 ( $2000 principal and $8000 interest), Check #5290.   "}]
[]
["June 29",{"$f":"Data!AA30","v":"Received payment in full from Honda for the June 27th transaction.        "}]
[]
["June 29",{"$f":"Data!AA31","v":"Paid in full for the purchase from Magellan on May 31st, Check #5291.        "}]
[]
["June 29",{"$f":"Data!AA32","v":"Check # 5292 was issued for payroll:  $14500 for salaried and $4750 for wages (wage expense)    "}]
[]
["June 30","Paid the first month's principal payment of $15,000 on the note payable.  In addition, paid one month's interest, Check #5293 "]
[]
["June 30","Issued bonds payable at face value for $450,000 "]
[]
["*All purchases on account terms of 2/15, n/30"]
[]
["**All credit sales have terms of 2/20, n/30"]
[]
["June Month-end Adjustments:"]
[]
["( A )",{"$f":"'Data - ADJ JE'!C3","v":"AC Speed has earned one month of the prepaid rent received from their tenant at the beginning of June. "}]
[]
["( B )",{"$f":"'Data - ADJ JE'!C6","v":"The Company took a physical count of Office Supplies on June 30 and found the following to be on hand: Office Supplies -  $2500"}]
[]
["( C )",{"$f":"'Data - ADJ JE'!C9","v":"AC Speed estimates bad debt expense on a monthly basis rather than waiting until year-end. The company uses the allowance method. Based on recent industry estimates, AC Speed estimates that the allowance account should be 2%  of accounts receivable. "}]
[]
["( D )",{"$f":"'Data - ADJ JE'!C11","v":"The Company took a physical inventory count on June 30 and found the following inventory on hand: Merchandise Inventory -  $120000"}]
[]
[]
["( E )",{"$f":"'Data - ADJ JE'!C13","v":"The Balance in the prepaid insurance account at the beginning of June represents  4 months of coverage. Record the amount of insurance for June. "}]
[]
["( F )","Depreciation on the company's fixed assets for the month of June is as follows:"]
[null,{"$f":"'Data - ADJ JE'!C16","v":"1. The furniture and equipment for the warehouse was purchased a few years ago for  10000. These assets have a 4-year life, an expected salvage value of 1000 and are depreciated using the straight-line method."}]
[null,{"$f":"'Data - ADJ JE'!C17","v":"2. The furniture and equipment for the office was purchased last year for  8500. these assets have a 7 year life, an expected salvage value of 1500 and are depreicated using stright-line method. "}]

{"sheet":"Products","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Product Name","Description"]
["GPS","In vehicle GPS unit"]
["DVD Player","In vehicle DVD player"]
["Docking Station","Cell phone / Mobile Communications Docking Station"]

{"sheet":"Chart of Accounts GL","index":6,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["AC Speed Corporation"]
["Chart of Accounts - General Ledger"]
[]
["BALANCE SHEET ACCOUNTS"]
["   Assets"]
["     Current Assets"]
[]
["Acct #","Account Name"]
[100,"Cash"]
[102,"Accounts Receivable"]
[103,"Allowance for Doubtful Accounts"]
[104,"Merchandise Inventory"]
[105,"Office Supplies"]
[106,"Prepaid Insurance"]
["     Property, Plant and Equipment"]
[140,"Land"]
[145,"Building"]
[146,"Accumulated Depreciation - Building"]
[151,"Equipment & Furniture - Warehouse"]
[152,"Accumulated Depreciation - Equip & Furn. - Warehouse"]
[153,"Equipment & Furniture - Office"]
[154,"Accumulated Depreciation - Equip & Furn. - Office"]
["   Liabilities"]
["     Current Liabilities"]
[]
[201,"Accounts Payable"]
[202,"Wages Payable"]
[203,"Interest Payable"]
[204,"Dividends Payable"]
[205,"Unearned Rent"]
["     Long-Term Liabilities"]
[250,"Notes Payable"]
[251,"Bonds Payable"]
[252,"Mortgage (Warehouse) Payable"]
["   Capital (Equity)"]
[300,"Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding"]
[301,"Paid In Capital - Excess of Par"]
[330,"Retained Earnings"]
[340,"Treasury Stock"]
["INCOME STATEMENT ACCOUNTS"]
["   Revenue"]
[500,"Sales"]
[510,"Sales Discounts"]
[511,"Sales Returns & Allowances"]
["   Cost of Goods Sold"]
[600,"Cost of Goods Sold"]
["   Operating Expenses"]
[700,"Wage Expense (hourly workers)"]
[701,"Salaries Expense (Exempt Staff)"]
[702,"Marketing Expense"]
[703,"Travel and Entertainment Expense"]
[704,"Bad Debt Expense"]
[705,"Property Tax Expense"]
[706,"Office Maintenance & Repair Expense"]
[707,"Legal Expenses"]
[708,"Insurance Expense"]
[709,"Utilities Expense"]
[710,"Office Supplies Expense"]
[711,"Telecommunications Expense"]
[712,"Depreciation Expense -  Equip & Furniture - Warehouse"]
[713,"Depreciation Expense - Equip & Furniture - Office"]
["   Other Income"]
[800,"Rent Income"]
["   Other Expenses"]
[900,"Interest Expense"]
["Other"]
[1000,"Income Summary"]

{"sheet":"Chart of Accounts AR Ledger","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Chart of Accounts - Accounts Receivable Ledger"]
[]
[null,"Account Name"]
[null,"General Motors"]
[null,"Ford Motor Co."]
[null,"Toyota"]
[null,"Honda"]
[null,"Kia"]
[null,"Nissan"]

{"sheet":"Chart of Accounts AP Ledger","index":8,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Chart of Accounts - Accounts Payable Ledger"]
[]
[null,"Account Name"]
[]
[null,"Garmin"]
[null,"JVC"]
[null,"Magellan"]
[null,"Michigan Utility Company"]
[null,"Motorola"]
[null,"Navistar"]
[null,"Office Max"]
[null,"Samsung"]

{"sheet":"Sales Journal","index":9,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Sales Journal"]
[]
["Date","Invoice No.","A/R Account Debited","Post Ref","A/R - DR                Sales - CR","CGS - DR                   Inv - CR"]

{"sheet":"Purchases Journal","index":10,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Purchases Journal"]
[]
["Date","Creditors Account Credited","Other Account - Debited","Post Ref","A/P - CR","Inventory - DR","Office Supplies - DR","Other - DR"]

{"sheet":"Cash Receipts Journal","index":11,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Cash Receipts Journal"]
[]
["Date","Acct - CR                      Customer Acct                  Other Acct","Post Ref","Sales - CR","A/R - CR","Other - CR","Sale Discount - DR","Cash - DR","CGS - DR           Inv - CR"]

{"sheet":"Cash Payments Journal","index":12,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Cash Payments Journal"]
[]
["Date","Check #","Payee","Account Debited","Post Ref","Cash - CR","Inventory - CR","Other - DR","A/P - DR"]

{"sheet":"General Journal","index":13,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["General Journal"]
[]
["Date","Accounts","Post Ref","DEBIT","CREDIT"]

{"sheet":"General Journal ADJ","index":14,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["General Journal"]
[]
["Date",null,"Accounts","Post Ref","DEBIT","CREDIT"]

{"sheet":"General Journal CLOSING","index":15,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["General Journal"]
[]
["Date","Accounts","Post Ref","DEBIT","CREDIT"]

{"sheet":"General Ledger","index":16,"n_rows":574,"n_cols":9,"rows_kept":574,"cut":false,"hidden":false,"merged":[]}
["Account:",{"$f":"'Chart of Accounts GL'!B9","v":"Cash"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A9","v":100}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,75000]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,120000]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B10","v":"Accounts Receivable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A10","v":102}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT",4]
["2010-05-31","Balance",null,null,null,{"$f":"'AR Ledger'!E4+'AR Ledger'!E17+'AR Ledger'!E30","v":490000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B11","v":"Allowance for Doubtful Accounts"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A11","v":103}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,null,15000]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B12","v":"Merchandise Inventory"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A12","v":104}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,{"$f":"'Inventory Control'!M4+'Inventory Control'!M19+'Inventory Control'!M32","v":334000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B13","v":"Office Supplies"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A13","v":105}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,2000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B14","v":"Prepaid Insurance"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A14","v":106}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,null,{"$f":"'Data - ADJ JE'!I13","v":14000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B16","v":"Land"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A16","v":140}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-06-01","Balance Carried Forward",null,2000600,null,{"$f":"D82","v":2000600}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B17","v":"Building"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A17","v":145}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-06-01","Balance Carried Forward",null,1500000,null,{"$f":"D95","v":1500000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B18","v":"Accumulated Depreciation - Building"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A18","v":146}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance Carried Forward",null,null,1500000,null,{"$f":"E108","v":1500000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B19","v":"Equipment & Furniture - Warehouse"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A19","v":151}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,10000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B20","v":"Accumulated Depreciation - Equip & Furn. - Warehouse"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A20","v":152}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,null,1900]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B21","v":"Equipment & Furniture - Office"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A21","v":153}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,8500]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B22","v":"Accumulated Depreciation - Equip & Furn. - Office"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A22","v":154}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,null,1600]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B26","v":"Accounts Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A26","v":201}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,null,{"$f":"157800+790800","v":948600}]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B27","v":"Wages Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A27","v":202}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B28","v":"Interest Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A28","v":203}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B29","v":"Dividends Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A29","v":204}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B30","v":"Unearned Rent"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A30","v":205}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B32","v":"Notes Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A32","v":250}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-06-01",null,null,null,{"$f":"'Cash Receipts Journal'!F5","v":0},null,{"$f":"E236","v":0}]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B33","v":"Bonds Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A33","v":251}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-06-01",null,null,null,{"$f":"'Cash Receipts Journal'!F29","v":0},null,{"$f":"E247","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B34","v":"Mortgage (Warehouse) Payable"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A34","v":252}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-06-01",null,null,null,{"$f":"'Cash Receipts Journal'!F41","v":0},null,200000]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B36","v":"Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A36","v":300}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance",null,null,null,null,{"$f":"60000*1","v":60000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B37","v":"Paid In Capital - Excess of Par"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A37","v":301}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,null,null,{"$f":"(60000*25)-159000","v":1341000}]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B38","v":"Retained Earnings"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A38","v":330}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31","Balance Brought Forward",null,null,null,null,{"$f":"389000+377000-400000","v":366000}]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B39","v":"Treasury Stock"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A39","v":340}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B42","v":"Sales"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A42","v":500}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B43","v":"Sales Discounts"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A43","v":510}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B44","v":"Sales Returns & Allowances"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A44","v":511}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B46","v":"Cost of Goods Sold"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A46","v":600}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B48","v":"Wage Expense (hourly workers)"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A48","v":700}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B49","v":"Salaries Expense (Exempt Staff)"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A49","v":701}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B50","v":"Marketing Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A50","v":702}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B51","v":"Travel and Entertainment Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A51","v":703}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B52","v":"Bad Debt Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A52","v":704}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B53","v":"Property Tax Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A53","v":705}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B54","v":"Office Maintenance & Repair Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A54","v":706}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B55","v":"Legal Expenses"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A55","v":707}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B56","v":"Insurance Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A56","v":708}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B57","v":"Utilities Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A57","v":709}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B58","v":"Office Supplies Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A58","v":710}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B59","v":"Telecommunications Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A59","v":711}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B60","v":"Depreciation Expense -  Equip & Furniture - Warehouse"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A60","v":712}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B61","v":"Depreciation Expense - Equip & Furniture - Office"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A61","v":713}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B63","v":"Rent Income"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A63","v":800}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B65","v":"Interest Expense"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A65","v":900}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B67","v":"Income Summary"},null,null,null,"Account No.",{"$f":"'Chart of Accounts GL'!A67","v":1000}]
[null,null,null,"Transaction",null,"Account Balance"]
["Date","Item","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]

{"sheet":"AR Ledger","index":17,"n_rows":68,"n_cols":6,"rows_kept":68,"cut":false,"hidden":false,"merged":[[65,1,65,3],[0,1,0,2],[13,1,13,3],[26,1,26,3],[39,1,39,3],[52,1,52,3]]}
["Account:  ",{"$f":"'Chart of Accounts AR Ledger'!B5","v":"General Motors"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,5000]
["2011-06-20",null,null,{"$f":"'General Journal'!E20","v":0},{"$f":"E4-D5","v":5000}]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B6","v":"Ford Motor Co."}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-05",null,300000,null,{"$f":"C17","v":300000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B7","v":"Toyota"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-11",null,{"$f":"Data!G9","v":185000},null,{"$f":"C30","v":185000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B8","v":"Honda"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B9","v":"Kia"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B10","v":"Nissan"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]

{"sheet":"AP Ledger","index":18,"n_rows":83,"n_cols":6,"rows_kept":83,"cut":false,"hidden":false,"merged":[[15,1,15,3],[2,1,2,3],[41,1,41,3],[54,1,54,3],[80,1,80,3],[28,1,28,3],[67,1,67,3]]}
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B6","v":"Garmin"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,null,18000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B7","v":"JVC"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,162500,null,{"$f":"D19","v":162500}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B8","v":"Magellan"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,null,30000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B10","v":"Motorola"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,null,58000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:  ",{"$f":"'Chart of Accounts AP Ledger'!B11","v":"Navistar"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2010-05-31",null,null,null,null,50000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B12","v":"Office Max"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B13","v":"Samsung"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]

{"sheet":"Worksheet June 2013","index":19,"n_rows":52,"n_cols":12,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,"Unadjusted",null,null,null,"Adjusted",null,"Income ",null,"Bal. Sheet"]
[null,null,"Trial Balance",null,"Adjustments",null,"Trial Balance",null,"Statement",null,"Stmt. Own. Equity"]
["Acct. No.","Account Title","Dr.","Cr.","Dr.","Cr.","Dr.","Cr.","Dr.","Cr.","Dr.","Cr."]
[{"$f":"'Chart of Accounts GL'!A9","v":100},{"$f":"'Chart of Accounts GL'!B9","v":"Cash"}]
[{"$f":"'Chart of Accounts GL'!A10","v":102},{"$f":"'Chart of Accounts GL'!B10","v":"Accounts Receivable"}]
[{"$f":"'Chart of Accounts GL'!A11","v":103},{"$f":"'Chart of Accounts GL'!B11","v":"Allowance for Doubtful Accounts"}]
[{"$f":"'Chart of Accounts GL'!A12","v":104},{"$f":"'Chart of Accounts GL'!B12","v":"Merchandise Inventory"}]
[{"$f":"'Chart of Accounts GL'!A13","v":105},{"$f":"'Chart of Accounts GL'!B13","v":"Office Supplies"}]
[{"$f":"'Chart of Accounts GL'!A14","v":106},{"$f":"'Chart of Accounts GL'!B14","v":"Prepaid Insurance"}]
[{"$f":"'Chart of Accounts GL'!A16","v":140},{"$f":"'Chart of Accounts GL'!B16","v":"Land"}]
[{"$f":"'Chart of Accounts GL'!A17","v":145},{"$f":"'Chart of Accounts GL'!B17","v":"Building"}]
[{"$f":"'Chart of Accounts GL'!A18","v":146},{"$f":"'Chart of Accounts GL'!B18","v":"Accumulated Depreciation - Building"}]
[{"$f":"'Chart of Accounts GL'!A19","v":151},{"$f":"'Chart of Accounts GL'!B19","v":"Equipment & Furniture - Warehouse"}]
[{"$f":"'Chart of Accounts GL'!A20","v":152},{"$f":"'Chart of Accounts GL'!B20","v":"Accumulated Depreciation - Equip & Furn. - Warehouse"}]
[{"$f":"'Chart of Accounts GL'!A21","v":153},{"$f":"'Chart of Accounts GL'!B21","v":"Equipment & Furniture - Office"}]
[{"$f":"'Chart of Accounts GL'!A22","v":154},{"$f":"'Chart of Accounts GL'!B22","v":"Accumulated Depreciation - Equip & Furn. - Office"}]
[{"$f":"'Chart of Accounts GL'!A26","v":201},{"$f":"'Chart of Accounts GL'!B26","v":"Accounts Payable"}]
[{"$f":"'Chart of Accounts GL'!A27","v":202},{"$f":"'Chart of Accounts GL'!B27","v":"Wages Payable"}]
[{"$f":"'Chart of Accounts GL'!A28","v":203},{"$f":"'Chart of Accounts GL'!B28","v":"Interest Payable"}]
[{"$f":"'Chart of Accounts GL'!A29","v":204},{"$f":"'Chart of Accounts GL'!B29","v":"Dividends Payable"}]
[{"$f":"'Chart of Accounts GL'!A30","v":205},{"$f":"'Chart of Accounts GL'!B30","v":"Unearned Rent"}]
[{"$f":"'Chart of Accounts GL'!A32","v":250},{"$f":"'Chart of Accounts GL'!B32","v":"Notes Payable"}]
[{"$f":"'Chart of Accounts GL'!A33","v":251},{"$f":"'Chart of Accounts GL'!B33","v":"Bonds Payable"}]
[{"$f":"'Chart of Accounts GL'!A34","v":252},{"$f":"'Chart of Accounts GL'!B34","v":"Mortgage (Warehouse) Payable"}]
[{"$f":"'Chart of Accounts GL'!A36","v":300},{"$f":"'Chart of Accounts GL'!B36","v":"Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding"}]
[{"$f":"'Chart of Accounts GL'!A37","v":301},{"$f":"'Chart of Accounts GL'!B37","v":"Paid In Capital - Excess of Par"}]
[{"$f":"'Chart of Accounts GL'!A38","v":330},{"$f":"'Chart of Accounts GL'!B38","v":"Retained Earnings"}]
[{"$f":"'Chart of Accounts GL'!A39","v":340},{"$f":"'Chart of Accounts GL'!B39","v":"Treasury Stock"}]
[{"$f":"'Chart of Accounts GL'!A42","v":500},{"$f":"'Chart of Accounts GL'!B42","v":"Sales"}]
[{"$f":"'Chart of Accounts GL'!A43","v":510},{"$f":"'Chart of Accounts GL'!B43","v":"Sales Discounts"}]
[{"$f":"'Chart of Accounts GL'!A44","v":511},{"$f":"'Chart of Accounts GL'!B44","v":"Sales Returns & Allowances"}]
[{"$f":"'Chart of Accounts GL'!A46","v":600},{"$f":"'Chart of Accounts GL'!B46","v":"Cost of Goods Sold"}]
[{"$f":"'Chart of Accounts GL'!A48","v":700},{"$f":"'Chart of Accounts GL'!B48","v":"Wage Expense (hourly workers)"}]
[{"$f":"'Chart of Accounts GL'!A49","v":701},{"$f":"'Chart of Accounts GL'!B49","v":"Salaries Expense (Exempt Staff)"}]
[{"$f":"'Chart of Accounts GL'!A50","v":702},{"$f":"'Chart of Accounts GL'!B50","v":"Marketing Expense"}]
[{"$f":"'Chart of Accounts GL'!A51","v":703},{"$f":"'Chart of Accounts GL'!B51","v":"Travel and Entertainment Expense"}]
[{"$f":"'Chart of Accounts GL'!A52","v":704},{"$f":"'Chart of Accounts GL'!B52","v":"Bad Debt Expense"}]
[{"$f":"'Chart of Accounts GL'!A53","v":705},{"$f":"'Chart of Accounts GL'!B53","v":"Property Tax Expense"}]
[{"$f":"'Chart of Accounts GL'!A54","v":706},{"$f":"'Chart of Accounts GL'!B54","v":"Office Maintenance & Repair Expense"}]
[{"$f":"'Chart of Accounts GL'!A55","v":707},{"$f":"'Chart of Accounts GL'!B55","v":"Legal Expenses"}]
[{"$f":"'Chart of Accounts GL'!A56","v":708},{"$f":"'Chart of Accounts GL'!B56","v":"Insurance Expense"}]
[{"$f":"'Chart of Accounts GL'!A57","v":709},{"$f":"'Chart of Accounts GL'!B57","v":"Utilities Expense"}]
[{"$f":"'Chart of Accounts GL'!A58","v":710},{"$f":"'Chart of Accounts GL'!B58","v":"Office Supplies Expense"}]
[{"$f":"'Chart of Accounts GL'!A59","v":711},{"$f":"'Chart of Accounts GL'!B59","v":"Telecommunications Expense"}]
[{"$f":"'Chart of Accounts GL'!A60","v":712},{"$f":"'Chart of Accounts GL'!B60","v":"Depreciation Expense -  Equip & Furniture - Warehouse"}]
[{"$f":"'Chart of Accounts GL'!A61","v":713},{"$f":"'Chart of Accounts GL'!B61","v":"Depreciation Expense - Equip & Furniture - Office"}]
[{"$f":"'Chart of Accounts GL'!A63","v":800},{"$f":"'Chart of Accounts GL'!B63","v":"Rent Income"}]
[{"$f":"'Chart of Accounts GL'!A65","v":900},{"$f":"'Chart of Accounts GL'!B65","v":"Interest Expense"}]
[null,"Total"]
[null,"Net Income (Loss)"]
[null,"Total"]
[null,"Total"]

{"sheet":"IS June 2013","index":20,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Income Statement"]

{"sheet":"Stmt RE June 2013","index":21,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Statement of Retained Earnings"]

{"sheet":"BS June 2013","index":22,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Balance Sheet"]

{"sheet":"Post Closing Trial Balance","index":23,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'IS June 2013'!A1","v":"AC Speed Corporation"}]
["Post-closing Trial Balance"]
[]
[null,"DEBIT","CREDIT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"C30-B30","v":0}]

{"sheet":"Adjusted Trial Balances","index":24,"n_rows":55,"n_cols":13,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"B/S Adjuster",1.1200000000000001,1.1200000000000001,1.06,1.06,1.1000000000000001,1.1000000000000001,1.0900000000000001,1.0900000000000001]
[null,"I/S Adjuster",12,12,1.02,1.02,1.02,{"$f":"G2","v":1.02},1.01,1.01]
[null,null,{"$f":"Data!K37","v":"2012-12-31"},null,{"$f":"Data!L37","v":"2011-12-31"},null,{"$f":"Data!M37","v":"2010-12-31"},null,{"$f":"Data!N37","v":"2009-12-31"},null,"2012-05-31"]
[null,null,"Adjusted",null,"Adjusted",null,"Adjusted",null,"Adjusted",null,"Adjusted"]
[null,null,"Trial Balance",null,"Trial Balance",null,"Trial Balance",null,"Trial Balance",null,"Trial Balance"]
["Acct. No.","Account Title","Dr.","Cr.","Dr.","Cr.","Dr.","Cr.","Dr.","Cr.","Dr.","Cr."]
[{"$f":"'[1]Chart of Accounts GL'!A9","v":100},{"$f":"'Chart of Accounts GL'!B9","v":"Cash"},{"$f":"($C$1*K7)+210000+5000","v":299000},{"$f":"$D$1*L7","v":0},{"$f":"($E$1*C7)","v":316940},{"$f":"$F$1*D7","v":0},{"$f":"G$1*E7","v":348634},{"$f":"H$1*F7","v":0},{"$f":"I$1*G7","v":380011.06000000006},{"$f":"J$1*H7","v":0},{"$f":"'General Ledger'!F4","v":75000}]
[{"$f":"'[1]Chart of Accounts GL'!A10","v":102},{"$f":"'Chart of Accounts GL'!B10","v":"Accounts Receivable"},{"$f":"($C$1*K8)+250000+150000","v":948800},{"$f":"$D$1*L8","v":0},{"$f":"$E$1*(C8-150000)","v":846728},{"$f":"$F$1*D8","v":0},{"$f":"(G$1*E8)","v":931400.8},{"$f":"H$1*F8","v":0},{"$f":"((I$1*G8))","v":1015226.8720000001},{"$f":"J$1*H8","v":0},{"$f":"'General Ledger'!F17","v":490000},null,{"$f":"J56","v":0}]
[{"$f":"'[1]Chart of Accounts GL'!A11","v":103},{"$f":"'Chart of Accounts GL'!B11","v":"Allowance for Doubtful Accounts"},{"$f":"$C$1*K9","v":0},16800,{"$f":"$E$1*C9","v":0},17808,{"$f":"G$1*E9","v":0},{"$f":"H$1*F9","v":19588.800000000003},{"$f":"I$1*G9","v":0},21351.792000000005,null,{"$f":"'General Ledger'!G30","v":15000}]
[{"$f":"'[1]Chart of Accounts GL'!A12","v":104},{"$f":"'Chart of Accounts GL'!B12","v":"Merchandise Inventory"},{"$f":"($C$1*K10)+227776","v":601856},0,{"$f":"($E$1*C10)","v":637967.35999999999},0,{"$f":"(G$1*E10)","v":701764.09600000002},0,{"$f":"(I$1*G10)","v":764922.86464000004},0,{"$f":"'General Ledger'!F42","v":334000}]
[{"$f":"'[1]Chart of Accounts GL'!A13","v":105},{"$f":"'Chart of Accounts GL'!B13","v":"Office Supplies"},{"$f":"($C$1*K11)","v":2240},0,2374.4,0,{"$f":"G$1*E11","v":2611.84},0,{"$f":"I$1*G11","v":2846.9056000000005},0,{"$f":"'General Ledger'!F56","v":2000}]
[{"$f":"'[1]Chart of Accounts GL'!A14","v":106},{"$f":"'Chart of Accounts GL'!B14","v":"Prepaid Insurance"},15680.000000000002,0,16620.800000000003,0,{"$f":"$G$1*E12","v":18282.880000000005},0,{"$f":"$G$1*G12","v":20111.168000000005},0,{"$f":"'General Ledger'!F69","v":14000}]
[{"$f":"'[1]Chart of Accounts GL'!A16","v":140},{"$f":"'Chart of Accounts GL'!B16","v":"Land"},{"$f":"K13","v":2000600},0,{"$f":"K13","v":2000600},0,{"$f":"$K13","v":2000600},0,{"$f":"$K13","v":2000600},0,{"$f":"'General Ledger'!F82","v":2000600}]
[{"$f":"'[1]Chart of Accounts GL'!A17","v":145},{"$f":"'Chart of Accounts GL'!B17","v":"Building"},{"$f":"E14","v":1500000},null,{"$f":"G14","v":1500000},null,{"$f":"$K14","v":1500000},null,{"$f":"$K14","v":1500000},null,{"$f":"'General Ledger'!F95","v":1500000}]
[{"$f":"'[1]Chart of Accounts GL'!A18","v":146},{"$f":"'Chart of Accounts GL'!B18","v":"Accumulated Depreciation - Building"},null,{"$f":"F15","v":1500000},null,{"$f":"H15","v":1500000},null,{"$f":"L15","v":1500000},null,1500000,null,{"$f":"'General Ledger'!G108","v":1500000}]
[{"$f":"'[1]Chart of Accounts GL'!A19","v":151},{"$f":"'Chart of Accounts GL'!B19","v":"Equipment & Furniture - Warehouse"},11200.000000000002,0,11872.000000000002,0,{"$f":"G$1*E16","v":13059.200000000003},0,14234.528000000004,{"$f":"J$1*H16","v":0},{"$f":"'General Ledger'!F121","v":10000}]
[{"$f":"'[1]Chart of Accounts GL'!A20","v":152},{"$f":"'Chart of Accounts GL'!B20","v":"Accumulated Depreciation - Equip & Furn. - Warehouse"},0,2128,0,2255.6800000000003,0,2481.2480000000005,0,{"$f":"J$1*H17","v":2704.560320000001},null,{"$f":"'General Ledger'!G134","v":1900}]
[{"$f":"'[1]Chart of Accounts GL'!A21","v":153},{"$f":"'Chart of Accounts GL'!B21","v":"Equipment & Furniture - Office"},9520,0,10091.200000000001,0,11100.320000000002,0,12099.348800000003,{"$f":"J$1*H18","v":0},{"$f":"'General Ledger'!F147","v":8500}]
[{"$f":"'[1]Chart of Accounts GL'!A22","v":154},{"$f":"'Chart of Accounts GL'!B22","v":"Accumulated Depreciation - Equip & Furn. - Office"},0,1792.0000000000002,0,1899.5200000000004,0,2089.4720000000007,0,{"$f":"J$1*H19","v":2277.5244800000009},null,{"$f":"'General Ledger'!G160","v":1600}]
[{"$f":"'[1]Chart of Accounts GL'!A26","v":201},{"$f":"'Chart of Accounts GL'!B26","v":"Accounts Payable"},0,{"$f":"$D$1*L20-250000","v":812432},0,{"$f":"$F$1*D20","v":861177.92},0,{"$f":"F20*H1","v":947295.71200000017},0,{"$f":"H20*J1-54214","v":978338.32608000026},null,{"$f":"'General Ledger'!G173","v":948600}]
[{"$f":"'[1]Chart of Accounts GL'!A27","v":202},{"$f":"'Chart of Accounts GL'!B27","v":"Wages Payable"},0,0,0,0,0,0,0,0,null,{"$f":"'General Ledger'!G185","v":0}]
[{"$f":"'[1]Chart of Accounts GL'!A28","v":203},{"$f":"'Chart of Accounts GL'!B28","v":"Interest Payable"},0,0,0,0,0,0,0,0,null,{"$f":"'General Ledger'!G198","v":0}]
[{"$f":"'[1]Chart of Accounts GL'!A29","v":204},{"$f":"'Chart of Accounts GL'!B29","v":"Dividends Payable"},0,0,0,0,0,0,0,0,null,0]
[{"$f":"'[1]Chart of Accounts GL'!A30","v":205},{"$f":"'Chart of Accounts GL'!B30","v":"Unearned Rent"},0,0,0,0,0,0,0,0,null,0]
[{"$f":"'[1]Chart of Accounts GL'!A32","v":250},{"$f":"'Chart of Accounts GL'!B32","v":"Notes Payable"},0,0,0,0,0,0,0,0,null,0]
[{"$f":"'[1]Chart of Accounts GL'!A33","v":251},{"$f":"'Chart of Accounts GL'!B33","v":"Bonds Payable"},0,0,0,0,0,0,0,0,null,0]
[{"$f":"'[1]Chart of Accounts GL'!A34","v":252},{"$f":"'Chart of Accounts GL'!B34","v":"Mortgage (Warehouse) Payable"},0,{"$f":"$D$1*L27-100000","v":124000.00000000003},0,131440.00000000003,0,{"$f":"H$1*F27","v":144584.00000000006},0,{"$f":"J$1*H27","v":157596.56000000008},null,{"$f":"'General Ledger'!G259","v":200000}]
[{"$f":"'[1]Chart of Accounts GL'!A36","v":300},{"$f":"'Chart of Accounts GL'!B36","v":"Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding"},0,{"$f":"Data!K38","v":65000},{"$f":"C28","v":0},65000,0,65000,{"$f":"G28","v":0},{"$f":"H28","v":65000},null,{"$f":"'General Ledger'!G271","v":60000}]
[{"$f":"'[1]Chart of Accounts GL'!A37","v":301},{"$f":"'Chart of Accounts GL'!B37","v":"Paid In Capital - Excess of Par"},0,{"$f":"Data!K39","v":1545000},0,1545000,0,1545000,{"$f":"G29","v":0},{"$f":"H29","v":1545000},null,{"$f":"'General Ledger'!G284","v":1341000}]
[{"$f":"'[1]Chart of Accounts GL'!A38","v":330},{"$f":"'Chart of Accounts GL'!B38","v":"Retained Earnings"},0,{"$f":"Data!K40+5000","v":1171744},null,{"$f":"Data!L40+5300-0.36","v":1071043.6399999999},null,{"$f":"Data!M40+5830-0.48","v":961859.52},null,{"$f":"Data!N40+6355+0.06","v":1244834.06},null,{"$f":"'General Ledger'!G296","v":366000}]
[{"$f":"'[1]Chart of Accounts GL'!A39","v":340},{"$f":"'Chart of Accounts GL'!B39","v":"Treasury Stock"},0,0,{"$f":"C31","v":0},0,0,0,0,0,0,0]
[{"$f":"'[1]Chart of Accounts GL'!A42","v":500},{"$f":"'Chart of Accounts GL'!B42","v":"Sales"},{"$f":"K32*$C$2","v":0},{"$f":"(L32*$D$2)+150000","v":8850000},{"$f":"C32*$E$2","v":0},{"$f":"(D32-150000)*$F$2","v":8874000},{"$f":"E32*G$2","v":0},{"$f":"(F32*H$2)","v":9051480},{"$f":"G32*I$2","v":0},{"$f":"(H32*J$2)","v":9141994.8000000007},null,{"$f":"Data!D38","v":725000}]
[{"$f":"'[1]Chart of Accounts GL'!A43","v":510},{"$f":"'Chart of Accounts GL'!B43","v":"Sales Discounts"},{"$f":"K33*$C$2","v":0},{"$f":"L33*$D$2","v":0},{"$f":"C33*$E$2","v":0},{"$f":"D33*$F$2","v":0},0,0,0,0,0,0]
[{"$f":"'[1]Chart of Accounts GL'!A44","v":511},{"$f":"'Chart of Accounts GL'!B44","v":"Sales Returns & Allowances"},0,0,0,0,0,0,0,0,0,0]
[{"$f":"'[1]Chart of Accounts GL'!A46","v":600},{"$f":"'Chart of Accounts GL'!B46","v":"Cost of Goods Sold"},{"$f":"K35*$C$2","v":7656000},0,{"$f":"C35*$E$2-147569","v":7661551},0,{"$f":"E35*G$2-189034","v":7625748.0200000005},0,{"$f":"(G35*I$2)+150000","v":7852005.5002000006},0,{"$f":"L32*Data!D39","v":638000}]
[{"$f":"'[1]Chart of Accounts GL'!A48","v":700},{"$f":"'Chart of Accounts GL'!B48","v":"Wage Expense (hourly workers)"},120000,0,122400,0,{"$f":"E36*G$2","v":124848},0,126096.48,0,{"$f":"Data!D40","v":10000}]
[{"$f":"'[1]Chart of Accounts GL'!A49","v":701},{"$f":"'Chart of Accounts GL'!B49","v":"Salaries Expense (Exempt Staff)"},360000,0,367200,0,374544,0,378289.44,0,{"$f":"Data!D41","v":30000}]
[{"$f":"'[1]Chart of Accounts GL'!A50","v":702},{"$f":"'Chart of Accounts GL'!B50","v":"Marketing Expense"},288000,0,293760,0,299635.20000000001,0,{"$f":"G38*I$2","v":302631.55200000003},0,{"$f":"Data!D42","v":24000}]
[{"$f":"'[1]Chart of Accounts GL'!A51","v":703},{"$f":"'Chart of Accounts GL'!B51","v":"Travel and Entertainment Expense"},27600,0,28152,0,28715.040000000001,0,29002.190399999999,0,{"$f":"Data!D43","v":2300}]
[{"$f":"'[1]Chart of Accounts GL'!A52","v":704},{"$f":"'Chart of Accounts GL'!B52","v":"Bad Debt Expense"},0,0,0,0,0,0,0,0,0,0]
[{"$f":"'[1]Chart of Accounts GL'!A53","v":705},{"$f":"'Chart of Accounts GL'!B53","v":"Property Tax Expense"},0,0,0,0,0,0,0,0,0,0]
[{"$f":"'[1]Chart of Accounts GL'!A54","v":706},{"$f":"'Chart of Accounts GL'!B54","v":"Office Maintenance & Repair Expense"},6000,0,6120,0,6242.4000000000005,0,6304.8240000000005,0,{"$f":"Data!D44","v":500}]
[{"$f":"'[1]Chart of Accounts GL'!A55","v":707},{"$f":"'Chart of Accounts GL'!B55","v":"Legal Expenses"},{"$f":"(C2*K43)","v":198600},0,202572,0,{"$f":"E43*G$2","v":206623.44},0,{"$f":"G43*I$2","v":208689.67440000002},0,{"$f":"Data!D45","v":16550}]
[{"$f":"'[1]Chart of Accounts GL'!A56","v":708},{"$f":"'Chart of Accounts GL'!B56","v":"Insurance Expense"},24000,0,24480,0,{"$f":"E44*G$2","v":24969.600000000002},0,{"$f":"G44*I$2","v":25219.296000000002},0,{"$f":"Data!D46","v":2000}]
[{"$f":"'[1]Chart of Accounts GL'!A57","v":709},{"$f":"'Chart of Accounts GL'!B57","v":"Utilities Expense"},12000,0,12240,0,12484.800000000001,0,12609.648000000001,0,{"$f":"Data!D47","v":1000}]
[{"$f":"'[1]Chart of Accounts GL'!A58","v":710},{"$f":"'Chart of Accounts GL'!B58","v":"Office Supplies Expense"},3480,0,3549.6,0,3620.5920000000001,0,3656.79792,0,{"$f":"Data!D48","v":290}]
[{"$f":"'[1]Chart of Accounts GL'!A59","v":711},{"$f":"'Chart of Accounts GL'!B59","v":"Telecommunications Expense"},660,0,673.2,0,686.6640000000001,0,693.53064000000006,0,{"$f":"Data!D49","v":55}]
[{"$f":"'[1]Chart of Accounts GL'!A60","v":712},{"$f":"'Chart of Accounts GL'!B60","v":"Depreciation Expense -  Equip & Furniture - Warehouse"},1980,0,2019.6000000000001,0,2059.9920000000002,0,2080.5919200000003,0,{"$f":"Data!D50","v":165}]
[{"$f":"'[1]Chart of Accounts GL'!A61","v":713},{"$f":"'Chart of Accounts GL'!B61","v":"Depreciation Expense - Equip & Furniture - Office"},1680,0,1713.6000000000001,0,1747.8720000000001,0,1765.3507200000001,0,{"$f":"Data!D51","v":140}]
[{"$f":"'[1]Chart of Accounts GL'!A63","v":800},{"$f":"'Chart of Accounts GL'!B63","v":"Rent Income"},0,0,0,0,0,0,0,0,0,0]
[{"$f":"'[1]Chart of Accounts GL'!A65","v":900},{"$f":"'Chart of Accounts GL'!B65","v":"Interest Expense"},0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total",{"$f":"SUM(C7:C51)","v":14088896},{"$f":"SUM(D7:D51)","v":14088896},14069624.759999998,14069624.76,14239378.756000001,14239378.752,{"$f":"SUM(I7:I51)","v":14659097.62324},{"$f":"SUM(J7:J51)","v":14659097.622880001},5159100,5159100]
[]
["Variance",null,{"$f":"C53-D53","v":0},null,{"$f":"E53-F53","v":0},null,{"$f":"G53-H53","v":4.0000006556510925E-3},null,{"$f":"I53-J53","v":3.5999901592731476E-4},null,{"$f":"K53-L53","v":0}]

{"sheet":"IS Comparative","index":25,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'[1]Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Income Statement"]
[null,{"$f":"'Adjusted Trial Balances'!C3","v":"2012-12-31"},null,{"$f":"'Adjusted Trial Balances'!E3","v":"2011-12-31"},null,{"$f":"'Adjusted Trial Balances'!G3","v":"2010-12-31"},null,{"$f":"'Adjusted Trial Balances'!I3","v":"2009-12-31"},null,{"$f":"'Adjusted Trial Balances'!K3","v":"2012-05-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Common Dividends",19200,null,16130,null,15000,null,1600]
["Weighted Average Common Shares",65000,null,65000,null,65000,null,62500]
["Market Price per Common Share",35,null,34,null,31,null,34]

{"sheet":"BS Comparative","index":26,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'[1]Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["Balance Sheet"]
[null,{"$f":"'IS Comparative'!B3","v":"2012-12-31"},null,{"$f":"'IS Comparative'!D3","v":"2011-12-31"},null,{"$f":"'IS Comparative'!F3","v":"2010-12-31"},null,{"$f":"'IS Comparative'!H3","v":"2009-12-31"},null,{"$f":"'IS Comparative'!J3","v":"2012-05-31"}]

{"sheet":"Ratios Historical","index":27,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'BS Comparative'!B3","v":"2012-12-31"},null,{"$f":"'BS Comparative'!D3","v":"2011-12-31"},null,{"$f":"'BS Comparative'!F3","v":"2010-12-31"},null,"INDUSTRY"]
["Liquidity"]
["Current Ratio (One decimal place)",null,null,null,null,null,null,2.2000000000000002]
[]
[]
[]
["Acid Test Ratio (One decimal place)",null,null,null,null,null,null,1.6]
[]
[]
[]
[]
[]
["Receivables Turnover (One decimal place)",null,null,null,null,null,null,10]
[]
[]
[]
[]
[]
["Inventory Turnover (One decimal place)",null,null,null,null,null,null,9.5]
[]
[]
[]
[]
["Profitability"]
[]
["Profit Margin (% with two decimal places)",null,null,null,null,null,null,3.5000000000000003E-2]
[]
[]
[]
["Asset Turnover (two decimal places)",null,null,null,null,null,null,1.9]
[]
[]
[]
[]
[]
["Return on Assets (% one decimal place)",null,null,null,null,null,null,0.105]
[]
[]
[]
["Return on Common Shareholders' Equity"]
[" (One decimal place)",null,null,null,null,null,null,0.183]
[]
[]
[]
[]
[]
[]
["Earnings per Share (EPS) (Two decimal places)",null,null,null,null,null,null,3.05]
[]
[]
[]
[]
["Price-Earnings (P/E ) Ratio (Two decimal places)",null,null,null,null,null,null,14.8]
[]
[]
[]
["Payout Ratio (% One decimal place)",null,null,null,null,null,null,0.15]
[]
[]
[]
[]
["Solvency Ratios"]
[]
["Debt to Total Assets Ratio (% One decimal place)",null,null,null,null,null,null,0.42199999999999999]
[]
[]
[]
[null,"Dec. 31, 2012",null,"Dec. 31, 2011",null,"Dec. 31, 2010"]
["Common Dividends",19200,null,16130,null,15000]
["Weighted Average Common Shares",65000,null,65000,null,63750]
["Market Price per Share",35,null,34,null,31]
[]
[]
[]
["INSTRUCTIONS:"]
["Calculate all of the ratios listed above."]
["Evaluate the company's performance trend relative to liquidity, profitability and solvency."]
["Evaluate the company's performance relative to liquidity, profitability and solvency for their industry for the three years."]
["Relate to the company management in which areas they are performing well and in which areas they need improvement."]

{"sheet":"Inventory Control","index":28,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Shoe:",{"$f":"Products!A2","v":"GPS"}]
[null,"Beginning Inventory (BI)",null,null,"Purchases ",null,null,"Sales",null,null,"Ending Inventory (EI)"]
["Date","BI Units","BI $/Unit","BI $","Purch Units","Purch $/Unit","Purch $","Sale Units (CGS)","Sale $/Unit (CGS)","Sale $ (CGS)","EI Units","EI $/Unit","EI $"]
["2010-06-01",3300,35,{"$f":"B4*C4","v":115500},null,null,{"$f":"E4*F4","v":0},null,null,{"$f":"H4*I4","v":0},null,null,{"$f":"D4+G4-J4","v":115500}]
[{"$f":"Data!A3","v":"2013-06-01"}]
[{"$f":"Data!A7","v":"2013-06-02"}]
[]
[]
[{"$f":"Data!A15","v":"2013-06-13"}]
["2010-06-17"]
["2011-06-17"]
["2011-06-20"]
["2011-06-27"]
[]
[]
["Shoe:",{"$f":"Products!A3","v":"DVD Player"}]
[null,"Beginning Inventory (BI)",null,null,"Purchases",null,null,"Sales",null,null,"Ending Inventory (EI)"]
["Date","BI Units","BI $/Unit","BI $","Purch Units","Purch $/Unit","Purch $","Sale Units (CGS)","Sale $/Unit (CGS)","Sale $ (CGS)","EI Units","EI $/Unit","EI $"]
["2010-06-01",2500,65,{"$f":"B19*C19","v":162500},null,null,{"$f":"E19*F19","v":0},null,null,{"$f":"H19*I19","v":0},null,null,{"$f":"D19","v":162500}]
[{"$f":"Data!A4","v":"2013-06-01"}]
[{"$f":"Data!A14","v":"2013-06-13"}]
[{"$f":"Data!A18","v":"2013-06-15"}]
[]
[]
[]
[]
[]
[]
["Shoe:",{"$f":"Products!A4","v":"Docking Station"}]
[null,"Beginning Inventory (BI)",null,null,"Purchases",null,null,"Sales",null,null,"Ending Inventory (EI)"]
["Date","BI Units","BI $/Unit","BI $","Purch Units","Purch $/Unit","Purch $","Sale Units (CGS)","Sale $/Unit (CGS)","Sale $ (CGS)","EI Units","EI $/Unit","EI $"]
["2010-06-01",1400,40,{"$f":"B32*C32","v":56000},null,null,null,null,null,{"$f":"H32*I32","v":0},null,null,{"$f":"D32+G32-J32","v":56000}]
[{"$f":"Data!A7","v":"2013-06-02"}]
[{"$f":"Data!A19","v":"2013-06-16"}]
[{"$f":"Data!A21","v":"2013-06-22"}]
[{"$f":"Data!A26","v":"2013-06-26"}]
[{"$f":"Data!A27","v":"2013-06-27"}]
[{"$f":"Data!A27","v":"2013-06-27"}]

{"sheet":"Data","index":29,"n_rows":51,"n_cols":27,"rows_kept":51,"cut":false,"hidden":true,"merged":[[48,0,48,2],[50,0,50,2],[49,0,49,2],[36,0,36,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[43,0,43,2],[36,6,36,9],[44,0,44,2],[45,0,45,2],[46,0,46,2],[47,0,47,2]]}
["Date","Type of Tran.","Journal","Other/ACT","Units","$ per Unit","Total $","Discount","Discount %","Balance Owing","Amt of Discount","Amt of Balance","L/T Payable","Interest","Duration (years)","Interest Paid","Balance Paid","Concatenate1","Concatenate2","Concatenate3","Concatenate4","Concatenate5","Concatenate6","Concatenate7","Concatenate8","Concatenate9","Concatenate10"]
["2013-06-01","Financing ","Cash Receipts Journal","Note Payable",null,null,null,null,null,null,null,null,210000,7.0999999999999994E-2,3,null,null,"Signed a",{"$f":"Table1[[#This Row],[Duration (years)]]","v":3},"year",{"$f":"Table1[[#This Row],[Interest]]*100","v":7.1},{"$f":"Table1[[#This Row],[L/T Payable]]","v":210000},"note payable with First Bank.",null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\"% , $\",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]])","v":"Signed a 3 year 7.1% , $210000 note payable with First Bank."}]
["2013-06-01","Purchase","Purchases Journal",null,3100,35.5,{"$f":"E3*F3","v":110050},"Yes",0.02,{"$f":"G3","v":110050},null,null,null,null,null,null,null,"Purchased",{"$f":"Table1[[#This Row],[Units]]","v":3100},"GPS units on credit from Navistar for $",{"$f":"Table1[[#This Row],[$ per Unit]]","v":35.5},"per unit.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\"\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]])","v":"Purchased 3100 GPS units on credit from Navistar for $35.5 per unit. "}]
["2013-06-01","Sale","Sales Journal",null,1983,75,{"$f":"E4*F4","v":148725},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":148725},null,null,null,null,null,null,null,"Sold",{"$f":"Table1[[#This Row],[Units]]","v":1983},"DVD players on account to Toyota for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":75},"per unit, Invoice #5555",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]])","v":"Sold 1983 DVD players on account to Toyota for $75 per unit, Invoice #5555 "}]
["2013-06-02","Purchase","Purchases Journal ",null,null,null,1150,"Yes",0.02,{"$f":"'General Ledger'!F56","v":2000},null,null,null,null,null,null,null,"Purchased office supplies from Office Max on credit for $",{"$f":"Table1[[#This Row],[Total $]]","v":1150},null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\"\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]])","v":"Purchased office supplies from Office Max on credit for $1150    "}]
["2013-06-02","Sale","Sales Journal",null,3400,58,{"$f":"E6*F6","v":197200},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":197200},null,null,null,null,null,null,null,"Sold",{"$f":"Table1[[#This Row],[Units]]","v":3400},"GPS units on account to Kia for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":58},"per unit, Invoice #5556.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]])","v":"Sold 3400 GPS units on account to Kia for $58 per unit, Invoice #5556. "}]
["2013-06-02","Sale","Sales Journal",null,975,66,{"$f":"E7*F7","v":64350},"Yes",0.02,null,null,null,null,null,null,null,null,"Sold",{"$f":"Table1[[#This Row],[Units]]","v":975},"docking stations for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":66},"per unit and",{"$f":"E8","v":1925}," GPS units for",{"$f":"F8","v":82},"per unit on account to Nissan, Invoice #5557.",{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" $\",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Sold 975 docking stations for $66 per unit and 1925  GPS units for $82 per unit on account to Nissan, Invoice #5557."}]
["2013-06-02","Sale","Sales Journal",null,1925,82,{"$f":"E8*F8","v":157850},"Yes",0.02]
["2013-06-04","Cash Receipt","Cash Receipts Journal",null,null,null,185000,"No",0.02,0,0,0,null,null,null,null,null,"Received payment from Toyota for May 11th sale.",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Received payment from Toyota for May 11th sale.        "}]
["2013-06-07","Cash Payments","Cash Payments Journal","Travel & Ent. Exp.",null,null,900,"No",null,0,0,0,null,null,null,null,null,"Received and paid expense reports for travel and entertainment totaling ",{"$f":"Table1[[#This Row],[Total $]]","v":900},", Check #5279.",null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Received and paid expense reports for travel and entertainment totaling  $900 , Check #5279.      "}]
["2013-06-08","Cash Payments","Cash Payments Journal",null,null,null,1200,"Yes",0.02,{"$f":"G11","v":1200},{"$f":"J11*I11","v":24},{"$f":"J11-K11","v":1176},null,null,null,null,null,"Paid for office supplies purchased on June 2nd, Check #5280.",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Paid for office supplies purchased on June 2nd, Check #5280.        "}]
["2013-06-11","Cash Payment","Cash Payments Journal",null,null,null,{"$f":"L12","v":107849},"Yes",0.02,{"$f":"G3","v":110050},{"$f":"J12*I3","v":2201},{"$f":"J12-K12","v":107849},null,null,null,null,null,"Paid in full for the June 1 purchase from Navistar, Check #5281.",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Paid in full for the June 1 purchase from Navistar, Check #5281.        "}]
["2013-06-11","Cash Payment","Cash Payments Journal","Legal Expenses",null,null,5400,"no",null,0,0,0,null,null,null,null,null,"Received a bill from the law firm of Larry, Moe & Curly for ",{"$f":"Table1[[#This Row],[Total $]]","v":5400},", payable upon receipt, for bond consulting fees, Check #5282.",null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Received a bill from the law firm of Larry, Moe & Curly for  $5400 , payable upon receipt, for bond consulting fees, Check #5282.      "}]
["2013-06-13","Purchase","Purchases Journal",null,3250,48,{"$f":"E14*F14","v":156000},"Yes",0.02,{"$f":"G14","v":156000},null,null,null,null,null,null,null,"Took advantage of a special deal to purchase ",{"$f":"Table1[[#This Row],[Units]]","v":3250},"DVD players on account from JVC for ",{"$f":"Table1[[#This Row],[$ per Unit]]","v":48},"per unit.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Took advantage of a special deal to purchase  3250 DVD players on account from JVC for  $48 per unit.    "}]
["2013-06-13","Purchase","Purchases Journal",null,850,33,{"$f":"E15*F15","v":28050},"Yes",0.02,{"$f":"G15","v":28050},null,null,null,null,null,null,null,"Purchased",{"$f":"Table1[[#This Row],[Units]]","v":850},"GPS units on credit from Magellan for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":33},"per unit.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Purchased 850 GPS units on credit from Magellan for $33 per unit.    "}]
["2013-06-15","Salaries","Cash Payments Journal",null,null,null,14500,"no",null,0,0,0,null,null,null,null,null,"Check # 5284 was issued for payroll: ",{"$f":"Table1[[#This Row],[Total $]]","v":14500},"for salaried and",{"$f":"G17","v":4750},"for wages (wage expense)",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Check # 5284 was issued for payroll:  $14500 for salaried and $4750 for wages (wage expense)    "}]
["2013-06-15","Wages","Cash Payments Journal",null,null,null,4750,"no",null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"        "}]
["2013-06-15","Sales","Sales Journal",null,2000,89,{"$f":"E18*F18","v":178000},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":178000},null,null,null,null,null,null,null,"Sold",{"$f":"Table1[[#This Row],[Units]]","v":2000},"DVD players on credit to Ford Motor Co. for ",{"$f":"Table1[[#This Row],[$ per Unit]]","v":89},"per unit, Invoice 5558. ",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Sold 2000 DVD players on credit to Ford Motor Co. for  $89 per unit, Invoice 5558.     "}]
["2013-06-16","Purchase","Purchases Journal",null,1800,42,{"$f":"Table1[[#This Row],[Units]]*Table1[[#This Row],[$ per Unit]]","v":75600},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":75600},null,null,null,null,null,null,null,"Purchased ",{"$f":"Table1[[#This Row],[Units]]","v":1800},"docking stations on credit from Samsung for ",{"$f":"Table1[[#This Row],[$ per Unit]]","v":42},"per unit.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Purchased  1800 docking stations on credit from Samsung for  $42 per unit.    "}]
["2013-06-18","Cash Receipts","Cash Receipts Journal",null,null,null,{"$f":"Table1[[#This Row],[Amt of Balance]]","v":145750.5},"Yes",0.02,{"$f":"G4","v":148725},{"$f":"G4*I4","v":2974.5},{"$f":"Table1[[#This Row],[Balance Owing]]-Table1[[#This Row],[Amt of Discount]]","v":145750.5},null,null,null,null,null,"Received  payment in full from Toyota for the June 1st sale.",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Received  payment in full from Toyota for the June 1st sale.        "}]
["2013-06-22","Sale","Sales Journal",null,1650,64.5,{"$f":"Table1[[#This Row],[Units]]*Table1[[#This Row],[$ per Unit]]","v":106425},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":106425},null,null,null,null,null,null,null,"Sold ",{"$f":"Table1[[#This Row],[Units]]","v":1650},"docking stations on credit to Kia for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":64.5},"per unit, Invoice #5559.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Sold  1650 docking stations on credit to Kia for 64.5 per unit, Invoice #5559.    "}]
["2013-06-23","Cash Payment","Cash Payments Journal",null,null,null,75000,"no",null,162500,0,{"$f":"Table1[[#This Row],[Balance Owing]]-Table1[[#This Row],[Total $]]","v":87500},null,null,null,null,null,"Paid",{"$f":"Table1[[#This Row],[Total $]]","v":75000},"of the",{"$f":"Table1[[#This Row],[Balance Owing]]","v":162500},"owed to JVC from May 25, Check #5285.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Paid $75000 of the $162500 owed to JVC from May 25, Check #5285.    "}]
["2013-06-23","Cash Receipt","Cash Receipts Journal",null,null,null,175000,"no",null,300000,0,{"$f":"Table1[[#This Row],[Balance Owing]]-Table1[[#This Row],[Total $]]","v":125000},null,null,null,null,null,"Received payment from Ford Motor Co. for",{"$f":"Table1[[#This Row],[Total $]]","v":175000},"of the",{"$f":"Table1[[#This Row],[Balance Owing]]","v":300000},"owed from May 5.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Received payment from Ford Motor Co. for $175000 of the $300000 owed from May 5.    "}]
["2013-06-24","Cash Payment","Cash Payments Journal","Telecom. Expense",null,null,100,"no",null,0,0,null,null,null,null,null,null,"Purchased a",{"$f":"Table1[[#This Row],[Total $]]","v":100},"international phone card for one of the sales representative's upcoming European business trip, Check #5286.",null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Purchased a $100 international phone card for one of the sales representative's upcoming European business trip, Check #5286.      "}]
["2013-06-25","Cash Payment","Cash Payments Journal",null,null,null,{"$f":"Table1[[#This Row],[Amt of Balance]]","v":152880},"Yes",null,{"$f":"J14","v":156000},{"$f":"Table1[[#This Row],[Balance Owing]]*0.02","v":3120},{"$f":"Table1[[#This Row],[Balance Owing]]-Table1[[#This Row],[Amt of Discount]]","v":152880},null,null,null,null,null,"Paid in full for the purchase from JVC on June 13, Check #5287",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Paid in full for the purchase from JVC on June 13, Check #5287        "}]
["2013-06-26","Cash Payment","Cash Payments Journal","Merchandise Inventory",1250,41,{"$f":"Table1[[#This Row],[Units]]*Table1[[#This Row],[$ per Unit]]","v":51250},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":51250},null,null,null,null,null,null,null,"Purchased",{"$f":"Table1[[#This Row],[Units]]","v":1250},"docking station from Samsung for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":41},"per unit paying in cash, Check #5288",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Purchased 1250 docking station from Samsung for $41 per unit paying in cash, Check #5288    "}]
["2013-06-27","Sale","Sales Journal",null,1500,61,{"$f":"Table1[[#This Row],[Units]]*Table1[[#This Row],[$ per Unit]]","v":91500},"Yes",0.02,{"$f":"Table1[[#This Row],[Total $]]","v":91500},null,null,null,null,null,null,null,"Sold",{"$f":"Table1[[#This Row],[Units]]","v":1500},"docking stations on credit to Honda for",{"$f":"Table1[[#This Row],[$ per Unit]]","v":61},"per unit, Invoice 5560.",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Sold 1500 docking stations on credit to Honda for $61 per unit, Invoice 5560.    "}]
["2013-06-27","Cash Payment","Cash Payments Journal","Marketing Expense",null,null,75000,null,null,0,null,null,null,null,null,null,null,"Hired and paid a consultant",{"$f":"Table1[[#This Row],[Total $]]","v":75000},"to devise a marketing plan. AC Speed's management felt this was necessary to develop brand awareness. Check #5289.",null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Hired and paid a consultant $75000 to devise a marketing plan. AC Speed's management felt this was necessary to develop brand awareness. Check #5289.      "}]
["2013-06-28","Cash Payment","Cash Payments Journal",null,null,null,null,null,null,null,null,null,null,null,null,8000,10000,"AC Speed is behind in its mortgage payments to Bank of America. Paid a total of",{"$f":"Table1[[#This Row],[Balance Paid]]","v":10000},"(",{"$f":"Table1[[#This Row],[Balance Paid]]-Table1[[#This Row],[Interest Paid]]","v":2000},"principal and",{"$f":"Table1[[#This Row],[Interest Paid]]","v":8000},"interest), Check #5290. ",null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" $\",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"AC Speed is behind in its mortgage payments to Bank of America. Paid a total of $10000 ( $2000 principal and $8000 interest), Check #5290.   "}]
["2013-06-29","Cash Receipt","Cash Receipts Journal",null,null,null,{"$f":"Table1[[#This Row],[Amt of Balance]]","v":89670},"Yes",0.02,{"$f":"G27","v":91500},{"$f":"Table1[[#This Row],[Balance Owing]]*Table1[[#This Row],[Discount %]]","v":1830},{"$f":"Table1[[#This Row],[Balance Owing]]-Table1[[#This Row],[Amt of Discount]]","v":89670},null,null,null,null,null,"Received payment in full from Honda for the June 27th transaction.",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Received payment in full from Honda for the June 27th transaction.        "}]
["2013-06-29","Cash Payment","Cash Payments Journal",null,null,null,30000,"No",null,30000,0,{"$f":"Table1[[#This Row],[Balance Owing]]-Table1[[#This Row],[Total $]]","v":0},null,null,null,null,null,"Paid in full for the purchase from Magellan on May 31st, Check #5291.",null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Paid in full for the purchase from Magellan on May 31st, Check #5291.        "}]
["2013-06-29","Salaries","Cash Payments Journal",null,null,null,14500,"no",null,0,0,0,null,null,null,null,null,"Check # 5292 was issued for payroll: ",{"$f":"Table1[[#This Row],[Total $]]","v":14500},"for salaried and",{"$f":"G33","v":4750},"for wages (wage expense)",null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" $\",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" $\",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"Check # 5292 was issued for payroll:  $14500 for salaried and $4750 for wages (wage expense)    "}]
["2013-06-29","Wages","Cash Payments Journal",null,null,null,4750,"no",null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(Table1[[#This Row],[Concatenate1]],\" \",Table1[[#This Row],[Concatenate2]],\" \",Table1[[#This Row],[Concatenate3]],\" \",Table1[[#This Row],[Concatenate4]],\" \",Table1[[#This Row],[Concatenate5]],\" \",Table1[[#This Row],[Concatenate6]],\" \",Table1[[#This Row],[Concatenate7]],\" \",Table1[[#This Row],[Concatenate8]],\" \",Table1[[#This Row],[Concatenate9]])","v":"        "}]
[]
[]
[]
["Account",null,null,"May 31 Balance",null,null,"Account",null,null,null,"2012-12-31","2011-12-31","2010-12-31","2009-12-31"]
["Sales",null,null,725000,null,null,"Common Stock, $1 Par, 100,000 Authorized; 60,000 shares Issued/Outstanding",null,null,null,65000]
["Cost of Goods Sold (Percentage of Sales)",null,null,0.88,null,null,"Paid In Capital - Excess of Par",null,null,null,1545000]
["Wage Expense (hourly workers)",null,null,10000,null,null,"Retained  Earnings",null,null,null,1166744,1065744,956030,1238479]
["Salaries Expense (exempt staff)",null,null,30000]
["Marketing Expense",null,null,24000]
["Travel and Entertainment Expense",null,null,2300]
["Office Maintenance & Repair Expense",null,null,500]
["Legal Expenses",null,null,16550]
["Insurance Expense",null,null,2000]
["Utilities Expense",null,null,1000]
["Office Supplies Expense",null,null,290]
["Telecommunications Expense",null,null,55]
["Depreciation Expense - Equipment & Furn - Warehouse",null,null,165]
["Depreciation Expense - Equipment & Furn - Office",null,null,140]

{"sheet":"Data - ADJ JE","index":30,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,0,1,1],[1,3,1,4],[0,8,0,9],[0,11,0,12],[0,14,0,16]]}
[null,null,null,null,null,"Required Information",null,null,"Adjustments",null,null,"Adjustment Calculations",null,null,"Concatenation Process",null,null,null,null,"Concatenated Phrase"]
["June Month-end Adjustments:",null,"Adj Transaction Description","Related transaction",null,null,null,null,"# of months","Rent per month",null,"Total Rent"]
[null,"( A )","AC Speed has earned one month of the prepaid rent received from their tenant at the beginning of June. ","June 4",{"$f":"T3","v":"Rented part of the warehouse to a new tenant and received $5400 for three months rent starting in June"},null,null,null,3,1800,null,{"$f":"I3*J3","v":5400},null,null,"Rented part of the warehouse to a new tenant and received",{"$f":"L3","v":5400},"for three months rent starting in June",null,null,{"$f":"CONCATENATE(O3,\" $\",P3,\" \",Q3)","v":"Rented part of the warehouse to a new tenant and received $5400 for three months rent starting in June"}]
[null,null,"Above transaction wording doesn't need changing"]
[null,null,null,null,null,"Previous balance",null,null,"Physical Count",null,null,"Debit","Credit"]
[null,"( B )",{"$f":"T6","v":"The Company took a physical count of Office Supplies on June 30 and found the following to be on hand: Office Supplies -  $2500"},null,null,{"$f":"'General Ledger'!F57","v":0},null,"Must be a write down",2500,null,null,{"$f":"IF(I6>F6,I6-F6,0)","v":2500},{"$f":"IF(I6<F6,F6-I6,0)","v":0},null,"The Company took a physical count of Office Supplies on June 30 and found the following to be on hand: Office Supplies - ",{"$f":"I6","v":2500},null,null,null,{"$f":"CONCATENATE(O6,\" $\",P6)","v":"The Company took a physical count of Office Supplies on June 30 and found the following to be on hand: Office Supplies -  $2500"}]
[]
[null,null,null,null,null,"Accounts receivable balance","Allowance credit balance",null,"Allowance %",null,null,"Debit","Credit"]
[null,"( C )",{"$f":"T9","v":"AC Speed estimates bad debt expense on a monthly basis rather than waiting until year-end. The company uses the allowance method. Based on recent industry estimates, AC Speed estimates that the allowance account should be 2%  of accounts receivable. "},null,null,{"$f":"'General Ledger'!F21","v":0},{"$f":"'General Ledger'!G31","v":0},null,0.02,null,null,{"$f":"IF(F9*I9>G9,0,-(F9*I9-G9))","v":0},{"$f":"IF(F9*I9>G9,F9*I9-G9,0)","v":0},null,"AC Speed estimates bad debt expense on a monthly basis rather than waiting until year-end. The company uses the allowance method. Based on recent industry estimates, AC Speed estimates that the allowance account should be","2%"," of accounts receivable. ",null,null,{"$f":"CONCATENATE(O9,\" \",P9,\" \",Q9)","v":"AC Speed estimates bad debt expense on a monthly basis rather than waiting until year-end. The company uses the allowance method. Based on recent industry estimates, AC Speed estimates that the allowance account should be 2%  of accounts receivable. "}]
[null,null,null,null,null,"Month End Inv Balance",null,null,"Inventory Count",null,null,"Debit","Credit"]
[null,"( D )",{"$f":"T11","v":"The Company took a physical inventory count on June 30 and found the following inventory on hand: Merchandise Inventory -  $120000"},null,null,{"$f":"'General Ledger'!F49","v":0},null,null,120000,null,null,{"$f":"F11-I11","v":-120000},null,null,"The Company took a physical inventory count on June 30 and found the following inventory on hand: Merchandise Inventory - ",{"$f":"I11","v":120000},null,null,null,{"$f":"CONCATENATE(O11,\" $\",P11)","v":"The Company took a physical inventory count on June 30 and found the following inventory on hand: Merchandise Inventory -  $120000"}]
[null,null,null,null,null,null,null,null,"Prepaid Insurance Balance","Months",null,null,"Credit"]
[null,"( E )",{"$f":"T13","v":"The Balance in the prepaid insurance account at the beginning of June represents  4 months of coverage. Record the amount of insurance for June. "},null,null,null,null,null,14000,4,null,null,{"$f":"I13/J13","v":3500},null,"The Balance in the prepaid insurance account at the beginning of June represents ",{"$f":"J13","v":4},"months of coverage. Record the amount of insurance for June. ",null,null,{"$f":"CONCATENATE(O13,\" \",P13,\" \",Q13)","v":"The Balance in the prepaid insurance account at the beginning of June represents  4 months of coverage. Record the amount of insurance for June. "}]
[]
[null,"( F )","Depreciation on the company's fixed assets for the month of June is as follows:",null,null,null,"Life",null,"Historical Price","Salvage Value",null,"Monthly Depr."]
[null,null,{"$f":"T16","v":"1. The furniture and equipment for the warehouse was purchased a few years ago for  10000. These assets have a 4-year life, an expected salvage value of 1000 and are depreciated using the straight-line method."},null,null,"Warehouse",4,null,10000,1000,null,{"$f":"(I16-J16)/(G16*12)","v":187.5},null,null,"1. The furniture and equipment for the warehouse was purchased a few years ago for ",{"$f":"I16","v":10000},". These assets have a 4-year life, an expected salvage value of",{"$f":"J16","v":1000},"and are depreciated using the straight-line method.",{"$f":"CONCATENATE(O16,\" \",P16,Q16,\" \",R16,\" \",S16)","v":"1. The furniture and equipment for the warehouse was purchased a few years ago for  10000. These assets have a 4-year life, an expected salvage value of 1000 and are depreciated using the straight-line method."}]
[null,null,{"$f":"T17","v":"2. The furniture and equipment for the office was purchased last year for  8500. these assets have a 7 year life, an expected salvage value of 1500 and are depreicated using stright-line method. "},null,null,"Office",7,null,8500,1500,null,{"$f":"(I17-J17)/(G17*12)","v":83.333333333333329},null,null,"2. The furniture and equipment for the office was purchased last year for ",{"$f":"I17","v":8500},". these assets have a 7 year life, an expected salvage value of",{"$f":"J17","v":1500},"and are depreicated using stright-line method. ",{"$f":"CONCATENATE(O17,\" \",P17,Q17,\" \",R17,\" \",S17)","v":"2. The furniture and equipment for the office was purchased last year for  8500. these assets have a 7 year life, an expected salvage value of 1500 and are depreicated using stright-line method. "}]

{"sheet":"Change Log","index":31,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Date","Transactional Data","Change"]
[{"$f":"Transactions!A6","v":"June 1"},{"$f":"Transactions!B6","v":"Signed a 3 year 7.1% , $210000 note payable with First Bank."},"Changed value to $200,000"]
[{"$f":"Transactions!A8","v":"June 1"},{"$f":"Transactions!B8","v":"Purchased 3100 GPS units on credit from Navistar for $35.5 per unit. "},"From $35 to $36 per unit"]
["June 2","Sold 2000 DVD players on account to Toyota for $76 per unit, Invoice #5555 ","From $75 to $76"]
["June 2","Sold 3500 GPS units on account to Kia for $53 per unit, Invoice #5566. ","From $52 to $53"]
["June 30","Issued bonds payable at face value for $450,000 ","From $350K to $450K"]
["ADJ C","Bad Debt","Changed from 2.5% to 2.0%"]