Notes

Capital Table in Excel
A Capital Tabulation Table (also known as C.T.F. or C.P. table) is a hypothetical table that gives an estimate of the effect of changes in ownership variables on the value of ownership for a business. This is calculated by dividing the total equity and potential ownership by the current market price of each type of capital, such as debt and equity. The results in the Capital Table are called the present value of capital. In accounting startups , the present value of capital is equal to the amount of money that would be invested if the business closed today and no reinvestment was made.

The purpose of the capital table is to allow businesses and other entities to obtain information about the potential value of their ownership interests. By calculating the discounted value of future capital transactions, investors and business managers can assess the value of shares and other options. The C.T.F. is used by corporations, partnerships, limited liability companies, limited partnerships, public corporations, and nonprofit organizations.

Capital pricing is based on the discounted values of future payments based on the value of an owner's shares at present time. A Capital Table is not the same as the Cap Table used by many small businesses and even more larger firms. The Cap Table provides historical data on equity and capital cost models that do not take into account current ownership. A C.T.F. uses discounted cash flow assumptions to provide the discount rates for the years immediately ahead and assumes the best possible scenarios for capital return and operating profits in the years ahead.

Most small businesses and startup corporations will have incomplete information on their capital structure and ownership structure. startups will only be able to provide the ratio of total shares outstanding to total capitalization. In some cases only the years of operation will be given, if the company is still relatively new. startups with complicated capital structures will not be able to provide a complete C.T.F. unless they are already private.

A Capital Table provides information needed by managers to calculate the value of the company through a transaction advisory. A typical Capital Table includes the market price of the company's common stock and the historical performance of that company's capital structure. This information allows managers to determine if the company is actually under-performing or simply buying at a great price. Managers may use the tables to select the best company acquisition strategy, or to choose a vendor who is capable of providing the most effective distribution model.

A Capital Table is used in investment banks and venture capital firms to determine the capitalization and relative shares of the capital. It is also used in acquisitions and in determining enterprise value. Value is equal to revenues less expenses over the weighted average time period. A Cap Table is not the same as a shareholder value or book value on a company's equity. Shareholders would receive a percentage of ownership in the company in exchange for a specific number of shares of capital. The capital structure, however, ties the amount of equity capital between the shareholders and the cap table.

Capital Tables are used to determine the overall profitability of a startup company. The Cap table in particular is used by investors when they make investments in new businesses. There are companies that deal exclusively with startup entrepreneurs and provide cap tables for their investors.

There are several advantages and disadvantages to Capital Tables. One advantage is that it is easy to use in Excel. Capital Tables allow investors and venture capitalists to quickly obtain information on the financial results of any given company. They can be very helpful in analyzing and determining the value of an equity stake. Capital Tables are also ideal for providing funding applicants with a simplified version of the full range of costs and payments associated with raising funds from equity investors and angel investors.
My Website: http://mymbgl.com/home.php?mod=space&uid=49536