How to do Forecasting of Financials ?

-
I'm learning this from youtube videos.

Two methods of taking forecast : 

1. Through Formula 

In this we use =forecast(Xs,knownYs,knowYs)

Eg : In this we will already had data till 2024, we had put in the formula =forecast(2025,Revenue (2019:2024), Year (2019:2024))


2. Forecast on the Data Tab !




We have taken the same data as the 1st formula !

These are for one line data and provide very accurate answers, but for more and better data one need to understand the technicality of growth and it's rate. 


Popular posts from this blog

About the Blog : An Outline

-
Image
Investment Banking Nerd is a Knowledge Repository. Hi,  My name is Ishika Mishra and I'm a blogger by hobby. My journey of blogging started with an amazing theory, my English subject teacher always scolded me for my spelling and verbs usage mistakes, you will very easily find the same in this write up also.  To tell you about my current blog "Investment Banking Nerd", it's an amazing creation that I love to do everyday. This blog helps many people from a ' Student ' who wants to enter Investment Banking to those working in Investment Banking industry and wants to research about Investors and documentations tools and it's importance.  Investment Banking Nerd blog is a creation of Knowledge base and a Portfolio for me !! Isn't it's amazing the you are working anywhere in this world and you just type in on the net your very own website name and everything you know & had made repository of comes off in a second in front of your eyes. This is the i...
Read more