A$1$

$fx$

Connections

Data Types

Sort A$1$

$fx$

Connections

Data Types

Sort A$1$

$fx$

Connections

Data Types

Sort A$1$

$fx$

Connections

Data Types

Sort

A$1$

$fx$

Connections

Data Types

Sort & Filter

Data Tools

B

C

D

E

F

G

G

$1$

Use the data on the Assumptions worksheet for a small shopping center in Miramar to complete the pro forma cash flows for the next $7$ years. The Assumptlons and the data in the worksheet will help you complete the rest of the tables.

Assume that any renewing leases are signed for a $5-$year term. All rents, expenses, and signage will grow at the rate of population growth.

Classwork Pro Forma

Classwork $-$ Assumptions

Homework Pro Forma

Homework $-$ Assumptions

Ready

Data Tools

Assume an Entry Cap of $6\mathrm{.}8\%.$ What is a fair price for the property today?

$6\mathrm{.}8\%$

Assume an Exit Cap of $7\mathrm{.}1\%$ in year $6.$ What is the terminal value of the property?

$\text{'}\mathrm{.}1\%$

Calculate the Equity Multiple based on these assumptions and the cash flows above

Classwork Pro Forma

Classwork $-$ Assumptions

Homework Pro Forma

Homework $-$ Assumptions

Ready

Data Tools

Assume an Entry Cap of $6\mathrm{.}8\%.$ What is a fair price for the property today?

$6\mathrm{.}8\%$

Assume an Exit Cap of $7\mathrm{.}1\%$ in year $6.$ What is the terminal value of the property?

$\text{'}\mathrm{.}1\%$

Calculate the Equity Multiple based on these assumptions and the cash flows above

Classwork Pro Forma

Classwork $-$ Assumptions

Homework Pro Forma

Homework $-$ Assumptions

Ready

SUMMARY OF EXPENSE INFORMATION $-$ PRIOR PERIOD

Expenses $($Year $0)$

CAM

RET

INS

MGMT

per s$.$f$.$

$$1\mathrm{.}58$

$$4\mathrm{.}10$

$$1\mathrm{.}11$

$$1\mathrm{.}80$

grow with population

grow with population

grow with population

grow with population

Operating Expenses

OPEX psf

CAM

Real Estate Taxes $($RET$)$

Insurance $($INS$)$

Management $($MGMT$)$

Total Property OPEX CAM

Real Estate Taxes $($RET$)$

Insurance $($INS$)$

Management $($MGMT$)$

Expense Recoveries

Each expense recovered is based on $\%$GLA for the tenant

See rent roll to identify which expenses are recovered for each tenant

Year $q,$ Est. Yr $1$ Est. Yr $2$

Est. Yr $3$

Est. Yr $4$

Est. Yr $5$

Est. Yr $6$

Est. Yr $7$

Total Expenses Recovered Grocery Store

Pharmacy

Bank

Clothing Store $$

Classwork Pro Forma

Classwork $-$ Assumptions

Homework Pro Forma

Homework $-$ Assumptions

Ready