REIT Modeling and Scenario Template

4.55K viewsTips and Techniques

I am building a forecasting model for a REIT with integrated financial statements and running into formula errors. Has anyone built a real estate financial model that allows for actual and forecasted numbers as well as the ability to turn on and off certain assets to see the summarized financials?


I have solved most of the formula errors that I ran into. Thanx for the reply. But now I am having an issue with the following.

I have setup a time based model where I enter an acquisition date for an asset and the income statement start on the appropriate month as does the balance sheet and cash flow. But loan interest and amortization/depreciation do not. I want to be able to configure the model so that based on the acquisition date the model correctly places the interest, depreciation, amortization amounts in the correct column.

Any suggestions. Please email me at [email:a5pmoxcz][/email:a5pmoxcz]

You are viewing 1 out of 3 answers, click here to view all answers.

Latest Questions