Capstone Homework
It is designed to familiarize you with the real-world practices of budgeting and financial management in healthcare organizations and demonstrate your ability to analyze a budget/financial statement using excel spreadsheets. It will require the application of the skills and concepts you have learned during the semester including a review of the pertinent literature. It will include a written and oral presentation component, including PowerPoint slides to be presented on the last day of class. This paper should be approximately 18 to 20 pages in length.
Can be a hospital, nonprofit, healthcare provider, health insurance, etc.
Suggested steps for conducting the project are described below:
A. Identify a healthcare organization that you are most interested in
B. Conduct a thorough literature review of budgeting, accounting, and/or financial management practices for the organization (e.g. hospital, clinic, etc.) you have selected to investigate.
C. Examine at least two or three past budgets and/or annual financial reports for your chosen entity to get a sense of its finances and budgeting/financial management practices.
D. Choose some particular topics that are worthy of more attention. For example, the condition of the economy might have affected funding levels and/or budgeting practices for particular revenues, programs, and services provided.
E. Develop at least five analytical techniques (provided by a professor) you have learned this semester for budgets and financial analysis. Use of excel spreadsheet for analysis, present value, forecasting, etc. must be incorporated. `You may also use charts and tables.
The report should be no more than 20 pages and include a detailed. The report should include all of the following and be structured as follows:
A. Cover Page
B. Table of contents
C. Abstract (No more than 300 words)
D. Introduction and background information for the chosen entity
a. Problem that you are looking at;
b. State purpose of your paper
E. Literature review
F. Budget/Financial Analysis
a. Include a basic description of your budget.
b. What accounts for the major sources of revenue and expenses?
c. Use at least 5 analytical techniques you will learn this semester for analysis (provided by professor)
d. Use of excel spreadsheets for analysis, present value, forecasting etc. must be incorporated. You may also use charts and tables.
G. Conclusion
H. References (not included in page limit)
a. Appendix (not included in page limit)
b. Any necessary supporting documents from the actual budget(s) that you have examined
An example of the paper will be available. Excel spreadsheets should be within the report and the Powerpoint (15 mins worth) reflecting the paper and results from the budget.
With the Excel spreadsheet:
Sheet 1= Ratio Analysis
Sheet 2= Forecasting
Sheet 3= Time Value of $
Sheet 4= Cost-benefit analysis
Sheet 5= Bond Valuation
Format your homework according to the give formatting requirements:
a. The answer must be double spaced, typed, using Times New Roman font (size 12), with one-inch margins on all sides.
b. The response also includes a cover page containing the title of the homework, the course title, the student's name, and the date. The cover page is not included in the required page length.
c. Also include a reference page. The references and Citations should follow APA format. The reference page is not included in the required page length.