APEC4501

Download as PDF

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

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]

Minimum credits

2

Maximum credits

2

Is this course repeatable?

No

Grading basis

AFV - A-F or Audit

Lecture

Fulfills the writing intensive requirement?

No

Typically offered term(s)

Every Spring