1580758452-21 x1580758452-11.xlsx
The project is development of a diabetes treatment center( DTC) to provide comprehensive diabetes care and education .The project serves to respond to population health needs assessment needs that identified high rate of diabetes in population from different geographical regions especially those living at 200 percent or below of poverty level. St. Ann Diabetes Treatment Centre (DTC), is a non-profit community hospital whose objectives are to develop a new addition within the facility to provide education and care to their patients. The clinic specializes in offering Diabetes health care to populations in the community who are diagnosed with this illness. After the clinic completed assessments with the members in the surrounding population they discovered that it is a high rate of individuals with diabetes. DTC realized that 50% of the population is 200% of the poverty level.
St. Anne Diabetes Treatment Center (DTC) Business Plan
I. Executive Summary
II. Program Overview
St. Anne Diabetes Treatment Center (DTC) Business Plan
I. Executive Summary
II. Program Overview
Location
Services
Other Professional Offerings
Staffing Needs
Operating Model
III. Market Profile
Market Overview
Demand Forecasting
IV. Financial Analysis
Capital Requirements
Reimbursement Model
Cost Per Patient Visit
V. Pro Forma
Patient Revenue
Operating Expenses
Income from Operations
Total expenses
Net Cash Flow
Pro-Forma Income Statement for DTC
1
Year 1Year 2Year 3Year 4Year 5
Visits4,8825,1265,3825,6525,934
Revenue Per Visit$450$450$450$450$450
Gross Revenue
Patient Reveue
Deductions from Patient Revenue
Contractual
Total Deductions from Revenue
Net Patient Revenue$0$0$0$0$0
Operating Expenses
Salaries and Wages
Employee Benefits
Utilities
Repair/Maintenance
Housekeeping
Telephone Service
Depreciation
Malpractice
Miscellaneous/Other
Variable Medical Supply Costs
Other Non-Personnel Costs
Excess of Rev over Exp. From Operations$0$0$0$0$0
Cummulative Income$0$0$0$0$0
Net Cash from Excess Rev (excl Depreciation)$0$0$0$0$0
Cummulative Income Net Cash$0$0$0$0$0
Pro Forma Income Statement
Sheet1
Pro Forma Income Statement | |||||||||||||||||||||||||||||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |||||||||||||||||||||||||||||||||
Visits | 4,882 | 5,126 | 5,382 | 5,652 | 5,934 | ||||||||||||||||||||||||||||||||
Revenue Per Visit | $450 | ||||||||||||||||||||||||||||||||||||
Gross Revenue | |||||||||||||||||||||||||||||||||||||
Patient Reveue | |||||||||||||||||||||||||||||||||||||
Gross Patient Revenue | |||||||||||||||||||||||||||||||||||||
Deductions from Patient Revenue | |||||||||||||||||||||||||||||||||||||
Contractual | |||||||||||||||||||||||||||||||||||||
Total Deductions from Revenue | |||||||||||||||||||||||||||||||||||||
Net Patient Revenue | $0 | ||||||||||||||||||||||||||||||||||||
Operating Expenses | |||||||||||||||||||||||||||||||||||||
Salaries and Wages | |||||||||||||||||||||||||||||||||||||
Employee Benefits | |||||||||||||||||||||||||||||||||||||
Utilities | |||||||||||||||||||||||||||||||||||||
Repair/Maintenance | |||||||||||||||||||||||||||||||||||||
Housekeeping | |||||||||||||||||||||||||||||||||||||
Telephone Service | |||||||||||||||||||||||||||||||||||||
Depreciation | |||||||||||||||||||||||||||||||||||||
Malpractice | |||||||||||||||||||||||||||||||||||||
Miscellaneous/Other | |||||||||||||||||||||||||||||||||||||
Variable Medical Supply Costs | |||||||||||||||||||||||||||||||||||||
Other Non-Personnel Costs | |||||||||||||||||||||||||||||||||||||
Total Operating Expenses | |||||||||||||||||||||||||||||||||||||
Excess of Rev over Exp. From Operations | |||||||||||||||||||||||||||||||||||||
Cummulative Income | |||||||||||||||||||||||||||||||||||||
Net Cash from Excess Rev (excl Depreciation) | |||||||||||||||||||||||||||||||||||||
Cummulative Income Net Cash |