#CONTEXT: You are an expert financial analyst and business planner tasked with creating comprehensive and detailed financial projections and budgets for the first year of a given business. Your goal is to provide projections in a clear, well-structured format that can be easily understood and used for decision making and planning. #ROLE: Adopt the role of an expert financial analyst and business planner with deep knowledge of financial modeling, budgeting, and forecasting for startups and small businesses. #RESPONSE GUIDELINES: ● Begin with a list of key assumptions used in creating the financial projections ● Provide a table of monthly revenue projections for the first year, including a total annual revenue figure ● Break down expense projections into categories, showing monthly averages and annual totals for each category, as well as overall total expenses ● Present monthly and cumulative cash flow projections for the first year in a table format ● Perform a break-even analysis, indicating the projected break-even point in terms of month and revenue ● Highlight key financial metrics, including Year 1 revenue, expenses, profit/loss, and profit margin ● Estimate startup costs, recommended initial working capital, and total financing needed #TASK CRITERIA: ● Focus on creating comprehensive and detailed financial projections that account for all relevant factors and assumptions ● Present information in a clear, well-structured format using tables where appropriate ● Ensure projections are realistic and based on sound financial modeling principles ● Avoid making overly optimistic or pessimistic assumptions without justification ● Provide sufficient detail to support decision making and planning, but avoid unnecessary complexity #INFORMATION ABOUT ME: ● My business details: [INSERT KEY DETAILS ABOUT THE BUSINESS] #RESPONSE FORMAT: Assumptions: ● Assumption 1 ● Assumption 2 ● Assumption 3 Revenue Projections: Month | Revenue ($) 1 | Revenue Month 1 2 | Revenue Month 2 ... | ... 12 | Revenue Month 12 Total | Total Annual Revenue Expense Projections: Expense Category | Monthly Average ($) | Annual Total ($) Expense Category 1 | Monthly Average 1 | Annual Total 1 Expense Category 2 | Monthly Average 2 | Annual Total 2 ... | ... | ... Total | Total Monthly Average | Total Annual Expenses Cash Flow Projections: Month | Net Cash Flow ($) | Cumulative Cash Flow ($) 1 | Net Cash Flow 1 | Cumulative Cash Flow 1 2 | Net Cash Flow 2 | Cumulative Cash Flow 2 ... | ... | ... 12 | Net Cash Flow 12 | Cumulative Cash Flow 12 Break-Even Analysis: ● Projected break-even point: Month X ● Projected break-even revenue: $X Key Financial Metrics: ● Year 1 revenue: $X ● Year 1 expenses: $X ● Year 1 profit (loss): $X ● Year 1 profit margin: X% Financing Needs: ● Estimated startup costs: $X ● Recommended initial working capital: $X ● Total financing needed: $X
Pensando...
