From Kai Neo: Could i make a suggestion, to include a column, for monthly profit or one-off revenue and then another for its ROI. this might encourage usage and remove those red ROI shelfware. thanks!---
The value creation (and, after doing the business' year-end today, asset lifetime and depreciation values) are generally calculated as follows:
(Knowing that this is subjective makes this super hard, and thus it would be easier to default to the second version of this instance, which would be Duy's reading of it, i.e. what would we have to pay if it wasn't LTD, and when is the breakeven?)
- Asset Lifetime Cost: Basically how much is the LTD worth over its planned lifespan? And since assets (and I see LTDs as assets) have maintenance, depreciation and such costs (even if minimal), they do sunset over a period that you write them off. If we can add those to the tool as well, my accountant would be crying with delight, I would be able to deduct the LTDs from tax even easier, and you basically have a full-on financial subscription asset management software there in 1 easy step.
As for teasing out the hidden subscriptions... Now Rohit, even if none of the rest of the above, that would be super awesome!