How to Create a Pro Forma Balance Sheet - BusinessTown

How to Create a Pro Forma Balance Sheet

What is a Pro Forma Balance Sheet?

A pro forma balance sheet is similar to a historical balance sheet, but it represents a future projection. Pro forma balance sheets are used to project how the business will be managing its assets in the future.

For example, a pro forma balance sheet can quickly show the projected relative amount of money tied up in receivables, inventory, and equipment. It can show whether you are going to run out of money, and how much additional money you need to borrow, beg, r steal to be able to pay your bills!

It can also be used to project the overall financial soundness of the company. For example, a pro forma balance sheet can help quickly pinpoint a high debt-to-equity ratio, a number that a banker might look to use to measure the creditworthiness of a business.

Let’s go through a pro forma balance sheet using an example of a company called Bright Lawn.

Related: Using Income Statements, Balance Sheets, Cash Flows, and Pro Formas to Drive Profitability

Pro Forma Current Assets

  • Pro forma cash: Take the current cash balance and add it to your projected cash flow between now and the pro forma period you’re looking at . I explain how to project future cash flow in an upcoming presentation. Let’s assume that Bright Lawn’s checking account balance on December 31 will be $50,000.
  • Pro forma accounts receivable:
To estimate the accounts receivable on December 31, you need to take into consideration the average collection time of receivables and the sales projections for prior periods. For example, let’s assume that Bright Lawn receives payment 30 days after services are performed. So, in this case, we need to look at the projected sales for December, which are $70,000. Because it takes 30 days to collect payment, we would expect to have all of December’s billings outstanding on December 31. Bright Lawn’s account receivables would be estimated at $70,000.
  • Pro forma total current assets: These are determined by adding pro forma cash and pro forma accounts receivable. In this case, Bright Lawn’s pro forma total current assets are $120,000.

More financial statements samples for your business: Sample Business Plan financials

Pro Forma Long-Term Assets

  • Pro forma land: Land is the easiest of pro forma asset values to calculate. Because land does not depreciate, it will always have the same value. Just enter the value of the land at its original purchase price. Bright Lawn’s land holdings are valued at $30,000.
  • Pro forma buildings: Buildings do depreciate. Let’s assume we are depreciating the building over 30 years. Bright Lawn bought its building for $300,000. Each year the building will depreciate by $10,000. By December 31 Bright Lawn will have owned the building for three years so the total depreciation will be $30,000. This will be reflected later in the accumulated depreciation total. Under the building heading we show the original value of the asset, or $300,000.
  • Pro forma vehicles: Vehicles also depreciate. They depreciate over a much shorter period of time than buildings do. Let’s assume we are depreciating Bright Lawn’s truck over a seven-year period. The truck was purchased for $73,500. So, each year the truck will depreciate by $10,500. On December 31 Bright Lawn will have owned the truck for one year and hence the truck will have an accumulated depreciation of $10,500.
  • Pro forma total long-term assets: These are determined by adding up all pro forma holdings; in this case, Bright Lawn’s total long-term assets are $363,000.

Related: The 300 Best Small Business Ideas

Pro Forma Total Assets

Pro forma total assets are determined by adding up the pro forma total current assets and the pro forma total long-term assets; in this case, it is $483,000.

Related: How to Start a Business in 5 Steps

Pro Forma Current Liabilities

  • Pro forma accounts payable: Pro forma accounts payable are determined by figuring out how much you will spend on supplies during the last months of the year and how long it takes you to pay your bills. Because Bright Lawn pays its bills in 30 days, it should only have outstanding bills for the supplies it anticipates purchasing in December as of December 31. Since Bright Lawn estimates a supply expenditure of $30,000 in December, it will have a pro forma accounts payable of $30,000.
  • Pro forma accrued payroll: It should be easy to determine a pro forma accrued payroll. Just check your payroll calendar to find out what employee pay periods will remain unpaid by the beginning of the pro forma balance sheet period. Bright Lawn’s weekly payroll is $10,000. Since it pays employees on a weekly basis, the pro forma accrued payroll will be $10,000 on December 31.
  • Pro forma notes payable: Pro forma notes payable include all notes or portions of notes that are payable within one year. Bright Lawn will include in its pro forma notes payable the portion of its outstanding mortgage that will fall due during following year under current liabilities on its December 31 balance sheet. The amount is calculated to be $15,000.
  • Pro forma total current liabilities: To obtain pro forma total current liabilities, you add up pro forma accounts payable, accrued payroll, and notes, or portions thereof, payable, for one year. Bright Lawn’s total current liabilities are projected to be $55,000. 

Pro Forma Long-Term Liabilities

Pro forma mortgage note payable: The size of a pro forma mortgage note payable is calculated by taking the mortgage note payable at the end of the current year and subtracting the principal (not interest) payments that will be made during the upcoming year. To obtain the portion of the mortgage that will be classified as a long-term liability, you need to subtract what is classified as current liability. In Bright Lawn’s case, $15,000 is subtracted from the current remaining principal payments of $200,000. Therefore, the long-term portion of Bright Lawn’s pro forma mortgage note payable is $185,000.

Pro Forma Total Liabilities

Pro forma total liabilities are determined by adding up current and long-term liabilities. Bright Lawn’s pro forma total liabilities are $240,000.

Pro Forma Owners’ Equity

  • Pro forma common stock: The common stock portion of the owners’ equity will not change from year to year unless new stock is issued.
  • Pro forma retained earnings: Pro forma retained earnings can be tricky to determine. They are the last item to be calculated on a pro forma balance sheet.
  • Total assets must balance the total liabilities plus owners’ equity. In Bright Lawn’s case, we already know that the total pro forma assets total $483,000.
  • Also, total liabilities added to total owners’ equity must equal total liabilities plus owners’ equity. So, you can determine total owners’ equity by subtracting total liabilities from total liabilities and owners’ equity.
  • Common stock added to retained earnings must equal total owners’ equity. So, by subtracting common stock from total owners’ equity, retained earnings can be determined. This completes a pro forma balance sheet.

Pro Forma Balance Sheet Example

Before creating your own pro forma balance sheet, take a look at our pro forma balance sheet sample:

Sample Business Plan Financials: Bob's Rent-A-Bike
Balance Sheets, Bob's Rent-A-Bike Starting Pro forma Pro forma Pro forma Pro forma
May 31 Year 1 June 20 Year 1 May 31 Year 2 May 31 Year 3 May 31 Year 4
(interim period
to show max
Assets cash need date)
Current Assets
Cash 1000 1600 15672 35548 67160
Inventory, Supplies 200 500 800 1000 1200
Total Current Assets 1200 2100 16472 36548 68360
Long-Term Assets
Depreciable Assets 1500 7500 7500 12500 15500
Accumulated Dep. (SL 60 mos) 0 0 1500 4000 7100
Net Long-Term Assets 1500 7500 6000 8500 8400
Total Assets 2700 9600 22472 45048 76760
-========== -========== -========== -=========== -==========
Liabilities & Equity
Current Liabilities
Accounts Payable 200 600 1000 1300 1600
Short-Term Debt 0 0 0 0 0
Total Current Liabilities 200 600 1000 1300 1600
Equity
Owner's Paid-in Capital 2500 2500 2500 2500 2500
Owner's Share Retained Earnings -500 5736 16874 32580
Investor's Paid-in Capital 7500 7500 7500 7500
Investor's Share Retained Earnings -500 5736 16874 32580
Total Equity 2500 9000 21472 43748 75160
Total Liabilities & Equity 2700 9600 22472 45048 76760
-========== -========== -========== -========== -==========
By June 20 Year 1 Pro Forma Expenditures and Investments:
Bicycle Assets 7500
Parts 500
Ads, etc. 1000
Total 9000
Less Accounts Payable 600
Projected Cash Usage 8400
Note: Additional bicyles bought in mid-June each year.
Note: Assumes founder and outside investor splitting retained earnings 50/50.

 

How to Create a Balance Sheet for Your Small Business


About Bob Adams

Bob Adams is a Harvard MBA serial entrepreneur. He has started over a dozen businesses including one that he launched with $1500 and sold for $40 million. He has written 17 books and created 52 online courses for entrepreneurs. Bob also founded BusinessTown, the go-to learning platform for starting and running a business.

We make starting a business simple…

We make starting a business simple.

Just stream our video courses and get ready to start a business you’ll love.

Just stream our video courses and get ready to start a business you’ll love.

Our courses will show you exactly how to start and run a business

You won’t have to guess. We’ll show you what to do at every step of the way. You will have unlimited access to easy to follow videos and downloadable tools.

Our courses will show you exactly how to start and run a business

Our courses are taught by real entrepreneurs

Our courses are taught by real entrepreneurs

BusinessTown teachers are real successful entrepreneurs. They will share their experience, wisdom, and skills with you. And they will guide you through every aspect of building your business.

Start a business you love, earn more money and live the life you want

With our easy to follow courses you can quickly learn how to start and grow a business. Even if you’re a beginner, you’ll soon know what to do at every step of starting a business. 

Start a business you love, earn more money and live the life you want

You’ll find a course that’s perfect for you

You’ll find a course that’s perfect for you

On BusinessTown you get access to 130+ courses. Marketing, ideas, planning, how to get started… No matter where you are in your business journey, there is a course just for you.

Learn at your own pace and on any device

Take all the courses you want. Anytime. Anywhere. Any device. Watch one video lesson a day (average 7 minutes) or binge watch the whole thing. It’s up to you!

Take all the courses you want. Anytime. Anywhere. Any device. Watch one video lesson a day (average 7 minutes) or binge watch the whole thing. It’s up to you!

Want to start a business but not sure what to do? Watch this video.

Play

Discover what you need to know to start a business and how BusinessTown can help you by watching this video.

Explore our top 3 courses and start learning now

This course will teach you all the basics of starting a business.

You will be guided step by step through the entire process of starting a business and becoming an entrepreneur. Our #1 most popular course.

This course will teach you all the basics of starting a business. You will be guided step by step through the entire process of starting a business and becoming an entrepreneur. Our #1 most popular course.

Learn how to find a great business idea with this course. 

Discover how to generate awesome business ideas, how to evaluate them, and how to choose the very best one for you.

Learn how to find a great business idea with this course. Discover how to generate awesome business ideas, how to evaluate them, and how to choose the very best one for you.

This course will show you exactly how to create an excellent business plan. 

Learn how to build your business plan from scratch! This course walks you through every step and includes a fill-in-the-blanks template and a complete sample plan.

This course will show you exactly how to create an excellent business plan. Learn how to build your business plan from scratch! This course walks you through every step and includes a fill-in-the-blanks template and a complete sample plan.

Get unlimited access to all these popular courses

You’ll get all the tools you need to succeed

Fill-in-the-blank templates and 50+ other tools will show you exactly what to do at any given step. They will save you time, keep you organized and help you get your business up and running as rapidly as possible. 

Our most popular tools include:

  • 300 Best Business Ideas, 111 pages
  • Business Idea Evaluation Worksheet
  • Ultimate Startup Checklist, 18 pages
  • Business Plan Template, 29 pages
  • Sample Business Plan, 35 pages
  • Marketing Plan Under $2k, 12 pages
  • Financial Statement Templates

What they are saying

What they are saying

BusinessTown founder Bob Adams’s courses and books have been featured in:

Learn how to start a business with our video courses

130+ courses

Unlimited access

50+ tools

Templates & more

Discussion board

Get expert answers

Try 7 days free. Then $19.95/month. Cancel anytime.

Frequently asked questions:

BusinessTown is an e-learning platform built for people interested in starting and running a business. 

On BusinessTown, you get unlimited access to 130+ business courses taught by real successful entrepreneurs and highly skilled experts. You also gain access to 50+ business tools and to our discussion board, where you can get expert answers to your business questions.

No matter what you want to learn or where you are on your business journey, there is a course for you. 

Marketing, ideas, financing, planning, naming, how to get started… BusinessTown covers everything you need to start and run your business right. 

The courses are available anywhere, anytime, on any device, and you can take them at your own pace. 

Create your BusinessTown account to get started and try BusinessTown free for 7 days. 

BusinessTown includes unlimited access to 130+ business courses taught by real successful entrepreneurs and highly skilled experts.

You also get full access to 50+ downloadable tools like worksheets, templates, and samples, and to our discussion board where you can get an answer to any business question you have. 

BusinessTown is $19.95 per month. It provides unlimited access to all 130+ courses, all tools, and our discussion board, where you can get expert answers to your business questions.

We offer a free 7-day trial. If you decide that BusinessTown is not for you, then just cancel within 7 days of starting your free trial and you will not be charged at all.

If you wish to cancel your BusinessTown account, you can do so through your account page under the Billing section. 

If you have any questions, email us at bbisson@businesstown.com. We are more than happy to help!

BusinessTown includes 130+ courses on all business topics: Getting started, business ideas, business plans, strategy, marketing, websites, social media, online advertising, finance, accounting, leadership, sales, legal issues, home-based businesses and more!

Looking for a business idea? Why don’t you check out our course How to Find a Business Idea. 

Do you need help creating your business plan? We’ve got you covered. Take a look at our course How to Create a Business Plan.

Do you want to be walked step by step through the entire process of starting a business? Check out our ultimate course, Start-a-Business 101. 

Are you not sure that you are ready to start your own business? Consider our course, What It Takes to Start a Business.

Are you looking for financing for a new or existing business? We offer 5 courses on financing a small business. We suggest you start with the course, How to Finance Your Business.

Do you want to learn about marketing? Because it’s so important, we offer over 30 courses on sales and marketing. Consider starting with the short course, Developing Your Marketing Message.

Want to learn about marketing online? We offer 5 courses on creating websites, 6 courses on digital marketing and 5 courses on promoting through social media. To get started we recommend the course, The Complete Guide to Digital Marketing.

Looking to get inspired and learn how other entrepreneurs succeeded in starting and growing their businesses? We offer several courses on this including, How to Succeed as a Woman Entrepreneur.

Do you already have a business and are looking to improve it? We have several courses on this topic. Try starting with the course, How to Boost Profits.

No matter where you are on your business journey, there is a course for you.   

On BusinessTown you have access to 50+ downloadable tools like worksheets, samples, and templates to help you start and run a business. 

Our most popular tools include:

The Ultimate Startup Checklist, 18 pages 

The 300 Best Small Business Ideas ebook, 105 pages 

The Complete Business Plan Template, 29 pages

Complete Sample Business Plan, 35 pages 

Sample Marketing Plan Under $2k, 12 pages

One Page Marketing Plan Template

One Page Sample Marketing Plan

50 Guerilla Marketing Tactics Worksheet, 8 pages

Business Idea Evaluation Worksheet 

8 Basic Steps to Making the Sale Template

Sales Presentations that Your Customers Will Love Template

Sales Presentation Sample Dialog

50 Ways to Generate Endless Sales Leads Worksheet 

Cold Calling Script Template and Sample

Emails that Land Sales Template and Sample

Voicemails that Get Callbacks Template and Sample

Income Statement Templates and Samples

Balance Sheet Templates and Samples

Cash Flow Templates and Samples

Calculate Depreciation Template

Key Financial Ratios Sample

How I Started a Successful Business with No Money and No Experience, Case Study

Key Questions to Select the Best Business Idea Worksheet

Validate Your Business Idea Worksheet

Using the 6-Step Approach to Choose a Business Idea Case Study

21 Easy-to-Start Part-Time Business Ideas Guide

42 Home-Based Businesses You Can Start Guide

Why I Repeatedly Changed the Legal Entity of My Business, Case Study

Evaluate Customer Segments and Competitors Worksheet

Differentiate Your Business from Competitors Worksheet

How I Differentiated My First Business in a Crowded Marketplace, Case Study

Creating a Press Release Template and Sample

Marketing Bob’s Rent-A-Bike, Case Study

Planning, Designing and Creating Your Website Worksheet

Search Engine Optimization Worksheet

50 Blog Post Ideas Worksheet

50 Creative Online Marketing Ideas Worksheet

Evaluate Potential Names for Your Business Worksheet

How I Financed Buying a Business Case Study

Cover Letter to Seek Financing Sample

Collection Letter Samples

The Four Quadrant Theory of Time Management Graphic

BusinessTown courses will show you how to start your business right and grow it into a highly successful enterprise. 

You will learn from highly experienced entrepreneurs and experts who have been there and done it. You won’t have to learn by trial and error. You won’t have to guess what to do next. BusinessTown courses will guide you through your entire business journey.

Even if you are a beginner you will quickly learn how to start a business you love. If you already have a business, BusinessTown will show how to grow it and make it better.

By just watching one video lesson a day (about 7 minutes average) you can quickly ramp up your business knowledge. No matter where you are on your business journey, there is a course for you taught by an expert on BusinessTown.

What would you like to learn more about today? Starting a business? How to find a business idea? How to write a business plan? How to do your marketing? How to build an online presence? How to get financing? How to prepare financial statements? BusinessTown has courses that cover all these topics and hundreds more.

So if you want to become a smarter entrepreneur and start and build a successful business, you’ll want to start streaming the courses on BusinessTown today.

Copyright © 2021 BusinessTown LLC. All rights reserved. BusinessTown ® is a registered trademark of BusinessTown LLC.