Module 11 Written Assignment - Final Continuing Project
Twinage12
_team_budget_061516.xlsxSheet1
| LLC REALTY | |||
| BUDGET FOR YEAR 2016/2017 | |||
| BUDGET | ACTUAL | UNDER/OVER | |
| SUMMARY | |||
| Total income | 67000 | 81000 | |
| Total expenses | 12000 | 123500 | |
| TOTAL | |||
| INCOME | BUDGET | ACTUAL | UNDER/OVER |
| OPERATING INCOME | |||
| Rental Income | 50,000.00 | 60,000.00 | 10,000.00 |
| interest on revenue | |||
| reinbursements | 1,000.00 | 1,000.00 | |
| gain on sale of assets | 17,000.00 | 20,000.00 | 5,000.00 |
| TOTAL | 67,000.00 | 81,000.00 | (14,000.00) |
| EXPENSES | |||
| OPERATING EXPENSE | |||
| Property acquisition | 20,000.00 | 18,000.00 | - 0 |
| Property Improvement | 5,000.00 | 70,000.00 | (25.00) |
| Utiliites | 2,000.00 | 1,000.00 | (40.00) |
| Fees | 2,000.00 | 3,000.00 | (44.00) |
| Insurance | 6,000.00 | 6,500.00 | (20.00) |
| Maintenance | 12,500.00 | 15,000.00 | - 0 |
| Property Taxes & Licenses | 8,500.00 | 10,000.00 | (1,500.00) |
| TOTAL | 56,000.00 | 123,500.00 | (67,500.00) |
| OFFICE | |||
| Office Supplies | 50,000.00 | - 0 | |
| Telephone expenses | 10,000.00 | ||
| Travel | 2,500.00 | ||
| Postage | 1,500.00 | ||
| TOTAL | 64,000.00 | ||
