Excel in Excel presents #EiEFreshTalk on Modeling a Franchise Business Opportunity by CA. Sandeep Kothari (Financial Modeler and Trainer)
Download the excises material used in this video: https://excelinexcel.in?ff_landing=9
Register for Upcoming #EiELearning Courses at https://excelinexcel.in/eielearning
Register for Upcoming #EiEFreshTalk at https://excelinexcel.in/eiefreshtalk
In this video:
00:00 – Get Started
02:55 – Introduction by CA Sandeep Kothari
04:03 – What is a franchise?
07:47 – A case study on MCDONALD’S
14:06 – Steps to Financial Modeling
19:14 – Assumptions – Initial Investment
24:28 – Assumptions – Sales
31:45 – Assumptions – Other Operating Costs
35:22 – Finacial Model of MCDONALD’S Franchise (an example)
01:11:50 – Q & A Session
1. Understand the process of Business Evaluation
2. Forecast Revenues and Expenses
3. Prepare Financial Statements
4. Compute Free Cash Flows and Decision making with Capital Budgeting
5. Sensitivity Analysis
#EiEFreshTalk is a Talk Show presented by Excel In Excel on its YouTube Channel (https://www.youtube.com/theexcelinexcel), where it will be hosting great leaders and subject matter experts (SMEs) from various fields to speak regularly on a variety of topics ranging from Excel to Analytics and Finance to Financial Modeling and many more.
These sessions are intended to offer the viewers the opportunity to listen to the esteemed speakers and interact with them to have their queries addressed.
Watch our past talks at https://www.youtube.com/playlist?list…
Register for Upcoming #EiEFreshTalk at https://excelinexcel.in/eieFreshTalk
Keep Learning on a go.
Join our Facebook Group @ https://www.facebook.com/groups/eiefreshtalk/
Join our WhatsApp @ https://www.excelinexcel.in/whatsappupdate
Join our Telegram @ https://www.t.me/ExcelinExcel
Visit: www.ExcelinExcel.in, an online resource center that seeks to equip users with knowledge about MS Excel with excellent content supported by examples, case studies, and short videos.
Please give this video a Like and subscribe to our channel to Learn more on MS Excel. In the comments section, please share your thoughts and let us know about things that you wish us to cover in our forthcoming videos.
Connect with us on:
Facebook at https://www.facebook.com/TheExcelInExcel
Twitter at https://twitter.com/theexcelinexcel
Instagram at https://www.instagram.com/theexcelinexcel
LinkedIn at https://www.linkedin.com/company/theexcelinexcel
#excel #microsoftexcel #exceltutorial #learnexcel #shortcuts #data