bdjobs.com :: Largest Job Site in Bangladesh

FM O1: Financial Modeling in Excel with Case Studies & Template

About Workshop

Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. This course will enable you to maximize the potential of the powerful Microsoft Excel software to produce more professional business information. This course is designed to equip participants with the technical knowledge of building financial models in Excel. The aim is to bridge the gap between financial theory and practice. Modeling skills acquired to develop sample applications in this course will provide participants with the tools and confidence to build their own finance applications.

Workshop topics to be covered:

Projects:

• Developing a Cash Flow Statement
• Developing an Income Statement
• Developing a Balance-Sheet
• Depreciation Calculation

Course Outline:

• The “A1” vs. the “R1C1“ style of cell references
• Types Of References Allowed In A Formula

a. Referencing cells from another worksheet
b. Referencing a block of cells
c. Referencing non–adjacent cells
d. Referencing entire rows
e. Referencing entire columns
F. Referencing corresponding blocks of cells/rows/columns from a set of worksheets

• Working simultaneously on cells in different worksheets
• Excel Workspace and grouping Excel workbooks
• Controlling cell reference behavior when copying and pasting formulae (use of the “$” key)
• Data validation
• Array formula
• Refreshing knowledge of essential functions :COUNT, COUNTA, COUNTBLANK, SUM, PRODUCT, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, AND, OR, NOT, INDIRECT, INDEX, TRIM, TRUNC, MATCH, SEARCH, MID, LEFT, RIGHT, REPLACE, ROUND, ROUNDUP, ROUNDDOWN, MAX, MIN, AVERAGE, AVERAGEA, OFFSET
• Error handling functions: ISNA, ISERR, ISERROR (#N/A, #Value!, #Ref!, #Div/0!, #Num!, #Name?, #Null!)
• Date Functions: DATEDIFF, YEAR, MONTH, DAY, NOW, TODAY
• Ranking Data
• Protecting Cells, Worksheets and Workbook
• Names in Formula
• Labels in formula
• Views
• Depreciation
• Depreciation of an asset over a single period
• Straight-line and Sum-of-year’s depreciation methods
• SLN function: Straight line depreciation
• SYD function: Sum-of-years' digit method
• Depreciation of an asset over specified period using declining balance methods
• Fixed declining balance method
• Variable declining balance method
• Developing a Cash Flow Statement
• Developing an Income Statement
• Developing a Balance-Sheet

Few Topics in Part 2 Training of this series ( Expecting to conduct shortly)
• Goal Seeking
• Solver Tool
• Working with scenarios
• What-IF analysis
• Data tables
• Tracing cell references & debugging formula errors
• Using charts in Financial Modeling
• Functions: PV, NPV, XNPV, IRR, MIRR, XIRR, RATE, NPER, FV, FVSCHEDULE, PMT, PPMT, etc.
• Loan Repayment Schedule
• Calculating Interests
• Discount cash flow analysis
• Etc.

Few Topics in Part 3 Training of this series ( Expecting to conduct shortly)
• Advance Financial Modeling
• Monte-Carlo Analysis
• Some Statistical Modeling
• Using VBA, add-ins including Crystal Ball for financial modelin

Back to Workshop Home