Free excell irr calculator?

Question

if i am buing a property eg. $20,000,000 and have a rental income of $1,000,000 at 7% rate and expense of $100,000

a year how do i set up on excell to IRR,NPV?

Answer 1

for IRR:

=irr(   at this point, click the fx button for help

for NPV

=npv(  use help here   )+Co

you have to add cash flow 0 for npv.  it was a glitch in the early versions, but people got used to it so they never bothered to fix it.