Financial projections - Income statement, bal sheet and cash flows


G

Guest

I am trying to make a model to forecast financial statements for a small
business. The problem is that I am having problems getting all the balance
sheet to balance. Can some point me to a template or instructions for doing
this?

Part of the challenge is figuring out what should be inputs and outputs and
where to plug the imbalance (in order to get Assets = Liab + SE, I have to
plug somewhere). I've read somewhere that cash should be the plug, but I am
currently calculating cash based on change in operating, financial and
investment cash balances year over year. Would greatly appreciate any help!
 
Ad

Advertisements

G

Guest

If you've captured all of the correct balances, the difference should equal
Current Period Earnings (the same difference the Income Statement would
have). Consequently, the "plug" should be to Equity.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
G

Guest

Thanks Ron. The year over year change to equity is from net income
incr(decr), so in my model equity is a dependent variable. Are you thinking
of another way?
 
Ad

Advertisements

G

Guest

If you're producing interim balance sheets, the reconciling value for the
balance sheet should equal YTD net income(loss) after taxes and adjustments.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top