break even calculator?

[Sassyonemeis]

Does anyone have an excel sheet that calculates days until you break even? I am pretty good in excel, but I cant seem to get a formula to calculate how many days until I break even.

It's givin me a headache

 

[keitht253]

Break even in terms of dollars spent? First steps would be to figure out what you spent per day on analogs, your up-front e-cig costs, and then your daily e-cig costs after that. Should be simple from there.

 

[Scubabatdan]

Hey I just wrote this. Is this what you are looking for?
Dan

View attachment Cost of savings.xls

 

[PKZap27]

I just did an advanced search for "break even calculator" on ECF and found two in the first post of this thread.

I think the rev 1 (second link in post 1) has a better "day" formula in it.

http://www.e-cigarette-forum.com/fo...27457-simple-e-cig-break-even-calculator.html

Check it out!

 

[firhill]

I've used this one courtesy of (CATANONIA, BOOBOO, JAAXX, and PUFF-PUFF-PASS) for almost two years now.

View attachment SuperECIGtracker v2.xls

It's pretty colourful and has areas to track different items/expenses

 

[Sassyonemeis]

AWESOME! The only thing I can find unlikeable about this tracker is that it doesnt take into account your juice inventory. Yes, it's an upfront cost, but that cost should be spread out IMO.

I did finally get my excel to perform *mostly* correctly when it calculated the break even date (I wanted it to show me a date, not the number of days until I get there). LOL I have come down with a cold and I guess my brain wasnt working too well when I posted this and I was frustrated.

Here's mine if anyone is interested... it's very simple and not protected, no fancy colors but it works.

View attachment VAPING.xls

Thanks so much

I've used this one coutesy of (CATANONIA, BOOBOO, JAAXX, and PUFF-PUFF-PASS) for almost two years now.

View attachment 30377

It's pretty colourful and has areas to track different items/expenses

 

[firhill]

AWESOME! The only thing I can find unlikeable about this tracker is that it doesnt take into account your juice inventory. Yes, it's an upfront cost, but that cost should be spread out IMO.

You can customise any of the sheets to display what you personally prefer.

 

[Snowblind258]

I have one as well Since everyone is sharing

View attachment E-CigsSavings.xls