Finance Assignment

Assignments

Activity 5.1: Read and Review

Gapenski, L. (2010). Understanding Healthcare Financial Management. (6^th ed.). Chicago, IL: Health Administration Press.

1.      Read the following in the Understanding Healthcare Financial Management:

a.       Chapter 13 – Financial Condition Analysis

b.      Chapter 14 – Financial Forecasting

Activity 5.2:  Submission - Chapter Problems (25 points)

Chapter problem assignments allow you to demonstrate your understanding of how to formulate and solve various types of financial management problems used in the decision making process.

Each assigned chapter problem is worth five points and requires you to present your solutions using Microsoft Excel. 

1. Complete the following problems located on the text book’s companion web site http://www.ache.org/pubs/hap_companion/book.cfm?pc=WWW1-2164:
   Note: You may want to save the Excel spreadsheet from the website to your desktop before you start to work on the problems.

a.       Chapter 13

                                                              i.      Explore the Spreadsheet Model

                                                            ii.      Solve End-of-Chapter Problems 1, 2, and 3

b.      Chapter 14

                                                              i.      Explore the Spreadsheet Model

                                                            ii.      Solve End-of-Chapter Problems 1 and 2

Save your work in the website Excel document. Title your saved document WS5 A2