You have been asked to develop a pro forma statement of cash flow for Betts Distribution Center, an Internet-based order fulfillment/distribution/office/warehouse property. In addition to recoverable operating expenses, the new tenant will be billed for pass throughs including insurance and property taxes, which will then be paid by the owner. The information given to you is listed below. Property Information: BETTS DISTRIBUTION CENTER Age of Improvement Rentable Space Single Tenant Financial Information: Rent 8 years old 218,000 square feet 10-year lease term, net, net Recoverable Expenses from Tenant Operating Expenses Property Taxes Insurance $7.00 per square feet (7-year term), flat $2.40 per square feet, fixed $745,000 $51,800 $16,800 Other Cash Outlays: Allowances for: Recurring CAPEX/Improve Allowance Required: $64,500 a. Develop a pro forma statement for the Betts property for a base year showing net operating income (NOI). Rent Add BETTS DISTRIBUTION CENTER $ 1,526,000 Required: a. Develop a pro forma statement for the Betts property for a base year showing net operating income (NOI). Rent Add Effective gross income Less BETTS DISTRIBUTION CENTER $ 1,526,000 Total operating expenses Cap expenses/Improvement allowance 0 0 $ 0 0