Business Plan - financial statement

profileS.SHARON
copy_of_financial_excel_sheet.xlsx
Home>Business & Finance homework help>Management homework help>Business Plan - financial statement

Income Statement

First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Revenue
Sales revenue
(Less sales returns and allowances)
Service revenue
Interest revenue
Other revenue
Total Revenue
Expenses
Advertising
Cost of goods sold
Depreciation
Payroll taxes
Office supplies
Salaries and Wages
Utilities
Rent
Insurance
Equipment
Other
Total Expenses
Net Income

Cash Flow

First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Operations
Cash receipts from customers
Cash paid for
Inventory purchases
Income taxes
Interest
Wage expenses
General operating
Net Cash Flow from Operations
Investing Activities
Cash receipts from
Sales of property and equipment
Sales of investment securities
Cash paid for
Purchase of property and equipment
Purchase of investment securities
Net Cash Flow from Investing Activities
Financing Activities
Cash receipts from
Issuance of stock
Borrowing
Cash paid for
Repurchase of stock
Dividends
Net Cash Flow from Financing Activities
Net Increase in Cash

Break Even Analysis

First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Fixed Costs
Advertising
Depreciation
Insurance
Payroll
Rent
Taxes
Utilities
supplies
Equipment
Other
Total Fixed Costs
Variable Costs
Cost of goods sold
Direct Labor
Overhead
Other
Total Variable Costs
Break Even Point
Break Even Units(X)
Break Even Sales(S)

Sourcing and Using Funds

First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Sources
Debt
Loan
Equity
Cash
U.S.cash
Non-U.S.cash
Non-Cash
U.S.non-cash Sources
Non-U.S.non-cash Sources
Total Sources
Uses
Construction/Capital Expenditure Costs
Constractor costs
Non-Constractor costs
Developmental costs
Permanent working capital
Project contingency costa
Financing fees
Total Uses

Marketing

National Marketing
Banner ads
Local Marketing
Newspaper
In-Stor Marketing
POP
First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Public Relations
Public events
Press releases
Conferences
Client events
Content Marketing
Landing page
ebooks
Social Media
Twitter
Facebook
Instagram
LinkedIn
Google
Advertising
Online
Print
Outdoor
Radio
Television
Other

Operation

First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Operating Expenses
Payroll
Rent
Marketing
Leased equipment
Utilities
Insurance
Benefits
Depreciation
Interest
Other
Total

Production

First Year Second Year Third Year
JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC
Production Expenses
Materials
Equipment
Facilities
Shipping
Publicity
Building rent
Wages of labor
Supplies
Taxes
Other
Total