Making a line item a hard coated number

[Anonymous]

Hi Michael,

I had a quick question on the DCF 40 min video… on minute 24 you talk about the “Loss-to-Lease” and hard coating the assumption for that so that if you change the percentage, the Year 1 will change as well.

Well, I am using a mac and not too sure how to use the short cuts you use. Can you please explain the long way on how to do it?

Thanks,

Ishaan

[Michael Belasco]

Hi Ishaan,

No problem. What you are doing here is copying and then pasting as a Value. So once you copy the cell, right click the mouse, or I believe you click the mouse pad with two fingers on a Mac laptop, and under Paste or Paste Special, there should be an option that says Values. Click that and you should be good to go. Let me know if that works for you or if you need further guidance here.

Thanks for the question,

MB

[Author]

Posts