circular referencing

  1. S

    Determining Purchase Price on Real Estate Transaction using Goal Seek, NPV, and IRR

    I work in commercial real estate and we are trying to back into a purchase price by determining what initial outlay gets our NPV to 0 and IRR to 30%. Essentially, what acquisition price gets us to a 30% IRR. We're looking at this over a three year period. For purposes of simplicity, say I can...
  2. C

    Why does my excel crash due to circular reference warning?

    Hi Mr Excel, I have created a model and there is a row that is impossible to delete. When I try to delete it, the following error message comes up and I have to re-start Excel. 'Circular reference warning One or more formulas contain a circular reference & may not calculate correctly...
  3. J

    Find percentage and change it

    I have several customers. Everyone has her own discount %. When I write a name, I want to find their discount %,calculate the price, round the price up, then to change the discount number. For example if Jane has 10%, the price is 960,after discount it will be 864, but as i will take only with...

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