Hi guys, I am trying to mimic the calculations I saw in a video about life insurance illustration calculations.
The guy running the video was using a suite of calculators from Truth Concepts Software
It seems like a highly overpriced piece of software that can easily be replicated by Excel - so I have attempted to do that!
I was able to mimic year one, but after that, I am not able to get the IRR and ROR numbers to match the screenshot below.
The calculations I used for Year 1 Total IRR on Net Cash Value was: (EOY Net Cash Value/Annual Premium)-1 (formatted to show percentage)
For Year One Total IRR on Net DB I used: (EOY Net Death Benefit/Annual Premium)/Annual Premium
Any help would be greatly appreciated.
Here is my spreadsheet:
The guy running the video was using a suite of calculators from Truth Concepts Software
It seems like a highly overpriced piece of software that can easily be replicated by Excel - so I have attempted to do that!
I was able to mimic year one, but after that, I am not able to get the IRR and ROR numbers to match the screenshot below.
The calculations I used for Year 1 Total IRR on Net Cash Value was: (EOY Net Cash Value/Annual Premium)-1 (formatted to show percentage)
For Year One Total IRR on Net DB I used: (EOY Net Death Benefit/Annual Premium)/Annual Premium
Any help would be greatly appreciated.
Here is my spreadsheet: