How to create a Financial Model with 0 experience

Occasional Visitor

Hi guys,

 

Hope you're Wednesday is going well!

 

I'm having trouble with this Financial Model, I've never done one before but really want to impress my manager. Can anyone explain clearly what I have to do with the below information to turn it into a Financial Model?

 

dairecasey_0-1657703071616.pngdairecasey_1-1657703090733.pngdairecasey_2-1657703149995.pngdairecasey_3-1657703177754.pngdairecasey_4-1657703208273.pngdairecasey_5-1657703238019.pngdairecasey_6-1657703253979.png

 

I'm also due to make a forecast for the next 3-5 years.

Any help at all would be greatly appreciated!

1 Reply
When you want to report to higher level, it should be in graph and easy to understand, so try to present it with Pivot chart or Pivot graph. For forecast Microsoft document is available, https://support.microsoft.com/en-us/office/forecast-and-forecast-linear-functions-50ca49c9-7b40-4892...