Discounted Cash Flow Model for Marcus & Millichap v.1.12 Mdel DCF

[Mitchell CowanParticipant]

When inserting the years in the Analysis Period End /Reversion Year End field, is that supposed to change the number of operating cash flow years.  The model I’m using extends to 10-years.  How do I change it to five years or some other time period?

[Arturo ParadaInstructor]

Hi Mitchell,

First, thanks for posting your question in the forum.

In terms of your questions.

When inserting the years in the Analysis Period End /Reversion Year End field, is that supposed to change the number of operating cash flow years.  The model I’m using extends to 10-years. 

Yes, you are right. This model was designed to go out in “Year 10”, which means that the “Analysis Period End” isn’t an input.

 How do I change it to five years or some other time period?

 There is a process behind that, so I will update the model in the next few days. Then, I will send you that.

Hope this helps!

Arturo Parada

[Arturo ParadaInstructor]

Hi Mitchell,

In terms of your request.

I updated the model considering the “Analysis Period End” (Cell E11, Model DCF – Tab) as an input.

I attached the new model called “Marcus & Millichap + A.CRE Model v1.14” with the changes.

Note: You can visualize the changelog in the version tab.

Hope this helps.

Arturo Parada

Attachments:

You must be logged in to access attached files.

1 user thanked author for this post.

Mitchell Cowan

[Mitchell CowanParticipant]

Arturo,

Thanks for the updated version.  Much appreciated.

[Author]

Posts