Commercial Property Valuations made easy with automated Cash Flow, Exit Values, NPV, IRR and MIRR

Description
This CRE Valuation Model will take you less than 40 seconds to input the data and view your results. The model only requires 9 x input fields relating to the lease amount, expenditures and incremental lease % and it will automatically provide you with a 5, 7, 10. 12, 15 and 20 year Model with all cash flows, exit values, NPV, IRR and MIRR, exactly what investors, fund managers, portfolio managers need to see. All or any factors may be changed in a flash. There are gearing options built-in to the model so that you can easily view the effects that gearing will have on the performance of the building. Most prudent investors will target a specific MIRR under certain conditions, so this formula is becoming the most important for analysts. A short note on the difference between IRR and MIRR. IRR has a flaw in that when the cash flows become positive, it will keep calculating these at the same rate as the initial cash flow. Now we know that it is virtually impossible to re-invest cash at the same rate as IRR, so MIRR corrects this by capping the positive cash flows to equal that of the funders rate because it is possible to invest in your own debt. This is why analysts will rely on MIRR more readily. The CRE Valuation model is dynamic and designed in a manner that admin or support staff are easily able to input the data on behalf of consultants.