{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Main Menu","Credits","Instructions","Academic Integrity","Transactions","Products","Chart of Accounts GL","Chart of Accounts AR Ledger","Chart of Accounts AP Ledger","Sales Journal","Purchases Journal","Inventory Control","Receipts","Cash Payments Journal","General Journal","General Journal ADJ","General Journal Closing","General Ledger","AR Ledger","AP ledger","Worksheet July 2011","IS July 2011","Stmt RE July 2011","BS July 2011","Post Closing Trial Balance","Comparative IS","Comparative BS","Ratios","Adj Trial Balances Prior Yrs","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":5,"defined_names":23,"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":"Main Menu","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[7,0,7,3],[8,0,8,3],[9,0,9,3],[10,0,10,3]]}
[null,null,null,null,"*Enter your name, access code, and CRN below and then click the Activate button."]
[null,null,null,null,"This file is NOT to be shared with any person as it is specifically linked with your name."]
[]
[null,null,null,null,"Date:"]
[null,null,null,null,"Name:"]
[null,null,null,null,"Access Code:",2012300220]
[null,null,null,null,"CRN:",30180]
["Davenport University",null,null,null,"Activation was successful."]
["ACCT202 Practice Set",null,null,null,"*Click the following buttons to go to the corresponding worksheets:"]
["Ver. 5.1, 2011-12"]
["Summer 2012"]

{"sheet":"Credits","index":1,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Login","Student","Access Code","Course","Login"]
["Date","Name","Number","CRN","Date"]
[{"$f":"NOW()","v":"2015-10-25T12:46:14.400"},"Anjum Bheda",2012300220,30180,"2012-05-26T10:40:10.960"]
[null,null,2012300220,30180]

{"sheet":"Instructions","index":2,"n_rows":53,"n_cols":1,"rows_kept":53,"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. As you work on parts of the project, you will note references to pages or sections of your accounting textbooks that will provide examples or explanations related to that task.  You are also 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 3/10, net 30."]
["b. When AC Speed sells merchandise to a customer on account, they offer that customer credit terms of 3/10, net 45."]
["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 first-in, first-out (FIFO) inventory costing method."]
["e. Subsidiary ledger records are kept for each customer and for each vendor.  The balances in the customer subsidiary ledger records, in total, must equal the Accounts Receivable account balance in the general ledger.  The balances in the vendor subsidiary ledger records, in total, must equal the Accounts Payable account balance in the general ledger."]
["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, such as the one on page 220."]
["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, similar in format to the example on page 711.  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 18 on financial statement analysis.  Page 809, 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 18 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 18 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":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,3,24,7],[27,3,27,5],[30,3,30,5],[5,3,8,10],[3,3,3,10],[10,3,12,10],[14,3,15,10],[17,3,18,10],[20,3,22,10]]}
[]
[]
[]
[null,null,null,"Project Academic Integrity Statement"]
[]
[null,null,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,null,null,"I also understand that I am not permitted to supply anyone with the results of my work or with information or assistance that compromises another student's completion of the project through his or her own efforts."]
[]
[]
[]
[null,null,null,"If I have any questions about these requirements, I will promptly ask my instrucor for clarification."]
[]
[]
[null,null,null,"I understand that any violation of this project academic integrity statement will lead, at minimum, to a failing grade for the project."]
[]
[]
[null,null,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 academic integrity statement."]
[]
[]
[]
[]
[null,null,null,"Student Name"]
[]
[]
[null,null,null,"Student ID Number"]
[]
[]
[null,null,null,"Date"]

{"sheet":"Transactions","index":4,"n_rows":108,"n_cols":2,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["JULY JOURNAL TRANSACTIONS"]
[]
["2011-07-01","Issued 8,200 shares of common stock for $11 per share (Refer to Chart of Accounts GL for description of common stock)."]
[]
["2011-07-01","Signed a two year 14%, $216,000 note payable with Fifth Third Bank."]
[]
["2011-07-01","Sold 1500 speakers on account to GM for $112 each, Invoice #2301"]
[]
["2011-07-01","Purchased 2800 rearview mirrors on credit from Gentex for $45 each."]
[]
["2011-07-02","Rented idle warehouse space to a new tenant and received $15,000 for three months rent. (July - October)"]
[]
["2011-07-02","Sold 250 rearview mirrors on account to Honda for $105 each, Invoice #2302"]
[]
["2011-07-03","Purchased 3450 speakers on credit from Bose for $72 each."]
[]
["2011-07-03","Sold 1300 GPS units on account to Toyota for $65 each, Invoice #2303"]
[]
["2011-07-04","60 defective speakers were returned from GM. A credit was issued to the customer."]
[]
["2011-07-05","The 60 defective speakers were returned to Bose."]
[]
["2011-07-06","Paid $650 for equipment repair. Check # 7000"]
[]
["2011-07-07","Reimbursed employees for entertainment expenses totaling $300. Check # 7001"]
[]
["2011-07-08","Paid June utility bill of  $1850. Check # 7002"]
[]
["2012-07-08","Purchased office supplies from Staples on credit for $700."]
[]
["2011-07-11","Paid in full for the July 1 purchase from Gentex. Check # 7003"]
[]
["2011-07-11","Received payment from GM on remaining balance for July 1st sale"]
[]
["2011-07-12","The Board of Directors declared a cash dividend of $0.50 per share for shareholders of record on July 14th, payable on July 20th."]
[]
["2011-07-12","Purchased 3100 GPS units from Garmin for $28 each on credit. "]
[]
["2011-07-12","Received payment in full from Honda for July 2nd sale.  "]
[]
["2011-07-13","Paid in full for the July 3rd purchase from Bose, Check # 7004"]
[]
["2011-07-13","Received payment in full from Toyota for July 3nd sale"]
[]
["2011-07-15","Check # 7005 was issued for payroll: $23,750 for salaries and $1,925 for wages"]
[]
["2011-07-17","Bought new Office Furniture for $15,600. Furniture use begins in August. Check # 7006"]
[]
["2011-07-19","1550 GPS units purchased on July 12th from Garmin were found to be the wrong model. All 1550 units were returned. "]
[]
["2011-07-19","Paid $1400 bill for phone survey performed by marketing consultant, Check # 7007"]
[]
["2011-07-20","Received $122,500 from Ford for June 5th sales."]
[]
["2011-07-20","Paid $21,000 mortgage payment to Fifth Third Bank ($6,000 principal and $15,000 interest), Check # 7008."]
[]
["2011-07-20","Paid the dividend that was declared on July 12, Check # 7009"]
[]
["2011-07-22","Paid the remaining balance on the purchase from Garmin on July 12th.  Check #7010"]
[]
["2011-07-23","General Motors declared bankruptcy. $10,000 receivable from General Motors was written off ."]
[]
["2011-07-25","Received $119,050 payment from Toyota for sale on June 11th. "]
[]
["2011-07-26","Purchased 800 shares of Treasury Stock for $15 per share, Check # 7011 (cost method)"]
[]
["2011-07-26","Sold 425 speakers to Honda for $114 each, Invoice # 2304"]
[]
["2011-07-27","Paid Gentex $40,000 for June 27 purchase, Check # 7012"]
[]
["2011-07-27","Sold 1850 Rearview mirrors to Ford for $89 each, Invoice # 2305"]
[]
["2011-07-28","Issued bonds payable at face value for $ 485,000"]
[]
["2011-07-29","Paid Bose $158,240 for balance due in June, Check # 7013"]
[]
["2011-07-29","Check #7014 was issued for payroll:  $ 20,500 for salaries and $ 3,560 for wages"]
[]
["2011-07-30","Received and paid legal service invoice of $9,025, Check # 7015"]
[]
["2011-07-31","Paid the first month's principal of $25,000 plus interest for notes issued at the beginning of the month. Check # 7016"]
[]
["*All purchases on account terms of 3/10, net 30"]
[]
["**All credit sales have terms of 3/10, net 45"]
[]
["July Month-end Adjustments:"]
[]
["( A )","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 estimate of bad debt expense should be 1.5% of total sales. "]
[]
["( B )","The balance in the Prepaid Insurance account at the beginning of July represents 6 months of coverage. Record the amount of insurance expense for July. (p.102)"]
[]
[]
["( C )","AC Speed has earned one month of the rent prepaid by their tenant at the beginning of July. (pp. 104-105)"]
[]
["( D )","The Company took a physical inventory count on July 31 and found the following inventory on hand:"]
[null,"Merchandise Inventory - $310,000 (p.211)"]
[]
["( E )","The Company took a physical count of Office Supplies on July 31 and found the following to be on hand:"]
[null,"Office Supplies - $2,415 (p.101)"]
[]
["( F )","Depreciation on the company's fixed assets for the month of July is as follows:"]
[null,"1. The furniture and equipment for the warehouse purchased a few years ago cost $10,000. These assets have a 10-year life, with $1500 salvage value, and are depreciated using the straight-line method. (p.444)"]
[null,"2. The furniture and equipment for the office was purchased last year for $8,500. These assets have a 5 year life, an expected salvage value of $1,500, and are depreciated using double declining method. "]
[null,"3.The new office furniture purchased in July has a 5 year life with a $500 salvage value, and is depreciated using the straight 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"]
["Speakers","High sound quality speakers"]
["Rearview Mirror","Rearview mirror with built in reverse camera display"]

{"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, 125,000 Authorized; 75,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,"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":9,"n_cols":3,"rows_kept":9,"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",0]
[null,"Ford Motor Co.",809650]
[null,"Toyota",80950]
[null,"Honda",48450]
[null,"Total",939050]

{"sheet":"Chart of Accounts AP Ledger","index":8,"n_rows":9,"n_cols":2,"rows_kept":9,"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,"Magellan"]
[null,"Bose"]
[null,"Gentex"]

{"sheet":"Sales Journal","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$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"]
["1st July",null,"General Motors",null,168000,106500]
["2nd July",null,"Honda",null,26250,10750]
["3rd July",null,"Toyota",null,84500,52000]
["27th July",null,"Honda",null,48450,30175]
[null,null,"Ford",null,164650,81350]
[null,null,"Total",null,491850,280775]

{"sheet":"Purchases Journal","index":10,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["AC Speed Corporation"]
["Purchases Journal"]
[]
["Date","Creditors Account Credited","Other Account - Debited","Post Ref","A/P - CR","Inventory - DR","Office Supplies - DR","Other - DR"]
["1st July","Gentex","Inventory",null,126000,126000]
["3rd july","Bose","Inventory",null,248400,248400]
["8th july","Staples","Office supplies",null,700,null,700]
["12th July","Garmin","Inventory",null,86800,86800]
[null,"Total",null,null,{"$f":"SUM(E5:E8)","v":461900},{"$f":"SUM(F5:F8)","v":461200},700]

{"sheet":"Inventory Control","index":11,"n_rows":38,"n_cols":14,"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 $"]
["2011-07-01",2500,40,{"$f":"B4*C4","v":100000},null,null,{"$f":"E4*F4","v":0},null,null,{"$f":"H4*I4","v":0},2500,40,{"$f":"D4+G4-J4","v":100000}]
["3rd Jul",null,null,null,null,null,null,1300,40,52000,1200,40,48000]
["12th jul",null,null,null,3100,28,86800,null,null,null,1200,40,48000]
[" ",null,null,null,null,null,null,null,null,null,3100,28,86800]
["19th July",null,null,null,null,null,null,1550,28,43400,1200,40,48000]
[null,null,null,null,null,null,null,null,null,null,1550,28,43400]
[]
[]
[]
[]
[]
[]
["Shoe:",{"$f":"Products!A3","v":"Speakers"}]
[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 $"]
["2011-07-01",2000,71,{"$f":"B19*C19","v":142000},null,null,{"$f":"E19*F19","v":0},null,null,{"$f":"H19*I19","v":0},2000,71,{"$f":"D19","v":142000}]
["1st jul",null,null,null,null,null,null,1500,71,106500,500,71,35500]
["3rd jul",null,null,null,3450,72,{"$f":"E21*F21","v":248400},null,null,null,500,71,35500]
[null,null,null,null,null,null,null,null,null,null,3450,72,{"$f":"K22*L22","v":248400}]
["4th jul",null,null,null,60,71,4260,null,null,null,560,71,39760]
[null,null,null,null,null,null,null,null,null,null,3450,72,{"$f":"K24*L24","v":248400}]
["5th jul",null,null,null,null,null,null,60,71,4260,500,71,35500]
[null,null,null,null,null,null,null,null,null,null,3450,72,{"$f":"K26*L26","v":248400}]
["26th jul",null,null,null,null,null,null,425,71,30175,75,71,5325]
[null,null,null,null,null,null,null,null,null,null,3450,72,{"$f":"K28*L28","v":248400}]
["Shoe:",{"$f":"Products!A4","v":"Rearview Mirror"}]
[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 $"]
["2011-07-01",1200,43,{"$f":"B32*C32","v":51600},null,null,{"$f":"E32*F32","v":0},null,null,{"$f":"H32*I32","v":0},1200,43,{"$f":"D32+G32-J32","v":51600}]
["1st jul",null,null,null,2800,45,126000,null,null,null,1200,43,51600]
[null,null,null,null,null,null,null,null,null,null,2800,45,126000]
["2nd Jul",null,null,null,null,null,null,250,43,10750,950,43,40850]
[null,null,null,null,null,null,null,null,null,null,2800,45,126000]
["27th jul",null,null,null,null,null,null,950,43,40850]
[null,null,null,null,null,null,null,900,45,40500,1900,45,85500," "]

{"sheet":"Receipts","index":12,"n_rows":14,"n_cols":9,"rows_kept":14,"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"]
["1st jul","Common stock and excess of par",null,null,null,90200,null,90200]
["1st july","Notes payable",null,null,null,216000,null,216000]
["2nd jul","Rent received in advance",null,null,null,15000,null,15000]
["11th jul","G.M",null,null,161280,null,4838,156442]
["12th jul","Honda",null,null,26250,null,787,25463]
["13th jul","Toyota",null,null,84500,null,2535,81965]
["20th jul","Ford",null,null,122500,null,3675,118825]
["25th jul","Toyota",null,null,119050,null,3571,115479]
["28th jul","Bonds payable",null,null,null,485000,null,485000]
[null,"Total",null,null,{"$f":"SUM( E8:E12)","v":513580},{"$f":"SUM(F5:F13)","v":806200},{"$f":"SUM(G7:G12)","v":15406},{"$f":"SUM(H5:H13)","v":1304374}]

{"sheet":"Cash Payments Journal","index":13,"n_rows":22,"n_cols":9,"rows_kept":22,"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"]
["2012-07-06",null,null,"Equipment repair",null,650,null,650]
["2012-07-07",null,null,"Entertainment expense",null,300,null,300]
["2012-07-08",null,null,"Utility bill",null,1850,null,1850]
["2012-07-11",null,null,"Gentex",null,122220,3780,null,126000]
["2012-07-13",null,null,"Bose",null,240948,7452,null,248400]
["2012-07-15",null,null,"Salaries & wages",null,25675,null,25675]
["2012-07-19",null,null,"Office furniture",null,15600,null,15600]
["2012-07-19",null,null,"Phone bill",null,1400,null,1400]
["2012-07-20",null,null,"Mortgage payable",null,21000,null,21000]
["2012-07-20",null,null,"Dividend payable",null,41600,null,41600]
["2012-07-22",null,null,"Garmin",null,42098,1302,null,43400]
["2012-07-26",null,null,"Treasury stock",null,12000,null,12000]
["2012-07-27",null,null,"Gentex",null,38800,1200,null,40000]
["2012-07-29",null,null,"Bose",null,158240,null,null,158240]
["2012-07-29",null,null,"Salaries & wages",null,24060,null,24060]
["2012-07-30",null,null,"Legal service",null,9025,null,9025]
["2012-07-31",null,null,"Note payable",null,27520,null,27520]
[null,null,null,"Total",null,782986,13734,180680,616040]

{"sheet":"General Journal","index":14,"n_rows":40,"n_cols":5,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["General Journal"]
[]
["Date","Accounts","Post Ref","DEBIT","CREDIT"]
["1st july","Cash",null,90200]
[null,"             Common Stock",null,null,8200]
[null,"          Paid in capital in excess of par",null,null,82000]
["1st july","Cash",null,216000]
[null,"        14% Note Payable",null,null,216000]
["2nd july","Cash",null,15000]
[null,"        Unearned Rent",null,null,15000]
["6th july","Equipment Repair",null,650]
[null,"       Cash",null,null,650]
["7th July","Entertainment Expense",null,300]
[null,"    Cash",null,null,300]
["8th July","Utility Bill",null,1850]
[null,"     Cash",null,null,1850]
["12 th july","Dividend ",null,41600]
[null,"       Dividend Payable",null,null,41600]
["15th July","Salaries ",null,23750]
[null,"Wages",null,1925]
[null,"       Cash",null,null,25675]
["17th July","Office Furniture ",null,15600]
[null,"       Cash",null,null,15600]
["19th July","Telephone",null,1400]
[null,"       Cash",null,null,1400]
["20th July","Bad Debts ",null,10000]
[null,"     GM",null,null,10000]
["26th july","Treasury stock",null,12000]
[null,"     Cash",null,null,12000]
["28th July","Cash",null,485000]
[null,"      Bonds payable",null,null,485000]
["29th July","Salaries ",null,20500]
[null,"Wages",null,3560]
[null,"       Cash",null,null,24060]
["30th July","Legal service ",null,9025]
[null,"       Cash",null,null,9025]
["31st July","14% notes payable",null,25000]
[null,"Interest expense",null,2520]
[null,"       Cash",null,null,27520]

{"sheet":"General Journal ADJ","index":15,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["General Journal"]
[]
["Date",null,"Accounts","Post Ref","DEBIT","CREDIT"]
["31st July",null,"Bad debts expense",null,7377]
[null,null,"       Allowance for dubtful accounts",null,null,7377]
["31st July",null,"Insurance expense",null,5000]
[null,null,"      Prepaid insurance",null,null,5000]
["31st July",null,"Unearned rent",null,5000]
[null,null,"       Rent revenue",null,null,5000]
["31st July",null,"Cost of goods sold",null,106891]
[null,null,"      Inventory",null,null,106891]
["31st July",null,"Supplies expense",null,285]
[null,null,"     Office supplies",null,null,285]
["31st July",null,"Depreciation expense",null,71]
[null,null,"       Accumulated depreciation-Warehouse",null,null,71]
["31st July",null,"Depreciation expense",null,442]
[null,null,"       Accumulated depreciation-Office",null,null,442]

{"sheet":"General Journal Closing","index":16,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Chart of Accounts GL'!A1","v":"AC Speed Corporation"}]
["General Journal"]
[]
["Date","Accounts","Post Ref","DEBIT","CREDIT"]
["31st July","Retained earnings",null,12337]
[null,"    Net loss",null,null,12337]
["31st July","Retained earnings",null,41600]
[null,"     Dividend",null,null,41600]

{"sheet":"General Ledger","index":17,"n_rows":575,"n_cols":7,"rows_kept":575,"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"]
["2011-06-30","Balance",null,null,null,{"$f":"65900+15000+13000","v":93900}]
[null,"Total receipts",null,1304374,null,{"$f":"F4+D5","v":1398274}]
[null,"Total payments",null,null,782986,{"$f":"F5-E6","v":615288}]
[]
[]
[]
[]
[]
[]
[]
["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","CREDIT"]
["2011-06-30","Balance",null,null,null,490000]
[null,"GM",null,168000,178000,480000]
[null,"Ford Motors",null,164650,122500,522150]
[null,"Toyota",null,84500,203550,403100]
[null,"Honda",null,74700,26250,451550]
[]
[]
[]
["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"]
["2011-06-30","Balance",null,null,null,null,15000]
[null,"Bad debts expense",null,null,7377,null,22377]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30","Balance",null,null,null,{"$f":"'Inventory Control'!M4+'Inventory Control'!M19+'Inventory Control'!M32","v":293600}]
[null,"Purchased",null,465460]
[null,"Issued",null,null,449060,310000]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30","Balance",null,null,null,2000]
[null,"A/P",null,700,null,2700]
[null,"Supplies expense",null,null,285,2415]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30",null,null,null,null,30000]
[null,"Insurance expense",null,null,5000,25000]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30","Balance Carried Forward",null,2000600,null,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"]
["2011-06-30","Balance Carried Forward",null,1500000,null,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"]
["2011-06-30","Balance Carried Forward",null,null,1500000,null,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"]
["2011-06-30","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"]
["2011-06-30","Balance",null,null,null,null,1900]
[null,"Depreciation expense",null,null,71,null,1971]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30","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"]
["2011-06-30","Balance",null,null,null,null,1600]
[null,"Depreciation expense",null,null,190]
[null,"Depreciation expense",null,null,252]
[null,null,null,null,null,null,{"$f":"2042","v":2042}]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30","Balance",null,null,null,null,928100]
[null,"Garmin",null,86800,86800,null,0]
[null,"Gentex",null,166000,126000,40000]
[null,"Bose",null,410900,248400,162500]
[null,"office supplies",null,null,700,null,726300]
[]
[]
[]
["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"]
[null,"dividend expense",null,null,41600,null,41600]
[null,"Cash",null,41600,null,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,null,15000,null,15000]
[null,"Rent revenue",null,5000,null,null,10000]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,null,null,null,216000]
[null,"Cash",null,25000,null,null,191000]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,null,null,null,485000]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-07-01",null,null,null,null,null,200000]
[null,"Cash",null,6000,null,null,194000]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts GL'!B36","v":"Common Stock, $1 Par, 125,000 Authorized; 75,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"]
["2011-06-30","Balance",null,null,null,null,{"$f":"75000*1","v":75000}]
[null,"Cash",null,null,8200,null,83200]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30",null,null,null,null,null,1341000]
[null,"Cash",null,null,82000,null,1423000]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-30","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"]
[null,"Cash",null,12000,null,12000]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"GM",null,null,168000]
[null,"Honda",null,null,74700]
[null,"Tyota",null,null,84500]
[null,"Ford",null,null,164650,null,491850]
[]
[]
[]
[]
[]
[]
["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"]
[null,"GM",null,4838]
[null,"Honda",null,787]
[null,"Toyota",null,6106]
[null,"Ford",null,3675,null,15406]
[]
[]
[]
[]
[]
[]
["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"]
[null,"GM",null,6720,null,6720]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Inventory",null,387666,null,387666]
[null,"Inventory",null,null,4260,383406]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,1925]
[null,"Cash",null,3560,null,5485]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,23750]
[null,"Cash",null,20500,null,44250]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,300,null,300]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"GM",null,10000]
[null,"Discount for doubtful",null,7377,null,17377]
[]
[]
[]
[]
[]
[]
[]
[]
["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":"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"]
[null,"Cash",null,650,null,650]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,9025,null,9025]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Prepaid expense",null,5000,null,5000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,1850,null,1850]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Supplies",null,285,null,285]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,1400,null,1400]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Accumulated Depreciation",null,71,null,71]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Unearned rent",null,null,5000,null,5000]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Cash",null,15000]
[null,"Cash",null,2520,null,17520]
[]
[]
[]
[]
[]
[]
[]
["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"]
[null,"Net sales",null,null,491850,null,491850]
[null,"Total expenses",null,509187,null,{"$f":"D573-G572","v":17337}]
[null,"Rent revenue",null,null,5000]
[null,"Net loss",null,null,null,12337]

{"sheet":"AR Ledger","index":18,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,1,0,2],[16,1,16,3],[29,1,29,3],[42,1,42,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"]
["2011-06-30",null,null,null,10000]
["2012-07-01",null,168000,null,178000]
["2012-07-04",null,null,6720,{"$f":"E5-D6","v":171280}]
["2012-07-11",null,null,161280,10000]
["2012-07-23",null,null,10000,0]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
["2011-06-05",null,200000,null,{"$f":"C20","v":200000}]
["2012-07-20",null,null,122500,77500]
["2012-07-27",null,164650,null,242150]
[]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B7","v":"Toyota"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2011-06-11",null,200000,null,200000]
["2012-07-03",null,84500,null,284500]
["2012-07-13",null,null,84500,200000]
["2012-07-25",null,null,119050,80950]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AR Ledger'!B8","v":"Honda"}]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2012-07-02",null,26250,null,26250]
["2012-07-12",null,null,26250,0]
["2012-07-26",null,48450,null,48450]

{"sheet":"AP ledger","index":19,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[28,1,28,3],[2,1,2,3],[15,1,15,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"]
["2011-06-30",null,null,null,null,18000]
["2012-07-12",null,null,86800,null,104800]
["2012-07-19",null,43400,null,null,61400]
["2012-07-22",null,43400,null,null,18000]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B9","v":"Gentex"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2011-06-27",null,null,null,null,40000]
["2012-07-01",null,null,126000,null,176000]
["2012-07-11",null,126000,null,null,40000]
["2012-07-27",null,40000,null,null,0]
[]
[]
[]
[]
[]
[]
["Account:",{"$f":"'Chart of Accounts AP Ledger'!B8","v":"Bose"},null,null,"Account No."]
[null,null,"Transaction",null,"Account Balance"]
["Date","Post Ref","DEBIT","CREDIT","DEBIT","CREDIT"]
["2011-06-30",null,null,162500,null,{"$f":"D32","v":162500}]
["2012-07-03",null,null,248400,null,410900]
["2012-07-05",null,4260,null,null,406640]
["2012-07-13",null,248400,null,null,158240]
["2012-07-29",null,158240,null,null,0]

{"sheet":"Worksheet July 2011","index":20,"n_rows":56,"n_cols":12,"rows_kept":56,"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"},93900,null,{"$f":"G4-C4","v":521388},null,615288,null,null,null,615288]
[{"$f":"'Chart of Accounts GL'!A10","v":102},{"$f":"'Chart of Accounts GL'!B10","v":"Accounts Receivable"},490000,null,null,38450,451550,null,null,null,{"$f":"451550-22377","v":429173}]
[{"$f":"'Chart of Accounts GL'!A11","v":103},{"$f":"'Chart of Accounts GL'!B11","v":"Allowance for Doubtful Accounts"},null,15000,null,{"$f":"H6-D6","v":7377},null,22377]
[{"$f":"'Chart of Accounts GL'!A12","v":104},{"$f":"'Chart of Accounts GL'!B12","v":"Merchandise Inventory"},293600,null,{"$f":"G7-C7","v":16400},null,310000,null,null,null,310000]
[{"$f":"'Chart of Accounts GL'!A13","v":105},{"$f":"'Chart of Accounts GL'!B13","v":"Office Supplies"},2000,null,{"$f":"G8-C8","v":415},null,2415,null,null,null,2415]
[{"$f":"'Chart of Accounts GL'!A14","v":106},{"$f":"'Chart of Accounts GL'!B14","v":"Prepaid Insurance"},30000,null,null,5000,25000,null,null,null,25000]
[{"$f":"'Chart of Accounts GL'!A16","v":140},{"$f":"'Chart of Accounts GL'!B16","v":"Land"},2000600,null,null,null,2000600,null,null,null,2000600]
[{"$f":"'Chart of Accounts GL'!A17","v":145},{"$f":"'Chart of Accounts GL'!B17","v":"Building"},1500000,null,null,null,1500000,null,null,null,0]
[{"$f":"'Chart of Accounts GL'!A18","v":146},{"$f":"'Chart of Accounts GL'!B18","v":"Accumulated Depreciation - Building"},null,1500000,null,null,null,1500000,null,null,null,0]
[{"$f":"'Chart of Accounts GL'!A19","v":151},{"$f":"'Chart of Accounts GL'!B19","v":"Equipment & Furniture - Warehouse"},10000,null,null,null,10000,null,null,null,{"$f":"10000-1971","v":8029}]
[{"$f":"'Chart of Accounts GL'!A20","v":152},{"$f":"'Chart of Accounts GL'!B20","v":"Accumulated Depreciation - Equip & Furn. - Warehouse"},null,1900,null,71,null,1971]
[{"$f":"'Chart of Accounts GL'!A21","v":153},{"$f":"'Chart of Accounts GL'!B21","v":"Equipment & Furniture - Office"},8500,null,15600,null,24100,null,null,null,{"$f":"24100-2042","v":22058}]
[{"$f":"'Chart of Accounts GL'!A22","v":154},{"$f":"'Chart of Accounts GL'!B22","v":"Accumulated Depreciation - Equip & Furn. - Office"},null,1600,null,442,null,2042]
[{"$f":"'Chart of Accounts GL'!A26","v":201},{"$f":"'Chart of Accounts GL'!B26","v":"Accounts Payable"},null,928100,{"$f":"D17-H17","v":201800},null,null,726300,null,null,null,726300]
[{"$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"},null,null,41600,null,41600]
[{"$f":"'Chart of Accounts GL'!A30","v":205},{"$f":"'Chart of Accounts GL'!B30","v":"Unearned Rent"},null,null,null,10000,null,10000,null,null,null,10000]
[{"$f":"'Chart of Accounts GL'!A32","v":250},{"$f":"'Chart of Accounts GL'!B32","v":"Notes Payable"},null,null,null,191000,null,191000,null,null,null,191000]
[{"$f":"'Chart of Accounts GL'!A33","v":251},{"$f":"'Chart of Accounts GL'!B33","v":"Bonds Payable"},null,null,null,485000,null,485000,null,null,null,485000]
[{"$f":"'Chart of Accounts GL'!A34","v":252},{"$f":"'Chart of Accounts GL'!B34","v":"Mortgage (Warehouse) Payable"},null,200000,6000,null,null,194000,null,null,null,194000]
[{"$f":"'Chart of Accounts GL'!A36","v":300},{"$f":"'Chart of Accounts GL'!B36","v":"Common Stock, $1 Par, 125,000 Authorized; 75,000 shares Issued/Outstanding"},null,75000,null,8200,null,83200,null,null,null,83200]
[{"$f":"'Chart of Accounts GL'!A37","v":301},{"$f":"'Chart of Accounts GL'!B37","v":"Paid In Capital - Excess of Par"},null,1341000,null,82000,null,1423000,null,null,null,1423000]
[{"$f":"'Chart of Accounts GL'!A38","v":330},{"$f":"'Chart of Accounts GL'!B38","v":"Retained Earnings"},null,366000,null,null,null,366000,null,null,null,{"$f":"366000-41600-12337","v":312063}]
[{"$f":"'Chart of Accounts GL'!A39","v":340},{"$f":"'Chart of Accounts GL'!B39","v":"Treasury Stock"},null,null,12000,null,12000,null,null,null,12000]
[{"$f":"'Chart of Accounts GL'!A42","v":500},{"$f":"'Chart of Accounts GL'!B42","v":"Sales"},null,null,null,491850,null,491850,null,491850]
[{"$f":"'Chart of Accounts GL'!A43","v":510},{"$f":"'Chart of Accounts GL'!B43","v":"Sales Discounts"},null,null,15406,null,15406,null,15406]
[{"$f":"'Chart of Accounts GL'!A44","v":511},{"$f":"'Chart of Accounts GL'!B44","v":"Sales Returns & Allowances"},null,null,6720,null,6720,null,6720]
[{"$f":"'Chart of Accounts GL'!A46","v":600},{"$f":"'Chart of Accounts GL'!B46","v":"Cost of Goods Sold"},null,null,383406,null,383406,null,383406]
[{"$f":"'Chart of Accounts GL'!A48","v":700},{"$f":"'Chart of Accounts GL'!B48","v":"Wage Expense (hourly workers)"},null,null,5485,null,5485,null,5485]
[{"$f":"'Chart of Accounts GL'!A49","v":701},{"$f":"'Chart of Accounts GL'!B49","v":"Salaries Expense (Exempt Staff)"},null,null,44250,null,44250,null,44250]
[{"$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"},null,null,300,null,300,null,300]
[{"$f":"'Chart of Accounts GL'!A52","v":704},{"$f":"'Chart of Accounts GL'!B52","v":"Bad Debt Expense"},null,null,17377,null,17377,null,17377]
[{"$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":"Maintenance & Repair Expense"},null,null,650,null,650,null,650]
[{"$f":"'Chart of Accounts GL'!A55","v":707},{"$f":"'Chart of Accounts GL'!B55","v":"Legal Expenses"},null,null,9025,null,9025,null,9025]
[{"$f":"'Chart of Accounts GL'!A56","v":708},{"$f":"'Chart of Accounts GL'!B56","v":"Insurance Expense"},null,null,5000,null,5000,null,5000]
[{"$f":"'Chart of Accounts GL'!A57","v":709},{"$f":"'Chart of Accounts GL'!B57","v":"Utilities Expense"},null,null,1850,null,1850,null,1850]
[{"$f":"'Chart of Accounts GL'!A58","v":710},{"$f":"'Chart of Accounts GL'!B58","v":"Office Supplies Expense"},null,null,285,null,285,null,285]
[{"$f":"'Chart of Accounts GL'!A59","v":711},{"$f":"'Chart of Accounts GL'!B59","v":"Telecommunications Expense"},null,null,1400,null,1400,null,1400]
[{"$f":"'Chart of Accounts GL'!A60","v":712},{"$f":"'Chart of Accounts GL'!B60","v":"Depreciation Expense -  Equip & Furniture - Warehouse"},null,null,71,null,71,null,71]
[{"$f":"'Chart of Accounts GL'!A61","v":713},{"$f":"'Chart of Accounts GL'!B61","v":"Depreciation Expense - Equip & Furniture - Office"},null,null,442,null,442,null,442]
[{"$f":"'Chart of Accounts GL'!A63","v":800},{"$f":"'Chart of Accounts GL'!B63","v":"Rent Income"},null,null,null,5000,null,5000,null,5000]
[{"$f":"'Chart of Accounts GL'!A65","v":900},{"$f":"'Chart of Accounts GL'!B65","v":"Interest Expense"},null,null,17520,null,17520,null,17520]
[null,"Total",4428600,4428600,1324390,1324390,5501740,5501740,509187,496850,3424563,3424563]
[]
[null,"Net Income (Loss)",null,null,null,null,null,null,null,{"$f":"I49-J49","v":12337}]
[null,"Total"]
[]
[]
[null,"Note:-"]
[null,"There is a diffrence of 20500 in the unadjusted trial balance and I have adjusted the trial balance according to information given below"]

{"sheet":"IS July 2011","index":21,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
[]
["Income Statement"]
[]
["INCOME STATEMENT ACCOUNTS"]
["   Revenue"]
["Sales",null,491850]
["Sales Discounts",15406]
["Sales Returns & Allowances",6720]
["   Cost of Goods Sold",383406]
["Cost of Goods Sold",383406]
["   Operating Expenses"]
["Wage Expense (hourly workers)",5485]
["Salaries Expense (Exempt Staff)",44250]
["Marketing Expense"]
["Travel and Entertainment Expense",300]
["Bad Debt Expense",17377]
["Property Tax Expense"]
["Maintenance & Repair Expense",650]
["Legal Expenses",9025]
["Insurance Expense",5000]
["Utilities Expense",1850]
["Office Supplies Expense",285]
["Telecommunications Expense",1400]
["Depreciation Expense -  Equip & Furniture - Warehouse",71]
["Depreciation Expense - Equip & Furniture - Office",442]
["   Other Income"]
["Rent Income",null,5000]
["   Other Expenses"]
["Interest Expense",17520]
[]
["Net Income/ Loss",null,12337]

{"sheet":"Stmt RE July 2011","index":22,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
[]
["Statement of Retained Earnings"]
[]
[]
["Opening Balance",null,366000]
["Less:-"]
["Dividend",41600]
["Net loss",12337]
["Closing Balance",null,{"$f":"C5-SUM(B7:B8)","v":312063}]

{"sheet":"BS July 2011","index":23,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3]]}
[]
["Balance Sheet"]
[]
["   Liabilities",null,"   Assets"]
["     Current Liabilities",null,"     Current Assets"]
["Accounts Payable",726300,"Cash",615288]
["Wages Payable",null,"Accounts Receivable",{"$f":"451550-22377","v":429173}]
["Interest Payable"]
["Dividends Payable",null,"Merchandise Inventory",310000]
["Unearned Rent",10000,"Office Supplies",2415]
["     Long-Term Liabilities",null,"Prepaid Insurance",25000]
["Notes Payable",191000,"     Property, Plant and Equipment"]
["Bonds Payable",485000,"Land",2000600]
["Mortgage (Warehouse) Payable",194000,"Building"]
["   Capital (Equity)"]
["Common Stock, $1 Par, ",null,"Equipment & Furniture - Warehouse",8029]
["125,000 Authorized; 75,000 shares Issued/Outstanding",83200]
["Paid In Capital - Excess of Par",1423000,"Equipment & Furniture - Office",22058]
["Retained Earnings",{"$f":"366000-41600-12337","v":312063}]
["Treasury Stock",-12000]
[]
["TOTAL",3412563,"TOTAL",3412563]

{"sheet":"Post Closing Trial Balance","index":24,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
[{"$f":"'IS July 2011'!A1","v":0}]
["Post-closing Trial Balance"]
[]
[null,"DEBIT","CREDIT"]
["Cash",615288]
["Accounts Receivable",{"$f":"451550-22377","v":429173}]
[]
["Merchandise Inventory",310000]
["Office Supplies",2415]
["Prepaid Insurance",25000]
["     Property, Plant and Equipment"]
["Land",2000600]
["Building"]
[]
["Equipment & Furniture - Warehouse",8029]
[]
["Equipment & Furniture - Office",22058]
[]
["Accounts Payable",null,726300]
["Wages Payable"]
["Interest Payable"]
["Dividends Payable"]
["Unearned Rent",null,10000]
["     Long-Term Liabilities"]
["Notes Payable",null,191000]
["Bonds Payable",null,485000]
["Mortgage (Warehouse) Payable",null,194000]
["   Capital (Equity)"]
["Common Stock, $1 Par, "]
["125,000 Authorized; 75,000 shares Issued/Outstanding",null,83200]
["Paid In Capital - Excess of Par",null,1423000]
["Retained Earnings",null,{"$f":"366000-41600-12337","v":312063}]
["Treasury Stock",12000]
["TOTAL",3424563,3424563]

{"sheet":"Comparative IS","index":25,"n_rows":27,"n_cols":16,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,12,1,13],[1,14,1,15]]}
["AC Speed Corporation"]
["Income Statement",null,null,null,null,null,null,null,null,null,2009,null,2010,null,2011]
[null,"2011-12-31",null,"2010-12-31",null,"2009-12-31",null,"2008-12-31",null,"2011-07-31","INCREASE/DECREASE","% CHANGE","INCREASE/DECREASE","% CHANGE","INCREASE/DECREASE","% CHANGE"]
["Sales",{"$f":"7564325+24670","v":7588995},null,{"$f":"6255371+4050+73502+14000+30000","v":6376923},null,{"$f":"6354521+26786-80026-43000-41000-13000","v":6204281},null,{"$f":"5689605+168472-34977","v":5823100},null,750000,{"$f":"(F4-H4)","v":381181},{"$f":"K4/H4","v":6.546015009187546E-2},{"$f":"D4-F4","v":172642},{"$f":"M4/F4","v":2.7826270280150108E-2},{"$f":"B4-D4","v":1212072},{"$f":"O4/D4","v":0.19007160663536316}]
["Less sales discount",{"$f":"140254+(0.6*24670)","v":155056},null,{"$f":"123746.4+(73502*0.6)","v":167847.59999999998},null,{"$f":"126221.328+(26786*0.3)","v":134257.128},null,{"$f":"100142+13990.8","v":114132.8},null,10110,{"$f":"(F5-H5)","v":20124.327999999994},{"$f":"K5/H5","v":0.17632379123266925},{"$f":"D5-F5","v":33590.47199999998},{"$f":"M5/F5","v":0.25019507344146363},{"$f":"B5-D5","v":-12791.599999999977},{"$f":"O5/D5","v":-7.6209609193101227E-2}]
["Less Sales return",{"$f":"98874+(24670*0.4)","v":108742},null,{"$f":"97920+(73502*0.4)","v":127320.8},null,{"$f":"99878.4+(26786*0.7)","v":118628.59999999999},null,{"$f":"100877.184+20986.2","v":121863.38399999999},null,8000,-3234.7839999999997,-2.6544347398066673E-2,8692.2000000000116,7.3272381196440084E-2,-18578.800000000003,-0.14592116920408921]
["Net sales (A)",{"$f":"B4-B5-B6","v":7325197},null,{"$f":"D4-D5-D6","v":6081754.6000000006},null,{"$f":"F4-F5-F6","v":5951395.2720000008},null,{"$f":"H4-H5-H6","v":5587103.8160000006},null,{"$f":"J4-J5-J6","v":731890},{"$f":"(F7-H7)","v":364291.45600000024},{"$f":"K7/H7","v":6.5202199206817135E-2},130359.32799999975,2.1903994280687684E-2,1243442.3999999994,0.20445455000765722]
["Less "]
["Cost of goods sold",{"$f":"5548521-96054+182555","v":5635022},null,{"$f":"4375062-89022+400500-114000+14000+30000","v":4616540},null,{"$f":"4500254-62350+83252+54000","v":4575156},null,{"$f":"4150254-101822+50923+104500","v":4203855},null,{"$f":"349715+107317","v":457032},{"$f":"(F9-H9)","v":371301},{"$f":"K9/H9","v":8.8323931248818044E-2},{"$f":"D9-F9","v":41384},{"$f":"M9/F9","v":9.0453746276629686E-3},1018482,0.22061587249325251]
["Wage expense",{"$f":"95410-1933","v":93477},null,{"$f":"87148.8-542","v":86606.8},null,{"$f":"88891.776-104","v":88787.775999999998},null,{"$f":"89780.69376-23","v":89757.693759999995},null,7120,{"$f":"(F10-H10)","v":-969.91775999999663},{"$f":"K10/H10","v":-1.0805956786205162E-2},{"$f":"D10-F10","v":-2180.9759999999951},{"$f":"M10/F10","v":-2.4563921952499353E-2},6870.1999999999971,7.9326334652706221E-2]
["Salaries expense",{"$f":"510000+36225","v":546225},null,{"$f":"501840+31222","v":533062},null,{"$f":"511876.8+13040","v":524916.80000000005},null,{"$f":"516995.568+11860","v":528855.56799999997},null,41000,-3938.7679999999236,-7.4477196390223578E-3,8145.1999999999534,1.5517125761644423E-2,13163,2.4693187659221631E-2]
["Marketing expense",{"$f":"20540+740","v":21280},null,{"$f":"18360+72","v":18432},null,{"$f":"18727.2-1800","v":16927.2},null,{"$f":"18914.472-3090","v":15824.472000000002},null,1500,1102.7279999999992,6.9684979062808475E-2,1504.7999999999993,8.8898341131433384E-2,2848,0.1545138888888889]
["Travel & entertainmnet expense",{"$f":"10580+6880","v":17460},null,{"$f":"9792+3654","v":13446},null,{"$f":"9987.84+1411","v":11398.84},null,{"$f":"10087.7184-1238","v":8849.7183999999997},null,800,2549.1216000000004,0.28804550436316712,2047.1599999999999,0.17959371304448521,4014,0.29852744310575635]
["Bad debts expense",{"$f":"185202+4512","v":189714},null,{"$f":"110160+4053","v":114213},null,{"$f":"112363.2+13980-11800","v":114543.2},null,{"$f":"113486.832+3031","v":116517.83199999999},null,9000,-1974.6319999999978,-1.6947036913628789E-2,-330.19999999999709,-2.8827551526410741E-3,75501,0.66105434582753275]
["Property tax expense",0,null,0,null,0,null,0]
["Maintanence & repair expense",{"$f":"6000-242","v":5758},null,{"$f":"6120-159","v":5961},null,{"$f":"6242.4+1500","v":7742.4},null,{"$f":"6304.824+1695","v":7999.8239999999996},null,500,-257.42399999999998,-3.2178707931574492E-2,-1781.3999999999996,-0.23008369497830128,-203,-3.4054688810602245E-2]
["Legal expense",{"$f":"64000+3201","v":67201},null,{"$f":"63000+2611","v":65611},null,{"$f":"62424+987","v":63411},null,{"$f":"63048.24-5374","v":57674.239999999998},null,5060,5736.760000000002,9.946832415997163E-2,2200,3.469429594234439E-2,1590,2.4233741293380684E-2]
["Insurance expense",{"$f":"48000+850","v":48850},null,{"$f":"48960+1446","v":50406},null,{"$f":"49939.2+2351","v":52290.2},null,{"$f":"50438.592+202+3555","v":54195.591999999997},null,4300,-1905.3919999999998,-3.5157693267747675E-2,-1884.1999999999971,-3.6033520621454825E-2,-1556,-3.086934095147403E-2]
["Utilities expense",{"$f":"18000+60","v":18060},null,{"$f":"18360+10","v":18370},null,{"$f":"18727.2+644","v":19371.2},null,{"$f":"18914.472+1114","v":20028.472000000002},null,1750,-657.27200000000084,-3.2816881886945787E-2,-1001.2000000000007,-5.1684975633930819E-2,-310,-1.6875340228633642E-2]
["Office supplies expense",{"$f":"5220-1100","v":4120},null,{"$f":"5324.4-555","v":4769.3999999999996},null,{"$f":"5430.988+75","v":5505.9880000000003},null,{"$f":"5485.19688+220","v":5705.1968800000004},null,435,-199.20888000000014,-3.4917091239803126E-2,-736.58800000000065,-0.13377944158250993,-649.39999999999964,-0.13615968465635084]
["Telecommunication expense",0,null,0,null,0,null,0]
["Depreciation expense-Warehouse",{"$f":"1700+302","v":2002},null,{"$f":"1732+263","v":1995},null,{"$f":"1768.68-89","v":1679.68},null,{"$f":"1786.3668-395","v":1391.3668},null,141.66666666666666,288.31320000000005,0.20721581110027928,315.31999999999994,0.18772623356829868,7,3.5087719298245615E-3]
["Depreciation expense-Office furniture",{"$f":"3526+280","v":3806},null,{"$f":"2815.2+455","v":3270.2},null,{"$f":"2871.504+107","v":2978.5039999999999},null,{"$f":"2900.21904-516","v":2384.2190399999999},null,230,594.28495999999996,0.24925770242989082,291.69599999999991,9.7933727804293672E-2,535.80000000000018,0.16384319001895914]
["Interest expense",{"$f":"150000+4650","v":154650},null,{"$f":"153000+4800","v":157800},null,{"$f":"156060+5400","v":161460},null,{"$f":"157620.6+12663","v":170283.6},null,12500,-8823.6000000000058,-5.1817086319528159E-2,-3660,-2.2668153102935712E-2,-3150,-1.9961977186311788E-2]
["Total expenses (B)",{"$f":"SUM(B9:B24)","v":6807625},null,{"$f":"SUM(D9:D24)","v":5690482.4000000004},null,{"$f":"SUM(F9:F24)","v":5646168.7879999997},null,{"$f":"SUM(H9:H24)","v":5283322.7948799999},null,{"$f":"SUM(J9:J24)","v":541368.66666666663},{"$f":"(F25-H25)","v":362845.99311999977},6.8677612026967039E-2,44313.612000000663,7.8484391210871928E-3,1117142.5999999996,0.19631773221897664]
["Add Rent income (c )",23620,null,{"$f":"24480-370","v":24110},null,24969.599999999999,null,{"$f":"25220.296+355","v":25575.295999999998},null,3640,-605.69599999999991,-2.368285395406567E-2,-859.59999999999854,-3.4425861848007118E-2,-490,-2.0323517212774783E-2]
["Net income (A-B+C)",{"$f":"B7-B25+B26","v":541192},null,{"$f":"D7-D25+D26","v":415382.20000000019},null,{"$f":"F7-F25+F26","v":330196.08400000108},null,{"$f":"H7-H25+H26","v":329356.3171200006},null,{"$f":"J7-J25+J26","v":194161.33333333337},839.76688000047579,2.5497214911305546E-3,85186.115999999107,0.25798645146863347,125809.79999999981,0.30287720561930614]

{"sheet":"Comparative BS","index":26,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,10,1,11],[1,12,1,13],[1,14,1,15]]}
["AC Speed Corporation"]
["Balance Sheet",null,null,null,null,null,null,null,null,null,2009,null,2010,null,2011]
[null,"2011-12-31",null,"2010-12-31",null,"2009-12-31",null,"2008-12-31",null,"2011-07-31","INCREASE/DECREASE","% CHANGE","INCREASE/DECREASE","% CHANGE","INCREASE/DECREASE","% CHANGE"]
["Cash",{"$f":"940547+43558-1905+9663+38777+16000+654+1933-740-6880+242-3201-850+1100+380-4650+12900","v":1047528},null,{"$f":"840436.688+34564-1003-4201+2025+8410+21360+255+72000+542-31222-72-3654+159-2611-1446-10+555+370-4800+63444+12500","v":1007601.688},null,{"$f":"924480.3568+4455-3302-134+4668-4850+558+42086+25-12936+1800-1411-1500-987-2351-644-75+89-107-5400-43000","v":901464.35679999995},null,{"$f":"892521+22391+4662-4889+4227+1009-6688+23-11860+3090+1238-1695-1114-12663+800","v":891052},null,584120,{"$f":"F4-H4","v":10412.35679999995},{"$f":"K4/H4","v":1.1685464821357171E-2},{"$f":"D4-F4","v":106137.33120000002},{"$f":"M4/F4","v":0.11773879954251788},{"$f":"B4-D4","v":39926.312000000034},{"$f":"O4/D4","v":3.9625094395435385E-2}]
["Accounts receivables",{"$f":"1458752+696126-961267-43558-60","v":1149993},null,{"$f":"876408+1393991-571886-334552-217184-34564-63444","v":1048769},null,{"$f":"964048.8-56972-4455+11000+49600+16004","v":979225.8},null,{"$f":"875698-22391","v":853307},null,515000,{"$f":"F5-H5","v":125918.80000000005},{"$f":"K5/H5","v":0.14756564753365442},{"$f":"D5-F5","v":69543.199999999953},{"$f":"M5/F5","v":7.1018553636964993E-2},{"$f":"B5-D5","v":101224},{"$f":"O5/D5","v":9.6516964174188979E-2}]
["Less Allowance for doubtful accounts",{"$f":"15680+4512","v":20192},null,{"$f":"16620.8+4053","v":20673.8},null,{"$f":"18282.88+13980-11800","v":20462.88},null,{"$f":"19928.3392+3031","v":22959.339199999999},null,14042,-2496.4591999999975,-0.10873393080929776,210.91999999999825,1.0307444504390303E-2,-481.79999999999927,-2.3304859290502921E-2]
["Merchandise inventory",{"$f":"600254+96054","v":696308},null,{"$f":"632031.36+89022","v":721053.36},null,{"$f":"695234.496+62350","v":757584.49600000004},null,{"$f":"757805.60064+101822","v":859627.60063999996},null,329050,-102043.10463999992,-0.11870617528337617,-36531.136000000057,-4.822054330953475E-2,-24745.359999999986,-3.4318347812705548E-2]
["Office supplies",{"$f":"2648.8+1347","v":3995.8},null,{"$f":"2807.728+1003","v":3810.7280000000001},null,{"$f":"3088.5008+1000","v":4088.5007999999998},null,{"$f":"3366.465872+1149-220","v":4295.4658720000007},null,2365,-206.96507200000087,-4.8182217754098089E-2,-277.77279999999973,-6.7940013610856997E-2,185.07200000000012,4.8566048272141206E-2]
["Prepaid insurace",{"$f":"22400+5622","v":28022},null,{"$f":"23744+4201","v":27945},null,{"$f":"26118.4-44","v":26074.400000000001},null,{"$f":"28730.24-3234-202","v":25294.240000000002},null,20000,780.15999999999985,3.0843385687808759E-2,1870.5999999999985,7.1740864602828774E-2,77,2.7554124172481662E-3]
["Total current assets",{"$f":"B4+B5+-B6+B7+B8+B9","v":2905654.8},null,{"$f":"D4+D5+-D6+D7+D8+D9","v":2788505.9760000003},null,{"$f":"F4+F5+-F6+F7+F8+F9","v":2647974.6736000003},null,{"$f":"H4+H5+-H6+H7+H8+H9","v":2610616.9673120002},null,{"$f":"J4+J5+-J6+J7+J8+J9","v":1436493},37357.706288000103,1.4309914765652179E-2,140531.30239999993,5.3071241126692287E-2,117148.82399999956,4.2011322553464577E-2]
["Land",2000600,null,2000600,null,2000600,null,2000600,null,2000600,0,0,0,0,0,0]
["Building",1500000,null,1500000,null,1500000,null,1500000,null,1500000,0,0,0,0,0,0]
["Less accumulated depreciation",1500000,null,1500000,null,1500000,null,1500000,null,1500000,0,0,0,0,0,0]
["Equipment-Warehouse",33600,null,35616,null,39177.600000000006,null,42703.584000000003,null,30000,-3525.9839999999967,-8.2568807339449463E-2,-3561.6000000000058,-9.090909090909105E-2,-2016,-5.6603773584905662E-2]
["Less accumulated depreciation",{"$f":"2286.66666666667+302","v":2588.6666666666702},null,{"$f":"2423.86666666667+263","v":2686.86666666667},null,{"$f":"2666.25333333333-222","v":2444.2533333333299},null,{"$f":"2906.21613333333-395","v":2511.2161333333302},null,2041.6666666666667,-66.962800000000243,-2.6665486539032134E-2,242.61333333334005,9.925866931414927E-2,-98.199999999999818,-3.6548147780562125E-2]
["Equipment-Office",{"$f":"9520+3789","v":13309},null,{"$f":"10091.2+3300","v":13391.2},null,{"$f":"11100.32+3302","v":14402.32},null,{"$f":"12099.3488+4662","v":16761.3488},null,8500,-2359.0288,-0.14074218179863904,-1011.119999999999,-7.0205355803787103E-2,-82.200000000000728,-6.1383595196846229E-3]
["Less accumulated depreciation",{"$f":"2049.6+280","v":2329.6},null,{"$f":"2172.576+455","v":2627.576},null,{"$f":"2389.4336+558","v":2947.4335999999998},null,{"$f":"2604.918624-516","v":2088.9186239999999},null,1830,858.51497599999993,0.41098536158199334,-319.85759999999982,-0.10852071442762946,-297.97600000000011,-0.11340338014961322]
["Total fixed assets",{"$f":"B11+B12-B13+B14-B15+B16-B17","v":2042590.7333333332},null,{"$f":"D11+D12-D13+D14-D15+D16-D17","v":2044292.7573333334},null,{"$f":"F11+F12-F13+F14-F15+F16-F17","v":2048788.2330666666},null,{"$f":"H11+H12-H13+H14-H15+H16-H17","v":2055464.7980426669},null,{"$f":"J11+J12-J13+J14-J15+J16-J17","v":2035228.3333333333},-6676.564976000227,-3.2482020525761574E-3,-4495.4757333332673,-2.1942120033578826E-3,-1702.0240000002086,-8.3257351174124625E-4]
["Total assets",{"$f":"B10+B18","v":4948245.5333333332},null,{"$f":"D10+D18","v":4832798.7333333334},null,{"$f":"F10+F18","v":4696762.9066666672},null,{"$f":"H10+H18","v":4666081.7653546669},null,{"$f":"J10+J18","v":3471721.333333333},30681.141312000342,6.5753544097331695E-3,136035.82666666619,2.8963741489606506E-2,115446.79999999981,2.388818702581734E-2]
["Accounts payable",{"$f":"800254+1347+5622+3789","v":811012},null,{"$f":"795412+3300","v":798712},null,{"$f":"621254+1000+44+80026+41000+13000","v":756324},null,{"$f":"502102+1149-3234+9324+104500","v":613841},null,741860,142483,0.23211711176021152,42388,5.6044763884261245E-2,12300,1.5399793667805165E-2]
["Wages payable",0,null,0,null,0,null,0]
["Interest payable",0,null,0,null,0,null,0]
["Dividend payable",0,null,0,null,0,null,0]
["Unearned rent",{"$f":"11200-1905","v":9295},null,{"$f":"11872-2025","v":9847},null,{"$f":"13059.5-4850","v":8209.5},null,{"$f":"14234.528-4889","v":9345.5280000000002},null,10000,-1136.0280000000002,-0.12155846090236959,1637.5,0.19946403556854864,{"$f":"B24-D24","v":-552},{"$f":"O24/D24","v":-5.6057682542906467E-2}]
["Current liabilities",{"$f":"SUM(B20:B24)","v":820307},null,{"$f":"SUM(D20:D24)","v":808559},null,{"$f":"SUM(F20:F24)","v":764533.5},null,{"$f":"SUM(H20:H24)","v":623186.52800000005},null,{"$f":"SUM(J20:J24)","v":751860},141346.97199999995,0.22681326641258834,44025.5,5.7584788632545209E-2,11748,1.4529551956010632E-2]
["Notes payable",{"$f":"198000+9663","v":207663},null,{"$f":"213696+8410","v":222106},null,{"$f":"235065.6+4668","v":239733.6},null,{"$f":"256221.504+4227","v":260448.50399999999},null,180000,-20714.90399999998,-7.9535507717871101E-2,-17627.600000000006,-7.3529951579586694E-2,-14443,-6.5027509387409616E-2]
["Bonds payable",{"$f":"510000+38777+16000+12900","v":577677},null,{"$f":"593600+21360+12500+477","v":627937},null,{"$f":"652960+42086","v":695046},null,{"$f":"711726.4+1009","v":712735.4},null,520000,-17689.400000000023,-2.4819028211591598E-2,-67109,-9.6553321650653334E-2,-50260,-8.0039876611825711E-2]
["Mortgage payable",{"$f":"118400+654","v":119054},null,{"$f":"125504+255","v":125759},null,{"$f":"138054.4+25","v":138079.4},null,{"$f":"150479.296-6688","v":143791.296},null,195000,-5711.8960000000079,-3.9723517061839457E-2,-12320.399999999994,-8.9226923060210253E-2,-6705,-5.3316263647134599E-2]
["Long term liabilities",{"$f":"SUM(B26:B28)","v":904394},null,{"$f":"SUM(D26:D28)","v":975802},null,{"$f":"SUM(F26:F28)","v":1072859},null,{"$f":"SUM(H26:H28)","v":1116975.2},null,{"$f":"SUM(J26:J28)","v":895000},-44116.199999999953,-3.9496132053782357E-2,-97057,-9.046575551866555E-2,-71408,-7.3178780121377088E-2]
["Common stock",65000,null,65000,null,65000,null,65000,null,66300,0,0,0,0,0,0]
["Paid in capital",1545000,null,1545000,null,1545000,null,1545000,null,1410300,0,0,0,0,0,0]
["Retained earnings",{"$f":"1166744-299371+182555+36225+760+541192","v":1628105},null,{"$f":"1065744-386391-500+263+400500+72000-114000+415382","v":1452998},null,{"$f":"956030-236152+83252+54000+11000+49600+16004+330196","v":1263930},null,{"$f":"1238478-306857-50000+50923+69954-1374+329356","v":1330480},null,{"$f":"167100+194161","v":361261},-66550,-5.0019541819493717E-2,189068,0.14958739803628365,175107,0.12051427462391552]
["Total equity & liabilities",{"$f":"B25+B29+B30+B31+B32","v":4962806},null,{"$f":"D25+D29+D30+D31+D32","v":4847359},null,{"$f":"F25+F29+F30+F31+F32","v":4711322.5},null,{"$f":"H25+H29+H30+H31+H32","v":4680641.7280000001},null,{"$f":"J25+J29+J30+J31+J32","v":3484721},30680.771999999881,6.5548217067042053E-3,136036.5,2.8874376568362704E-2,115447,2.38164740841353E-2]
["Treasury stock",14560.000000000002,null,14560.000000000002,null,14560.000000000002,null,14560.000000000002,null,13000,0,0,0,0,0,0]
[null,{"$f":"B33-B34","v":4948246},null,{"$f":"D33-D34","v":4832799},null,{"$f":"F33-F34","v":4696762.5},null,{"$f":"H33-H34","v":4666081.7280000001},null,{"$f":"J33-J34","v":3471721},30680.771999999881,6.5752753141660961E-3,136036.5,2.8963887358579448E-2,115447,2.3888227091588124E-2]

{"sheet":"Ratios","index":27,"n_rows":118,"n_cols":8,"rows_kept":118,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"'Adj Trial Balances Prior Yrs'!C3","v":"Dec. 31, 2011"},null,{"$f":"'Adj Trial Balances Prior Yrs'!E3","v":"Dec. 31, 2010"},null,{"$f":"'Adj Trial Balances Prior Yrs'!G3","v":"Dec. 31, 2009"},null,"INDUSTRY"]
["Liquidity"]
["Current Ratio (One decimal place)",null,null,null,null,null,null,2.2000000000000002]
["Current assets",{"$f":"'[4]Comparative BS'!B10","v":2905654.8},null,{"$f":"'[4]Comparative BS'!D10","v":2788505.9760000003},null,{"$f":"'[4]Comparative BS'!F10","v":2647974.6736000003}]
["Current liabilities",{"$f":"'[4]Comparative BS'!B25","v":820307},null,{"$f":"'[4]Comparative BS'!D25","v":808559},null,{"$f":"'[4]Comparative BS'!F25","v":764533.5}]
["Current assets/Current liabilities",{"$f":"B4/B5","v":3.5421553150223022},null,{"$f":"D4/D5","v":3.4487353130693004},null,{"$f":"F4/F5","v":3.463516868260188}]
["Acid Test Ratio (One decimal place)",null,null,null,null,null,null,1.5]
["Liquid assets",{"$f":"'[4]Comparative BS'!B10-696308-28022","v":2181324.7999999998},null,{"$f":"'[4]Comparative BS'!D10-721053-27945","v":2039507.9760000003},null,{"$f":"'[4]Comparative BS'!F10-757584-26074","v":1864316.6736000003}]
["Current liabilities",{"$f":"'[4]Comparative BS'!B25","v":820307},null,{"$f":"'[4]Comparative BS'!D25","v":808559},null,{"$f":"'[4]Comparative BS'!F25","v":764533.5}]
["Liquid assets/Current liabilities",{"$f":"B8/B9","v":2.6591566328216141},null,{"$f":"D8/D9","v":2.5223984594816211},null,{"$f":"F8/F9","v":2.4385022678535346}]
[]
[]
["Receivables Turnover (One decimal place)",null,null,null,null,null,null,10]
["Net Sales",{"$f":"'[5]Comparative IS'!B7","v":7325197},null,{"$f":"'[5]Comparative IS'!D7","v":6081754.6000000006},null,{"$f":"'[5]Comparative IS'!F7","v":5951395.2720000008}]
[null,{"$f":"'[4]Comparative BS'!B5+1048769-20192-20674","v":2157896},null,{"$f":"'[4]Comparative BS'!D5+979226-20674-20463","v":1986858},null,{"$f":"'[4]Comparative BS'!F5+853307-20463-22959","v":1789110.8}]
["Average receivables=",{"$f":"2157896/2","v":1078948},null,{"$f":"1986858/2","v":993429},null,{"$f":"F15/2","v":894555.4}]
["Net Sales/Average receivables ",{"$f":"B14/B16","v":6.7892030014421456},null,{"$f":"D14/D16","v":6.1219821446726446},null,{"$f":"F14/F16","v":6.6529085532321428}]
[]
["Inventory Turnover (One decimal place)",null,null,null,null,null,null,9.5]
["Cost of goods sold",{"$f":"'[5]Comparative IS'!B9","v":5635022},null,{"$f":"'[5]Comparative IS'!D9","v":4616540},null,{"$f":"'[5]Comparative IS'!F9","v":4575156}]
[null,{"$f":"'Comparative BS'!D7+'Comparative BS'!B7","v":1417361.3599999999},null,{"$f":"'Comparative BS'!F7+'Comparative BS'!D7","v":1478637.8560000001},null,{"$f":"'Comparative BS'!H7+'Comparative BS'!F7","v":1617212.0966400001}]
["Average Inventory",{"$f":"B21/2","v":708680.67999999993},null,{"$f":"D21/2","v":739318.92800000007},null,{"$f":"F21/2","v":808606.04832000006}]
[]
["Cost of goods sold/Average inventory",{"$f":"B20/B22","v":7.9514260216604189},null,{"$f":"D20/D22","v":6.2443146322367653},null,{"$f":"F20/F22","v":5.6580778853999059}]
[]
["Profitability"]
[]
["Profit Margin (% with two decimal places)",null,null,null,null,null,null,7.4999999999999997E-2]
["Net Income",{"$f":"'Comparative IS'!B27","v":541192},null,{"$f":"'Comparative IS'!D27","v":415382.20000000019},null,{"$f":"'Comparative IS'!F27","v":330196.08400000108}]
["Net sales",{"$f":"'Comparative IS'!B7","v":7325197},null,{"$f":"'Comparative IS'!D7","v":6081754.6000000006},null,{"$f":"'Comparative IS'!F7","v":5951395.2720000008}]
["Net Income/Net Sales",{"$f":"B29/B30*100","v":7.3880879927188312},null,{"$f":"D29/D30*100","v":6.8299730475807117},null,{"$f":"F29/F30*100","v":5.548212963664179}]
["Asset Turnover (two decimal places)",null,null,null,null,null,null,1.9]
["Net sales",{"$f":"'Comparative IS'!B7","v":7325197},null,{"$f":"'Comparative IS'!D7","v":6081754.6000000006},null,{"$f":"'Comparative IS'!F7","v":5951395.2720000008}]
["Average Assets",{"$f":"B35/2","v":4890522.1333333328},null,{"$f":"D35/2","v":4764780.82},null,{"$f":"F35/2","v":4681422.3360106666}]
["Total Assets",{"$f":"'Comparative BS'!B19+'Comparative BS'!D19","v":9781044.2666666657},null,{"$f":"'Comparative BS'!D19+'Comparative BS'!F19","v":9529561.6400000006},null,{"$f":"'Comparative BS'!F19+'Comparative BS'!H19","v":9362844.6720213331}]
["Net sales/Average Assets",{"$f":"B33/B34","v":1.4978353640549247},null,{"$f":"D33/D34","v":1.2763975573592072},null,{"$f":"F33/F34","v":1.2712792918127438}]
[]
["Return on Assets (% one decimal place)",null,null,null,null,null,null,0.105]
["Net Income",{"$f":"'Comparative IS'!B27","v":541192},null,{"$f":"'Comparative IS'!D27","v":415382.20000000019},null,{"$f":"'Comparative IS'!F27","v":330196.08400000108}]
["Average Assets",{"$f":"B41/2","v":4890522.1333333328},null,{"$f":"D41/2","v":4764780.82},null,{"$f":"F41/2","v":4681422.3360106666}]
["Assets",{"$f":"'Comparative BS'!B19+'Comparative BS'!D19","v":9781044.2666666657},null,{"$f":"'Comparative BS'!D19+'Comparative BS'!F19","v":9529561.6400000006},null,{"$f":"'Comparative BS'!F19+'Comparative BS'!H19","v":9362844.6720213331}]
["Net Income / average assets",{"$f":"B39/B40*100","v":11.066139468243827},null,{"$f":"D39/D40*100","v":8.7177609147612412},null,{"$f":"F39/F40*100","v":7.0533282472732814}]
["Return on Common Shareholders' Equity"]
[" (One decimal place)",null,null,null,null,null,null,0.183]
["Net Income",{"$f":"'Comparative IS'!B27-B72","v":499592},null,{"$f":"'Comparative IS'!D27-D72","v":377882.20000000019},null,{"$f":"'Comparative IS'!F27-F72","v":295196.08400000108}]
["AverageStockholders equity",{"$f":"'Comparative BS'!B30+'Comparative BS'!B31+'Comparative BS'!B32","v":3238105},null,{"$f":"'Comparative BS'!D30+'Comparative BS'!D31+'Comparative BS'!D32","v":3062998},null,{"$f":"'Comparative BS'!F30+'Comparative BS'!F31+'Comparative BS'!F32","v":2873930}]
["Net Income -Dividend/Avg  Stockholders equity",{"$f":"B45/B46*100","v":15.428529958108214},null,{"$f":"D45/D46*100","v":12.337004464253654},null,{"$f":"F45/F46*100","v":10.271512667323181}]
[]
[]
[]
["Earnings per Share (EPS) (Two decimal places)",null,null,null,null,null,null,7.9]
["Net Income",{"$f":"'Comparative IS'!B27-B72","v":499592},null,{"$f":"'Comparative IS'!D27-D72","v":377882.20000000019},null,{"$f":"'Comparative IS'!F27-F72","v":295196.08400000108}]
["Weighted Average Common Shares ",65000,null,63000,null,63000]
["Net Income/ Weighted Average common shares",{"$f":"B52/B53","v":7.6860307692307694},null,{"$f":"D52/D53","v":5.9981301587301621},null,{"$f":"F52/F53","v":4.6856521269841442}]
[]
["Price-Earnings (P/E ) Ratio (Two decimal places)",null,null,null,null,null,null,10.72]
["Market Price per Share",56,null,52,null,50]
["EPS",{"$f":"B54","v":7.6860307692307694},null,{"$f":"D54","v":5.9981301587301621},null,{"$f":"F54","v":4.6856521269841442}]
["Market Price per Share /EPS",{"$f":"B57/B58","v":7.2859453313904146},null,{"$f":"D57/D58","v":8.6693683904666532},null,{"$f":"F57/F58","v":10.67087326266831}]
["Payout Ratio (% One decimal place)",null,null,null,null,null,null,6.5000000000000002E-2]
["Net Income",{"$f":"'Comparative IS'!B27","v":541192},null,{"$f":"'Comparative IS'!D27","v":415382.20000000019},null,{"$f":"'Comparative IS'!F27","v":330196.08400000108}]
["Common Dividend",{"$f":"83200*0.5","v":41600},null,{"$f":"75000*0.5","v":37500},null,{"$f":"70000*0.5","v":35000}]
["Common Dividend/Net Income ",{"$f":"B62/B61*100","v":7.686735945838076},null,{"$f":"D62/D61*100","v":9.0278302729389903},null,{"$f":"F62/F61*100","v":10.599762291547918}]
[]
["Solvency Ratios"]
[]
["Debt to Total Assets Ratio (% One decimal place)",null,null,null,null,null,null,0.42199999999999999]
["Total Debt",{"$f":"'Comparative BS'!B26+'Comparative BS'!B27+'Comparative BS'!B28+'Comparative BS'!B25","v":1724701},null,{"$f":"SUM('Comparative BS'!D26:D28)+'Comparative BS'!D25","v":1784361},null,{"$f":"SUM('Comparative BS'!F26:F28)+'Comparative BS'!F25","v":1837392.5}]
["Total Assets",{"$f":"'Comparative BS'!B19+'Comparative BS'!D19","v":9781044.2666666657},null,{"$f":"'Comparative BS'!D19+'Comparative BS'!F19","v":9529561.6400000006},null,{"$f":"'Comparative BS'!F19+'Comparative BS'!H19","v":9362844.6720213331}]
["Total Debt/ Total assets",{"$f":"B68/B69*100","v":17.633096763274033},null,{"$f":"D68/D69*100","v":18.724481433754594},null,{"$f":"F68/F69*100","v":19.624297575827747}]
[null,"Dec. 31, 2011",null,"Dec. 31, 2010",null,"Dec. 31, 2009"]
["Common Dividends",{"$f":"83200*0.5","v":41600},null,{"$f":"75000*0.5","v":37500},null,{"$f":"70000*0.5","v":35000}]
["Weighted Average Common Shares ",65000,null,63000,null,63000]
["Market Price per Share",56,null,52,null,50]
[]
[]
[]
["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."]
[]
["Ideal Current ratio is 2:1.Company's current ratio is improving from year to year.This means that the finacial position "]
["of the compny is good and they are able to pay its liabilities easily.Company 's current ratio is also more from industrys ratio."]
[]
["Ideal acid test ratio is 1:1.It is also increasing from year to year.this means that company is able to payoff its debts easily."]
["Industry's acid test ratio is 1:5 but comapnys ratio is more, it shows that company has sound financial position."]
[]
["Receivable turnover ratio is increasing in 2011 but industry's ratio is more which shows that th company is not "]
["able to collect its receivables in time.In this case company must make efforts to collect the receivables."]
[]
["Inventoy turnover ratio is also less than the industry's turnover ratio which shows that it takes time to convert inventory "]
["in cash."]
[]
["Company's net income is increasing from year to year which is a good sign for the company and it nearly equal to "]
["industry's ratio."]
[]
["Assets turnover ratio is slightly less than the industry's ratio which means company is not efficiently utilising its assets "]
["and it also indicates deficiency osfsales as compared to capital employed"]
[]
["There is a increasing trend of company's retun on total assets but still it is less than the industry's average which means "]
["that company must pay attention for the efficient utilisation of the assets."]
[]
["There is a increasing trend in the comapnys return on shareholders equity but less than the industry's average which"]
["means that return to shareholders is less than the industry."]
[]
["Company's EPS Is incraesing and it is more than industry's average which means that company's market price of the share "]
["is more than the industry's market price of share."]
[]
["There is decreasing trend of company's price earning ratio and it is also less than the company's industry's ratio which shows that "]
["company's will not be able to maintain its goodwill in near future."]
[]
["Comapnys payout ratio is decresing from year to year but more than the industry's ratio which shows that company is "]
["paying more dividend to its shareholders in the beginning but decreases gradually"]
[]
["There is a decreasing trend in the debt to total assets ratio but it is very much less than the industry's average "]
["which means that the total assets has not been purchased on credit which is a good sign for the company."]

{"sheet":"Adj Trial Balances Prior Yrs","index":28,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
[null,"B/S Adjuster",1.1200000000000001,{"$f":"C1","v":1.1200000000000001},1.06,{"$f":"E1","v":1.06},1.1000000000000001,{"$f":"G1","v":1.1000000000000001},1.0900000000000001,1.0900000000000001]
[null,"I/S Adjuster",12,12,1.02,{"$f":"E2","v":1.02},1.02,{"$f":"G2","v":1.02},1.01,{"$f":"I2","v":1.01}]
[null,null,"Dec. 31, 2011",null,"Dec. 31, 2010",null,"Dec. 31, 2009",null,"Dec. 31, 2008",null,"2011-07-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":"'Chart of Accounts GL'!A9","v":100},{"$f":"'Chart of Accounts GL'!B9","v":"Cash"},{"$f":"940547+43558-1905+9663+38777+16000+654+1933-740-6880+242-3201-850+1100+380-4650+12900","v":1047528},0,{"$f":"840436.688+34564-1003-4201+2025+8410+21360+255+72000+542-31222-72-3654+159-2611-1446-10+555+370-4800+63444+12500","v":1007601.688},0,{"$f":"924480.3568+4455-3302-134+4668-4850+558+42086+25-12936+1800-1411-1500-987-2351-644-75+89-107-5400-43000","v":901464.35679999995},0,{"$f":"892521+22391+4662-4889+4227+1009-6688+23-11860+3090+1238-1695-1114-12663+800","v":891052},0,584120]
[{"$f":"'Chart of Accounts GL'!A10","v":102},{"$f":"'Chart of Accounts GL'!B10","v":"Accounts Receivable"},{"$f":"1458752+696126-961267-43558-60","v":1149993},0,{"$f":"876408+1393991-571886-334552-217184-34564-63444","v":1048769},0,{"$f":"964048.8-56972-4455+11000+49600+16004","v":979225.8},0,{"$f":"875698-22391","v":853307},0,515000]
[{"$f":"'Chart of Accounts GL'!A11","v":103},{"$f":"'Chart of Accounts GL'!B11","v":"Allowance for Doubtful Accounts"},0,{"$f":"15680+4512","v":20192},0,{"$f":"16620.8+4053","v":20673.8},0,{"$f":"18282.88+13980-11800","v":20462.88},0,{"$f":"19928.3392+3031","v":22959.339199999999},null,14042]
[{"$f":"'Chart of Accounts GL'!A12","v":104},{"$f":"'Chart of Accounts GL'!B12","v":"Merchandise Inventory"},{"$f":"600254+96054","v":696308},0,{"$f":"632031.36+89022","v":721053.36},0,{"$f":"695234.496+62350","v":757584.49600000004},0,{"$f":"757805.60064+101822","v":859627.60063999996},0,329050]
[{"$f":"'Chart of Accounts GL'!A13","v":105},{"$f":"'Chart of Accounts GL'!B13","v":"Office Supplies"},{"$f":"2648.8+1347","v":3995.8},0,{"$f":"2807.728+1003","v":3810.7280000000001},0,{"$f":"3088.5008+1000","v":4088.5007999999998},0,{"$f":"3366.465872+1149-220","v":4295.4658720000007},0,2365]
[{"$f":"'Chart of Accounts GL'!A14","v":106},{"$f":"'Chart of Accounts GL'!B14","v":"Prepaid Insurance"},{"$f":"22400+5622","v":28022},0,{"$f":"23744+4201","v":27945},0,{"$f":"26118.4-44","v":26074.400000000001},0,{"$f":"28730.24-3234-202","v":25294.240000000002},0,20000]
[{"$f":"'Chart of Accounts GL'!A16","v":140},{"$f":"'Chart of Accounts GL'!B16","v":"Land"},2000600,0,2000600,0,2000600,0,2000600,0,2000600]
[{"$f":"'Chart of Accounts GL'!A17","v":145},{"$f":"'Chart of Accounts GL'!B17","v":"Building"},1500000,null,1500000,null,1500000,null,1500000,null,1500000]
[{"$f":"'Chart of Accounts GL'!A18","v":146},{"$f":"'Chart of Accounts GL'!B18","v":"Accumulated Depreciation - Building"},null,1500000,null,1500000,null,1500000,null,1500000,null,1500000]
[{"$f":"'Chart of Accounts GL'!A19","v":151},{"$f":"'Chart of Accounts GL'!B19","v":"Equipment & Furniture - Warehouse"},33600,0,35616,0,39177.600000000006,0,42703.584000000003,0,30000]
[{"$f":"'Chart of Accounts GL'!A20","v":152},{"$f":"'Chart of Accounts GL'!B20","v":"Accumulated Depreciation - Equip & Furn. - Warehouse"},0,{"$f":"2286.66666666667+302","v":2588.6666666666702},0,{"$f":"2423.86666666667+263","v":2686.86666666667},0,{"$f":"2666.25333333333-222","v":2444.2533333333299},0,{"$f":"2906.21613333333-395","v":2511.2161333333302},null,2041.6666666666667]
[{"$f":"'Chart of Accounts GL'!A21","v":153},{"$f":"'Chart of Accounts GL'!B21","v":"Equipment & Furniture - Office"},{"$f":"9520+3789","v":13309},0,{"$f":"10091.2+3300","v":13391.2},0,{"$f":"11100.32+3302","v":14402.32},0,{"$f":"12099.3488+4662","v":16761.3488},0,8500]
[{"$f":"'Chart of Accounts GL'!A22","v":154},{"$f":"'Chart of Accounts GL'!B22","v":"Accumulated Depreciation - Equip & Furn. - Office"},0,{"$f":"2049.6+280","v":2329.6},0,{"$f":"2172.576+455","v":2627.576},0,{"$f":"2389.4336+558","v":2947.4335999999998},0,{"$f":"2604.918624-516","v":2088.9186239999999},null,1830]
[{"$f":"'Chart of Accounts GL'!A26","v":201},{"$f":"'Chart of Accounts GL'!B26","v":"Accounts Payable"},0,{"$f":"800254+1347+5622+3789","v":811012},0,{"$f":"795412+3300","v":798712},0,{"$f":"621254+1000+44+80026+41000+13000","v":756324},0,{"$f":"502102+1149-3234+9324+104500","v":613841},null,741860]
[{"$f":"'Chart of Accounts GL'!A27","v":202},{"$f":"'Chart of Accounts GL'!B27","v":"Wages Payable"},0,0,0,0,0,0,0,0]
[{"$f":"'Chart of Accounts GL'!A28","v":203},{"$f":"'Chart of Accounts GL'!B28","v":"Interest Payable"},0,0,0,0,0,0,0,0]
[{"$f":"'Chart of Accounts GL'!A29","v":204},{"$f":"'Chart of Accounts GL'!B29","v":"Dividends Payable"},0,0,0,0,0,0,0,0]
[{"$f":"'Chart of Accounts GL'!A30","v":205},{"$f":"'Chart of Accounts GL'!B30","v":"Unearned Rent"},0,{"$f":"11200-1905","v":9295},0,{"$f":"11872-2025","v":9847},0,{"$f":"13059.5-4850","v":8209.5},0,{"$f":"14234.528-4889","v":9345.5280000000002},null,10000]
[{"$f":"'Chart of Accounts GL'!A32","v":250},{"$f":"'Chart of Accounts GL'!B32","v":"Notes Payable"},0,{"$f":"198000+9663","v":207663},0,{"$f":"213696+8410","v":222106},0,{"$f":"235065.6+4668","v":239733.6},0,{"$f":"256221.504+4227","v":260448.50399999999},null,180000]
[{"$f":"'Chart of Accounts GL'!A33","v":251},{"$f":"'Chart of Accounts GL'!B33","v":"Bonds Payable"},0,{"$f":"510000+38777+16000+12900","v":577677},0,{"$f":"593600+21360+12500+477","v":627937},0,{"$f":"652960+42086","v":695046},0,{"$f":"711726.4+1009","v":712735.4},null,520000]
[{"$f":"'Chart of Accounts GL'!A34","v":252},{"$f":"'Chart of Accounts GL'!B34","v":"Mortgage (Warehouse) Payable"},0,{"$f":"118400+654","v":119054},0,{"$f":"125504+255","v":125759},0,{"$f":"138054.4+25","v":138079.4},0,{"$f":"150479.296-6688","v":143791.296},null,195000]
[{"$f":"'Chart of Accounts GL'!A36","v":300},{"$f":"'Chart of Accounts GL'!B36","v":"Common Stock, $1 Par, 125,000 Authorized; 75,000 shares Issued/Outstanding"},0,65000,0,65000,0,65000,0,65000,null,66300]
[{"$f":"'Chart of Accounts GL'!A37","v":301},{"$f":"'Chart of Accounts GL'!B37","v":"Paid In Capital - Excess of Par"},0,1545000,0,1545000,0,1545000,0,1545000,null,1410300]
[{"$f":"'Chart of Accounts GL'!A38","v":330},{"$f":"'Chart of Accounts GL'!B38","v":"Retained Earnings"},0,{"$f":"1166744-299371+182555+36225+760","v":1086913},null,{"$f":"1065744-386391-500+263+400500+72000-114000","v":1037616},null,{"$f":"956030-236152+83252+54000+11000+49600+16004","v":933734},null,{"$f":"1238478-306857-50000+50923+69954-1374","v":1001124},null,167100]
[{"$f":"'Chart of Accounts GL'!A39","v":340},{"$f":"'Chart of Accounts GL'!B39","v":"Treasury Stock"},14560.000000000002,0,14560.000000000002,0,14560.000000000002,0,14560.000000000002,0,13000]
[{"$f":"'Chart of Accounts GL'!A42","v":500},{"$f":"'Chart of Accounts GL'!B42","v":"Sales"},0,{"$f":"7564325+24670","v":7588995},0,{"$f":"6255371+4050+73502+14000+30000","v":6376923},0,{"$f":"6354521+26786-80026-43000-41000-13000","v":6204281},0,{"$f":"5689605+168472-34977","v":5823100},null,750000]
[{"$f":"'Chart of Accounts GL'!A43","v":510},{"$f":"'Chart of Accounts GL'!B43","v":"Sales Discounts"},{"$f":"140254+(0.6*24670)","v":155056},0,{"$f":"123746.4+(73502*0.6)","v":167847.59999999998},0,{"$f":"126221.328+(26786*0.3)","v":134257.128},0,{"$f":"100142+13990.8","v":114132.8},0,10110]
[{"$f":"'Chart of Accounts GL'!A44","v":511},{"$f":"'Chart of Accounts GL'!B44","v":"Sales Returns & Allowances"},{"$f":"98874+(24670*0.4)","v":108742},0,{"$f":"97920+(73502*0.4)","v":127320.8},0,{"$f":"99878.4+(26786*0.7)","v":118628.59999999999},0,{"$f":"100877.184+20986.2","v":121863.38399999999},0,8000]
[{"$f":"'Chart of Accounts GL'!A46","v":600},{"$f":"'Chart of Accounts GL'!B46","v":"Cost of Goods Sold"},{"$f":"5548521-96054+182555","v":5635022},0,{"$f":"4375062-89022+400500-114000+14000+30000","v":4616540},0,{"$f":"4500254-62350+83252+54000","v":4575156},null,{"$f":"4150254-101822+50923+104500","v":4203855},null,{"$f":"349715+107317","v":457032}]
[{"$f":"'Chart of Accounts GL'!A48","v":700},{"$f":"'Chart of Accounts GL'!B48","v":"Wage Expense (hourly workers)"},{"$f":"95410-1933","v":93477},0,{"$f":"87148.8-542","v":86606.8},0,{"$f":"88891.776-104","v":88787.775999999998},0,{"$f":"89780.69376-23","v":89757.693759999995},0,7120]
[{"$f":"'Chart of Accounts GL'!A49","v":701},{"$f":"'Chart of Accounts GL'!B49","v":"Salaries Expense (Exempt Staff)"},{"$f":"510000+36225","v":546225},0,{"$f":"501840+31222","v":533062},0,{"$f":"511876.8+13040","v":524916.80000000005},0,{"$f":"516995.568+11860","v":528855.56799999997},0,41000]
[{"$f":"'Chart of Accounts GL'!A50","v":702},{"$f":"'Chart of Accounts GL'!B50","v":"Marketing Expense"},{"$f":"20540+740","v":21280},0,{"$f":"18360+72","v":18432},0,{"$f":"18727.2-1800","v":16927.2},0,{"$f":"18914.472-3090","v":15824.472000000002},0,1500]
[{"$f":"'Chart of Accounts GL'!A51","v":703},{"$f":"'Chart of Accounts GL'!B51","v":"Travel and Entertainment Expense"},{"$f":"10580+6880","v":17460},0,{"$f":"9792+3654","v":13446},0,{"$f":"9987.84+1411","v":11398.84},0,{"$f":"10087.7184-1238","v":8849.7183999999997},0,800]
[{"$f":"'Chart of Accounts GL'!A52","v":704},{"$f":"'Chart of Accounts GL'!B52","v":"Bad Debt Expense"},{"$f":"185202+4512","v":189714},0,{"$f":"110160+4053","v":114213},0,{"$f":"112363.2+13980-11800","v":114543.2},0,{"$f":"113486.832+3031","v":116517.83199999999},0,9000]
[{"$f":"'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]
[{"$f":"'Chart of Accounts GL'!A54","v":706},{"$f":"'Chart of Accounts GL'!B54","v":"Maintenance & Repair Expense"},{"$f":"6000-242","v":5758},0,{"$f":"6120-159","v":5961},0,{"$f":"6242.4+1500","v":7742.4},0,{"$f":"6304.824+1695","v":7999.8239999999996},0,500]
[{"$f":"'Chart of Accounts GL'!A55","v":707},{"$f":"'Chart of Accounts GL'!B55","v":"Legal Expenses"},{"$f":"64000+3201","v":67201},0,{"$f":"63000+2611","v":65611},0,{"$f":"62424+987","v":63411},0,{"$f":"63048.24-5374","v":57674.239999999998},0,5060]
[{"$f":"'Chart of Accounts GL'!A56","v":708},{"$f":"'Chart of Accounts GL'!B56","v":"Insurance Expense"},{"$f":"48000+850","v":48850},0,{"$f":"48960+1446","v":50406},0,{"$f":"49939.2+2351","v":52290.2},0,{"$f":"50438.592+202+3555","v":54195.591999999997},0,4300]
[{"$f":"'Chart of Accounts GL'!A57","v":709},{"$f":"'Chart of Accounts GL'!B57","v":"Utilities Expense"},{"$f":"18000+60","v":18060},0,{"$f":"18360+10","v":18370},0,{"$f":"18727.2+644","v":19371.2},0,{"$f":"18914.472+1114","v":20028.472000000002},0,1750]
[{"$f":"'Chart of Accounts GL'!A58","v":710},{"$f":"'Chart of Accounts GL'!B58","v":"Office Supplies Expense"},{"$f":"5220-1100","v":4120},0,{"$f":"5324.4-555","v":4769.3999999999996},0,{"$f":"5430.988+75","v":5505.9880000000003},0,{"$f":"5485.19688+220","v":5705.1968800000004},0,435]
[{"$f":"'Chart of Accounts GL'!A59","v":711},{"$f":"'Chart of Accounts GL'!B59","v":"Telecommunications Expense"},0,0,0,0,0,0,0,0]
[{"$f":"'Chart of Accounts GL'!A60","v":712},{"$f":"'Chart of Accounts GL'!B60","v":"Depreciation Expense -  Equip & Furniture - Warehouse"},{"$f":"1700+302","v":2002},0,{"$f":"1732+263","v":1995},0,{"$f":"1768.68-89","v":1679.68},0,{"$f":"1786.3668-395","v":1391.3668},0,141.66666666666666]
[{"$f":"'Chart of Accounts GL'!A61","v":713},{"$f":"'Chart of Accounts GL'!B61","v":"Depreciation Expense - Equip & Furniture - Office"},{"$f":"3526+280","v":3806},0,{"$f":"2815.2+455","v":3270.2},0,{"$f":"2871.504+107","v":2978.5039999999999},0,{"$f":"2900.21904-516","v":2384.2190399999999},0,230]
[{"$f":"'Chart of Accounts GL'!A63","v":800},{"$f":"'Chart of Accounts GL'!B63","v":"Rent Income"},0,{"$f":"24000-380","v":23620},0,{"$f":"24480-370","v":24110},0,24969.599999999999,0,{"$f":"25220.296+355","v":25575.295999999998},null,3640]
[{"$f":"'Chart of Accounts GL'!A65","v":900},{"$f":"'Chart of Accounts GL'!B65","v":"Interest Expense"},{"$f":"150000+4650","v":154650},0,{"$f":"153000+4800","v":157800},0,{"$f":"156060+5400","v":161460},0,{"$f":"157620.6+12663","v":170283.6},0,12500]
[]
[null,"Total",{"$f":"SUM(C7:C52)","v":13559338.800000001},{"$f":"SUM(D7:D52)","v":13559339.266666666},12358997.776000001,12358998.242666665,12136231.989599999,12136231.666933334,11727520.218191998,11727520.497957334,5562113.666666667,5562113.666666667]

{"sheet":"Sheet1","index":29,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet2","index":30,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}