FI 105

Modeling for Financial Analysis

3 Unit(s)

Presents the techniques of financial analysis and modeling using electronic spreadsheet tools. Includes basic operations such as organizing spreadsheets, entering numbers and text, performing calculations, using financial commands, creating charts, embedding spreadsheets in word processing documents, file management, etc. It emphasizes advanced spreadsheet methods for doing sensitivity analysis, break-even ratio analysis, capital budgeting, sales forecasting, funds forecasting, cash budgeting, cash flow and financial ratio analysis, and capital structure analysis. This is a hands-on course that develops spreadsheet skills and shows how to use the results to make better financial decisions. It highlights the use of spreadsheets for communicating as well as calculating. Prerequisite(s): FI 100.