APEC4501: Financial Modeling: Spreadsheet Applications in Finance, Management, and Marketing
2 Credits
Designing/implementing solutions to problems in finance, management, and market analysis with MS Excel® spreadsheet, VBA language, MS Power BI and Power Excel tools. Exercises cover topics such as proforma financial statement analysis, efficient portfolio derivation, VBA macros and functions, and building interactive dashboards for analysis of market trends. prereq: [APEC 3501 or FINA 3001], [APEC 1251 or ACCT 2050]