XIRR calculator spreadsheet for returns
Apr 14, 2016 13:00:49 GMT
bababill, ablrateandy, and 3 more like this
Post by james on Apr 14, 2016 13:00:49 GMT
Attached is a zipped Excel 97 format spreadsheet that you can use to calculate annualised investment returns using the XIRR method. To use just put the current account balance - loans and cash - in the yellow cell at the upper right and fill in the later rows with the dates and amounts of the transactions. Excel 97 because that should be importable without problems by most spreadsheets.
To get started with a particular account you can do one of two things:
1. Enter today's date and the current balance as a deposit to the account. XIRR will be from this starting date.
2. Enter the past deposits and withdrawals. XIRR will be from the first date you use.
To get started with a particular account you can do one of two things:
1. Enter today's date and the current balance as a deposit to the account. XIRR will be from this starting date.
2. Enter the past deposits and withdrawals. XIRR will be from the first date you use.
