Need breakeven analysis and sensitivity analysis for the "Master Financial Spreadsheet Inspire Adventure"
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 currently, 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 JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberYTD 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- 0115,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- 01,800.00$ 57,600- 01,800.00$ 57,600- 03,600.00122,400 Allowances & Discounts- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Net Client Revenue- 0- 0- 0- 0- 01,800.0057,600.00- 01,800.0057,600.00- 03,600.00122,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- 0230,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$ 100.00$ 100.00$ 200.00$ 400.00$ 400.00$ 400.00$ 400.00$ 400.00$ 400.00$ 400.00$ 400.00$ 400.00$ 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$ 546.00$ 546.00$ 546.00$ 546.00$ 546.00$ 546.00$ 547.00$ 547.00$ 547.00$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 JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecemberYTD 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 Investments200,000- 0-10,0005,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 Dividends199,300198,196196,992178,505151,518$ 78,032$ 101,722$ 72,297$ 59,672$ 83,04753,622$ 27,7951,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/2412/31/2512/31/2612/31/2712/31/28 Assets Current 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$ (300.00)$ (500.00)$ (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 Current Assets Total Current Assets$ 29,295.00$ 72,317.00$ 126,701.00$ 199,412.00$ 301,524.00 Non-Current 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 Noncurrent 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 Current Liabilities- loans$ - 0$ - 0$ 11,376.00$ 11,376.00$ 11,376.00 Non-current 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/2412/31/2512/31/2612/31/2712/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$