I am doing a business plan and need baby step help on how to set up the
calculation of an IRR so that I can dp several 'what ifs' and also be able to
explain to the client how the spread sheet works. I need to be walked
through step by step as i can't seem to get the 'HELP ' to be clear enough
for me to get the right answer instead of error messages
Assume $3,000,000 investment
15 year amortization
desired IRR of 10% -- what would the monthly payments need to be to get this

I iam using Excel 2000