Docstoc

Sample Startup Projections (Excel)

Document Sample
Sample Startup Projections (Excel) Powered By Docstoc
					Summary Page
                              Borrower:

                         Items                                                      = Formula cell (do not type)
Real Estate Acquisition/Construction
Capital Equipment                                  113,585              Note: Working Capital for SBA purposes is
Start Up Costs                                      38,250              the total of Startup Costs, Working Capital (operating)
Build Out/Leasehold Improvements                   157,930              and Closing Costs. This total may be limited
Operating Working Capital                          100,000              to approximately 30% of Project Total, but may be larger,
SBA Closing Costs                                   14,000              please consult with your Coffman Representative
PROJECT TOTAL                                      423,765

Less 10% Borrower Cash Injection                    42,376              *Working Capital Percentage:        35.93%


Coffman Capital SBA Loan                           381,388



Notes


*Start-up cost incorporated into the proforma and reflected in first year cost, to be classified as
working capital and combined with amount shown as operating working capital
Assumptions

Clinic Open 60 Hrs/Week


Patient Encounters
                                                                    Patient encounter is defined as face to face encounter with physician provider
                                                                    Patient encounters are based on 312 practice days/year312
                                                                    Average practice days/month = 26

Patient Encounter Projections

Month                                                                  1        2       3       4       5     6        7     8     9     10    11      12     13    14      15     16      17      18       19    20    21    22     23     24    Total
Per Month                                                                  56   110     165     218     272   318      371   425   480   535     589    641   639    659     679    699    720      740     760   780   800    820    840   860   13176
Per Day                                                                    2        4       6       8   10        12   14    16    18     21     23     25     25     25      26     27     28         28    29    30    31     32    32     33

Center is open 26 days/month

Revenue Projections
                                                                    Total revenue per encounter = $140.00

Expenses

WAGES & BENEFITS:Physicians (1FTE + 1PTE) 1.5                       Based on 1.5 FTE Physician paid at $65 per hour on contract bases. Officer(MD) will provide coverage one day per week at no cost
WAGES & BENEFITS: Officer                                           Officers will only be compensated from profit; amount for loan projections is based on SBA requirements for minimum draw
WAGES & BENEFITS:Officer Payroll Taxes                              Officers will only be compensated from profit
WAGES & BENEFITS: Staff                                             Require 1.5 FTE in first year at $18 per hour. Assumption is billing will be outsourced Addition FTE in 5th mth 2nd year
WAGES & BENEFITS:Payroll Taxes - Staff (7.7%)                       Payroll tax of staff
WAGES & BENEFITS:Retirement Plan                                    Not offered, may consider in future
WAGES & BENEFITS:Health Insurance                                   Health insurance not offered, may consider in future
WAGES & BENEFITS:Other payroll expenses                             Payroll services cost
ADVERTISING, MARKETING:Practice Development                         Marketing cost with front load expense and $20,000 spent in first year
AUTO EXPENSES:Officer                                               Officers will only be compensated from profit
BANK, CREDIT CARD CHARGES:Merchant Card Service                     Projected cost for credit card deposits
BANK, CREDIT CARD CHARGES:Other bank charges                        Projected cost for bank charges
COMMUNICATIONS:Answering Service                                    N/A
COMMUNICATIONS:Office - Basic & long-distance                       Projected installation of telephones plus monthly cost, actual cost for system incorporated into equipment lease
COMMUNICATIONS:Cellular Telephone                                   N/A
COMMUNICATIONS:Cellular Officer Cellular Phone                      N/A
COMMUNICATIONS:Internet                                             Projected monthly cost
DUES & SUBSCRIPTIONS:Officer Professional Dues                      Officers will only be compensated from profit
DUES & SUBSCRIPTIONS:General Dues                                   Budgeted expense
DUES & SUBSCRIPTIONS:General Subscripts & Pubs                      Budgeted expense
INSURANCE:General Liability Insurance                               Budgeted expense that is paid annually
INSURANCE:Life Insurance                                            N/A
INSURANCE:Malpractice Insurance Officer                             Projected at $12000 for Facility with 25% paid in 1st month
INSURANCE:Work Comp                                                 Budgeted expense based on 1% of staff and physician salary cost
INSURANCE:Disability                                                N/A
LICENSES & PERMITS:General Business                                 Budgeted expense for occupational licenses, biohazardous permit etc
MEDICAL SUPPLIES:Medical/Pharmaceutical                             Projected at 4% of revenue with initial cost projected from start-up needs
OFFICE & ADMIN EXPENSES:RENT@$28.50 per sq. ft.first yr.            Based on 3400 sq ft per month
OFFICE SPACE MAINT/TAX-$4.30 per sq. ft. per year for 3400 sq.ft.   Based on 3400 sq ft per year but paid out monthly
OFFICE SPACE UTILITIES                                              Budgeted expenses for utilities, Gas, light, waste
OFFICE & ADMIN EXPENSES:Computer repairs, maintenance*              Budgeted expense for hardware of computers, printers
OFFICE & ADMIN EXPENSES:Other repairs, maintenance                  Budgeted expense for copier, fax, other office equipment
OFFICE & ADMIN EXPENSES:Equipment                                   Based on capital equipment cost of $113,585 financed with SBA 7(a) loan
OFFICE & ADMIN EXPENSES:General office supplies                     Projected at 1% of revenue with initial cost budgeted from start up expenses
OFFICE & ADMIN EXPENSES:Printing and Reproduction                   Budgeted expense for stationary, business cards etc
OFFICE & ADMIN EXPENSES:Postage and Delivery                        Budgeted expense
OTHER EXPENSES:Interest, finance charges Loan Repayment             Based on loan of 391,507 at 4.50% at straight 15 year fixed repayment plan
OTHER EXPENSES:Miscellaneous                                        Budgeted expense
OTHER EXPENSES:Penalties                                            N/A
OTHER EXPENSES:Waste Management                                     Budgeted expense
PROFESSIONAL DEVELOPMENT:Officer CME                                Budgeted expense
PROFESSIONAL DEVELOPMENT:Staff Education                            Budgeted expense
PROFESSIONAL FEES:Accounting                                        Budgeted expense
PROFESSIONAL FEES:Billing Service                                   Practice has elected to bill in-house which results in increase captal expenses and staff
PROFESSIONAL FEES:Consulting                                        Budgeted expense for consultant fee during start up process with$5000 paid out over ten months
PROFESSIONAL FEES:Legal Fees                                        Budgeted expense for attorney fees to create partnership agreement
PROFESSIONAL FEES: Recruitment                                      Recruitment will be conducted via network connections to recruit MD's
INTANGIBLES                                                         $0 per month provided for unexpected expenses
TRAVEL, MEALS & ENT.:Officer Related Expense                        Officers will only be compensated from profit
TRAVEL, MEALS & ENT.:General Entertainment - 50%                    Officers will only be compensated from profit
TRAVEL, MEALS & ENT.:Lodging                                        Officers will only be compensated from profit
TRAVEL, MEALS & ENT.:Meals - 50%                                    Officers will only be compensated from profit
TRAVEL, MEALS & ENT.:Parking, local milage reimb                    Officers will only be compensated from profit
TRAVEL, MEALS & ENT.:Travel                                         Officers will only be compensated from profit




                                                                                                                                                                                                 4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xlsAssumptions
                             Year 1                                 Mnth 1    Mnth 2    Mnth 3    Mnth 4    Mnth 5    Mnth 6    Mnth 7      Mnth 8      Mnth 9     Mnth 10     Mnth 11    Mnth 12       Total  % of Total
Patient Encounters                                                       60       116       171       225       280       330       385         443         499         556         601        660        4326

REVENUE
Patient & Insurance Payments ($140 per encounter)                      8400     16240     23940     31500     39200     46200     53900        62020       69860      77840       84140       92400     605640

TOTAL REVENUES                                                         8400     16240     23940     31500     39200     46200     53900        62020       69860      77840       84140       92400     605640

EXPENSES
WAGES & BENEFITS:Physicians (2.5 FTE )                                14083     14084     14083     14084     14083     14084     14083        14084       14083      14083       14083       14083     169000        33.1%
WAGES & BENEFITS: Officer                                              2083      2083      2083      2083      2083      2083      2083         2083        2083       2083        2083        2083      25000         4.9%
WAGES & BENEFITS:Officer Payroll Taxes                                    0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
WAGES & BENEFITS:Staff                                                 8620      8620      8620      8620      8620      8620      8620         8620        8620       8620        8620        8620     103440        20.3%
WAGES & BENEFITS:Payroll Taxes - Staff (7.7%)                           664       664       664       664       664       664       664          664         664        664         664         664       7965         1.6%
WAGES & BENEFITS:Retirement Plan                                          0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
WAGES & BENEFITS:Health:Officer Health Insurance                          0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
WAGES & BENEFITS:Other payroll expenses (Paychex etc)                   100       100       100       100       100       100       100          100         100        100         100         100       1200         0.2%
ADVERTISING, MARKETING:Practice Development                            3000      2000      1000      1000      1000       500       500          500         500          0           0           0      10000         2.0%
AUTO EXPENSES:Officer                                                     0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
BANK, CREDIT CARD CHARGES:Merchant Card Service                          30        30        30        30        30        30        30           30          30         30          30          30        360         0.1%
BANK, CREDIT CARD CHARGES:Other bank charges                             25        25        25        25        25        25        25           25          25         25          25          25        300         0.1%
COMMUNICATIONS:Answering Service                                          0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
COMMUNICATIONS:Office - Basic & long-distance                          1000       300       300       300       300       300       300          300         300        300         300         300       4300         0.8%
COMMUNICATIONS:Cellular Telephone                                         0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
COMMUNICATIONS:Cellular Officer Cellular Phone                            0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
COMMUNICATIONS:Internet                                                  80        80        80        80        80        80        80           80          80         80          80          80        960         0.2%
DUES & SUBSCRIPTIONS:Officer Professional Dues                            0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
DUES & SUBSCRIPTIONS:General Dues                                         0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
DUES & SUBSCRIPTIONS:General Subscripts & Pubs                           25        25        25        25        25        25        25           25          25         25          25          25        300         0.1%
INSURANCE:General Liability Insurance & Property                        900         0         0         0         0         0         0            0           0          0           0           0        900         0.2%
INSURANCE:Life Insurance                                                  0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
INSURANCE:Malpractice Insurance for the Entity                         2400       873       873       873       873       873       873          873         873        873         873         873      12003         2.4%
INSURANCE:Work Comp (1% of Salary)                                      227       227       227       227       227       227       227          227         227        227         227         227       2724         0.5%
INSURANCE:Disability                                                      0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
LICENSES & PERMITS:General Business                                     500         0         0         0         0         0         0            0           0          0           0           0        500         0.1%
MEDICAL SUPPLIES:Medical/Pharmaceutical                                3000       650       958      1260      1568      1848      2156         2481        2794       3114        3366        3696      26890         5.3%
OFFICE & ADMIN EXPENSES:RENT@$28.50 per sq. ft.                        8075      8075      8075      8075      8075      8075      8075         8075        8075       8075        8075        8075      96900        19.0%
OFFICE SPACE MAINT/TAX-$4.30 per sq. ft. per year for 3400 sq.ft.      1218      1218      1218      1218      1218      1218      1218         1218        1218       1218        1218        1218      14620         2.9%
OFFICE SPACE UTILITIES                                                  250       250       250       250       250       250       250          250         250        250         250         250       3000         0.6%
OFFICE & ADMIN EXPENSES:Computer repairs, maintenance*                  250       250       250       250       250       250       250          250         250        250         250         250       3000         0.6%
OFFICE & ADMIN EXPENSES:Other repairs, maintenance                      250       250       250       250       250       250       250          250         250        250         250         250       3000         0.6%
OFFICE & ADMIN EXPENSES:General office supplies                        3000        84       162       239       315       392       462          539         620        699         778         841       8132         1.6%
OFFICE & ADMIN EXPENSES:Printing and Reproduction                        42        42        42       500        42        42        42           42          42         42          42          42        962         0.2%
OFFICE & ADMIN EXPENSES:Postage and Delivery                             50        50        50        50        50        50        50           50          50         50          50          50        600         0.1%
OTHER EXPENSES:Miscellaneous                                             50        50        50        50        50        50        50           50          50         50          50          50        600         0.1%
OTHER EXPENSES:Penalties                                                  0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
OTHER EXPENSES:Waste Management                                          76        76        76        76        76        76        76           76          76         76          76          76        912         0.2%
PROFESSIONAL DEVELOPMENT:Officer CME                                      0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
PROFESSIONAL DEVELOPMENT:Staff Education                                  0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
PROFESSIONAL FEES:Accounting                                            250       250       250       250       250       250       250          250         250        250         250         250       3000         0.6%
PROFESSIONAL FEES:Billing Service                                         0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
PROFESSIONAL FEES:Consulting                                            500       500       500       500       500       500       500          500         500        500           0           0       5000         1.0%
PROFESSIONAL FEES:Legal Fees                                           4250         0         0         0         0         0         0            0           0          0           0           0       4250         0.8%
PROFESSIONAL FEES: Recruitment                                            0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
INTANGIBLES                                                               0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
TRAVEL, MEALS & ENT.:Officer Related Expense                              0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
TRAVEL, MEALS & ENT.:General Entertainment - 50%                          0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%
TRAVEL, MEALS & ENT.:Lodging                                              0         0         0         0         0         0         0            0           0          0           0           0          0         0.0%


                                                                                                                                          4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xls Projections YR 1
                                 Year 1                       Mnth 1       Mnth 2      Mnth 3       Mnth 4      Mnth 5     Mnth 6    Mnth 7       Mnth 8      Mnth 9     Mnth 10     Mnth 11    Mnth 12       Total     % of Total
TRAVEL, MEALS & ENT.:Meals - 50%                                       0           0           0            0          0         0          0            0           0          0           0          0            0        0.0%
TRAVEL, MEALS & ENT.:Parking, local milage reimb                       0           0           0            0          0         0          0            0           0          0           0          0            0        0.0%
TRAVEL, MEALS & ENT.:Travel                                            0           0           0            0          0         0          0            0           0          0           0          0            0        0.0%
TOTAL EXPENSES                                                   54,998      40,856      40,241       41,080     41,004     40,862     41,239       41,642      42,036     41,934      41,765     42,159      509,818      100.0%
NET                                                            (46,598)    (24,616)    (16,301)      (9,580)     (1,804)    5,338     12,661       20,378      27,824     35,906      42,375     50,241       95,822
SBA 7(a) Loan of $-------- for 120 mo @ 9.25% (7.0 + 2.25)        4,883       4,883       4,883        4,883       4,883     4,883      4,883        4,883       4,883      4,883       4,883      4,883       58,596
Cash Flow Coverage Ratio                                          (9.54)      (5.04)      (3.34)       (1.96)     (0.37)     1.09       2.59         4.17        5.70       7.35        8.68      10.29          1.64
Net After Loan Debt Service                                    (51,481)    (29,499)    (21,184)     (14,463)     (6,687)      455      7,778       15,495      22,941     31,023      37,492     45,358       37,225


                                                             Loan Payment Factor for 10 year loan
                                                             0.0128033




                                                                                                                                                4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xls Projections YR 1
                             Year 2                                 Mnth 1    Mnth 2    Mnth 3    Mnth 4    Mnth 5    Mnth 6    Mnth 7    Mnth 8    Mnth 9    Mnth 10     Mnth 11    Mnth 12     Total Yr 2 % of Total Yr 2
Patient Encounters                                                      670       685       690       705       720       740       760       780       800        820         840        860          9,070

REVENUE
Patient & Insurance Payments ($140 per encounter)                    93,800    95,900    96,600    98,700   100,800   103,600   106,400   109,200   112,000    114,800     117,600    120,400      1,269,800

TOTAL REVENUES                                                       93,800    95,900    96,600    98,700   100,800   103,600   106,400   109,200   112,000    114,800     117,600    120,400      1,269,800

EXPENSES
WAGES & BENEFITS:Physicians (2.5FTE                                  14,083    14,084    14,083    14,084    14,083    14,084    14,083    14,084    14,083      14,083     14,083      14,083      169,000           32.3%
WAGES & BENEFITS: Officer                                             2,083     2,083     2,083     2,083     2,083     2,083     2,083     2,083     2,083       2,083      2,083       2,083       25,000            4.8%
WAGES & BENEFITS:Officer Payroll Taxes                                  100       100       100       100       100       100       100       100       100         100        100         100        1,200            0.2%
WAGES & BENEFITS:Staff                                                8,620     8,620     8,620     8,620     8,620     8,620     8,620     8,620     8,620       8,620      8,620       8,620      103,440           19.8%
WAGES & BENEFITS:Payroll Taxes - Staff (7.7%)                           664       664       664       664       664       664       664       664       664         664        664         664        7,965            1.5%
WAGES & BENEFITS:Retirement Plan                                          0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
WAGES & BENEFITS:Health:Officer Health Insurance                          0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
WAGES & BENEFITS:Other payroll expenses                                 100       100       100       100       100       100       100       100       100         100        100         100        1,200            0.2%
ADVERTISING, MARKETING:Practice Development                               0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
AUTO EXPENSES:Officer                                                     0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
BANK, CREDIT CARD CHARGES:Merchant Card Service                          30        30        30        30        30        30        30        30        30          30         30          30          360            0.1%
BANK, CREDIT CARD CHARGES:Other bank charges                             25        25        25        25        25        25        25        25        25          25         25          25          300            0.1%
COMMUNICATIONS:Answering Service                                          0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
COMMUNICATIONS:Office - Basic & long-distance                           300       300       300       300       300       300       300       300       300         300        300         300        3,600            0.7%
COMMUNICATIONS:Cellular Telephone                                         0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
COMMUNICATIONS:Cellular Officer Cellular Phone                            0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
COMMUNICATIONS:Internet                                                  80        80        80        80        80        80        80        80        80          80         80          80          960            0.2%
DUES & SUBSCRIPTIONS:Officer Professional Dues                            0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
DUES & SUBSCRIPTIONS:General Dues                                         0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
DUES & SUBSCRIPTIONS:General Subscripts & Pubs                           25        25        25        25        25        25        25        25        25          25         25          25          300            0.1%
INSURANCE:General Liability Insurance                                   900         0         0         0         0         0         0         0         0           0          0           0          900            0.2%
INSURANCE:Life Insurance                                                  0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
INSURANCE:Malpractice Insurance Officer                               2,400       873       873       873       873       873       873       873       873         873        873         873       12,003            2.3%
INSURANCE:Work Comp                                                     227       227       227       227       227       227       227       227       227         227        227         227        2,724            0.5%
INSURANCE:Disability                                                      0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
LICENSES & PERMITS:General Business                                     500         0         0         0         0         0         0         0         0           0          0           0          500            0.1%
MEDICAL SUPPLIES:Medical/Pharmaceutical                               3,752     3,836     3,864     3,948     4,032     4,144     4,256     4,368     4,480       4,592      4,704       4,816       50,792            9.7%
OFFICE & ADMIN EXPENSES:RENT@$29.35 per sq. ft.                       8,316     8,316     8,316     8,316     8,316     8,316     8,316     8,316     8,316       8,316      8,316       8,316       99,792           19.1%
OFFICE SPACE MAINT?TAX-$4.30 per sq. ft. per year for 3400 sq.ft.     1,218     1,218     1,218     1,218     1,218     1,218     1,218     1,218     1,218       1,218      1,218       1,218       14,620            2.8%
OFFICE SPACE UTILITIES                                                  250       250       250       250       250       250       250       250       250         250        250         250        3,000            0.6%
OFFICE & ADMIN EXPENSES:Computer repairs, maintenance*                  250       250       250       250       250       250       250       250       250         250        250         250        3,000            0.6%
OFFICE & ADMIN EXPENSES:Other repairs, maintenance                      250       250       250       250       250       250       250       250       250         250        250         250        3,000            0.6%
OFFICE & ADMIN EXPENSES:General office supplies                         938       938       959     3,000       987     1,008     1,036     1,064     1,092       1,120      1,148       1,176       14,466            2.8%
OFFICE & ADMIN EXPENSES:Printing and Reproduction                        42        42        42        42        42        42        42        42        42          42         42          42          504            0.1%
OFFICE & ADMIN EXPENSES:Postage and Delivery                             50        50        50        50        50        50        50        50        50          50         50          50          600            0.1%
OTHER EXPENSES:Miscellaneous                                             50        50        50        50        50        50        50        50        50          50         50          50          600            0.1%
OTHER EXPENSES:Penalties                                                  0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
OTHER EXPENSES:Waste Management                                          76        76        76        76        76        76        76        76        76          76         76          76          912            0.2%
PROFESSIONAL DEVELOPMENT:Officer CME                                      0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
PROFESSIONAL DEVELOPMENT:Staff Education                                  0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
PROFESSIONAL FEES:Accounting                                            250       250       250       250       250       250       250       250       250         250        250         250        3,000            0.6%
PROFESSIONAL FEES:Billing Service                                         0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
PROFESSIONAL FEES:Consulting                                              0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
PROFESSIONAL FEES:Legal Fees                                              0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
PROFESSIONAL FEES: Recruitment                                            0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
INTANGIBLE                                                                0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
TRAVEL, MEALS & ENT.:Officer Related Expense                              0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%
TRAVEL, MEALS & ENT.:General Entertainment - 50%                          0         0         0         0         0         0         0         0         0           0          0           0            0            0.0%




                                                                                                                                               4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xls Projections YR 2
                                 Year 2                      Mnth 1    Mnth 2    Mnth 3    Mnth 4    Mnth 5    Mnth 6    Mnth 7    Mnth 8       Mnth 9     Mnth 10     Mnth 11    Mnth 12     Total Yr 2   % of Total Yr 2
TRAVEL, MEALS & ENT.:Lodging                                       0         0         0         0         0         0         0         0             0          0           0          0             0            0.0%
TRAVEL, MEALS & ENT.:Meals - 50%                                   0         0         0         0         0         0         0         0             0          0           0          0             0            0.0%
TRAVEL, MEALS & ENT.:Parking, local milage reimb                   0         0         0         0         0         0         0         0             0          0           0          0             0            0.0%
TRAVEL, MEALS & ENT.:Travel                                        0         0         0         0         0         0         0         0             0          0           0          0             0            0.0%
TOTAL EXPENSES                                                45,579    42,737    42,785    44,911    42,981    43,115    43,254    43,395        43,534     43,674      43,814     43,954       523,738          100.0%
NET                                                           48,221    53,163    53,815    53,789    57,819    60,485    63,146    65,805        68,466     71,126      73,786     76,446       746,062
SBA 7(a) Loan of $-------- for 120 mo @ 9.25% (7.0 + 2.25)     4,883     4,883     4,883     4,883     4,883     4,883     4,883     4,883         4,883      4,883       4,883      4,883        58,596
Cash Flow Coverage Ratio - Year 2                               9.88     10.89     11.02     11.02     11.84     12.39     12.93     13.48         14.02      14.57       15.11      15.66         12.73
Cash Flow Coverage Ratio - Years 1 & 2 Combined >>>>>>>                                                                                                                                                    >>>>>>>>>>>
Net After Loan Debt Service                                   43,338    48,280    48,932    48,906    52,936    55,602    58,263    60,922        63,583      66,243     68,903      71,563      687,466




                                                                                                                                            4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xls Projections YR 2
4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xls Projections YR 2
841,884
117,193

   7.18




          4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xls Projections YR 2
Staffing Budget


                       Position                   Employee          FTE                Hr. Rate    % Inc.   Hrs. Worked    Total $
          Office Manager/Billing Manager    40 hrs per week              1                  $18                    2080     37,440
          LPN/Receptionist/Xray Tech        60 + 20 hrs. per week 3PTE/2FTE                 $15                    4160     62,400
          Xray Tech Cert. Course                                 3                       $1,200                    3600       3,600
          Radiology Tech                                                 0                   $0                        0           0
          Lab Tech - Hold Initially
          Total Staff                                                      3                                        9840    103,440

          Physicians(60 hr.-10 hr=50hrs.)                                1.5                $65                     2600    169,000


          Total                                                          4.5                                                272,440




          Clinic Hours=60 Hrs./week( 3120 hrs. per year)
          Officer MD will work 10 hours per week to reduce cost of Physician salary.




                                                                 4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xlsStaffing Budget
Start-Up Cost



                   Description   Cost
Incorporation Costs                       250
Legal Services/Accounting                4,000
Accounting Fees                             0
Consulting Services                      5,000
Build-out
Marketing Campaign                      20,000
 Marketing Plan
 Web Page Development
Recruitment                              3,000
Initial Clerical Supplies                3,000
Initial Clinical Supplies                3,000




Total                                   38,250
Capital Equipment Budget

         Item Description                     # Unit        Cost/Unti     Total Cost
         Waiting Room
           Chairs                                      20            80        1,600.00
           End Tables                                   3            50          150.00
           Magazine Rack                                2            35           70.00
           Television Ceiling Mount                     1           400          400.00
           Fixed Toys                                   1           300          300.00
           Water Fountain                               1           200          200.00
           Decorating Items                                        1000        1,000.00
           Sound System                                             500          500.00

         Receptionist Station
          Desk - built in                                                          0.00
          Chairs                                       2            125          250.00
          Filing System                                1           2000        2,000.00
          Scanner                                      0              0            0.00
          Copier                                       2            800        1,600.00
          FAX                                          0              0            0.00
          Headsets                                     2            250          500.00

         Triage Station
          Scale
           Adult                                       1            450          450.00
           Pediatric                                   1            180          180.00
          Auto BP, Pulse, Thermometer                  2           1068        2,136.00
          Thermometer                                  1            120          120.00
          Thermometer (ear)                            1            300          300.00
          Chair                                        1            125          125.00
          Rolling Stool                                1            250          250.00

         Clinical Station
          Desk, etc built in                                                       0.00
          Chair(s)                                     4            100          400.00
          Small Refrigerator                           1            225          225.00

         Exam Rooms
          Exam Table(s)                                4           1200        4,800.00
          Foot Stools                                  4            100          400.00
          Storage Cabinets - built in                                              0.00
          Medical Waste Equpment                       4            125          500.00
          Opthalmoscope                                4            131          524.00
          Otoscope                                     4             75          300.00
          Sphyg, Aneroid Wall                          4            188          752.00
          Rolling Stool                                4            250        1,000.00
          Side Chair                                   4            225          900.00
          Gooseneck Lamp                               2            150          300.00

         Procedure Room
         UV Woods Handheld                             1          318.5          318.50
         Pulse Ox                                      2           546         1,092.00
         Sphyg, Aneroid Wall                           1           188           188.00
         Instrument Stand                              2          100.1          200.20
         Aspirator Pump                                1         262.15          262.15
         Defibrillator                                 1          2764         2,764.00
         EKG                                           1          3714         3,714.00



                                        4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xlsCapital Budget
Item Description                      # Unit        Cost/Unti      Total Cost
Stretcher, Hydrolic                            1           1187          1,187.00
Rolling Carts                                  1             700           700.00
Cautery                                        1             120           120.00
Side Chair                                     1             250           250.00
Rolling Stool                                  1             250           250.00
Nebulizer                                      2           2000          4,000.00
IV Poles                                       1             225           225.00
Histofreezer                                   1             302           302.00
Ambu Bag                                       1             200           200.00
Spirometry                                     1           4000          4,000.00
Audiology                                      1           3000          3,000.00
Peak Flow                                      1             100           100.00
Refrigerator                                   1             175           175.00

Lab
 Draw Chair(s)                                 1            500           500.00
 Side Chair                                    1            225           225.00
 Staff Chair                                   1            100           100.00
 Centrifuge                                    1            500           500.00
 Refrigerator                                  1            175           175.00
 Desk/Cabinetry Built In                                                    0.00

Radiology
 Diagnostic Equipment                          1          20000        20,000.00

 Billing/Office Manager
 Desk                                          1            400           400.00
 Chair                                         1            100           100.00
 Chair,side                                    1             80            80.00
 Storage                                       1            600           600.00

Physician Office
 Chair(s)                                      1            125            125.00
 Chair, Side                                   2            100            200.00
 Furnishings                                   1           3000          3,000.00

Break Room
 Table and Chairs (6)                          1            750           750.00
 Refrigerator                                  1            800           800.00
 Microwave                                     1            150           150.00
 Dishwasher
 Built In Cabinetry                                                          0.00

Information Technology
 Billing/Scheduling includes below              1         12000        12,000.00
 Computers                                      2             0             0.00
Computer Practice System                        1         15000        15,000.00
 Printers                                       1             0             0.00
 Networking (peer to peer)                      1         10000        10,000.00
 EMR                                            0             0             0.00
 Telephone System includes 10 Tel.              1          3600         3,600.00
 Telephone Units - Include Above               10             0             0.00


TOTAL                                                                $113,584.85




                                4/25/20121:46 AM31bb7e58-0bc8-4bcb-877f-4ec1c611ce90.xlsCapital Budget

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:36
posted:4/25/2012
language:English
pages:12