K Kyaruzi New Member Sep 18, 2012 #1 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
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 Sep 18, 2012 #2 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
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