As a startup, we are continually updating our financial documents and now require a highly accurate financial model for an ongoing medtech project (OSTAAT™ smart shorts for hip and lower-spine stimulation). A rigorous financial plan is critical to execution and fundraising, and we seek students to help build and validate it.

Student tasks include:

• Learning our strategy, milestones, and constraints to understand goals, roadmap, and markets
• Building a modular Excel/Google Sheets model covering revenue, COGS, Opex, P&L, cash flow, and balance sheet, with clearly documented assumptions
• Creating unit and revenue forecasts (base/upside/downside) and income projections with sensitivity analysis (price, CAC, conversion, returns, timelines)
• Working with our team to develop an expense budget (manufacturing, quality/regulatory, clinical, marketing, distribution, logistics)
• Conducting break-even and runway analyses using the projections
• Reporting on projected assets, liabilities, and key ratios (gross margin, contribution margin, burn)
• Including clear visuals (graphs/charts) to compare scenarios and highlight drivers and risks
• Deliverables: working model (with assumptions and scenario tabs), a brief methods/assumptions memo, and a slide summary of insights. Confidentiality required; we will provide inputs and periodic guidance.

By the end of the project, students should complete the following list of activities (this is basically a retelling of the steps above):

• Completed a sales forecast and an income projection for the five years of operations.
• Conducted a break-even analysis using the sales forecast and expense budget.
• Analyzed projected assets and liabilities our company will have in the first five years of operations.
• Included extra visuals in the report to help us understand the differences between the conservative and aggressive income projections.

Final deliverables:

• A final report including a sales forecast, income projection, expense budget, break-even point, assets, liabilities, as well as any calculations and assumptions used.
• A 30-minute presentation explaining all research and findings from the report.