Financial Modeling and Strategic Narrative Development for a Three-Year Projection

Jan 9, 2025

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)

No comments yet

Be the first to share your thoughts!