Left Blocks Image | Learnfly Right Blocks Image | Learnfly
All in One Offer! | Access Unlimited Courses in any category starting at just $29. Offer Ends in:

Learnfly | Menu Trigger Icons Browse Library

  • Business Solutions
  • Become an Instructor
  • 0
    Shopping Cart
    Learnfly | Empty Cart Icons

    Your Cart is empty. Keep shopping to find a course!

    Browse Courses
Free
2 days left at this price!

This plan includes

  • Limitedfree coursesaccess
  • Play & PauseCourse Videos
  • VideoRecorded Lectures
  • Learn onMobile/PC/Tablet
  • Quizzes andReal Projects
  • Lifetime CourseCertificate
  • Email & ChatSupport
Get Unlimited Learning Access
$29
2 days left at this price!
30-Day Money-Back Guarantee

This plan includes

  • Access to11,000+Courses
  • Adsfree experienceCourses
  • Play & PauseCourse Videos
  • Learnfly HD IconsHD VideoRecorded Lectures
  • Learn onMobile/PC/Tablet
  • Quizzes andReal Projects
  • Lifetime CourseCertificate
  • InstructorDirect Support
  • Email & ChatSupport
  • Cancel Anytime
$29
$29
$29
  • Know how to organize models in Excel
  • Be able to budget the business performance
  • Know how to model financial statements
  • Understand how the financial statements are linked together
  • Enhance your current Excel files
  • Format spreadsheets in a professional way
  • Know how to forecast sales and expenses
  • Understand the key assumptions that drive a budget

If you are currently working in an FP&A role, or anywhere between accounting and finance, there’s a high chance you’ll probably face the challenge of preparing a budget statement. It would be great if you are ready to tackle such a challenge with confidence and promptly.

And this is the course to prepare you for that!

You willstart with an empty Excel spreadsheet and build acomplete dynamic model for a 3-statement budget in Excel!

What you’ll get out of this course?

Create a 3-statement Budget Model in Excelcourse will guide you through the actual practical process of creating a budget model in Excel, step by step. We will define a clear structure and build a robust dynamic model, which you can reuse over and over again. I will help you understand the flow of information between different parts of a budget model. You will gain knowledge on how to forecast sales, production cost and other expenses. We will define a consistent framework of formatting our model, to make it easier to read and understand, even after time has passed.

I will show you some ways to tremendously improve the value of your budget by adding validation checks, dynamic scenarios and sensitivity analysis. We will take it to the end and prepare a summary sheet that is ready to print and share with stakeholders.

For this course, I anonymized a real set of company data so that you will see a real-life example.

After you take the Create a 3-statement Budget Model in Excel course, you will have the confidence to prepare your complex models and bring value to any budget you have to work on.

What should you know to take the course?

This course is aimed at an intermediate level of students. We will go over the main shortcuts and formulas that we use in the model, and you will have to become familiar with those, to be able to follow along. I expect you to have solid fundamental knowledge on Excel, be able to use formulas, link to cells in other sheets, know how the standard formatting tools and the ribbons work. If you are entirely new to Excel, this course will be hard to take. Please, take a look at some of the excellent introductory courses here on Learnfly, and come back after you’ve mastered the fundamentals of Excel.

To fully understand the model, you will need some basic accounting knowledge. I explain everything whenever we go into specifics. Still, I expect you to be familiar with an Income Statement, Balance Sheet, and Cash Flow Statement, have a general idea of how these are linked together. I would also expect you to understand words like Depreciation and Amortization, Interest, Cash Flows, and other similar terms.

It would still be possible to follow along and learn a lot from the course, even without basic accounting knowledge, but I would suggest you get yourself familiar with that first, and then take the Create a 3-statement Budget Model in Excel course.

Who is this course for?

I made the Create a 3-statement Budget Model in Excel course to serve as a practical guide on how to build high-quality budgets in real companies. The course is most suitable for:

  • Junior to Mid-Senior finance and accounting professionals, who are engaged in the budgeting process;
  • Business owners and entrepreneurs who want to understand how budgeting works in practice;
  • Managers in start-ups where no finance professionals are available;
  • Students in Finance and Economics majors who wish to get a head start.

I hope you are ready to upgrade yourself, learn how to build a 3-statement budget model in Excel, and propel in your career!

Are you excited to start?

Then enroll in the course, and I’ll see you in class!

  • Microsoft Excel 2010 or later
  • Comfortable with Basic Excel Functionality
  • Knоwledge on Fundamental Accounting Principles
  • Junior to Mid-Senior finance and accounting professionals, who are engaged in the budgeting process
  • Business owners and entrepreneurs who want to understand how budgeting works in practice
  • Managers in start-ups where no finance professionals are available
  • Students in Finance and Economics majors
View More...
  • Section 1 : Getting Ready 9 Lectures 00:29:27

    • Lecture 1 :
    • Introduction to the Course Preview
    • Lecture 2 :
    • About this Course
    • Lecture 3 :
    • Enable the Developer Tab in Excel
    • Lecture 4 :
    • Download Resources
    • Lecture 5 :
    • Install Magnimetrics Tools_EDITED
    • Lecture 6 :
    • What is Budgeting?
    • Lecture 7 :
    • Excel Functions Refresher
    • Lecture 8 :
    • Excel Shortcuts
    • Lecture 9 :
    • Discuss Source Files
  • Section 2 : Income Statement 18 Lectures 01:41:36

    • Lecture 1 :
    • Let's get started
    • Lecture 2 :
    • Create the Sales Budget
    • Lecture 3 :
    • Forecasting Performance Part 1
    • Lecture 4 :
    • Forecasting Performance Part 2
    • Lecture 5 :
    • Starting the Income Statement
    • Lecture 6 :
    • Direct Material Costs
    • Lecture 7 :
    • Production Staff Cost
    • Lecture 8 :
    • Production Overheads
    • Lecture 9 :
    • Issues with linked files
    • Lecture 10 :
    • Mapping the Expenses Budget
    • Lecture 11 :
    • Administrative Expenses
    • Lecture 12 :
    • Selling Expenses
    • Lecture 13 :
    • Expense on Spare Parts
    • Lecture 14 :
    • Depreciation Expense and PPE Schedule
    • Lecture 15 :
    • Amortization Expense and Intangibles Schedule
    • Lecture 16 :
    • Interest Expense and Investment Loan Schedule
    • Lecture 17 :
    • Interest Expense and Working Capital Loan
    • Lecture 18 :
    • Other Expenses
  • Section 3 : Balance Sheet 13 Lectures 00:55:20

    • Lecture 1 :
    • Starting the Balance Sheet
    • Lecture 2 :
    • PPE, Intangibles and Deferred Tax Assets
    • Lecture 3 :
    • Cash Conversion Cycle Historical Review
    • Lecture 4 :
    • Working Capital - Annualized Sales and Cost of Goods Sold
    • Lecture 5 :
    • Working Capital - Inventory
    • Lecture 6 :
    • Working Capital - Receivable
    • Lecture 7 :
    • Working Capital - Payables
    • Lecture 8 :
    • Intercompany Receivables
    • Lecture 9 :
    • Other Receivables
    • Lecture 10 :
    • Investment and Working Capital Loans
    • Lecture 11 :
    • Other Payables
    • Lecture 12 :
    • Retained Earnings & Pre-tax Profit
    • Lecture 13 :
    • Share Capital and Reserves
  • Section 4 : Cash Flow Statement 1 Lectures 00:12:08

    • Lecture 1 :
    • Link the Cash Flow Statement
  • Section 5 : Improving Our Model 2 Lectures 00:19:09

    • Lecture 1 :
    • Dynamic Validation Checks
    • Lecture 2 :
    • Bank Covenants Check
  • Section 6 : Optimizing Our Model 2 Lectures 00:20:27

    • Lecture 1 :
    • Optimizations in Admin and Selling Expenses
    • Lecture 2 :
    • Assumptions and Dynamic Scenarios
  • Section 7 : Sharing Our Model 3 Lectures 00:21:07

    • Lecture 1 :
    • Create a Print-ready Summary Statement
    • Lecture 2 :
    • Group Model Sections
    • Lecture 3 :
    • Save Without Links
  • Section 8 : Conclusion 2 Lectures 00:00:44

    • Lecture 1 :
    • Congratulations!
    • Lecture 2 :
    • Resources Files
  • Section 9 : Additional Lectures and Learning Materials 5 Lectures 01:08:04

    • Lecture 1 :
    • Running a Monte Carlo Simulation in Excel
    • Lecture 2 :
    • Mapping a Trial Balance to Create Financial Statements
    • Lecture 3 :
    • Sensitivity Analysis in Excel Models
    • Lecture 4 :
    • Pareto Analysis in Excel (80/20 Rule)
    • Lecture 5 :
    • Create a Dynamic Sales Dashboard to Visualize Data
  • Learnfly Google Logo
  • Learnfly Facebook Logo
  • Learnfly Apple Logo
  • Learnfly EA Logo
  • Learnfly Amazon Logo
  • Learnfly IBM Logo
  • Learnfly Microsoft Logo
  • Learnfly Reddit Logo
  • Learnfly Spotify Logo
  • Learnfly Uber Logo
  • Learnfly Youtube Logo
  • Learnfly Instagram Logo
  • How do i access the course after purchase?

    It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
  • Are these video based online self-learning courses?

    Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
  • Can i play & pause the course as per my convenience?

    Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
  • How do i contact the instructor for any doubts or questions?

    Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
  • Do i need a pc to access the course or can i do it on mobile & tablet as well?

    Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
  • Do i get any certificate for the courses?

    Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
    Learnfly LMS Sample
  • For how long can i access my course on the platform?

    You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
  • Is there any free trial?

    Currently, we do not offer any free trial.
  • Can i cancel anytime?

    Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?
User Images | Learnfly

92534 Course Views

1 Courses

For the past ten years, I have been working in the fields of audit, management accounting, financial modeling, budgeting, and reporting. I am excited about delving deep into the specifics of various industries and identifying the best solutions for clients. The best part about my career has been the opportunity to share my knowledge and pass it on to colleagues and friends. I love creating video tutorials, doing one-on-one coaching, and organizing training sessions for businesses. In my spare time, I am into video compositing and writing. The time offline I prefer to spend hanging out with friends, hiking, skiing, or reading a nice fantasy book.
View More...
  • Unmatched Variety and Value!
    Learnfly's monthly subscription offers unlimited access to a vast range of courses. Affordable pricing, compared to competitors, makes it the ultimate choice for continuous learning.
    Jessica M.

    4.7

    JM
  • Top-Notch Quality, Affordable Rates!
    High-quality courses with certified instructors make Learnfly stand out. The affordable pricing is a game-changer for those seeking premium education.
    Alex P.

    4.5

    AP
  • Certified Excellence Every Time!
    Learnfly's courses, taught by certified instructors, ensure top-notch learning experiences. The course completion certificates add significant value to one's skill set.
    Sarah R.

    4.3

    SR
  • Round-the-Clock Support!
    Learnfly goes the extra mile with 24/7 course support. Their dedication to helping students succeed is commendable.
    Ryan K.

    4.1

    RK
  • Learn Anywhere, Anytime!
    Whether on mobile, PC, or tablet, Learnfly's platform offers flexibility. Learning on the go has never been easier.
    Emily S.

    4.7

    ES
  • Job-Ready Skills!
    Learnfly's job-oriented courses equip learners with practical skills for the workplace. An investment in career growth!
    Jake M.

    4.2

    JM
  • Budget-Friendly Brilliance!
    Learnfly's pricing is a steal for the quality and variety of courses offered. Quality education without breaking the bank.
    Olivia T.

    4.5

    OT
  • Instructor Excellence Unleashed!
    Learn from the best with Learnfly's certified instructors. The platform ensures that knowledge is imparted by industry experts.
    Daniel L.

    4.0

    DL
  • Achievement Unlocked!
    Learnfly not only offers courses but also recognizes your efforts with course completion certificates. A sense of accomplishment with every course finished.
    Maya H.

    4.6

    MH
  • Learning Revolution!
    Learnfly's platform is a revolution in education. Access to unlimited courses at affordable rates is a game-changer.
    Ethan W.

    4.7

    EW
  • learn-ms-excel-from-basic-to-advance

    Learn MS Excel From Basic to Advanc...

    By : Ashwini Bissa

    Lectures 14 Beginner 0:24:50
  • odoo-purchases-sales-inventory-with-accounting-modules

    Odoo: Purchases, Sales, Inventory w...

    By : Quantic Statistics R spatial analysis

    Lectures 13 Beginner 3:20:52
  • hotel-management-course-analyse-financial-statements-and-performance

    Hotel Management Course - Analyse f...

    By : Manish Gupta

    Lectures 34 Intermedite 2:58:18
  • how-to-carry-out-financial-analysis-as-a-banker

    How to carry out Financial Analysis...

    By : CA N Raja Natarajan

    Lectures 25 Intermedite 2:57:27
  • advanced-capital-budgeting-improve-long-term-roi

    Advanced Capital Budgeting: Improve...

    By : Blair Cook

    Lectures 7 Intermedite 0:54:52
  • envision-the-future-financial-modeling-using-excel

    Envision the Future: Financial Mode...

    By : Blair Cook

    Lectures 8 Intermedite 1:32:15

Students learning on Learnfly works with Fortune 500 companies around the globe.

  • Learnfly | a-l-1a Icons
  • Learnfly | a-l-2a Icons
  • Learnfly | a-l-3a Icons
  • Learnfly | a-l-4a Icons
  • Learnfly | a-l-6a Icons
  • Learnfly | a-l-7a Icons
Sign Up & Start Learning
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons
Learnfly | Sign Up Icons
By signing up, you agree to our Terms of Use and Privacy Policy
Reset Password
Enter your email address and we'll send you a link to reset your password.
Learnfly | Sign Up Icons