One page business plan pro forma spreadsheet

A pro forma is simply a financial statement written as you expect things to look, at some point in the future. Nobody expects a pro forma to be completely accurate, but it should be based on real information and written to reflect your good faith expectations.

One page business plan pro forma spreadsheet

A pro forma is simply a financial statement written as you expect things to look, at some point in the future. Nobody expects a pro forma to be completely accurate, but it should be based on real information and written to reflect your good faith expectations.

Pro Forma Income Statement To write a pro forma income statement, first list all of your anticipated sources of income.

If your company has multiple sources of revenue, such as retail and wholesale sales, use a separate line for each. Base your pro forma projections on past sales figures and trends, such as consistent percent annual growth.

Also figure in anticipated changes, such as whether you will be introducing a new product or moving to a bigger location. Next, list your anticipated expenses, such as rent, labor, payroll, utilities and marketing.

Apple Footer

Use historical trends such as the percentage of gross revenue that you typically spend on materials and labor. Also figure in specific upcoming expenses that are on your radar, such as a rent increase or equipment purchase. Subtract the total projected expenses from total projected revenue to calculate your pro forma net profit.

Pro Forma Balance Sheet Your pro forma balance sheet shows what you expect your overall financial situation to look like at a specific point in the future. Create one by listing all of the assets you anticipate owning at that point in time. Include cash on hand and in the bank, as well as the inventory, equipment, leasehold improvements and accounts receivable owed to you.

Next, list your anticipated liabilities, such as the balances that will be owed on loans and credit cards. Also include sums that you will have collected in payroll withholding and sales tax but are not yet paid.

Create a spreadsheet with a column for each month during the year.

Financial Projections: Analysis: Business Plans: Butler Consultants

In the left hand column on the top half of the page, create fields for each type of revenue you earn, such as retail and wholesale. Subtract your total expected expenses from your total expected revenue month by month, using the amount left over in each month as the starting capital for the following month.

one page business plan pro forma spreadsheet

References 2 Yale University Press: In she transformed her most recent venture, a farmers market concession and catering company, into a worker-owned cooperative. She does one-on-one mentoring and consulting focused on entrepreneurship and practical business skills.yunusemremert.com is dedicated to Helping Small Businesses by offering tools that can improve performance.

Free Business Templates and Sample Business Plans. A business plan is all conceptual until you start filling in the numbers and terms. The sections about your marketing plan and strategy are interesting to read, but they don't mean a thing if you.

ESSENTIALS Live Classroom and On-Demand. Learn the core competencies of real estate management and/or prepare to earn an IREM credential with our . May 19,  · Opinions expressed by Forbes Contributors are their own. A rock-solid business plan spreadsheet pro forma that is comprehensive enough and easy enough to use is a very complex and time-consuming.

Do you need a free online form to help you collect money online? Easily sell your products and services with a ready-made form or customize your own. About the Program The Business Administration - Management (BAM) program is designed for students whose goals include business management, human resource management, self-employment, entrepreneurial ventures, or a variety of different careers.

Bar Business Plan