Spreadsheet: 151755d1335107745-need-excel-automation-and-accounting-help-please-workbook1
Sheet: TASK 1

Accrual | Year to Date Balances for period 12/11
 |  |  |  |  |  | [1] Calculate the net cash at this property if you sold it today.
 |  |  |  |  |  | 2) I need to create a formula that you can use for the next month.  Not all months will have the same accounts or rows for each account.  New accounts may be used or not used depending on their month end balances.
Account Description |  | Debit |  | Credit
1000-0000 | Cash - Operating | 5739047.51 |  | 0
1012-0000 | Cash - Tax and Insurance Reserve | 777014.33 |  | 0
1071-0000 | Cash - Low DSCR Escrow | 0 |  | 0
1099-0000 | Petty Cash | 750 |  | 0
1101-0000 | A/R - Base Rents | 16512.32 |  | 0
1104-0000 | A/R - Storage Rent | 912.28 |  | 0
1105-0000 | A/R - Other Rent | 0 |  | 0.24
1110-0000 | A/R - Operating Exp Recov | 0 |  | 2505.18
1112-0000 | A/R - REtax Recovery | 0 |  | 61352.82
1116-0000 | A/R - Utility Recov | 31364.89 |  | 0
1124-0000 | A/R - Misc Tenant Charges | 1 |  | 0
1199-0000 | A/R - Property Misc | 10913.23 |  | 0
1200-0274 | A/R - MG Leasing III | 205471 |  | 0
1310-0000 | Prepaid Taxes | 58102.67 |  | 0
1320-0000 | Prepaid Insurance | 31436.7 |  | 0
1399-0000 | Other Prepaids | 3770.26 |  | 0
1400-0000 | Utility Deposit | 49791.2 |  | 0
1550-0000 | Office Equipment | 10548.6 |  | 0
1551-0000 | [NAME] Equip | 0 |  | 10116.97
1650-0000 | Bldg Furn & Fixtures | 27730 |  | 0
1650-9999 | Bldg Furn & Fixtures - CY Additions | 11816.65 |  | 0
1651-0000 | [NAME] | 0 |  | 13361.38
1700-0000 | Land | 19612500 |  | 0
1750-0000 | Office Building | 114621025.33 |  | 0
1750-1000 | Office Building Projects in Progress | 180897.79 |  | 0
1750-9999 | Office Building - CY Additions | 78495.79 |  | 0
1751-0000 | [NAME] Bldg | 0 |  | 11432149.27
1800-0000 | Lease Commissions | 2189500.09 |  | 0
1800-9999 | Lease Commissions - CY Additions | 35872.24 |  | 0
1801-0000 | [NAME] | 0 |  | 456740.89
1825-0000 | Other Lsg Considerations | 177163.07 |  | 0
1825-9999 | Other Lsg Consid - CY Additions | 608675.19 |  | 0
1826-0000 | [NAME] | 0 |  | 101084.93
1830-0000 | FAS141 Acquired Leases | 1453202 |  | 0
1831-0000 | [NAME] Leases | 0 |  | 1187220
1850-0000 | Tenant Improvements | 1949520.73 |  | 0
1850-1000 | Tenant Finish in Progress | 1324415.73 |  | 0
1850-9999 | [NAME] Additions | 0 |  | 17916.39
1851-0000 | [NAME] Improv | 0 |  | 1038593.03
1895-0000 | Financing Costs | 923739.71 |  | 0
1895-9999 | Financing Costs - CY Additions | 6000 |  | 0
1896-0000 | [NAME] Costs | 0 |  | 903104.5
1950-0000 | FASB13 Accrd Rents | 2125046.42 |  | 0
1970-0000 | Deferred Main Expenses | 361059.07 |  | 0
2000-0000 | A/P - Operating Expenses | 0 |  | 165660
2050-0000 | A/P - Real Estate Taxes | 0 |  | 500471.8
2060-0000 | A/P - Mortgage Interest | 0 |  | 163127.89
2075-0000 | A/P - Capital Expenditure | 0 |  | 302995.24
2085-0000 | Accrued Audit and Tax Fees | 0 |  | 10800
2099-0000 | A/P - Accrued Expenses | 0 |  | 109729.78
2100-0061 | A/P - Miller Global Prop 08 | 0 |  | 1698.02
2300-0000 | Tenant Security Deposits | 0 |  | 378636.95
2401-0000 | Prepaid Base Rent | 0 |  | 584693.88
2404-0000 | Prepaid Storage Rent | 0 |  | 600
2405-0000 | Prepaid Other Rent | 0 |  | 140715.93
2410-0000 | Prepaid Oper Exp Recov | 0 |  | 26979.5
Database: ACCTGDAT | Trial Balance |  |  | Page:      2
 | MGP Main DB |  |  | Date: 3/26/2012
 |  |  |  | Time: 05:11 PM
Accrual | Year to Date Balances for period 12/11
Account Description |  | Debit |  | Credit
2700-0000 | Mortgage Payable | 0 |  | 93262125.02
2999-0270 | Inter-entity Miller Global Fund VI | 500000 |  | 0
3273-0270 | [NAME] VI (1333 H St.) | 0 |  | 48000000
3673-0270 | [NAME] (1333 H St.) | 5500000 |  | 0
3700-0270 | PY R/E - Miller Global Fund VI LLC | 0 |  | 847798.53
4001-0000 | Base Rent | 0 |  | 10380901.99
4002-0000 | FASB13 Rent | 0 |  | 736034.52
4002-0100 | FAS141 Acquired Leases | 209881 |  | 0
4004-0000 | Storage Rent | 0 |  | 27068.41
4005-0000 | Other Rent | 0 |  | 191629.4
4050-0000 | Percentage Rent | 0 |  | 205471
4110-0000 | Oper Exp Recov | 0 |  | 416153.15
4112-0000 | Retax Recov | 0 |  | 186878.9
4116-0000 | Utility Recov | 0 |  | 397116.32
4124-0000 | [NAME] Recov | 0 |  | 4641.42
4190-0000 | Late Fee Income | 0 |  | 3612.24
4490-0000 | Vending Income | 0 |  | 727.84
5000-0000 | Janitorial Contract | 299432.47 |  | 0
5005-0000 | Day Porter | 32475.91 |  | 0
5010-0000 | Special Cleaning | 1300.66 |  | 0
5030-0000 | Window Cleaning | 12789.36 |  | 0
5050-0000 | [NAME] | 7668.58 |  | 0
5125-0000 | Electrical Repairs | 8939.7 |  | 0
5150-0000 | Electrical Supplies | 3994.79 |  | 0
5170-0000 | Light Bulbs/Fixtures | 18566.18 |  | 0
5200-0000 | HVAC Contract | 9396.51 |  | 0
5210-0000 | HVAC Repair | 252737.34 |  | 0
5250-0000 | HVAC Supplies | 8988.84 |  | 0
5260-0000 | Water Treatment | 4737.48 |  | 0
5300-0000 | Elevator Contract | 62723.96 |  | 0
5310-0000 | Elevator Repair | 2953.84 |  | 0
5320-0000 | Musak/Network Video | 3547.2 |  | 0
5400-0000 | Plumbing Repairs | 6066.35 |  | 0
5450-0000 | Plumbing Supplies | 7894.78 |  | 0
5500-0000 | Painting - Common Areas | 1720.66 |  | 0
5600-0000 | General Building Repairs | 2596.52 |  | 0
5605-0000 | General Building Supplies | 179.48 |  | 0
5610-0000 | BLDG Repairs - Ins Reimb | 2733.21 |  | 0
5615-0000 | Building Services - Tenant Reimbursement | 0 |  | 99680
5620-0000 | Doors & Store Fronts | 2605.27 |  | 0
5640-0000 | Metal Maintenance | 11031.36 |  | 0
5650-0000 | Misc Hardware & SM Tools | 3936.25 |  | 0
5660-0000 | Locks & Keys | 3932.9 |  | 0
5680-0000 | Seasonal Decorations | 3140.11 |  | 0
5695-0000 | Roof & Structural Repairs | 1501.34 |  | 0
5700-0000 | Maintenance/Secur P/R | 228463.9 |  | 0
5725-0000 | WO Service Contract | 5345.04 |  | 0
5799-0000 | Uniforms | 1277.72 |  | 0
5800-0000 | Security Contract | 205737.43 |  | 0
5810-0000 | Fire Safety Contract | 1900 |  | 0
5820-0000 | Sec & Fire Safety Supp | 1697.3 |  | 0
5830-0000 | Sec & Fire Safety Repairs | 0 |  | 0
5850-0000 | Sec & Fire Safety Monitor | 21589.86 |  | 0
5890-0000 | Sec & Fire Safety Inspect | 20862.31 |  | 0
5900-0000 | Trash Removal | 15811.5 |  | 0
5930-0000 | Interior Plant Contract | 4961.28 |  | 0
Database: ACCTGDAT | Trial Balance |  |  | Page:      3
 | MGP Main DB |  |  | Date: 3/26/2012
 |  |  |  | Time: 05:11 PM
Accrual | Year to Date Balances for period 12/11
Account Description |  | Debit |  | Credit
5960-0000 | Pest Control | 3558.1 |  | 0
6000-0000 | Electricity | 576527.22 |  | 0
6020-0000 | Gas | 85540.3 |  | 0
6060-0000 | Water & Sewer | 40770.17 |  | 0
6100-0000 | Grounds Contract | 5691.65 |  | 0
6130-0000 | Landscaping Exterior | 634.5 |  | 0
6190-0000 | Snow Removal | 2059.1 |  | 0
6400-0000 | License and Permits | 1286.91 |  | 0
6500-0000 | Office Supplies | 5460.98 |  | 0
6510-0000 | Office [NAME] | 9121.58 |  | 0
6520-0000 | Office Equip Maintenance | 3074.87 |  | 0
6530-0000 | Dues & Subscriptions | 2701.99 |  | 0
6535-0000 | Professional Development | 1788 |  | 0
6540-0000 | Meeting Expense | 1224.41 |  | 0
6550-0000 | Telephone & Fax | 15684.41 |  | 0
6558-0000 | Internet Service | 1371.85 |  | 0
6560-0000 | Postage & Messenger | 5411.72 |  | 0
6570-0000 | Office Rent | 34550.04 |  | 0
6575-0000 | Parking/Bus Passes | 12240 |  | 0
6576-0000 | Travel Reimbursement | 10.83 |  | 0
6585-0000 | Other Office Expense | 472.31 |  | 0
6700-0000 | Management Contract | 294280.78 |  | 0
6705-0000 | Personal Property Taxes | 149 |  | 0
6707-0000 | Other Business Taxes | 139788.43 |  | 0
6730-0000 | Mgmt Salaries Taxes & Ben | 201821.39 |  | 0
6800-0000 | Real Estate Taxes | 1862527.51 |  | 0
6870-0000 | General Liability Insurance | 82196.04 |  | 0
7100-0000 | Marketing Expenses | 1299.68 |  | 0
7130-0000 | Charitable Contributions | 95.42 |  | 0
7150-0000 | Tenant Relations | 10518.03 |  | 0
7250-0000 | Legal Fees - Leasing | 2897.2 |  | 0
7255-0000 | Legal Fees - Other | 7888.11 |  | 0
7300-0000 | Outside Consultant | 15950 |  | 0
7599-0000 | Other Admin Expenses | 22.77 |  | 0
7800-0000 | Vacant Unit Fix-Up | 4581 |  | 0
7805-0000 | Non-Passthrough Repairs and Maintenance | 2109.7 |  | 0
7806-0000 | Non-Passthrough Utilities | 397116.32 |  | 0
7820-0000 | Space Plans/Drawings | 1363.79 |  | 0
7900-0000 | Reimbursable Expenses | 0 |  | 4744.89
8150-0000 | Telephone | 11.06 |  | 0
8180-0000 | Postage & Messenger | 241.79 |  | 0
8215-0000 | [NAME] Expenses | 41.42 |  | 0
8300-0000 | Airfare | 6766 |  | 0
8310-0000 | Ground Transportation | 1827.94 |  | 0
8330-0000 | Meals | 1032.74 |  | 0
8340-0000 | Hotels | 2579.59 |  | 0
8350-0000 | Parking - Meetings & Trav | 236 |  | 0
8390-0000 | Client Development | 63.9 |  | 0
8410-0000 | Legal Fees - General | 13131.19 |  | 0
8440-0000 | Audit and Tax Fees | 18000 |  | 0
8459-0000 | Loan Fees | 35000 |  | 0
8460-0000 | Organization/Filing Fees | 250.4 |  | 0
8465-0000 | Business Licenses and Permits | 175 |  | 0
8600-0000 | Interest Exp - Mort | 1888429.62 |  | 0
8696-0000 | Interest Exp - Fee Amortization | 244964.15 |  | 0
9000-0000 | Asset [NAME] | 720000 |  | 0
Database: ACCTGDAT | Trial Balance |  |  | Page:      4
 | MGP Main DB |  |  | Date: 3/26/2012
 |  |  |  | Time: 05:11 PM
Accrual | Year to Date Balances for period 12/11
Account Description |  | Debit |  | Credit
9551-0000 | Depr - Office Equipment | 1741.6 |  | 0
9651-0000 | Depr - Bldg Furn & Fix | 6390.05 |  | 0
9751-0000 | Depr - Office | 2934602.68 |  | 0
9801-0000 | Amrt - Lease Commissions | 236410.23 |  | 0
9826-0000 | Amrt - Other Lease Cons | 86210.57 |  | 0
9831-0000 | Amrt - FAS141 Acquired Leases | 1867368 |  | 0
9851-0000 | Amrt - Tenant Improvement | 358163.99 |  | 0
 | Total: | 172374838.22 |  | 172374838.22