Budgeting Models using EXCEL

Theme

Key Topics

Introduction

Financial Models, Master Budget, Sensitivity Analysis, Contribution Margin Analysis, Ratio Analysis, Valuation

Sales and Collections

Assumptions, Dashboard, Unit Sales, Price, Composition, Cash collections from customers, Accounts receivables

COGS, Inventory, Purchases

Cost of Goods Sold, Inventory, Purchase, Disbursements for Budgets, Accounts Payable

Operating Expenses

Headcount, Operating Expenses, Disbursements

Income Statement

Budgeted Income Statement

Capital Budget & Cash Budget

Capital Expenditures, Disbursements, Depreciation, Cash

Balance Sheet

Budgeted Balance sheet

Note - Course content and topics to be covered in the training can be customized as per requirement for Corporates.

Faculty profile

FEES for Corporates

Based on the syllabus, contents and other requirements for the corporate training, scope with detailed inclusions and exclusions along with the fee will be shared.