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.
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
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.
Note: Students successfully completing this course will earn quarter units which may be eligible to be used towards the CA Board of Accountancy's educational requirement for CPA Exam eligibility and licensure. For more information contact firstname.lastname@example.org or https://www.dca.ca.gov/cba/
Course Number: BUSA-40992
Credit: 2.00 unit(s)
Related Certificate Programs: Healthcare Financial Analysis
+ Expand All
7/31/2023 - 9/10/2023
This course is entirely web-based and to be completed asynchronously between the published course start and end dates. Synchronous attendance is NOT required.
You will have access to your online course on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.
No information available at this time.
No refunds after: 8/8/2023.
Healthcare Finance: An Introduction to Accounting and Financial Management, 7th Edition, Gapenski, Louis C. and Reiter, Kristin L. (eBook is available from VitalSource) ISBN: 978-1-64055-186-2
You can buy your course textbooks or get information about them from the UC San Diego Bookstore. You can
visit the UC San Diego Bookstore Website, call at (800) 520-7323, or visit in person. You may also be able to
buy or rent books from other online retailers.
7/31/2023 - 9/10/2023
You will have access to your course materials on the published start date OR 1 business day after your enrollment is confirmed if you enroll on or after the published start date.
There are no sections of this course currently scheduled. Please contact the Business, Professional & Legal Programs department at 858-534-8131 or email@example.com for information about when this course will be offered again.