0 0

Profit and Loss Projection Model

ABOUT THIS DOCUMENT

This Profit and Loss Projection provides a spreadsheet model for making monthly and quarterly profit and loss projections. A profit and loss statement, also known as an income statement, is a financial statement showing total revenues and costs. Sales and expenses should be input into this template on a monthly basis. A profit and loss projection is a planning tool that allows managers to see a company's net income (the bottom line) once costs, expenses, and taxes have been taken out of revenues (top line), over the course of an entire fiscal year.

Reads: 8679 times
Used: 88 times
Pages: 2
Size: 55 kb
Format: Excel Spreadsheet

Text Version

Income Statement Projection PnL projection









Profit and Loss Projection (12 Months)

Business Name



For The Year Begging

Aug-11









2









2

11









2





AR

n-1









r-1









l-1

g-









y-

v-

p-









c-









r-

b-









n-









LY

t-









12









%

11









11

11









11









12





12









12

Ma









Ma

Au









No









Ap

Oc









YE

De

Se









Ju







Ju

Fe

Ja

Revenue (Sales)

Specify source $ 100.00 $ 100.00 $ 200.00 100.0

Specify source $ - 0.0

Specify source $ - 0.0

Specify source $ - 0.0

Specify source $ - 0.0

Specify source $ - 0.0

Specify source $ - 0.0

Total Revenue (Sales) $ 100.00 $ 100.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200.00 100.0



Cost of Sales

Specify details $ -

Specify details $ -

Specify details $ -

Specify details $ -

Specify details $ -

Specify details $ -

Specify details $ -

Total Cost of Sales $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -



Gross Profit $ 100.00 $ 100.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200.00



Expenses

Salary expenses $ -

Payroll expenses $ -

Outside services $ -

Supplies (office and operating) $ -

Repairs and maintenance $ -

Advertising $ -

Car, delivery and travel $ -

Accounting and legal $ -

Rent $ -

Telephone $ -

Utilities $ -

Insurance $ -

Taxes $ -

Interest $ -

Depreciation $ -

Misc. expenses $ -

$ -

$ -

$ -

Total Expenses $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ -



Net Profit $ 100.00 $ 100.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200.00

Profit & Loss Projection Quarterly







Aug-11

Nov-11 Mar-12 Jul-12

Revenue (Sales) 1st Quarter % 2nd Quarter % 3rd Quarter % Year Total %



$ 200.00 100 $ - - $ - - $ 200.00 100

$ - 0 $ - - $ - - $ - 0

$ - 0 $ - - $ - - $ - 0

$ - 0 $ - - $ - - $ - 0

$ - 0 $ - - $ - - $ - 0

$ - 0 $ - - $ - - $ -

$ - 0 $ - - $ - - $ -

Total Sales $ 200.00 100 $ - - $ - - $ 200.00 100



Cost of Sales

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

Total Cost of Sales $ - $ - $ - $ -





Gross Profit $ 200.00 $ - $ - $ 200.00



Expenses

Salary expenses $ - $ - $ - $ -

Payroll expenses $ - $ - $ - $ -

Outside services $ - $ - $ - $ -

Supplies (office and operating) $ - $ - $ - $ -

Repairs and maintenance $ - $ - $ - $ -

Advertising $ - $ - $ - $ -

Car, delivery and travel $ - $ - $ - $ -

Accounting and legal $ - $ - $ - $ -

Rent $ - $ - $ - $ -

Telephone $ - $ - $ - $ -

Utilities $ - $ - $ - $ -

Insurance $ - $ - $ - $ -

Taxes $ - $ - $ - $ -

Interest $ - $ - $ - $ -

Depreciation $ - $ - $ - $ -

Misc. expenses $ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

Total Expenses $ - $ - $ - $ -





Net Profit $ 200.00 $ - $ - $ 200.00


$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

Total Cost of Sales $ - $ - $ - $ -





Gross Profit $ 200.00 $ - $ - $ 200.00



Expenses

Salary expenses $ - $ - $ - $ -

Payroll expenses $ - $ - $ - $ -

Outside services $ - $ - $ - $ -

Supplies (office and operating) $ - $ - $ - $ -

Repairs and maintenance $ - $ - $ - $ -

Advertising $ - $ - $ - $ -

Car, delivery and travel $ - $ - $ - $ -

Accounting and legal $ - $ - $ - $ -

Rent $ - $ - $ - $ -

Telephone $ - $ - $ - $ -

Utilities $ - $ - $ - $ -

Insurance $ - $ - $ - $ -

Taxes $ - $ - $ - $ -

Interest $ - $ - $ - $ -

Depreciation $ - $ - $ - $ -

Mis expenses $ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

$ - $ - $ - $ -

Total Expenses $ - $ - $ - $ -





Net Profit $ 200.00 $ - $ - $ 200.00

Get Unlimited Access to Our Complete Business Library

Plus

  • All Licenses and Permits For Your Business
  • Customized Legal and Business Forms and Agreements
  • Document Packages for Specific Situations
Learn More »
Sign-up for Docstoc Premium
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.


Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?