APEC4501
APEC 4501 - Financial Modeling: Spreadsheet Applications in Finance, Management, and Marketing (2 Cr.)
Applied Economics (11033)
TCOA - College of Food, Agricultural and Natural Resource Sciences
APEC 4501 - Financial Modeling: Spreadsheet Applications in Finance, Management, and Marketing (2 Cr.)
Course description
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]
prereq: [APEC 3501 or FINA 3001], [APEC 1251 or ACCT 2050]
Minimum credits
2
Maximum credits
2
Is this course repeatable?
No
Grading basis
AFV - A-F or Audit
Lecture
Typically offered term(s)
Every Spring