Middlebury

INTD 1160

Fin. Modeling/Data Analysis

Financial Modeling and Data Analysis
Spreadsheets are amazing tools for organizing information, performing analysis, and persuading others. In this hands-on course, we will use spreadsheets to evaluate financial projects and analyze data. In the finance portion of this course, we will build financial models to evaluate projects on both a pre-tax unleveraged basis and an after-tax leveraged basis. Evaluation criteria such as NPV, IRR, coverages, and sensitivities will be covered. In the data portion of this course, we will create meaning from data sets by learning to organize, analyze, summarize, and present insights about the data. Topics covered will include: Functions, Filters, Pivot Tables, and Basic Statistics.
Subject:
Interdepartmental
Department:
Interdepartmental
Division:
Interdisciplinary
Requirements Fulfilled:
DED WTR

Sections

Winter 2015

INTD1160A-W15 Lecture (Chroman)