Syllabus
Course Code: BA-403 Course Name: Specialisation- H: BUSINESS ANALYTICS - Financial Modeling |
||
MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
---|---|---|
1 | Corporate Financial Statements Spreadsheet skills: Organizing and creating spreadsheets; entering and formatting data values; entering expressions for calculating values; linking worksheets; splitting screens to facilitate working between several worksheets. Financial management skills: Understanding the three key financial statements (i.e., a company’s income statement, balance sheet, and cash flow statement) and the relationships between the various items on them. Analysis of Financial Statements Spreadsheet skills: Using logical IF statements; using conditional formatting to call attention to conditions that need correcting; pasting an Excel document into a Word document. Financial management skills: Analyzing the year-to-year changes in financial statements and various financial ratios; performing vertical analysis of financial statements; using financial ratios to benchmark a company’s performance against competitors; inserting spreadsheet results into company reports. Forecasting Annual Revenues Spreadsheet skills: Creating, validating, and using linear, quadratic, cubic, and exponential regression models to fit the trends of historical data; creating various types of charts (e.g., scatter diagrams, forecast charts, error patterns, and downside risk curves); estimating the accuracy of forecasts; expressing forecast accuracy in terms of confidence limits and downside risk curves. Financial management skills: Making forecasts; recognizing the difference between valid and invalid forecasting models; handling the risks inherent in forecasts; adjusting regression models for changes in trends. |