Syllabus
Course Code: IT-403 Course Name: Specialisation – E: INFORMATION TECHNOLOGY - E-Business Financial Modeling |
||
MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
---|---|---|
1 | Introduction to Excel and Financial Modeling :Introduction to Excel, Overview of Financial Modeling, Types and Purpose of financial models, Navigate Worksheets and Workbooks, Name Manager Exploring Excel as a Tool for Financial Modeling : Excel Functions, Mathematical Functions, Statistical Functions, Financial Functions, Logical Functions, Lookups & Reference Functions, Text Functions, Date & Information Functions. Advanced analysis techniques :Working named ranges, Working with Charts, Data Validation, Hyperlink, Conditional Formatting, Pivot Tables, Auto & Advance Filter, Grouping & Ungrouping, Sheet Protection, What if Analysis, Financial Statement Analysis Understanding the Financial Statements and its interlinking: Income Statement, Balance Sheet, Cash Flow Statement, Ratio Analysis, Basic and Diluted EPS,ROE and DUPONT Analysis. Introduction to Valuation: Need to value companies, Difference between price and value, Different terms of value: Market value/Intrinsic value, Valuation Techniques :Absolute Valuation Free Cash flow to Firm (FCFF)/Free Cash flow to Equity (FCFE)/Cost of Equity (Ke) /Cost of Debt (Kd) /Cost of Capital (WACC)/,Relative Valuation :Equity based Multiples: P/E, P/BV, P/S & PEG/Firm based Multiples: EV/EBITDA, EV/EBIT & EV/Sales. |