Balance Sheet (Projected)

Enter your Company Name here

Beginning Projected
as of mm/dd/yyyy as of mm/dd/yyyy
Assets

Current Assets Notes on Preparation

Cash in bank Rs0.00 Rs0.00 Note: You may want to print this information to use as reference la
Accounts receivable Rs0.00 Rs0.00 delete these instructions, click the border of this text box and then p
Inventory Rs0.00 Rs0.00 the DELETE key.
Prepaid expenses Rs0.00 Rs0.00
Projecting your balance sheet can be quite a complex accounting p
Other current assets Rs0.00 Rs0.00
but that does not mean you need to be a professional accountant t
Total Current Assets Rs0.00 Rs0.00 or to benefit from the exercise. The desired result is not a perfect f
but rather a thoughtful plan detailing what additional resources will
Fixed Assets needed by the company, where they will be needed, and how they
Machinery & equipment Rs0.00 Rs0.00 financed. Using your last historical balance sheet as a starting poin
Furniture & fixtures Rs0.00 Rs0.00 project what your balance sheet will look like at the end of the 12 m
Leasehold improvements Rs0.00 Rs0.00 period covered in your Profit & Loss and Cash Flow forecasts. How
the year's operations affect assets, debts, and owners' equity? For
Land & buildings Rs0.00 Rs0.00
example, let us say you are planning significant sales growth in the
Other fixed assets Rs0.00 Rs0.00 year. Go through the balance sheet item by item, asking what the e
(LESS accumulated depreciation will likely be:
on all fixed assets) Rs0.00 Rs0.00 ASSETS: Inventory and Accounts Receivable will have to grow. Ne
Total Fixed Assets (net of equipment may be needed for increased production. You may draw
depreciation) Rs0.00 Rs0.00 on cash to finance some of this.
Now, since a balance must balance, you need to consider the effec
the other half of the statement: LIABILITIES & EQUITY: Some of th
Other Assets
growth may be financed by profits retained in the business as Reta
Intangibles Rs0.00 Rs0.00 Earnings. Your Profit & Loss Projection will tell you how much migh
Deposits Rs0.00 Rs0.00 available from that source. Funds may be contributed by the owner
Goodwill Rs0.00 Rs0.00 through contributions of more Invested Capital or loans to the comp
Other Rs0.00 Rs0.00 (Notes Payable to Stockholders). Suppliers may provide some of th
Total Other Assets Rs0.00 Rs0.00 financing via increased Accounts Payable. The rest will have to be
financed by borrowing, which can be: Short term loans (due within
months) such as a line of credit. Or by Long Term Debt (maturity gr
TOTAL Assets Rs0.00 Rs0.00
than 12 months).

Liabilities and Equity Technical Tips:

1. Your firm's balance sheet no doubt has more lines than this temp
Current Liabilities For clarity and ease of analysis, we recommend you combine categ
Accounts payable Rs0.00 Rs0.00 fit into this compressed format.
Interest payable Rs0.00 Rs0.00 2. As always for projections, we recommend that you condense you
numbers. Most people find it useful to express the values in thousa
Taxes payable Rs0.00 Rs0.00
rounding to the nearest hundred dollars; for example, $11,459 wou
Notes, short-term (due within 12 entered as 11.5.
months) Rs0.00 Rs0.00 3. In the Fixed Assets section, the "LESS accumulated depreciation
Current part, long-term debt Rs0.00 Rs0.00 figure is the total of all depreciation accrued over the years on all fi
Other current liabilities Rs0.00 Rs0.00 assets still owned by the company. Be sure to enter it as a negative
Total Current Liabilities Rs0.00 Rs0.00 number so the spreadsheet will subtract it from Total Fixed Assets.
4. In Owners' Equity, "Retained Earnings-Beginning" is retained ea
as of the last historical balance sheet or the end of the last fiscal ye
Long-term Debt
"Retained Earnings-Current" is net profit for the period of the projec
Bank loans payable Rs0.00 Rs0.00 less any owner's draw (for partnerships and proprietorships) or divi
Notes payable to stockholders Rs0.00 Rs0.00 paid (for corporations).
LESS: Short-term portion Rs0.00 Rs0.00
Other long term debt Rs0.00 Rs0.00
Total Long-term Debt Rs0.00 Rs0.00

Total Liabilities Rs0.00 Rs0.00

Owners' Equity
Invested capital Rs0.00 Rs0.00
Retained earnings - beginning Rs0.00 Rs0.00
Retained earnings - current Rs0.00 Rs0.00
Total Owners' Equity Rs0.00 Rs0.00

Total Liabilities & Equity Rs0.00 Rs0.00

 use as reference later. To
s text box and then press

omplex accounting problem,

ssional accountant to do it
sult is not a perfect forecast,
tional resources will be
eded, and how they will be
eet as a starting point,
t the end of the 12 month
Flow forecasts. How will
owners' equity? For
nt sales growth in the coming
m, asking what the effects

will have to grow. New

uction. You may draw down

to consider the effects on

EQUITY: Some of the
he business as Retained
you how much might be
ributed by the owners
or loans to the company
ay provide some of the
rest will have to be
m loans (due within 12
rm Debt (maturity greater

e lines than this template.

d you combine categories to

at you condense your

the values in thousands,
ample, $11,459 would be

mulated depreciation"
er the years on all fixed
enter it as a negative
m Total Fixed Assets.
nning" is retained earnings
d of the last fiscal year.
e period of the projections,
oprietorships) or dividends