Trouble With financial projections

Hey Guys,

So this is my first post and would really like any help if possible.

I am currently doing a 3 year financial projection for my company. I have entered all the data and done all the formula work across the 3 years.

Everything is perfect with regards to the numbers but the only problem I am having is that the projections are not carrying across all three years so it looks like its a startup for every year instead of the profits from year 1 moving over to year 2 and then year 3 etc. Im not too sure about how to change this? In essence I need to link the profits from year ones income statement to the next years and so forth.

Kind regards,

Jm

JM, welcome to the forum. It is difficult to know how to help you without more detail or a sample sheet. For example, if you have information in sheet1 for example, and it is for CY 2012 financial information, same with sheet2 except it is 2013 etc. You could make a summary sheet with profit information for all three completed years (fiscal or calendar) then create a graph with that info, then apply a trend line to it to show changes over time. For better help you may have to post a sample sheet.