Exercises
Below are links to examples, practice exercises, and
assignments in Microsoft Excel 95 and Microsoft Word 95. Not all chapters have examples,
practice exercises, or assignments.
Chapter 2
Assignment
Student Assignment Exercise
2-1.doc
Chapter 4
Example
Student
Example 4-A Contractual Allowances.xls
Assignment
Assignment
Exercise # 4-2 Revenue Sources and Grouping Revenue.doc
Chapter 5
Practice Exercise
Practice
Exercise 5-I Grouping Expenses by Cost Center.doc
Assignment
Assignment
Exercise 5-1 Grouping Expenses by Cost Center.doc
Chapter 6
Practice Exercises
Practice
Exercise 6-I Identifying Direct and Indirect Costs.doc
Practice
Exercise 6-II Responsibility Centers.doc
Assignment
Student
Assignment Exercise 6-1 Allocating Indirect Costs.xls
Chapter 7
Practice Exercises
Student
Practice Exercise 7-I Analyzing Mixed Costs.xls
Student
Practice Exercise 7-II Calculating the Contribution Margin.xls
Student
Practice Exercise 7-III Calculating the PV Ratio.xls
Assignments
Student
Assignment Exercise 7-1 Analyzing Mixed Costs.xls
Student
Assignment Exercise 7-2 Calculating Contribution Margin.xls
Student
Assignment Exercise 7-3 Calculating the PV Ratio & CVP Ratio.xls
Chapter 8
Examples
Student Example 8-A .xls
Student Example 8-B.xls
Practice Exercises
Student
Practice Exercise 8-I FTEs to Annualize Staffing.xls
Student
Practice Exercise 8-II FTEs to Fill a Position.xls
Assignments
Student
Assignment Exercise 8-1 FTEs to Annualize Staffing.xls
Student
Assignment Exercise 8-2 FTEs to fill a Position.xls
Chapter 9
Examples
Example 9-A Common
Sizing.doc
Example 9-II Trend
Analysis.doc
Practice Exercises
Student
Practice Exercise 9-I Common Sizing.xls
Student
Practice Exercise 9-II Trend Analysis.xls
Assignments
Student
Assignment Exercise 9-1 Common Sizing.xls
Student
Assignment Exercise 9-2 Trend Analysis.xls
Chapter 10
Example
Student Example 10-A
Budgeting.xls
Practice Exercises
Student Practice
Exercise 10-I Budgeting.xls
Student
Practice Exercise 10-B Variance Analysis.xls
Assignments
Student
Assignment Exercise 10-3 Variance analysis.xls
Chapter 11
Examples
Student
Example 11-A Unadjusted Rate of Return.xls
Example
11-B Finding the Future Value.doc
Example
11-C Finding the Present Value.doc
Example
11-D Internal Rate of Return.doc
Student Example 11-E
Payback Period.xls
Practice Exercises
Student
Practice Exercise 11-I Unadjusted Rate of Return.xls
Practice
Exercise 11-II Finding the Future Value.doc
Practice
Exercise 11-III Finding the Present Value.doc
Practice
Exercise 11-IV Internal Rate of Return.doc
Student Practice
Exercise 11-V Payback.xls
Assignments
Student
Assignment Exercise 11-1 Unadjusted Rate of Return.xls
Assignment
Exercise 11-2 Finding the Future Value.doc
Assignment
Exercise 11-3 Finding the Present Value.doc
Assignment
Exercise 11-4 Computing an Internal Rate of Return.doc
Student
Assignment Exercise 11-5 Payback Period.xls
Chapter 12
Practice Exercises
Practice
Exercise 12-I Components of Balance Sheet and Statement of Revenue and Expenses.doc
Student
Practice Exercise 12-II Depreciation Concept.xls
Assignments
Assignment
Exercise 12-1 Components of Balance Sheet.doc
Chapter 13
Practice Exercises
Student
Practice Exercise 13-I Liquidity Ratios.xls
Student
Practice Exercise 13-II Solvency Ratios.xls
Student
Practice Exercise 13-III Profitability Ratio.xls
Assignments
Student
Assignment Exercise 13-1 Liquidity Ratios.xls
Student
Assignment Exercise 13-2 Solvency Ratios.xls
Student
Assignment Exercise 13-3 Profitability Ratios.xls
Chapter 14
Assignments
Student
Assignment Exercise 14-1 Quartiles.xls
Assignment
Exercise 14-3 Pareto rule.doc
Supplemental Material: Metropolis Health System
Student Metropolis Balance
Sheet.xls
Student
Metropolis Change in Fund Balance.xls
Student
Metropolis Revenue & Expenses.xls
Student
Metroplois Schdule of Hosp Statistics.xls
Student
Metropolis Schdule Operating Expenses Exer.xls
Student
Metropolis Schdule Patient Revenue.xls
Student
Metropolis SchdulePlant & Equip.xls
Supplemental Material: Doctors Smith and Brown
Student Smith and
Brown Bal Sheet.xls
Student Smith
Brown Change in Capital.xls
Student
Smith and Brown Net Income State.xls |
