![]() See the example below:Īt the last row put the Date and amount you received So in a Spreadsheet we put the date and the value both. IRR does not solve one problem and that is when the payments are at Irregular interval. XIRR IRR when periodicity of cash flow is not equal If its’ some other time frame like monthly or quarterly use XIRR and put specific dates. The values need to be a set of Positive and Negative ValuesĪny amount Invested will be Negative so if you invest Rs 10000, put -10000Īny amount you Receive will be Positive so if you get Rs 5000, put +5000Īll the payment or receiving of money are equidistant, Like 1st of every month OR May 15th Every yearĪll the payments are assumed to be yearly by default. the time interval between two cash flows are equal.Įnter your Investments (amount which you paid) in each row (you have to put “-” before each value)Įnter the Amount you Received at the end (put “+” after that amount)įormula: =IRR(values)( place your values put the range of cells which contains values) see below:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |