Healthcare Financial Modeling With Excel

Students must have an intermediate understanding of Microsoft 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
• 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.


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.