Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Need breakeven analysis and sensitivity analysis for the "Master Financial Spreadsheet Inspire Adventure"

1 answer below »
Financial Key Assumptions
    Inspire Adventure Therapy Financial Key Assumptions
    
    Inpsire, Inc. received an in-kind donation of 34 acres of land, where it will conduct all of its adventure activities. The value of the land cu
ently, is $243,000. In 2024, all office activities, intake appointments, staff interviews, etc. will be done virtually or off-site at an appropriate location. In 2025, Inspire, Inc. will rent approximately 1300 square feet of office space to be able to conduct its adminstrative services. In 2026, Inspire, Inc. will take out a loan for approximately $75,000 to build out office space, conference/classroom space and to be able to support all staff and services on location at location of the adventure property. This project will also provide the capacity for Inspire, Inc. to be able to host retreats onsite for couples and corporations.
    All Q1 2024 activities will be completed by Inspire's founding members, Tyler "Paxton" Davis, Sarah Werner and Kristen Wootton. The activities that will be conducted include obtaining all business licenses, registering as a 501 c (3), and obtaining all permits. In April of 2024, the Program Director and Director of Development will be hired and will begin leading all operational activities and marketing/development activities.
    Inspire, Inc. will have client co-horts of of 6:1 (6 clients per 1 wilderness therapy guide) and it is required that there be a minimum of 2 therapy guides at all times (1 male & 1 female)
    Each client will pay a non-refundable registration fee of $150 and a 12-week program fee of $4,800 (these will be cash payments, as Inspire will not be accepting insurance payments at this time. Scholarships will be awarded based off of the availability of scholarship funds and will be granted via a need-based application process.
    Inspire will be starting to market for its first 2 client co-horts in April, 2024. This strategy will be lead by our Program Director and our Director of Development both of which will come on as staff in April of 2024. It is assumed that through the direct marketing efforts a 12 client co-hort will be recruited and able to start receiving services in July 2024
    Inspire, Inc. will be starting with its first client co-hort (12 clients) in July of 2024 for its inaugural 12-week program and will have 2 total co-horts in 2024. Over the next year, Inspire will increase its capability to be able to have a total of 96 clients per calendar year in the Adolescent Adventure program. The plan as discussed will be to expand to other populations of clients to include couples and corporate retreat clients. Inspire would also like to consider a Summer Adventure Program for adolescents who have graduated from the initial 12-week program previously but who may need/want additional support.
Statement of Operations- Year 1
    Inspire Adventure Therapy Statement of Operations (Income Statement)
    January 2024- December 2024
            January    Fe
uary    March    April    May    June    July    August    September    October    November    December    YTD
    Revenue
    Client Registration Fees        - 0    - 0    - 0    - 0    - 0    $ 1,800    - 0    - 0    $ 1,800    - 0    - 0    $ 3,600    $ 7,200
    Client Program Fees        - 0    - 0    - 0    - 0    - 0    - 0    $ 57,600    - 0    - 0    $ 57,600    - 0    - 0    115,200
    Couples Retreat Revenue        - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0
    Corporate Retreat Revenue        - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0
    Total Client Revenue        - 0    - 0    - 0    - 0    - 0    1,800.00    $ 57,600    - 0    1,800.00    $ 57,600    - 0    3,600.00    122,400
    Allowances & Discounts        - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0
    Net Client Revenue        - 0    - 0    - 0    - 0    - 0    1,800.00    57,600.00    - 0    1,800.00    57,600.00    - 0    3,600.00    122,400
    Other Non Client Revenue        - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0
    Contributions, Donations, Etc.         $ 200,000    - 0    - 0    $ 10,000    - 0    $ 5,000    - 0    - 0    $ 15,000    - 0    - 0    - 0    230,000
    Total Net Operating Revenue        $ 200,000    $ - 0    $ - 0    $ 10,000    $ - 0    $ 6,800    $ 57,600    $ - 0    $ 16,800    $ 57,600    $ - 0    $ 3,600    $ 352,400
    Operating Expenses
        Salaries, Wages, Insurance & Taxes                $ 12,587.00    $ 12,587.00    $ 22,097.00    $ 23,789.00    $ 23,789.00    $ 23,789.00    $ 23,789.00    $ 23,789.00    $ 23,789.00    $ 190,005.00
    Fundraising        $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0    $ - 0
    Sales & Market        $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ 4,000.00
    General & Administrative        $600    $1,004.00    $1,004.00    $ 2,000.00    $ 2,000.00    $ 2,475.00    $ 2,607.00    $ 2,922.00    $ 2,922.00    $ 2,922.00    $ 2,922.00    $ 2,922.00    $ 26,300.00
    Programming                    $ 11,000.00    $ 2,000.00    $ 2,314.00    $ 2,314.00    $ 2,314.00    $ 2,314.00    $ 2,314.00    $ 2,314.00    $ 2,316.00    $ 29,200.00
    Depreciation Expenses                    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $ XXXXXXXXXX    $4,917
    Total Operating Expenses        $ 700    $ 1,104    $ 1,204    $ 26,533    $ 17,533    $ 27,832    $ 29,656    $ 29,971    $ 29,971    $ 29,972    $ 29,972    $ 29,974    $ 254,422
    Total Net Operating Revenue        $ 200,000    $ - 0    $ - 0    $ 10,000    $ - 0    $ 6,800    $ 57,600    $ - 0    $ 16,800    $ 57,600    $ - 0    $ 3,600    $ 352,400
    Net Income        $ 199,300    $ (1,104)    $ (1,204)    $ (16,533)    $ (17,533)    $ (21,032)    $ 27,944    $ (29,971)    $ (13,171)    $ 27,628    $ (29,972)    $ (26,374)    $ 97,978
Statement of Cash Flow- Year 1
    Inspire Adventure Therapy Statement of Cash Flow
    January 2024- December 2024
        January    Fe
uary    March    April    May    June    July    August    September    October    November    December    YTD
    Cash at Beginning of Period    $ - 0    $ 199,300    $ 198,196    $ 196,992    $ 178,505    $ 151,518    $ 78,032    $ 101,722    $ 72,297    $ 59,672    $ 83,047    $ 53,622    $ 1,372,903
    Cash Receipts from Operating Activities
    Cash From Client Payments    -    -    -    -    -    $ 1,800    $ 52,800    -    $ 1,800    $ 52,800    -    $ 3,600    $ 112,800
    Cash Payments for Operating Activities
    Cash paid for Salaries, Wages, Insurance & Taxes    - 0    - 0    - 0    (12,587)    (12,587)    (22,097)    (23,789)    (23,789)    (23,789)    (23,789)    (23,789)    (23,789)    (190,005)
    Cash paid for Fundraising    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0    - 0
    Cash paid for Sales and Marketing    (100)    (100)    (200)    (400)    (400)    (400)    (400)    (400)    (400)    (400)    (400)    (400)    (4,000)
    Cash paid for General & Administrative    (600)    (1,004)    (1,004)    (2,000)    (2,000)    (2,475)    (2,607)    (2,922)    (2,922)    (2,922)    (2,922)    (2,922)    (26,300)
    Cash paid for Programming    -    -    -    (11,000)    (2,000)    (2,314)    (2,314)    (2,314)    (2,314)    (2,314)    (2,314)    (2,316)    (29,200)
    Cash paid for Loan Interest Expense    -    -    -    -    -    -
    Net Cash from Operating Activities    $ (700)    $ (1,104)    $ (1,204)    $ (25,987)    $ (16,987)    $ (25,486)    $ 23,690    (29,425)    $ (27,625)    $ 23,375    (29,425)    $ (25,827)    $ (136,705)
    Cash from Financing and Investing
    Cash from New Loans    -    -    -    -    -    -    -    -    -    -    -    -
    Cash from New Investments    200,000    - 0    -    10,000        5,000    -    -    15,000    -    -    -    230,000
    Cash paid on Loan Principal    - 0    - 0    - 0    - 0    - 0    -    -    -    -    -    -    -
    Cash paid for Fixed Assets        - 0    -    (2,500)    (10,000)    (53,000)    -    -    -        -    -    (65,500)
    Net Cash from Financing and Investing    $ 200,000    $ - 0    $ - 0    $ 7,500    $ (10,000)    $ (48,000)    $ - 0    $ - 0    $ 15,000    $ - 0    $ - 0    $ - 0    $ 164,500
    Cash Before Dividends    199,300    198,196    196,992    178,505    151,518    $ 78,032    $ 101,722    $ 72,297    $ 59,672    $ 83,047    53,622    $ 27,795    1,400,698
    Cash paid for Dividends    - 0    - 0    - 0    - 0    - 0
    Net Cash Inflow (Outflow)    $ 199,300    $ (1,104)    $ (1,204)    $ (18,487)    $ (26,987)    $ (73,486)    $ 23,690    $ (29,425)    $ (12,625)    $ 23,375    (29,425)    $ (25,827)    $ 27,795
    Cash at End of Period    $ 199,300    $ 198,196    $ 196,992    $ 178,505    $ 151,518    $ 78,032    $ 101,722    $ 72,297    $ 59,672    $ 83,047    $ 53,622    $ 27,795
Five Year Financial Statements
    Inspire Adventure Therapy Five Year Financial Statements
    Years Ending 2024, 2025, 2026, 2027 & 2028
    Inspire Adventure Therapy, Inc.
    Balance Sheet
        12/31/24        12/31/25        12/31/26        12/31/27        12/31/28
    Assets
    Cu
ent Assets
    Cash    $ 27,795.00        $ 69,217.00        $ 124,201.00        $ 196,912.00        $ 299,024.00
    Accounts Receivable    $ 1,800.00        $ 3,600.00        $ 3,600.00        $ 3,600.00        $ 3,600.00
     Allowance for Bad Debt    $ XXXXXXXXXX)        $ XXXXXXXXXX)        $ (1,000.00)        $ (1,000.00)        $ (1,000.00)
    Net Accounts Receivable    $ 1,500.00        $ 3,100.00        $ 2,500.00        $ 2,500.00        $ 2,500.00
    Other Cu
ent Assets
    Total Cu
ent Assets    $ 29,295.00        $ 72,317.00        $ 126,701.00        $ 199,412.00        $ 301,524.00
    Non-Cu
ent Assets
    Plant and Equipment    $ 65,500.00        $ 65,500.00        $ 75,500.00        $ 75,500.00        $ 75,500.00
    Accumulated Depreciation    $ (4,917.00)        $ (8,214.00)        $ (9,614.00)        $ (9,614.00)        $ (9,614.00)
    Net Plant and Equipment    $ 60,583.00        $ 57,286.00        $ 65,886.00        $ 65,886.00        $ 65,886.00
    Property- value of real estate    $ 243,000.00        $ 243,000.00        $ 243,000.00        $ 243,000.00        $ 243,000.00
    Investments    $ - 0        -
    Other Assets    $ - 0        -
    Total Noncu
ent Assets    $ 303,583.00        $ 300,286.00        $ 308,886.00        $ 308,886.00        $ 308,886.00
    Total Assets    $ 332,878.00        $ 372,603.00        $ 435,587.00        $ 508,298.00        $ 610,410.00
    Cu
ent Liabilities- loans    $ - 0        $ - 0        $ 11,376.00        $ 11,376.00        $ 11,376.00
    Non-cu
ent Liabilities- mortgage payments in another year    $ - 0        $ - 0        $ 63,624.00        $54,248        $42,872
    Total Liabilities    $ - 0        $ - 0        $ 75,000.00        $ 65,624.00        $ 54,248.00
    Total Net Assets    $ 332,878.00        $ 372,603.00        $ 360,587.00        $ 442,674.00        $ 556,162.00
    Total Liabilities & Net Assets    $ 332,878.00        $ 372,603.00        $ 435,587.00        $ 508,298.00        $ 610,410.00
    Inspire Adventure Therapy
    Statement of Operations (Income Statement)
        12/31/24        12/31/25        12/31/26        12/31/27        12/31/28
    Revenues
    Unrestricted Revenues and Gains
    Client Registration Revenue    $ 7,200.00        $ 14,400.00        $ 14,400.00        $ 14,400.00        $ 14,400.00
    Client Program Revenue    $ 115,200.00        $ 460,800.00        $ 460,800.00        $ 460,800.00        $ 460,800.00
    Couples Retreat Revenue    $ - 0        $ - 0        $ 10,000.00        $ 20,000.00        $ 30,000.00
    Corporate Retreat Revenue    $ - 0        $ - 0                $ 16,000.00        $ 32,000.00
    Total Client Revenue    $ 122,400.00        $ 475,200.00        $ 485,200.00        $ 511,200.00        $ 537,200.00
    Allowances & Discounts (Client Scholarships)    $ 9,600.00        $ 14,400.00        $ 28,800.00        $ 38,400.00        $ 48,000.00
    Net Client Revenue    $ 112,800.00        $ 460,800.00        $ 456,400.00        $ 472,800.00        $ 489,200.00
    Other Non Client Revenue    $ - 0        $ - 0        $ - 0        $ - 0        $ - 0
    Contributions, Donations, etc    $ 230,000.00        $ 100,000.00        $ 200,000.00        $
Answered 6 days After Jul 19, 2023

Solution

Khushboo answered on Jul 26 2023
23 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here