{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Problem","Worksheet"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":2,"comments":2,"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":"Problem","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,7],[4,1,4,6],[5,1,5,6],[3,1,3,6],[1,0,1,7]]}
["Reagan Sakai is in charge of financial management for Land Monitrix.  Land Monitrix utilizes satellite technology and sophisticated mapping software to alert its customers to trespassing, illegal dumping, and other encroachments on property these customers own around the globe.  Customers typically purchase one-year contracts for this service, and the pricing depends on the number and size of sites monitored."]
["Mr. Sakai desires to review financial reports -- an income statement, statement of retained earnings, and balance sheet.  Prepare these reports from the following adjusted trial balance.   Mr. Sakai needs this information for internal review purposes, and does not require a classified balance sheet.  The operating data relate to the full year, and the blank worksheet already includes partial data.  "]
[]
[null,"LAND MONITRIX CORPORATION"]
[null,"Adjusted Trial Balance"]
[null,"As of December 31, 20X5"]
[]
[null,null,null,"Debits",null,"Credits"]
[null,null,"Cash",834221,null,0]
[null,null,"Accounts receivable",345909,null,0]
[null,null,"Prepaid expenses",45787,null,0]
[null,null,"Supplies",66665,null,0]
[null,null,"Satellite equipment",3009000,null,0]
[null,null,"Accumulated depreciation",0,null,1222199]
[null,null,"Accounts payable",0,null,544190]
[null,null,"Unearned revenues",0,null,455000]
[null,null,"Loan payable",0,null,1000000]
[null,null,"Capital stock",0,null,560000]
[null,null,"Retained earnings, Jan. 1",0,null,228892.00000000058]
[null,null,"Dividends",50000,null,0]
[null,null,"Revenues",0,null,2373402]
[null,null,"Selling expenses",476445,null,0]
[null,null,"Interest expense",80000,null,0]
[null,null,"Salaries expense",677667,null,0]
[null,null,"Maintenance and supplies expense",222989,null,0]
[null,null,"Depreciation expense",575000,null,0]
[null,null,null,{"$f":"SUM(D9:D26)","v":6383683},null,{"$f":"SUM(F9:F26)","v":6383683}]

{"sheet":"Worksheet","index":1,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[[15,0,15,5],[39,1,39,5],[40,1,40,5],[1,1,1,5],[2,1,2,5],[3,1,3,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[38,1,38,5]]}
[]
[]
[null,"Income Statement"]
[]
[null,null,"Revenues"]
[null,null,"Services to customers",null,0,null," "]
[null,null,"Expenses"]
[null,null,null,0]
[null,null,null,0,null,null," "]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0,{"$f":"SUM(D8:D12)","v":0},null," "]
[null,null,"Net income",null,{"$f":"E6-E12","v":0}]
[]
[]
["Note -- The \"Excel\" tip uses macros, and your security settings may limit access."]
[]
[null,"LAND MONITRIX CORPORATION"]
[null,"Statement of Retained Earnings"]
[]
[null,null,"Beginning retained earnings",null,0]
[null,null,"Plus: Net income",null,0]
[null,null," ",null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"E23-E24","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"LAND MONITRIX CORPORATION"]
[null,"Balance Sheet"]
[]
[null,null,"Assets"]
[null,null,null,null,0]
[null,null,null,null,0,null," "]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,"Satellite equipment",0]
[null,null,"Less: Accumulated depreciation",0,{"$f":"D47+D48","v":0}]
[null,null,"Total assets",null,{"$f":"SUM(E42:E48)","v":0}]
[]
[null,null,"Liabilities"]
[null,null,null,0,null,null," "]
[null,null,null,0]
[null,null,null,0,null,null," "]
[null,null,"Total liabilities",null,{"$f":"SUM(D52:D54)","v":0}]
[null,null,"Stockholders' equity"]
[null,null,null,0]
[null,null,null,0]
[null,null,"Total stockholders' equity",null,{"$f":"SUM(D57:D58)","v":0}]
[null,null,"Total liabilities and equity",null,{"$f":"SUM(E55:E59)","v":0}]