Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 56 views

    Dermatology Express LLC - Confidential Year 1 Revenue

    Uploaded by

    Bob Spoont
    Dermatology Express LLC provided quarterly financial projections for years 1 and 2. In year 1, revenue increased each quarter as patient volume grew. However, operating expenses exceeded revenue, resulting in a net loss. In year 2, revenue continued growing substantially each quarter due to increasing patient numbers and higher fees. While expenses also rose, revenue growth led to net profits in all quarters of the second year.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Dermatology Express LLC - Confidential Year 1 Revenue

    Uploaded by

    Bob Spoont
    56 views9 pages
    Dermatology Express LLC provided quarterly financial projections for years 1 and 2. In year 1, revenue increased each quarter as patient volume grew. However, operating expenses exceeded revenue, resulting in a net loss. In year 2, revenue continued growing substantially each quarter due to increasing patient numbers and higher fees. While expenses also rose, revenue growth led to net profits in all quarters of the second year.

    Original Description:

    Original Title

    Model v3

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Dermatology Express LLC provided quarterly financial projections for years 1 and 2. In year 1, revenue increased each quarter as patient volume grew. However, operating expenses exceeded revenue, resulting in a net loss. In year 2, revenue continued growing substantially each quarter due to increasing patient numbers and higher fees. While expenses also rose, revenue growth led to net profits in all quarters of the second year.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    56 views9 pages

    Dermatology Express LLC - Confidential Year 1 Revenue

    Uploaded by

    Bob Spoont
    Dermatology Express LLC provided quarterly financial projections for years 1 and 2. In year 1, revenue increased each quarter as patient volume grew. However, operating expenses exceeded revenue, resulting in a net loss. In year 2, revenue continued growing substantially each quarter due to increasing patient numbers and higher fees. While expenses also rose, revenue growth led to net profits in all quarters of the second year.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 9

    Dermatology Express LLC -- Confidential

    Y1Q1 Y1Q2 Y1Q3 Y1Q4 Year 1


    Revenue
    ARNP - 162,360 243,540 324,720 730,620
    Cosmetic - 15,000 27,500 65,000 107,500
    Total Revenue - 177,360 271,040 389,720 838,120
    Op Ex
    Corp Costs
    Legal 100,000 15,000 15,000 15,000 145,000
    Website 5,000 - - - 5,000
    Telephone 2,500 750 750 750 4,750
    Ms&Ent 5,000 1,000 1,000 1,000 8,000
    Admin Office
    Bld Out 15,000 - - - 15,000
    Equiptment 7,000 - - - 7,000
    Rent - 3,000 3,000 3,000 9,000
    Gen Office Exp 2,500 2,500 2,500 2,500 10,000
    Employee+Benefits 41,688 41,688 41,688 41,688 166,750
    Marketing 50,000 25,000 25,000 25,000 125,000
    Insurance 12,500 12,500 12,500 12,500 50,000
    Total Corp Costs 241,188 101,438 101,438 101,438 545,500

    Clinic Costs
    Build-Out 160,000 - - - 160,000
    Rent - 22,500 22,500 22,500 67,500
    LHI - 2,500 2,500 2,500 7,500
    ERM Software 5,000 5,000 5,000 5,000 20,000
    Electric 750 750 750 750 3,000
    Uniforms 750 750 750 750 3,000
    Front Desk Staff 21,140 21,140 29,780 29,780 101,840
    DNP 38,750 38,750 65,000 65,000 207,500
    Empl Benefits 8,984 8,984 14,217 14,217 46,401
    Workmans Comp 6,250 6,250 6,250 6,250 25,000
    Insurance 25,000 25,000 25,000 25,000 100,000
    Office Supplies 6,250 6,250 6,250 6,250 25,000
    Dermatology Supp - 10,642 16,262 23,383 50,287
    Total Clinic Costs 272,874 148,515 194,259 201,380 817,028

    Total Operating Expenses 514,061 249,953 295,697 302,818 1,362,528

    EBITDA (514,061) (72,593) (24,657) 86,902 (524,408)


    Y2Q1 Y2Q2 Y2Q3 Y2Q4 Year 2

    514,800 514,800 600,600 686,400 2,316,600


    120,000 150,000 200,000 250,000 720,000
    634,800 664,800 800,600 936,400 3,036,600

    15,000 15,000 15,000 15,000 60,000


    2,500 - - - 2,500
    750 750 750 750 3,000
    1,000 1,000 1,000 1,000 4,000

    - - - - -
    7,000 - - - 7,000
    3,000 3,000 3,000 3,000 12,000
    2,500 2,500 2,500 2,500 10,000
    63,250 63,250 63,250 63,250 253,000
    25,000 25,000 25,000 25,000 100,000
    12,500 12,500 12,500 12,500 50,000
    132,500 123,000 123,000 123,000 501,500

    - - - - -
    22,500 22,500 22,500 22,500 90,000
    2,500 2,500 2,500 2,500 10,000
    5,000 5,000 5,000 5,000 20,000
    750 750 750 750 3,000
    750 750 750 750 3,000
    38,420 38,420 38,420 38,420 153,680
    65,000 65,000 65,000 65,000 260,000
    15,513 15,513 15,513 15,513 62,052
    6,250 6,250 6,250 6,250 25,000
    25,000 25,000 25,000 25,000 100,000
    6,250 6,250 6,250 6,250 25,000
    38,088 39,888 48,036 56,184 182,196
    226,021 227,821 235,969 244,117 933,928

    358,521 350,821 358,969 367,117 1,435,428

    276,279 313,979 441,631 569,283 1,601,172


    Revenue

    ARNP Build Y1Q1 Y1Q2 Y1Q3 Y1Q4 Y2Q1

    Days/Week Open 5.5 5.5 5.5 5.5 5.5


    Days/Month Open 22 22 22 22 22

    Hours/Day 10 10 10 10 10
    Hours/Month 220 220 220 220 220

    Patients/Hour 0 2 3 4 6
    Patients/Day 0 20 30 40 60
    Patients/Month 0 440 660 880 1320

    Revenue $/p $ 123 $ 123 $ 123 $ 123 $ 130

    Revenue/Month $ - $ 54,120 $ 81,180 $ 108,240 $ 171,600

    Revenue/Qtr $ - $ 162,360 $ 243,540 $ 324,720 $ 514,800

    Cosmetic Build

    Revenue/Qtr 0 15,000 27,500 65,000 120,000

    Total Revenue $ - $ 177,360 $ 271,040 $ 389,720 $ 634,800


    Y2Q2 Y2Q3 Y2Q4

    5.5 5.5 5.5


    22 22 22

    10 10 10
    220 220 220

    6 7 8
    60 70 80
    1320 1540 1760

    $ 130 $ 130 $ 130

    $ 171,600 $ 200,200 $ 228,800

    $ 514,800 $ 600,600 $ 686,400

    150,000 200,000 250,000

    $ 664,800 $ 800,600 $ 936,400


    Corporate Expenses Y1Q1 Y1Q2 Y1Q3 Y1Q4 Y2Q1
    Legal 100,000 15,000 15,000 15,000 15,000
    Website 5,000 - - - 2,500
    Telephone 2,500 750 750 750 750
    Ms&Ent 5,000 1,000 1,000 1,000 1,000
    Admin Office
    Bld Out 15,000 - - - -
    Equiptment 7,000 - - - 7,000
    Rent - 3,000 3,000 3,000 3,000
    Gen Office Exp 2,500 2,500 2,500 2,500 2,500
    Operating Managers
    #1 25,000 25,000 25,000 25,000 25,000
    #2 - - - - 18,750
    Admin #1 11,250 11,250 11,250 11,250 11,250
    Benefits 5,438 5,438 5,438 5,438 8,250

    Marketing 50,000 25,000 25,000 25,000 25,000


    Insurance 12,500 12,500 12,500 12,500 12,500
    Y2Q2 Y2Q3 Y2Q4 Assume
    15,000 15,000 15,000
    - - -
    750 750 750
    1,000 1,000 1,000

    - - -
    - - -
    3,000 3,000 3,000 Rent p/m $ 1,000
    2,500 2,500 2,500

    25,000 25,000 25,000 Salary $ 100,000


    18,750 18,750 18,750 Salary $ - $ 75,000
    11,250 11,250 11,250 Salary $ 45,000
    8,250 8,250 8,250 Benefits 15%

    25,000 25,000 25,000


    12,500 12,500 12,500 $ 50,000
    Assume:
    Clinic 1
    Sq Foot 2000

    Clinic Exp Bld Y1Q1 Y1Q2 Y1Q3 Y1Q4 Y2Q1


    Build-Out 160,000 - - - -
    Rent 22,500 22,500 22,500 22,500
    LHI - 2,500 2,500 2,500 2,500
    ERM Software 5,000 5,000 5,000 5,000 5,000
    Electric 750 750 750 750 750
    Uniforms 750 750 750 750 750
    Employees
    Front Desk Mgr 12,500 12,500 12,500 12,500 12,500
    Admin 8,640 8,640 8,640 8,640 8,640
    Admin 8,640 8,640 8,640
    Admin 8,640

    DNP
    #1 38,750 38,750 38,750 38,750 38,750
    #2 26,250 26,250 26,250

    Empl Benefits 8,984 8,984 14,217 14,217 15,513

    Workmans Comp 6,250 6,250 6,250 6,250 6,250


    Insurance 25,000 25,000 25,000 25,000 25,000
    Office Supplies 6,250 6,250 6,250 6,250 6,250
    Dermatology Supp - 10,642 16,262 23,383 38,088
    Y2Q2 Y2Q3 Y2Q3 Assume
    - - - $ 80 /sqft
    22,500 22,500 22,500 $ 45 /sqft
    2,500 2,500 2,500 $ 5 /sqft
    5,000 5,000 5,000 $ 20,000 year
    750 750 750 $ 3,000 year
    750 750 750 $ 3,000 year

    12,500 12,500 12,500 $ 50,000 year


    8,640 8,640 8,640 $ 18 160 hours/month
    8,640 8,640 8,640 $ 18 160 hours/month
    8,640 8,640 8,640 $ 18 160 hours/month

    38,750 38,750 38,750 $ 155,000 year


    26,250 26,250 26,250 $ 105,000 year

    15,513 15,513 15,513 15% of base

    6,250 6,250 6,250 $ 25,000 year


    25,000 25,000 25,000 $ 100,000 year
    6,250 6,250 6,250 $ 25,000 year
    39,888 48,036 56,184 6% of gross Revenue
    ours/month
    ours/month
    ours/month

    You might also like