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.Recurring CAPEX$/$Improve Allowance

$$67,500$

Required:

a$.$ Develop a pro forma statement for the Betts property for a base year showing net operating income $($NOI$).$

$\backslash$table$[[$BETTS DISTRIBUTION CENTER,$],[$Rent$,,],[$Add:$,,],[,,],[,,],[$Subtotal$,,],[$Less:$,,],[,,],[,,],[$Total operating expenses,,$],[$Cap expenses$/$Improvement allowance,,$],[,,]]$

Property Information:

BETTS DISTRIBUTION CENTER

Age of Improvement $8$ years old

Rentable Space $230,000$ square feet

Single Tenant $10-$year lease term, net, net

Financial Information:

Rent $$7\mathrm{.}00$ per square feet $(7-$year term$),$ flat

Recoverable Expenses from Tenant $$3\mathrm{.}00$ per square feet, fixed

Operating Expenses $$775,000$

Property Taxes $$53,000$

Insurance $$18,000$

Other Cash Outlays:

Allowances for:

Recurring CAPEX$/$Improve Allowance $$67,500$

Required:

a$.$ Develop a pro forma statement for the Betts property for a base year showing net operating income $($NOI$).$

Answering with supporting work on excel if possible