Business Finance Course
Course Features
Module 1- Financial statements: The language of business
1. Basics of Accounting, Why & How
2. Learn accounting Principles &concepts, Revenue& Expenses Recognition
3. Revenue & Gross Margin, Net Margin, accrued Income & Net Income etc
4. Capitalization of Expenditure, Revenue Expenditure, Prepaid Expense etc
5. Preparation &overview of main financial statements
6. Understanding of financial statements
Module 2 - Cash Flow & Funds Flow Statement: Movement of Cash/Funds
1. Preparation of Cash Flow Statement & Fund Flow Statement
2. Learn Analysis of CFS / FFS
3. Discuss managerial implications of CFS / FFS
Module 3 - Financial Analysis & Ratios
1. Learn Ratios Analysis & Financial Analysis
2. Learn how to evaluate company performance
3. Implications of financial analysis
Module 4 - Financial Planning and Capital Budgeting
1. Understanding & Requirement of Capital Budgeting
2. Capital Budgeting Options IRR, NPV & PBP
3. Assess & Choose investment options
Module 5 - Working Capital Management
1. Evaluate requirement of Working Capital
2. Management of Working Capital
3. Credit period, Finance cost of Credit period
Module 6 - Preparation of Reports in Excel / MIS/ Advance Excel
1. Preparation of Financial Reports, Budgets and Other in Excel
2. Creating Formulas , AutoSum, Common Formulas, Data Validation, Goal Seek
3. Formatting data and tables - Data formatting
4. Mathematical Formulas
5. Analysis Tools Creating PivotTables, Choosing Fields, PivotTable Layout, Filtering PivotTables
6. Lookup Formulas - This Excel lecture covers Lookup formulas such as VLOOKUP, HLOOKUP