Shareholder's Equity Model - Excel Template

This is Wall Street Oasis' Shareholder’s equity template for calculating net worth

by Wall Street Oasis
Most entertaining and useful online finance community in the world.Follow 145

with Patrick Curtis
CEO & Founder at Wall Street Oasis, Chief Learning Officer at IBP InstituteFollow 12

6 reviews831 views|Start the discussion!|Bookmark download for free

Description
This excel model is WSO’s free Shareholder’s Equity template. The model allows you to create your own sheet for the shareholder's equity section of a financial model so as to measure a company’s net worth. This plug-and-play model lets you put in your own data & formulae to auto-populate output numbers. Other tabs for other elements of a financial model are also included in this template.

Shareholder’s equity measures a firm’s net worth and can be found on a company’s balance sheet. It gives the company owners’ residual claim after all creditors and debts have been paid. Analysts will use shareholder equity, along with other indicators, to evaluate the financial health of a business. Shareholder equity is also an important financial metric in determining the return being generated versus the total amount being invested by equity investors.

Shareholder’s equity can also represent the net or book value of a company. It is the difference between total assets and total liabilities, making the formula for Shareholder Equity…

[ Shareholders’ equity = total assets – total liabilities. ]

If you have any questions, feel free to start a discussion below or send a private message via the Wall Street Oasis Eloquens channel.

This Best Practice includes
1 Shareholders' Equity Model Excel sheet