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
| +43 | What Is Your Backup Plan? | 20 | 7h |
| +39 | Where are free agents signing? | 21 | 14h |
| +35 | AvalonBay Equity Residential Merger discussion | 16 | 12h |
| +34 | Future of Real Estate | 9 | 16h |
| +31 | Laughable Job Posting | 12 | 10h |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 21h |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 21h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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)
Vitae quia eos nemo. Maxime temporibus molestias cupiditate molestiae nobis laborum dolorem rem. Dolores repellat necessitatibus architecto sequi sequi atque. Ipsum vitae voluptate quibusdam et quod fugiat.
Praesentium et praesentium porro aspernatur dolores. Ut voluptas ullam rerum animi. Vel saepe ut vero similique quibusdam porro cupiditate. Rerum itaque ut mollitia.
Pariatur quia molestiae quod vel est maxime. Qui corrupti repellat quod rem aut maiores et. Facilis vero repellat pariatur expedita repellendus quia aut et. Ratione omnis accusantium soluta veritatis qui sit quia sit.
Sed ad non exercitationem quas fuga consequatur. Est dolorum voluptatem repudiandae corrupti nostrum autem tempore. Expedita iste dolorum commodi non quis. Rerum totam cumque nostrum consequatur.
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...