• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel formula

Kyaruzi

New Member
Please assist.

Just working on the assignment that requires me to calculate the IRR for one investment. Please get me template from may process my data to obtain the rate.


Regards
 

Hui

Excel Ninja
Staff member
Kyaruzi


Firstly, Welcome to the Chandoo.org forums.


If your a student I'd suggest starting with excel Help and typing IRR and seeing what comes up


Excel has two IRR Formulas


IRR and XIRR


IRR is for regular cashflows and uses the Format =IRR(Values, Guess) where values is a Range or array of values


XIRR is for irregular cashflows and uses the Format =XIRR(Values, Dates, Guess)where values is a Range or array of values, same for dates
 
Top