How to Build a Forecasting Model in Excel

How to Build a Forecasting Model in Excel - Tutorial | Corporate Finance Institute
Enroll in the Full course to earn your certificate and advance your career: courses.corporatefinanceinstit...
Master the art of building a rolling 12-month cash flow forecast model in our Financial Planning & Analysis (FP&A) course. In this course you will learn to build a cash flow model from scratch complete with assumptions, financials, supporting schedules and charts.
-- FREE COURSES & CERTIFICATES --
Enroll in our FREE online courses and earn industry-recognized certificates to advance your career:
► Introduction to Corporate Finance: loom.ly/us5oJEw
► Excel Fundamentals: loom.ly/4KnYciU
► Accounting Fundamentals: loom.ly/xHJgJO4
► Reading Financial Statements: loom.ly/2wrcPw8
► Fixed Income Fundamentals: loom.ly/DZdjDA0
-- 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 top universities, investment banks, accounting firms and operating companies in the world.
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.
Explore CFI courses: courses.corporatefinanceinsti...
-- JOIN US ON SOCIAL MEDIA --
LinkedIn: / corporate-finance-inst...
Facebook: / corporatefinanceinstit...
Instagram: / corporatefinanceinstitute
Google+: plus.google.com/+Corporatefin...
KZbin: / corporatefinanceinstit...

[@goldenpark2009]

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

[@CFI_Official]

Our pleasure, thanks for watching!

[@TSquared2001]

This was on time. I definitely appreciate the refresher.

[@CFI_Official]

That's great, glad you found the tutorial valuable!

[@jahorasvictornaibaho7467]

Thanks for sharing knowledge. Really appreciated

[@zeeshanshah8292]

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

[@peterheine6240]

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.

[@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?

[@zonanagon9764]

Thank you for the sharing. Subscribed, liked!

[@martinsanchezpanizza6401]

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

[@heaviestmelo3873]

Will this work well for a trucking company?

[@afsalkp1685]

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

[@FRANKWHITE1996]

Thanks for sharing video

[@darkstar7255]

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?

[@joecorrea8254]

Account payable is related to supplies from suppliers aka cost of goods

[@Mad1080]

Sir, Thanks for the wonderful video.. Can you plz share a video forecasting future based on past present.

[@loucaviotto4193]

what is the difference between a normal financial model class at a university and a statistical financial model class?

[@talaatkabeel6396]

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

[@tharindhijayawardena6053]

you are god sent

[@John83118]

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

[@suyashgupta9418]

hey , i started doing the free course but can you please specify how am i supposed to get the certificate for the course also there was a pdf there which i had to download ,which i did but it doesnt show the tick mark as done as a result my course doesn't get 100% completed...hope u solve these issues because i am planning to take more courses and i am confused as i dont get alot of things...thank uu

[@muhammadshabbir9682]

Good job

[@hcompa25]

Hi, Can you please send me the link to download the spreadsheet? Thanks

[@gnashi1]

Thank you for the exhilarating course. will you please share the excel sheet that you are using? Thank you in advance for your prompt answer

[@CFI_Official]

Thank you for the wonderful feedback! The downloadable model is available as part of our FP&A course. Here's the enrollment link: courses.corporatefinanceinstitute.com/courses/fpa-rolling-12-month-cash-flow-forecast-course

[@Itwealthservices]

please share the excel sheet too that you are using

[@Marc_Koch]

Can you please tell me how to set up my spreadsheet so that I can click on a primary category and it expands the categories into additional rows. For instance, click on P&L category and it expands into line items.

[@CFI_Official]

Sure, happy to help! 1) Select the rows you want to group 2) Press Alt, D, G, G 2) Rows will be grouped and can now expand / contract These steps are covered in detail in our FREE Excel crash course. Here's the link to enroll:courses.corporatefinanceinstitute.com/courses/free-excel-crash-course-for-finance

[@YazminAbat]

@@CFI_Official If everybody were like you guys

[@rogeriooliveira4934]

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

[@businessman1060]

could you please upload this excel sheet

[@kristenchenchen4864]

Could you share the excel sheets you used?

[@abassmohamed145]

Duration to finish the course?

[@shahsyed9957]

Sir can you share this excel sheet where OK are show

[@morrazzo4432]

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

[@asarwaribit]

Please share the file you are using for practice, Thanks

[@jameshernandez8963]

Question regarding the inventory numbers. Are you saying that this formula is showing an average of how many days of inventory is on hand per month per calendar year. Not an accounting major here and trying to learn more about forecasting inventory.

[@CFI_Official]

Yes exactly, it's an assumption about the value of inventory that would be on the balance sheet at the end of each month, assuming an average number of days to sell the inventory

[@nidhichowdhary1473]

Hi , from where do I download this excel file?

[@edwardg9765]

Can I buy this template?

[@jen_305]

Where can I find this download?

[@rulaabunuwar8034]

Please share the excel sheet that you are viewing on KZbin

[@CFI_Official]

Hi Rula, thanks for reaching out to us! This short tutorial is part of our FP&A course. When you enroll in the course, you'll have access to the Excel models: courses.corporatefinanceinstitute.com/courses/fpa-rolling-12-month-cash-flow-forecast-course

[@asdemb]

How does the check works?? Thanks

[@seasme]

Where can I download that file

[@snehilarora1724]

PLEASE SHARE THE EXCEL SHEET AS WELL SO THAT PEOPLE CAN WORK ON THAT. THANK YOU

[@CFI_Official]

Hi Snehil, As stated in the description, this video is an excerpt from our FP&A course, which you can find here: courses.corporatefinanceinstitute.com/courses/fpa-rolling-12-month-cash-flow-forecast-course

[@user-om9lg9vx3q]

Where can I find the Excel template?

[@comvid3246]

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

[@ishashah7913]

I did not understand ...all the forecasts cells were already filled...where did you forecast???

[@CFI_Official]

Check out the full course at: corporatefinanceinstitute.com/

[@vompire01]

the link to the attachment file pls ?

[@StayPolishThinkEnglish]

12:18 Why do you put 1 minus ? (if I may ask)

[@TheWhispex]

To calculate this percentage, you assume that 25% is 25/100, right? What means that equals to 0,25. Then, if you have 25% of gross margin and wants to know your cost of goods sold (cogs), then you need to subtract 0,25 from 1. Gross Margin: 25% --> 0,25 COGS = 75% --> (1-0,25)

[@StayPolishThinkEnglish]

@@TheWhispex ohhh. I get it. So simple. Thanks a lot, man :)

[@augmiester123]

Why does it just completely cut to a new section right in the middle?

[@CFI_Official]

Hi Augustine, This video is taken from our Financial Modeling Templates Bundle, and moves on to demonstrating how the model works in Excel after a brief introduction.

[@IfIknewthen]

template?

[@williamturpin8278]

Where is the Excel File?

[@londonviahongkong]

Anyone else sped this up to 1.25x?

[@TSquared2001]

Is that even an option?

[@dianapuerta9487]

Its too bad that the excel sheet is not available for free you have to purchase it and it cost $147.00 per month thats a lot money for a student to pay. If this is a tutorial and its public we should at lease be able to try for free. Great tutorial but I am Disappointed that this is just a business strategy to make you pay and enrolled!

[@CFI_Official]

Hi Diana, Thank you for reaching out to us. Please note that the $147 is a one-time fee that grants you lifetime access to the course and all of its study materials.

[@SaniRecords]

Knowing all the facts before judging makes the difference between small and big humans.

[@skurt21]

You lost me at "In the first part I'm going to introduce myself" Sorry.

[@112r]

please share the excel sheet too that you are using

[@calutron008]

I want to download it as i am blind and can't see what tim is doing can somewne out there send me a link for the spread sheet -- I am also a bit confused as to what area we're in like is this investmant banking say or just financial theory. I can't find a friend to watch this with.

[@112r]

@@calutron008 well someone has been rejected too many times from everyone including mommy n daddy and completely bitter now..... No one is talking to u,..stay rejected in your closet!

[@youtubecommenter5662]

@@112r lol bro what are you even saying

[@ShadowIYI]

@@youtubecommenter5662 I think they thought the reply above them was being sarcastic. Idk if they were tbh😂