{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Analysis","Cash Flow","Profit & Loss","Balance Sheet","Instructions"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Analysis","index":0,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","2014-07-01","2014-08-01","2014-09-01","2014-10-01"]
["Total Sales",{"$f":"RANDBETWEEN(1,100)","v":8},20,72,12,72,96,2,46,35,22]
["Gross Margin",60,93,6,27,18,56,57,31,15,2]
["Net Income",15,14,53,2,100,17,41,2,28,88]
[]
["Propane Gross Margin",{"$f":"RANDBETWEEN(1,100)","v":81},89,25,6,60,30,11,59,17,14]
["Retail Gross Margin",75,10,53,3,37,18,65,75,95,34]
["Salary as Percentage of Sales",93,71,38,70,91,77,10,29,23,98]
[]
["Current Ratio",{"$f":"RANDBETWEEN(1,100)","v":67},87,14,64,32,86,90,57,25,72]
["Quick Ratio",18,86,23,14,98,93,95,2,93,79]
["Return on Assets",98,86,48,32,61,31,21,83,35,4]

{"sheet":"Cash Flow","index":1,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[37,0,37,11],[0,0,0,11],[1,0,1,11],[2,0,2,11]]}
["Altitude Equipment Rentals, LLC"]
["Statement of Cash Flows"]
["January - October, 2014"]
[]
[null,"Jan 2014","Feb 2014","Mar 2014","Apr 2014","May 2014","Jun 2014","Jul 2014","Aug 2014","Sep 2014","Oct 2014","Total"]
["OPERATING ACTIVITIES"]
["   Net Income",{"$f":"RANDBETWEEN(1,100)","v":22},9,59,96,30,76,2,43,3,88,32]
["   Adjustments to reconcile Net Income to Net Cash provided by operations:",null,null,null,null,null,null,null,null,null,null,{"$f":"(((((((((B8)+(C8))+(D8))+(E8))+(F8))+(G8))+(H8))+(I8))+(J8))+(K8)","v":0}]
["      Accounts Receivable (A/R)",68,31,69,95,74,20,97,37,51,2,20]
["      Inventory Asset",29,57,100,99,41,62,26,64,9,14,46]
["      Prepaid Expenses:Prepaid Insurance",12,81,78,84,63,97,45,31,34,77,67]
["      Leasehold Improvements:Accumulated Depreciation",71,98,73,49,3,58,59,40,79,21,86]
["      Other fixed assets:Accumulated Depreciation",22,49,49,1,40,11,43,1,74,94,70]
["      Rental Equipment:Accumulated Depreciation",98,35,67,49,36,84,24,79,3,66,35]
["      Shop Tools:Accumulated Depreciation",64,95,81,87,18,60,66,22,57,45,2]
["      Vehicles:Accumulated Depreciation",1,7,88,45,32,94,69,58,71,65,57]
["      Accounts Payable (A/P)",60,88,68,85,64,64,89,72,31,21,27]
["      Visa Account (XXXXXXXXXXXX 2915)",17,30,83,57,60,18,37,87,28,34,44]
["      Visa Account (XXXXXXXXXXXXXXX 3111)",61,84,65,45,88,82,64,66,44,32,16]
["      Sales tax payable",36,21,12,29,5,50,9,11,71,36,98]
["      Utah State Tax Payable",77,86,24,78,29,45,2,38,4,78,36]
["      Wages Payable",53,48,83,58,13,2,4,91,70,55,41]
["Net cash provided by operating activities",{"$f":"(((((((((((((((B7)+(B8))+(B9))+(B10))+(B11))+(B12))+(B13))+(B14))+(B15))+(B16))+(B17))+(B18))+(B19))+(B20))+(B21))+(B22)","v":691},819,999,957,596,823,636,740,629,728,7618]
["INVESTING ACTIVITIES"]
["   Leasehold Improvements:Original Cost",{"$f":"RANDBETWEEN(1,100)","v":61},20,79,76,37,58,79,54,21,50,69]
["   Rental Equipment:Original Cost",18,59,71,58,88,16,29,17,52,11,47]
["Net cash provided by investing activities",{"$f":"(B25)+(B26)","v":79},79,150,134,125,74,108,71,73,61,{"$f":"(((((((((B27)+(C27))+(D27))+(E27))+(F27))+(G27))+(H27))+(I27))+(J27))+(K27)","v":954}]
["FINANCING ACTIVITIES"]
["   Notes Payable",{"$f":"RANDBETWEEN(1,100)","v":83},25,97,57,59,51,41,40,46,2,55]
["   Shane Olson Contributions",39,49,58,2,6,91,61,77,58,23,9]
["Net cash provided by financing activities",{"$f":"(B29)+(B30)","v":122},74,155,59,65,142,102,117,104,25,{"$f":"(((((((((B31)+(C31))+(D31))+(E31))+(F31))+(G31))+(H31))+(I31))+(J31))+(K31)","v":965}]
["Net cash increase for period",{"$f":"((B23)+(B27))+(B31)","v":892},972,1304,1150,786,1039,846,928,806,814,9537]
["Cash at beginning of period",null,null,null,null,null,null,null,null,null,null,0]
["Cash at end of period",{"$f":"(B32)+(B33)","v":892},972,1304,1150,786,1039,846,928,806,814,9537]
[]
[]
[]
["Friday, Nov 21, 2014 03:03:08 PM PST GMT-7"]

{"sheet":"Profit & Loss","index":2,"n_rows":82,"n_cols":12,"rows_kept":82,"cut":false,"hidden":false,"merged":[[81,0,81,11],[0,0,0,11],[1,0,1,11],[2,0,2,11]]}
["Altitude Equipment Rentals, LLC"]
["Profit and Loss"]
["January - October, 2014"]
[]
[null,"Jan 2014","Feb 2014","Mar 2014","Apr 2014","May 2014","Jun 2014","Jul 2014","Aug 2014","Sep 2014","Oct 2014","Total"]
["Income"]
["   Discounts/Cancelled Orders Given",{"$f":"RANDBETWEEN(1,100)","v":9},63,97,32,89,78,52,83,29,44,31]
["   Rental Revenue",23,15,29,89,7,87,72,9,77,70,64]
["   Retail Revenue",87,76,26,51,53,15,17,90,99,21,6]
["      Propane Revenue",56,76,49,93,38,98,97,93,67,99,83]
["   Total Retail Revenue",{"$f":"(B9)+(B10)","v":143},152,75,144,91,113,114,183,166,120,{"$f":"(((((((((B11)+(C11))+(D11))+(E11))+(F11))+(G11))+(H11))+(I11))+(J11))+(K11)","v":1301}]
["   Service Revenue",60,89,53,91,37,91,73,77,42,1,64]
["   U-Haul Revenue",100,68,81,56,69,11,69,35,27,43,85]
["Total Income",{"$f":"((((B7)+(B8))+(B11))+(B12))+(B13)","v":335},387,335,412,293,380,380,387,341,278,3528]
["Cost of Goods Sold"]
["   Cost of Goods Sold",{"$f":"RANDBETWEEN(1,100)","v":89},88,90,42,30,20,69,73,38,52,96]
["      Propane COGS",2,55,17,43,96,84,84,66,65,88,94]
["   Total Cost of Goods Sold",{"$f":"(B16)+(B17)","v":91},143,107,85,126,104,153,139,103,140,{"$f":"(((((((((B18)+(C18))+(D18))+(E18))+(F18))+(G18))+(H18))+(I18))+(J18))+(K18)","v":1191}]
["   Cost of U-Haul Sales",{"$f":"RANDBETWEEN(1,100)","v":2},{"$f":"189.53","v":189.53},{"$f":"863.6","v":863.6},{"$f":"491.84","v":491.84},{"$f":"1126.18","v":1126.18},{"$f":"480.33","v":480.33},{"$f":"509.52","v":509.52},{"$f":"555.37","v":555.37},{"$f":"437.5","v":437.5},{"$f":"392.66","v":392.66},5048.53]
["Total Cost of Goods Sold",{"$f":"(B18)+(B19)","v":93},332.53,970.6,576.83999999999992,1252.18,584.32999999999993,662.52,694.37,540.5,532.66000000000008,6239.53]
["Gross Profit",{"$f":"(B14)-(B20)","v":242},54.470000000000027,-635.6,-164.83999999999992,-959.18000000000006,-204.32999999999993,-282.52,-307.37,-199.5,-254.66000000000008,-2711.5299999999997]
["Expenses"]
["   Advertising",{"$f":"RANDBETWEEN(1,100)","v":25},90,32,99,79,20,7,18,54,8,56]
["   Bad Debts",25,25,90,83,65,9,64,67,78,22,42]
["   Bank Charges",70,44,73,57,63,98,91,82,69,17,54]
["   Building Maintenance",8,90,16,71,1,58,96,2,30,71,8]
["   Commissions & fees",80,72,11,71,18,26,94,57,34,64,15]
["   Contract Labor",73,57,15,61,85,90,4,37,92,94,48]
["   Disposal Fees",33,16,97,4,76,47,67,55,97,77,82]
["   Dues & subscriptions",72,60,59,64,79,96,2,13,73,74,90]
["   Fuel - Large Machinery",28,63,72,16,27,40,16,65,95,40,19]
["   Fuel - Small Machinery",24,68,61,7,49,9,43,92,76,90,32]
["   Fuel - Vehicles",22,17,6,30,46,69,53,53,74,92,81]
["   Insurance",98,36,61,11,46,75,58,97,38,100,11]
["   Interest Expense",76,28,53,56,78,83,78,97,17,89,93]
["   Late Fees",35,32,79,19,90,36,30,39,73,71,44]
["   Legal & Professional Fees",79,69,7,77,62,93,1,73,61,42,29]
["      Accounting/Order Software Fees",72,40,31,29,1,8,97,94,64,42,75]
["      Alarm System Monitoring",{"$f":"RANDBETWEEN(1,100)","v":95},18,75,17,92,41,70,28,7,81,74]
["      Legal Fees",32,37,13,18,18,86,49,39,82,51,52]
["      Merchant Processing Fees",19,69,55,39,69,77,65,84,44,35,79]
["      Payroll Servicing",67,99,15,11,83,43,37,22,100,26,59]
["   Total Legal & Professional Fees",{"$f":"(((((B37)+(B38))+(B39))+(B40))+(B41))+(B42)","v":364},332,196,191,325,348,319,340,358,277,{"$f":"(((((((((B43)+(C43))+(D43))+(E43))+(F43))+(G43))+(H43))+(I43))+(J43))+(K43)","v":3050}]
["   Meals and Entertainment",null,null,null,null,null,{"$f":"RANDBETWEEN(1,100)","v":63},33,34,75,31,74]
["   Office Supplies",{"$f":"RANDBETWEEN(1,100)","v":15},43,10,100,35,32,50,66,11,4,28]
["   Other General and Admin Expenses",38,17,90,98,37,93,67,14,98,57,87]
["   Registration & Dues",68,16,31,79,41,73,49,61,99,37,87]
["   Rent or Lease",79,68,79,98,82,14,53,3,47,72,19]
["   Rental Equipment Maintenance",35,18,95,23,80,75,53,4,86,94,41]
["   Rental Equipment Repairs",41,44,23,47,36,7,44,8,18,59,99]
["   Rental Split",74,28,13,3,95,70,88,3,87,78,66]
["   Rerent Expense",5,9,58,1,52,93,5,29,48,28,78]
["   Salaries & Wages",1,3,64,86,17,96,29,95,76,99,56]
["      Auto/Cell Reimbursement",87,3,66,73,26,18,36,63,16,9,31]
["      Insurance Stipend",68,3,97,61,49,77,45,28,67,96,43]
["      Payroll Taxes",53,45,83,87,86,7,94,12,8,70,96]
["   Total Salaries & Wages",{"$f":"(((B53)+(B54))+(B55))+(B56)","v":209},54,310,307,178,198,204,198,167,274,2099]
["   Shipping and delivery expense",{"$f":"RANDBETWEEN(1,100)","v":22},4,41,34,44,60,88,16,5,45,53]
["      Transport",49,29,66,29,60,42,91,67,94,98,70]
["   Total Shipping and delivery expense",{"$f":"(B58)+(B59)","v":71},33,107,63,104,102,179,83,99,143,984]
["   Shop Supplies/Tools",{"$f":"RANDBETWEEN(1,100)","v":41},55,73,28,76,93,8,40,55,25,2]
["   Small Engine Repair",64,13,8,63,20,61,33,99,59,37,78]
["   Taxes & Licenses",76,43,18,57,40,18,54,8,17,79,77]
["   Utilities",13,21,67,41,12,58,35,98,25,1,55]
["   Vehicle Maintenance",59,52,63,24,15,98,34,85,28,98,64]
["Total Expenses",{"$f":"((((((((((((((((((((((((((((((B23)+(B24))+(B25))+(B26))+(B27))+(B28))+(B29))+(B30))+(B31))+(B32))+(B33))+(B34))+(B35))+(B36))+(B43))+(B44))+(B45))+(B46))+(B47))+(B48))+(B49))+(B50))+(B51))+(B52))+(B57))+(B60))+(B61))+(B62))+(B63))+(B64))+(B65)","v":1921},1544,1966,1872,2030,2252,2011,1947,2277,2303,20123]
["Net Operating Income",{"$f":"(B21)-(B66)","v":-1679},-1489.53,-2601.6,-2036.84,-2989.1800000000003,-2456.33,-2293.52,-2254.37,-2476.5,-2557.66,-22834.53]
["Other Income"]
["   Gain on Sale of Rental Equipment",{"$f":"RANDBETWEEN(1,100)","v":97},34,74,82,41,100,57,17,78,43,86]
["   Interest Earned",28,53,32,93,50,32,72,86,55,83,54]
["   Loss on Sale of Equipment",22,64,84,82,29,87,29,16,16,33,79]
["Total Other Income",{"$f":"((B69)+(B70))+(B71)","v":147},151,190,257,120,219,158,119,149,159,{"$f":"(((((((((B72)+(C72))+(D72))+(E72))+(F72))+(G72))+(H72))+(I72))+(J72))+(K72)","v":1669}]
["Other Expenses"]
["   Depreciation Expense",{"$f":"RANDBETWEEN(1,100)","v":64},2,81,45,65,10,55,57,37,99,55]
["   Miscellaneous",58,66,29,24,75,57,28,43,48,83,44]
["Total Other Expenses",{"$f":"(B74)+(B75)","v":122},68,110,69,140,67,83,100,85,182,{"$f":"(((((((((B76)+(C76))+(D76))+(E76))+(F76))+(G76))+(H76))+(I76))+(J76))+(K76)","v":1026}]
["Net Other Income",{"$f":"(B72)-(B76)","v":25},83,80,188,-20,152,75,19,64,-23,{"$f":"(((((((((B77)+(C77))+(D77))+(E77))+(F77))+(G77))+(H77))+(I77))+(J77))+(K77)","v":643}]
["Net Income",{"$f":"(B67)+(B77)","v":-1654},-1406.53,-2521.6,-1848.84,-3009.1800000000003,-2304.33,-2218.52,-2235.37,-2412.5,-2580.66,{"$f":"(((((((((B78)+(C78))+(D78))+(E78))+(F78))+(G78))+(H78))+(I78))+(J78))+(K78)","v":-22191.53}]
[]
[]
[]
["Friday, Nov 21, 2014 02:34:06 PM PST GMT-7 - Accrual Basis"]

{"sheet":"Balance Sheet","index":3,"n_rows":79,"n_cols":11,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,0,78,10],[0,0,0,10],[1,0,1,10],[2,0,2,10]]}
["Altitude Equipment Rentals, LLC"]
["Balance Sheet"]
["As of October 31, 2014"]
[]
[null,"Jan 2014","Feb 2014","Mar 2014","Apr 2014","May 2014","Jun 2014","Jul 2014","Aug 2014","Sep 2014","Oct 2014"]
["ASSETS"]
["   Current Assets"]
["      Bank Accounts"]
["         Basic Business Checking (XXXXXXX 55-9)",{"$f":"RANDBETWEEN(1,100)","v":1},37,39,77,37,16,88,54,18,55]
["         Business Gold Stmt Savings (XXXXXXXX 57-4)",79,59,57,2,45,95,64,11,45,26]
["         Cash Drawer",34,84,3,74,55,58,6,30,7,17]
["      Total Bank Accounts",{"$f":"((B9)+(B10))+(B11)","v":114},180,99,153,137,169,158,95,70,98]
["      Accounts Receivable"]
["         Accounts Receivable (A/R)",{"$f":"RANDBETWEEN(1,100)","v":33},26,7,97,44,76,36,91,95,36]
["      Total Accounts Receivable",{"$f":"B14","v":33},26,7,97,44,76,36,91,95,36]
["      Other current assets"]
["         Inventory Asset",{"$f":"RANDBETWEEN(1,100)","v":79},1,12,82,13,56,49,44,52,41]
["         Prepaid Expenses",1,36,37,71,6,44,5,15,82,11]
["            Prepaid Insurance",56,2,50,42,1,45,70,51,11,24]
["         Total Prepaid Expenses",{"$f":"(B18)+(B19)","v":57},38,87,113,7,89,75,66,93,35]
["         Undeposited Funds",{"$f":"RANDBETWEEN(1,100)","v":4},28,83,10,17,48,37,57,15,66]
["      Total Other current assets",{"$f":"((B17)+(B20))+(B21)","v":140},67,182,205,37,193,161,167,160,142]
["   Total Current Assets",{"$f":"((B12)+(B15))+(B22)","v":287},273,288,455,218,438,355,353,325,276]
["   Fixed Assets"]
["      Leasehold Improvements",{"$f":"RANDBETWEEN(1,100)","v":21},69,90,76,66,63,60,1,48,72]
["         Accumulated Depreciation",54,94,22,66,30,71,30,32,90,85]
["         Original Cost",7,4,57,95,3,3,37,67,74,23]
["      Total Leasehold Improvements",{"$f":"((B25)+(B26))+(B27)","v":82},167,169,237,99,137,127,100,212,180]
["      Other fixed assets",{"$f":"RANDBETWEEN(1,100)","v":46},57,39,76,77,23,30,85,20,70]
["         Accumulated Depreciation",19,78,89,72,28,99,45,2,36,76]
["         Original Cost",92,62,81,48,65,10,93,42,83,23]
["      Total Other fixed assets",{"$f":"((B29)+(B30))+(B31)","v":157},197,209,196,170,132,168,129,139,169]
["      Rental Equipment",{"$f":"RANDBETWEEN(1,100)","v":88},21,19,94,90,98,48,9,86,77]
["         Accumulated Depreciation",3,99,7,73,27,22,17,89,50,3]
["         Original Cost",34,32,11,5,37,45,13,41,29,8]
["      Total Rental Equipment",{"$f":"((B33)+(B34))+(B35)","v":125},152,37,172,154,165,78,139,165,88]
["      Shop Tools",{"$f":"RANDBETWEEN(1,100)","v":1},{"$f":"RANDBETWEEN(1,100)","v":90},30,99,80,46,58,66,45,31]
["         Accumulated Depreciation",86,22,22,76,75,27,83,43,51,7]
["         Original Cost",12,53,82,9,88,59,40,71,46,50]
["      Total Shop Tools",{"$f":"((B37)+(B38))+(B39)","v":99},165,134,184,243,132,181,180,142,88]
["      Vehicles",null,{"$f":"B41","v":0},0,0,0,0,0,0,0,0]
["         Accumulated Depreciation",{"$f":"RANDBETWEEN(1,100)","v":64},35,42,38,97,76,90,68,20,3]
["         Original Cost",13,66,19,18,18,47,1,41,12,17]
["      Total Vehicles",{"$f":"((B41)+(B42))+(B43)","v":77},101,61,56,115,123,91,109,32,20]
["   Total Fixed Assets",{"$f":"((((B28)+(B32))+(B36))+(B40))+(B44)","v":540},782,610,845,781,689,645,657,690,545]
["TOTAL ASSETS",{"$f":"(B23)+(B45)","v":827},1055,898,1300,999,1127,1000,1010,1015,821]
["LIABILITIES AND EQUITY"]
["   Liabilities"]
["      Current Liabilities"]
["         Accounts Payable"]
["            Accounts Payable (A/P)",{"$f":"RANDBETWEEN(1,100)","v":37},93,89,84,70,20,86,79,92,44]
["         Total Accounts Payable",{"$f":"B51","v":37},93,89,84,70,20,86,79,92,44]
["         Credit Cards"]
["            Visa Account (XXXXXXXXXXXX 2915)",{"$f":"RANDBETWEEN(1,100)","v":78},12,56,36,67,1,83,89,3,38]
["            Visa Account (XXXXXXXXXXXXXXX 3111)",82,69,84,53,22,100,48,78,60,27]
["         Total Credit Cards",{"$f":"(B54)+(B55)","v":160},81,140,89,89,101,131,167,63,65]
["         Other Current Liabilities"]
["            Payroll Tax Payable",{"$f":"RANDBETWEEN(1,100)","v":30},31,42,72,66,18,38,63,29,68]
["            Sales tax payable",32,20,20,9,46,88,78,34,19,45]
["            Utah State Tax Payable",49,44,74,53,13,5,11,6,90,9]
["            Wages Payable",6,4,81,25,43,56,85,74,26,87]
["         Total Other Current Liabilities",{"$f":"(((B58)+(B59))+(B60))+(B61)","v":117},99,217,159,168,167,212,177,164,209]
["      Total Current Liabilities",{"$f":"((B52)+(B56))+(B62)","v":314},273,446,332,327,288,429,423,319,318]
["      Long-Term Liabilities"]
["         Notes Payable",{"$f":"RANDBETWEEN(1,100)","v":6},49,45,87,33,88,36,56,19,37]
["      Total Long-Term Liabilities",{"$f":"B65","v":6},49,45,87,33,88,36,56,19,37]
["   Total Liabilities",{"$f":"(B63)+(B66)","v":320},322,491,419,360,376,465,479,338,355]
["   Equity"]
["      Kelly Walker Contributions",{"$f":"RANDBETWEEN(1,100)","v":69},25,30,89,56,93,61,47,7,48]
["      Opening Balance Equity",29,63,90,48,12,18,81,85,36,31]
["      Retained Earnings",50,84,15,46,97,44,34,37,19,8]
["      Shane Olson Contributions",93,69,75,84,85,9,87,82,39,58]
["      Net Income",84,31,99,91,35,38,60,55,10,66]
["   Total Equity",{"$f":"((((B69)+(B70))+(B71))+(B72))+(B73)","v":325},272,309,358,285,202,323,306,111,211]
["TOTAL LIABILITIES AND EQUITY",{"$f":"(B67)+(B74)","v":645},594,800,777,645,578,788,785,449,566]
[]
[]
[]
["Friday, Nov 21, 2014 02:36:53 PM PST GMT-7 - Accrual Basis"]

{"sheet":"Instructions","index":4,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ratios",null,null,null,null,null,null,"Calculations"]
["Current Ratio","=current assets/ current liabilities",null,null,null,null,null,"retail margin percentage"]
["A/R Turnover","= credit sales/ average AR",null,null,null,null,null,"propane margin percentage"]
["Average collection period","=# of days in period/A/R turnover",null,null,null,null,null,"Salary % of total income"]
["roe","= net income/average equity"]
["roa"]
["quick ratio","=cash/current liabilities"]
["inventory turnover"]
["asset turnover"]
["net margin"]
["nopat"]
["nopm"]
["sales growth"]