Expected Revenue Per Store$=$$$44$ million

Standard Deviation$=$$$10$ million

Operating Pre tax Margin Minimum$=6\%$

Operating Pre tax Margin Maximum$=12\%$

Expected Pre tax Margin Value$=9\%$

Non Operating Expenses$=$$$1\mathrm{.}5$ million

GDP Growth Rate$=3\%$

Inflation Rate$=2\%$

Revenue Growth Rate$=5\%$

Cost of Capital$=10\%$

Tax Rate$=40\%$

Expexted Base Year

After Tax Flows $=$$$1\mathrm{.}476$ million

Risk Adjusted Value

Of Store$=$$$11\mathrm{.}53$ million

Simulate Annual Revenue and Pre tax Operating Margins with a normal distribution on a spread sheet. Show the spread sheet oeprstions used for the simulation.