Shopping Centre Development Model - 20-year Three Statement Analysis and Valuation

Description
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 and IRR. 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 up to 191 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, IRR, and MIRR 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.