For Example:

A ) In Jan-2008 We have Invested 100,000,000 $ for that 50% (50,000,000) we took a loan from financial institution and 50% (50,000,000) we invest from our capital.

B) Rate of interest for borrowing (50,000,000) is 8% flat yearly.

C) We need to pay extra (cost) of $ 1,000,000 for incurring cost monthly.

C) We sold out this investment in 120,000,000. in June-2008.

Can anybody guide me to calculate IRR (Internal Rate of Interest).

Also convey with if you have any easy example/function/theory.

Best Regards,