Mile High Ski and Snowboard Shop Pennsylvania Entity Aggregated Balance Sheet Worksheet 6/ 30/XX Final Project (Part 4) EXCEL Account Number 010 020 030 040 050 060 100 110 120 130 190 150 160 170 180 Current Assets Cash Accounts receivable Bad debt reserve Marketable Securities Inventory Prepaid Assets Total Current Assets Fixed Assets Computer equipment Computer Software Furniture and Fixtures Machinery Ofce Equipment Total Fixed Assets Accumulated depreciation Computer equipment Computer Software Furniture and Fixtures Machinery Total Accumulated Depreciation Unadjusted Trail Balance 131,195 12,500 (625) 25,000 41,598 7,600 217,268 27,500 5,000 10,000 12,500 55,000 (3,667) (667] (1,333) (1,190) (6,857)