The Undergraduate Business Analytics Club Presents: Financial Functions Workshop

The financial function workshop is mainly for finance majors who are interested in having a jump start on utilizing functions in Excel to understand basic financial concepts like loan payments, interest paid and earned during a specific period, and calculating coupons. This workshop will be especially helpful for freshmen/sophomore and probably juniors. A spreadsheet with examples will be provided to each attendee to work on examples together. Assistance will be given to students who might fall behind during the workshop.

This workshop will show attendees how to use majority of the financial functions in Excel 2016 to analyze data. Some of the topics to cover include: How to calculate PPMT, Interest Paid during a Specific Period, Number of Periods, Depreciation (using both the straight line & declining methods), analyzing CF, and many more.