break even

Hi everyone, I have the following table with two different adjusters: X and Y. A3, B3, C3 are all fixed values and D3 and E3 are input variables. Then, the Final Change (F3) is the following formula: =((B3+(C3*E3))+(A3*D3)) My goal is: figure out a formula to find out the minimum Assumption Y...

I've been trying to solve a breakeven analysis but I get stuck when I want to add a yearly growth on top of the product mix, Does anyone have a solution for below scenario, In total 5 products over a 6 year period, if possible I would like to calculate backwards, so accumulated Net profit year...

Hi, I would like to know if it is at all possible to simply have just a single marker on a scatter graph with lines. I've created a breakeven point chart and just want a marker on the exact point in which the lines intersect. Thanks!

I have a stream of cashflows going all across row 37, where each column represents a month (ie. B37 is cashflow in january, C37 february, etc.), and I want to have a function that finds what month these cashflows go from negative to positive, and then calculate the difference between those two...

First post so if I do something wrong I apologize in advance. I have a function (below) to figure out days of sale on a weekly basis. This function works well as it uses 7 as a static base to figure out how many days out it will go considering starting inventory. However I need figure out...

I am a new trader and I need an excel formula that will tell me the break even stock price I need to hit before I start taking profits. Below is the first example of a scenario i) I buy 2000 units of Coca Cola Amatil Ltd (ASX:CCL) at $11.83/unit = $23,660 ii) My transactional costs to buy and...