I have a tricky problem that I think has an easy/simple solution but I can't think of it at the moment. I hope you can take a look and help me out!

So I have a set of data that spans over the course of 30 months. I got the data from a past project and want to use it to forecast a future project. It includes the $ value and the % value of the total (see below). From there I'm creating trendlines for this in a chart. Like I said previously, I'm trying to use this set of data as a precedent for future data. End goal is to plug in a duration (months) and a revenue expectation ($) and predict what might happen on future projects.

Any thoughts on how to approach this would be great! Thanks!

ForecastingTest.png

ForecastingTest.xlsx