Shareholder Basis Worksheet Excel

A shareholder has a stock basis and a debt basis. If a portion of the shareholders stock is disposed of enter the stock basis related to the shares sold after considering the current years adjustments eg income expense and distribution items.

The Warren Buffett Spreadsheet A Powerful Value Investing Excel

To move to the basis wks screen for another person or entity open that persons or entitys k1 screen and click the basis worksheet tabs there.

Shareholder basis worksheet excel. See open account debt page 19 11 thetaxbook deluxe editionsmall business edition. The amount that the propertys owner has invested into the property is considered the basis. The top of the basis worksheet and basis worksheet continued screen displays the id number and name of the person or entity to which the worksheet refers.

For losses and deductions which exceed a shareholders stock basis the shareholder is allowed to deduct the excess up to the shareholders basis in loans personally made to the s corporation see item 4 below. This worksheet assumes loans from the shareholder are combined and not evidenced by separate written instruments. The initial debt basis is the amount of money loaned by the shareholder to the s corporation.

Decreased for items of loss and deduction. When determining the taxability of a non dividend distribution the shareholder looks solely to his stock basis. This amount entered on line 20 is the shareholders stock basis for calculating gain or loss on the stock disposition.

Each block of stock is accounted for separately. You do need to prepare a worksheet like the one linked above for each prior year of your ownership in order to get to your current basis. Increased for income items and excess depletion.

Stock basis is adjusted annually as of the last day of the s corporation year in the following order. An s corp basis worksheet is used to compute a shareholders basis in an s corporation. There are separate worksheets for stock and debt basis.

S corporation shareholder stock basis worksheet. Shareholders who have ownership in an s corporation must make a point to have a general understanding of basis. The initial stock basis is the amount of equity capital supplied by the shareholder.

Stock basis is also adjusted when shareholders buy sell or transfer shares. Decreased for non deductible non capital expenses and depletion. Losses from s corporations are deductible on a taxpayers form 1040 only to the extent of the shareholders stock plus debt basis.

This basis fluctuates with changes in the company. Tax preparers should maintain the following two worksheets courtesy small business taxes and management for each of their s corporation shareholder clients. I hope this helps for computing your basis in the s corporation.

Financial Model Templates Download Over 200 Free Excel Templates