Solving for sell price based on Cash on Cash Return

delunatic

New Member
Joined
Apr 8, 2019
Messages
9
Please refer to the attached spreadsheet, my property analyzer. You'll see all the columns on the left that show all the important metrics I look for when analyzing potential investment properties. After entering a minimum of data I look to the YEAR 1 COC ROI (COC) (Cash on Cash Return on Investment). That percentage must be >12% to continue to analyze the property as a potential investment.

I'd like to add another few boxes on the left that I can enter my desired COC and in the next box have it solve for the sell price, factoring in all the income and expenses. It would make is easy for me to very quickly see what the offer price should be, all other things being equal. Creating this spreadsheet isn't that difficult once you understand the metrics. It's figuring out how to write that formula that stumps me.

Here's the spreadsheet - https://drive.google.com/file/d/0B2X1XJmvfW5Hc2FmeEM4c1dOQ0hScXE5mpsZ2xpTkliaE8w/view?usp=drivesdk

Thank you.
 

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Oh! Apologies. I'll fix the link or resubmit the post when I get home with a working link. Sorry about that.
 
Upvote 0

Forum statistics

Threads
1,223,164
Messages
6,170,444
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top