Healthcare Financial Modeling With Excel

This course will cover key concepts of financial modeling, including the purpose, inputs, design, and interpretation of core models, particularly as they relate to the healthcare industry. Heavy emphasis will be placed on understanding spreadsheet concepts, the interactive nature of modelling, scenario planning, and forecasting best practices.

Microsoft Excel will be utilized for model development and students will explore the software tool’s primary financial functions and capabilities.

Learning Outcomes:
By the end of this course, students will obtain a broad understanding of Excel’s capabilities as they relate to financial analysis, modeling, and predictive analytics. By the end of this course, students will be able to:

Utilize key formulas, shortcuts, commands, formatting, and mathematical principles in Excel
Build financial models including a 3-statement-model, discounted cash flow, capital and operating budgets, and staffing models
Develop the skills to create educated projections using sensitivity analyses
Interpret materials for deliverable and presentation purposes
Prerequisites

Introductory education in financial and accounting principles is required, preferably with some understanding of healthcare environments. In particular, students should have experience reviewing and analyzing accounting statements (income statements, balance sheets, and statements of cash flow) and breakeven analyses.

Students must also have an intermediate understanding of Microsoft Excel.

Format: This course is offered in an online asynchronous format. There are no set meeting times, however, students follow a weekly schedule and there will be deadlines to meet in terms of course requirements. This course cannot be completed at an accelerated rate. UCSD Extended Studies operates in Pacific Standard Time and therefore any deadline is considered 11:59 p.m. Pacific Standard Time.