How to Build a Forecasting Model in Excel (FP&A)

Chapters:
00:00 - Introduction
00:47 - Key Learning Objectives
02:50 - Assumptions
04:54 - Historical
10:59 - Income Statement
14:12 - Charting
17:43 - Review

FREE COURSES & CERTIFICATES

Enroll in our FREE online courses and earn industry-recognized certificates to advance your career:

About Corporate Finance Institute: CFI is a leading global provider of online financial modeling and valuation courses for financial analysts. Our programs and certifications have been delivered to thousands of individuals at the world's top universities, investment banks, accounting firms, and operating companies.

By taking our courses, you can expect to learn industry-leading best practices from professional Wall Street trainers. Our courses are extremely practical, with step-by-step instructions to help you become a first-class financial analyst.

Join us on social media!

#Excel

[rizalukman]

Thank you very much for the video.I used to work as a financial analyst but I didn't know that before creating a 3 financial statement model I have to learn first about assumption

[goldenpark]

You guys are doing awesome job by sharing knowledge. Keep doing, thank you a lot

[TSquared]

This was on time. I definitely appreciate the refresher.

[talaatkabeel]

That is awesome lecture , would you please send me the link to download the spreadsheet . Mt regards.

[John]

This piece is amazingly insightful. Experiencing a book with parallel content was a pivotal event for me. "Mastering Money Mindfulness" by Benjamin Hawk

[sweetsarah]

Really like your channel. You mentioned that I need to download the file at the beginning of the course. Could you share the download link please? Thank you a lot.

[wanderlust_rona]

Thank you for the course! What if you don't have any historical records? Ler's say for a start-up company, you only have market trend available, how about that?

[zeeshanshah]

Hello. I am really enjoying learning this model and I am so thankful to you for this sharing. Though I am confused on somethings here as well. Can you please tell me how you calculated these ratios( explain the formula and also how you get the "x" next to numeric? i.e. "times" because my result is coming in numbers and different than yours.14:45

[peterheine]

Hello,
I have a question about forecasting. Should plan corrections be determined during forecasting? Or is it not necessary to determine them? Why is there an extrapolation? An extrapolation is absolutely necessary.

[martinsanchezpanizza]

Hi, thanks for sharing. Can you please send me the link to download the spreadsheet?
Thanks!

[zonanagon]

Thank you for the sharing. Subscribed, liked!

[darkstar]

Thank you for sharing the tutorial. I'm just wondering why account payable in days calculation is Account Payable/(COGS) rather than Account payable/Annual purchased?

[Mad]

Sir,

Thanks for the wonderful video..

Can you plz share a video forecasting future based on past present.

[morrazzo]

How much time does it take to develop financial model in general?

[jahorasvictornaibaho]

Thanks for sharing knowledge. Really appreciated

[asarwaribit]

Please share the file you are using for practice, Thanks

[rogeriooliveira]

great content, can share the base. Thank you so much.

[comvid]

Sales per square foot on an annual basis? But why are actuals on a monthly basis?

[afsalkp]

Hi It was a nice presentation, thank you! I was looking for a financial forecasting template for a manufacturing company (Need to project - Revenue, Production, COst of Revenue and Cash Flow). Is it possible to provide thihs particular template instead of subscribing to the whole 1 year course? Please let me know

[heaviestmelo]

Will this work well for a trucking company?