Help with this problem please:

1 You have been asked to develop a pro forma statement of cash flow for West Office Plaza. The information given to you is listed below Property Information: WEST OFFICE PLAZA Rentable Area (sq. ft.) Age (in years) # Stories Financial Information: Base Rent Avg. (per sq.ft.) Other Income/Parking/Storage (per sq. ft.) Expenses Recoverable from Tenants (per sq. ft.) Current Vacancy Expenses: Mgmt./Admin./Security/Ownership Property Taxes Insurance General Operations/Leasing Expense/Marketing Utilities Janitorial/Cleaning Business Taxes 2 3 4 5 20.00 $1.50 $2.50 5.00% 300,000 15 # Tenants 8 Other: 9 Recurring CAPEX/Improvement Allowance 10 40 $695,000.00 $675,000.00 $430,000.00 $667,000.00 $1,159,100.00 $489,000.00 $110,000.00 700,000.00 12 13 14 15 a. Develop a pro forma statement of cash flow for a base year showing net operating income (NOI) for West Office Plaza 16 b. If you plan to begin work on future pro formas for West Office Plaza, list at least five major factors that you would consider. 17 18 Outputs: 19 a. 20 Proforma Income Statement 21 Revnues 22Base rent 23 +Recoverable expenses 24 +Other incom 25vacancy 26 Effective gross income (revenue) 27-Mgmt./admin./security/ownership expense 28Property taxes 29Insurance expense 30 General operations/leasing/marketing expense 31-Utilities 32Janitorial/cleaning 33Business taxes 34Operating income before capital expense 35Recurring capital expense 36 Net operating income (NOI) 37 b. Period Input your five reasons below 38 2 39 40 4 41 42