Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Exploring The Hospitality Industry

Authors: John R Walker, Josielyn T Walker

3rd Edition

0133762777, 9780133762778

More Books

Students also viewed these General Management questions

Question

A39

Answered: 1 week ago

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago

Question

3. An initial value (anchoring).

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago