What is the Net Operating Income $($NOI$)$ of the following investment? Please, do this

in Excel in Pro$-$Forma analysis showing each step and upload your Excel work.

Office Building: Review of Assumptions.

$-$Total acquisition price: $$2,000,000.$

$-$Property consists of eight office suites.

$-$ Rents: two suites at $$1,800$ per month, one at $$3,600$ per month, and five at $$1,560$

per month.

$-$Vacancy and collection losses: $10\%$ per year.

$-$Operating expenses: $40\%$ of effective gross income each year.

$-$Capital expenditures: $5\%$ of effective gross income each year.