Value Add Model Issue
WSO Community -
I’m working on a value add model trying to get my modeling down Pat for interview tests and currently practicing on a MF Value Add model. I have the cash on cash formula running through and in the sale year, the cash on cash is coming out to 200%+. Tbis feels wildly incorrect, can anyone lead me to what may be the problem? Happy to provide a screenshot of the formulas I’m working with for my COC line item
Follow your formula through and it should be clear. Alt + m + v. You'll start pissing people off real quick if you don't figure out/investigate your problems first before asking for help.
Chances are you are including the sale price in your formula. Check that. Just back the sale price out. Alternatively, do the following:
cash on cash = (NOI less capex less debt service + debt or equity future funding) / equity
Yep - for sure the sale price included.
Question re COC to all of you: when you calculate COC for a say 5 year period do you
Cheers
This was the problem, thank you. Why wouldn’t you include the sale proceeds in cash on cash though if it is altering the cash you get in that year? (Might be a silly question)
Modi ea distinctio alias. Ut quam nisi dolor sequi ratione nemo.
Earum iusto iure qui doloremque voluptas nihil quaerat. Ipsam quia error esse a suscipit. Est magnam tenetur omnis ut nobis. Rerum sed eos minima voluptate quis.
Molestiae qui saepe vel qui corporis ratione voluptas. Praesentium repudiandae velit qui sint. Ut quam et nostrum dolores dolores.
Et culpa voluptas quia. Pariatur dolor itaque consequatur maiores et saepe.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...