SHOPPING CENTER or MALL DEVELOPMENT MODEL – 20 Year Three Statement Analysis and Valuation

Commercial Real Estate Properties, Development, Financial Model, Hospitality, Investment, Real Estate, Tourism & Attractions

10-year Financial Projections, Business Valuation, Cap Rate (Capitalization Rate), Capitalized Earnings, Cash Flow Analysis, Cash Flow Projections, DCF Model, Debt Amortization, Debt Schedule, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Modeling, Financial Projections, Financial Ratios, Financial Statements, Financing, Forecast, Forecasting, Income Statement, Investor Cash Flows, IRR (Internal Rate of Return), KPIs (Key Performance Indicators), Levered Yield, NPV (Net Present Value), Profitability Analysis, Property Appraisals, Property Valuation, Real Estate Valuation, Three Statement Model | Three Financial Statements, Valuation

This Shopping Center or Mall Development Model will take you through the development timeline according to your own tax periods.

The Model generates a 20-year three-statement analysis and Valuation adjustments at the end of each tax year cycle based on your input data.

The Input data that is required will be well known to the Investor/developer in that all costs associated with the development may be input according to the timeline expected. You stipulate when the Shopping Center starts to generate income and we time all this in your cash flows. The model also generates a Valuation with NPV, IRR, and MIRR.

There is a Dashboard and the Inputs are easy to change as you assess the financial aspects of the development and consequential results. Critical to the Model is that all Blue cells should be Input to obtain an accurate reading on the development, even if it is a Zero % or Zero amount. The Input fields allow for any number of shops in the Center and this is easy to expand. We also provide the re-valuation account in the balance and make note of possible CGT liability in the event that the Investor exits.

The financial models take you through 20 years of Cash Flow Statements, Income Statements, and Balance Sheets. The Valuation method operates on the Net Operating Income and Cap Rate applied, The financial evaluation method applies all cash flows as they would happen and produces the NPV, and IRR, at 5-year intervals.

This Model is an excellent tool to provide you with realistic expectations and timing of cash flows. The information provided in the Cash Flows will also allow the Investor the opportunity to analyze when it is suitable to alter the gearing and create cash flow for further investments. The Investor’s analysis also provides the equity partners with detailed profit estimates and exit values along the way. This model is easy to follow and coherent.

You must log in to submit a review.