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
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
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?
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.
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.
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?
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.
@@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!
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
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
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)
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
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.
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
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
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.
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
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
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.
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!
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.
Check out the full course at: corporatefinanceinstitute.com/
You guys are doing awesome job by sharing knowledge. Keep doing, thank you a lot
Our pleasure, thanks for watching!
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
This was on time. I definitely appreciate the refresher.
That's great, glad you found the tutorial valuable!
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
That is awesome lecture , would you please send me the link to download the spreadsheet . Mt regards.
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?
Hi, thanks for sharing. Can you please send me the link to download the spreadsheet?
Thanks!
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.
Thank you for the sharing. Subscribed, liked!
Sir,
Thanks for the wonderful video..
Can you plz share a video forecasting future based on past present.
you are god sent
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.
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?
Account payable is related to supplies from suppliers aka cost of goods
Thanks for sharing knowledge. Really appreciated
great content, can share the base. Thank you so much.
How much time does it take to develop financial model in general?
please share the excel sheet too that you are using
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.
@@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!
@@112r lol bro what are you even saying
@@youtubecommenter5662 I think they thought the reply above them was being sarcastic. Idk if they were tbh😂
How does the check works?? Thanks
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
Please share the file you are using for practice, Thanks
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
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
Will this work well for a trucking company?
12:18 Why do you put 1 minus ? (if I may ask)
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)
@@CarteiraForte_Oficial ohhh. I get it. So simple. Thanks a lot, man :)
Hi, Can you please send me the link to download the spreadsheet? Thanks
Where can I find the Excel template?
what is the difference between a normal financial model class at a university and a statistical financial model class?
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
Sales per square foot on an annual basis? But why are actuals on a monthly basis?
Where can I find this download?
the link to the attachment file pls ?
Could you share the excel sheets you used?
Can I have the copy of your file?
Good job
Thanks for sharing video
Hi , from where do I download this excel file?
Sir can you share this excel sheet where OK are show
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.
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
@@CFI_Official If everybody were like you guys
Duration to finish the course?
could you please upload this excel sheet
Can I buy this template?
Where can I download that file
PLEASE SHARE THE EXCEL SHEET AS WELL SO THAT PEOPLE CAN WORK ON THAT. THANK YOU
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
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.
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
Please share the excel sheet that you are viewing on UA-cam
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
I did not understand ...all the forecasts cells were already filled...where did you forecast???
template?
Where is the Excel File?
Why does it just completely cut to a new section right in the middle?
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.
Anyone else sped this up to 1.25x?
Is that even an option?
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!
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.
Knowing all the facts before judging makes the difference between small and big humans.
You lost me at "In the first part I'm going to introduce myself"
Sorry.
please share the excel sheet too that you are using