Property Analysis
New member
- Joined
- Jul 22, 2022
- Messages
- 1
[math]ROI = \frac{(GOI-(TX+INS+W))-(DS*12)}{(OP*DPP)+(OP*CCP)}\\ ROI = \frac{(GOI-(TX+INS+W))-(DS*12)}{OP*(DPP+CCP)}\\ OP = \frac{(GOI-(TX+INS+W))-(DS*12)}{ROI*(DPP+CCP)}\\[/math]I am attempting to rearrange the equation below so that instead of solving for ROI it will solve for OP. I have successfully solved for ROI using excel equations but I am having difficulty accurately computing the OP value when entering a set ROI and would greatly appreciate any help!
View attachment 33466
I think you're missing the fact that the equation for DS contains OP, so that ROI depends on OP both directly and through DS. What @Property Analysis has done is to replace DS with its expression, so that now he has to solve his third equation for OP.[math]ROI = \frac{(GOI-(TX+INS+W))-(DS*12)}{(OP*DPP)+(OP*CCP)}\\ ROI = \frac{(GOI-(TX+INS+W))-(DS*12)}{OP*(DPP+CCP)}\\ OP = \frac{(GOI-(TX+INS+W))-(DS*12)}{ROI*(DPP+CCP)}\\[/math]
I am attempting to rearrange the equation below so that instead of solving for ROI it will solve for OP. I have successfully solved for ROI using excel equations but I am having difficulty accurately computing the OP value when entering a set ROI and would greatly appreciate any help!
View attachment 33466