Property Analysis
New member
- Joined
- Jul 22, 2022
- Messages
- 1
ROI=(OP∗DPP)+(OP∗CCP)(GOI−(TX+INS+W))−(DS∗12)ROI=OP∗(DPP+CCP)(GOI−(TX+INS+W))−(DS∗12)OP=ROI∗(DPP+CCP)(GOI−(TX+INS+W))−(DS∗12)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.ROI=(OP∗DPP)+(OP∗CCP)(GOI−(TX+INS+W))−(DS∗12)ROI=OP∗(DPP+CCP)(GOI−(TX+INS+W))−(DS∗12)OP=ROI∗(DPP+CCP)(GOI−(TX+INS+W))−(DS∗12)
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