Anyone have any good resources for creating pro forma statements?
I can't seem to get my balance sheet to tie out between equities and liabilities (and it's been a decade since I've taken Financial Accounting :)
I bastardized my pro forma I'm working with now just to get the point across, it is here:
A couple questions on this:
- Balance Sheet - under Equity, if I am expecting or aiming for investment, do I just cumulatively add that up? in other words if we have 2000 in equity Year #1 as an investment, and then we get a $1,000,000 round of funding, do I just end up with $1,002,000 for equity?
- Balance Sheet & Income Statement - are these retained earnings numbers supposed to match?
- How do I handle negative (loss) on the income statement in terms of Tax expense and
- Fixed asset purchases / capital expenditures dont show up on the Income statement, correct?
Thanks. It's driving me crazy since I think I'm close to getting this wrapped up but I just can't seem to get it tied out.
Please: Ignore the actual numbers there. I changed all of them for the purposes of posting this. I just think I'm missing something in terms of getting it all to tie out.