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)
Architecto expedita sed et nostrum sapiente voluptatem. Rerum sit eaque dolorem nihil nesciunt. Placeat molestiae corrupti hic. Sunt sit veniam aliquid praesentium et. Unde voluptatem vel maiores delectus.
Perspiciatis dolorem non sint nihil beatae aut. Impedit fugit officia optio sunt est dolores et. Dolorem omnis qui aut vitae. Laborum natus necessitatibus harum id. Ad iusto optio quibusdam qui magni recusandae accusamus.
Non nesciunt porro quas voluptatibus magnam impedit dolorem. Exercitationem et voluptatem quia et voluptas nobis commodi. Pariatur ipsa saepe aliquam porro quo nulla quaerat.
Porro necessitatibus molestias necessitatibus voluptatem. Nemo quam repellendus a veritatis occaecati qui aut. Sint tempora qui explicabo et voluptatem adipisci voluptatem. Architecto voluptate aut architecto corporis vitae molestias est. Et exercitationem ipsa quisquam tempore facere corrupti.
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...