Financial Modeling and Strategic Narrative Development for a Three-Year Projection
Description
This prompt outlines the role of a financial modeler tasked with creating a three-year financial model and accompanying narrative based on a Business Model Canvas. The process involves reviewing SMART statements from the Business Model Canvas, extracting key financial drivers, making reasonable assumptions about revenue and expenses, constructing a detailed Profit and Loss (P&L) statement, and finally, writing a strategic narrative for stakeholders. The narrative discusses revenue growth, strategic investments, expense management, financial performance, and concludes with a vision for market leadership, incorporating relevant Key Performance Indicators (KPIs).
Prompt
As a financial modeler it is your goal to present a financial model & narrative for the next three year is is aligned with the present financial model. Step 1) Review the smart statements of the Business Model Canvas presented, including customer segments, value propositions, channels, customer relationships, revenue streams, key activities, key resources, key partners, and cost structure. Step 2) Extract financial drivers from the SMART statements presented the Business Model Canvas. Financial drivers include revenue targets, cost estimates, recruitment goals, and key performance metrics. Step 3) Make Reasonable Assumptions: !Examples of Revenue Assumptions: [Determine pricing strategy (e.g., subscription fees). Estimate the number of customers/users. Identify additional revenue sources (e.g., premium features). Expense Assumptions: Personnel costs (salaries, number of employees). Operational costs (monthly or annual expenses). Marketing and sales budgets. Development and maintenance costs. Miscellaneous expenses (unexpected or minor costs).] Step 4) Construct the P&L Statement: with the following Columns: US GAAP P&L Category Canvas Block Financial Driver Year 1 Year 2 Year 3 Revenue Revenue Streams Subscription Fees Premium Features Revenue Total Revenue COGS Key Resources AI Developers/Data Scientists Gross Profit Operating Expenses Cost Structure Operational Expenses Development and Maintenance Costs Customer Support Costs Marketing and Sales Budget Miscellaneous Expenses Total Operating Expenses Operating Income Net Income Step 5) Write a narrative for the stakeholders: Subject: Three-Year Financial Outlook and Strategic Growth Plan, discussing relevant KPI's • Revenue Growth: A Promising Horizon • Strategic Investments: Enhancing Value and Engagement • Expense Management: Prudent and Strategic • Financial Performance: Sustainable Growth and Profitability • Conclusion: A Path to Market Leadership
How to Use
1
Copy the prompt
Click the copy button above to copy the entire prompt to your clipboard
2
Open AI model
Go to your preferred AI model or any compatible AI assistant
3
Paste & customize
Paste the prompt into the chat and modify it for your specific needs
4
Send & enjoy
Send the prompt and wait for the AI to generate a response
Comments (0)
to join the discussion
No comments yet
Be the first to share your thoughts!