Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
