Hi,
i have a question relating to a budget i'm making. The budget has rows consisting of various posts of revenue and costs, and the columns are the months, e.g. 24 months in 2 years. My short-costs and revenues vary a lot, but my long-term costs are stable and i can vary my revenue based on 1 factor.
At the bottom of the budget i have a budget line for liquidity. What i want is to calculate the abovementioned factor for which the liquidity in the long term does not change, so when income and costs are even.
I cannot calculate this in the Excel ways that i know of. What i do now is that i vary the factor manually, until income and costs are even in month 24 (there is 1 break-even point, because there is only 1 factor that influences revenue, and the long-term costs are fixed).
Do you know of any way to automate what i do now manually?
best,
Rik