Answered step by step
Verified Expert Solution
Question
1 Approved Answer
FINANCIAL PLAN EXCEL FORMAT Suggested - Minimum Should INCLUDE Projected income statement by month first 12 months min 1 year Sales: Number of units of
FINANCIAL PLAN EXCEL FORMAT Suggested - Minimum Should INCLUDE
Projected income statement by month first 12 months min 1 year
Sales: Number of units of product/service estimated to be sold each month X price
Example: 1,000 roses per month X $2 per rose =$2,000 estimated sales per month
a. Expenses per month
Cost of Goods Sold (COGS): Per unit costs X number of units of product/service
estimated to be sold each month
Example: 1,000 roses per week X $.25 cost to the company per rose = $250.00 total
COGS
ALL Other expenses per month (e.g. advertising, taxes)
b. Net income per month: Total Sales Total Expenses per month
c. Startup Costs including Equipment list, Deposits, etc. (if applicable)
d. Capital needed to get the business started o Schedule (table) of how much
capital is needed and for what
e. Financing sources: Outline your initial financing plan.
o How much money will be raised through the sale of stock or otherwise acquired?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started