UK Balance sheet (forecast) - Shareholder's equity


Joined
Apr 14, 2021
Messages
2
Reaction score
0
Country
United Kingdom
Hi all,

I prepared forecast for a new start up but the balance sheet doesn't look right. The Shareholder's equity is showing up as negative and the total Shareholder equity seems low when compared to net profit from previous years. Please advise if you can spot where I made the error?

Thanks
 
Ad

Advertisements

kirby

VIP Member
Joined
May 12, 2011
Messages
2,129
Reaction score
291
Country
United States
You need to start over.
I suspect your balance sheet is forced into balance using the Equity Capital line as the balancing figure. There is no other reason why it would change like that.
You can easily tell that you are forcing balances when you see that your Balance Sheet cash amount is always $100,000 when on your cash flow projection sheet the corresponding ending cash balance varies from $161,730 to $1, 868,670.86, which ain't $100,000.
So put lots lots more thought and work into this.

But the report format is pretty...
 
Ad

Advertisements

Joined
Apr 11, 2021
Messages
16
Reaction score
1
Country
United Kingdom
Hi all,

I prepared forecast for a new start up but the balance sheet doesn't look right. The Shareholder's equity is showing up as negative and the total Shareholder equity seems low when compared to net profit from previous years. Please advise if you can spot where I made the error?

Thanks
Hi

This happens when liabilities exceed assets. It is not necessarily an error you made. However if you want positive equity you need to either increase assets or reduce liabilities. For a client I did that by showing the overdrawn directors loan account as a dividend.

Kind regards
 

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