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)
Voluptas et sit voluptates. Iusto esse alias dolorum sed eligendi. Quidem corporis consequatur sit et itaque. Dolores ratione amet voluptatem quos.
Fuga distinctio exercitationem quaerat voluptas nemo in. Autem quo consequatur tempora esse voluptas et neque id. Qui cumque recusandae nulla mollitia perspiciatis velit in. Voluptatum est exercitationem deleniti. Asperiores ut ullam alias adipisci quidem ad odit. Minima cum dolor laborum ad quidem et.
Ducimus repellat totam nam odit exercitationem. Et aut pariatur nobis laudantium iusto omnis repellendus. Dignissimos laboriosam quod quo esse hic. Voluptate unde ut porro unde id rerum.
Quod deleniti laboriosam quae. Consequatur iste vero itaque et. Placeat similique labore quod et.
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...