Creating a Payback period model

Hi team,

I'm trying to create a model to analyse the payback period on certain products. I have earnings per product per year (presented with the product in the rows and earnings separated out by year - with the year across the columns). I also have costs in a separate file I intend to join by product SKU.

I want to analyse the payback period - i.e. how many years it has taken per product to recoup the costs. Can anybody please help?

Thanks,

Matt

Accepted answers

All comments

Christine_Assaad

Hi @Blondek

It will be helpful to share a sample of how your data is structured... but generally speaking you can use Alteryx DateTimediff formula and configure it to run the difference between two dates in a specified units such as year.

Hope this helps. Cheers!

Blondek

Hi,

Thanks a lot - Sample data attached. Of course the actual data is much larger, but I'd like a column which is 'Payback period', which determines how many years it took to recoup the costs. If it has not yet recouped, I'd like it so say how long it would take to recoup under the current trend.

Thanks,

Matt

Sample Data.xlsx

Raj_Singh1

hi @Blondek

if you could pleas share some data sample or excel file. and some more instructions, would be useful for community to reply back with the workflow or solution

Blondek

Hi,

Thanks, sample data above.

Matt

Raj_Singh1

Hi @Blondek

Please see attached solution. If only gives the year and product where payback period is reached.

Let me know if you have any more questions 🙂

Payback Period Screenshot.png

Payback Period 11-11-2020.yxmd

Blondek

Hi @Raj_Singh1

Thanks for this - this isn't a packaged workbook, so I can't see the detail.

However, there is a bit of a difference between what you've done and what I'm trying to achieve: I'm trying to create a model which tells the actual OR forecast payback:

- If it has paid back, I want to see how long it took to payback in years

- If it hasn't paid back, I want to see how long it will take in years if current revenue levels continue

Is there a way of achieving this?

Thanks a lot,

Matt

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157