Good work, as always. Thanks for getting this done...this is awesome ðŸ™‚ ]]>

This is a simultaneous equation

I would solve this manually like:

(1) x+y =120.56

(2) 28x/100+18y/100 =32.4

(3) = (1) x 18/100

= 18x/100 +18y/100 = 18*120.56/100

= 18x/100 +18y/100 = 21.7008

(4) = (2) - (3)

28x/100+18y/100 =32.4

- 18x/100 +18y/100 = 21.7008

= 10x/100 + 0 = 32.4 - 21.7008

= x/10 = 10.6992

(5) Multiply both sides by 10

x = 106.992

(6) Substitute x into (1)

x+y =120.56

106.992 + y = 120.56

y = 120.56 - 106.992

y = 13.568

Enjoy

]]>x+y =120.56

28x/100+18y/100 =32.4

then what is the value of x and y

how it find

x+y =136.96

28x/100+18y/100 =16

then what is the value of x and y

how it find

With regards to my specific issue, which requires 2 steps (1: set the year 3 price, 2: goal seek the equity to achieve 25% IRR), how would you set up that macro? The end goal is to create rows 31 and 32 in Hui's example, but in a quick, repeatable way such that I can copy/paste with minimal adjustments to solve this question for hundreds of different investments.

The real models used are significantly more complex than this, although they do have simple inputs for price and equity.

Thanks!

MR06

]]>