I am having problem with a formula that references itself. Here is what I am trying to do. i will put in the numbers that i have marked known and i would like to generate purchase price, mortage payment and cash flow. Purchase price references itself. I can do the calculation on paper but excel does not like it. Thanks for the help.
<tbody>
</tbody>
Income | pulled in from another cell |
Expenses | pulled in from another cell |
Mortgage Type | text block |
Interest Rate % | known value |
Downpayment % | known value |
Mortgage (Years) | known value |
Mortgage Payment | =-pmt(interest rate/12, mortgage years*12, P) |
ROI % | known value |
Purchase Price =P | P=((Income-Expenses)-((Income-Expenses)-c))/ROI |
Cash Flow=c | c=ROI*P |
<tbody>
</tbody>