Data table for desired outputs for varied inputs

[yaswanth92]

Hi,

I need your help in calculating the breakeven point for every year i.e., say my timeline is of 5 years from 2023 to 2027 and I have an input variable as revenue growth % rest assumed all the inputs are fixed. Using data table or some other way, I need to find out the exact growth % for a project breakeven at 2023, 2024,...to 2027. Thank you for your help. I know the data table works for varied outputs for desired inputs but here I need it other way around.

 

[vletm]

yaswanth92
For Your needs,
You should able to send a sample Excel-file
with some sample data
with expected results.