Location of Principal Office:
2100 Burnett Plaza
801 Cherry Street
Fort Worth, Texas 76102-6898

Noel C. Ice, Attorney At Law
Cantey & Hanger, L.L.P.
Board Certified, Estate Planning and Probate Law,
Texas Board of Legal Specialization, 1983.
PERSONAL BIO


(817) 877-2885 (Atty. Dir. Line)
(817) 877-6094 (Sec. Dir. Line)
(817) 877-2800 (C&H Receptionist)
(817) 877-2807 (FAX)

Last Update Wednesday, June 09, 2004 04:53 PM

 

Home

What's New Forms Guides and  Articles Excel Templates Personal Bio Favorite Links Mission Statement What I Do ( Fees) Where I'd Rather Be Charitable Giving
LIST OF ARTICLES AND FORMS

 

Guides and Articles
Subdirectories link to articles on Pensions, IRAs, Trusts, Probate, etc. There is a separate page for Forms

TrustsAndEstates.net

(To see what I am interested in when not earning a living, visit
www.philosophyforum.net )











E-mail me at
teleice@TrustsAndEstates.net

Clicking the Iceberg Will Always Take You Home
.

Excel Estate Planning Spreadsheet Templates 

Here are all 14 (or so) Templates in one downloadable Self-Executing Zip package.


The individual templates and their descriptions are found below.

 

I am not intending to give legal advice by making these materials available. Legal advice would require an intimate knowledge of a person's individual circumstances, and a tailoring of that legal knowledge to those circumstances. These materials are being offered for free, and although I hope they will be useful to you, they are not to be relied upon. If you want specific legal advice, you should consult, and pay, a lawyer.

These templates are all beta versions. Use at your own risk. They are not to be relied upon.

Read this documents first:
Templates Memo.htm

Push Download Button to Download an Excel '2000 Version of Template

Do not try to open a self-executing zipped file within your Excel without unzipping if first.

To unzip a zipped template, simply click on it and pay attention to the location where the unzipped document is to go. The unzipped document can be directly opened within Excel or by double clicking it.

New MRD Excel Spread Sheet Under the Final Regulations
 
 
Form 706 Estate Tax Return
Form 709 Gift Tax Return

Here is a little GRAT template to add to the collection. It is not very sophisticated, but it will give you some idea about how to plan for the income tax consequences. As you know, if all of the ordinary income is not carried out, the grantor will still be stuck with the tax bill, which can be good, unless the IRS ruling position is expanded to require reimbursement out of what would have been the remainder. Under the subtraction method of 2702, this is not a good result. But if all of the ordinary income is being carried out anyway, and most of the growth is in unrealized capital gains, the IRS position is not hurtful. This program helps analyze the likelihood that all the income might not be paid out.

Not Zipped (because it is small).

If you do not have Excel '97 or later, but can open an Excel 5 version, click here, but I cannot guaranty that it will work.

Texas Probate Significant Date List
This little jewel is a "must" for Texas Probate Lawyers.
Check it out & tell me what you think, particularly if you find any errors.

Not Zipped (because it is small). If it actually opens on your screen in Excel, try it out,and if you like it, simply save it anywhere you want under what ever name suits you. The price is right; it's free!

If you do not have Excel '97 or later, but can open an Excel 5 version, click here. I am told that the v5 version works.

Investment Co. Calculations. Read this Memo InvestmentCoRulesRTF.htm in connection with template.

IRS Form 4972 for use if anyone still qualifies for lump sum averaging.

Here are a series of spreadsheets that can help compute the Minimum Required Distribution Rules. See the Explanatory Memo,

I will periodically be posting more Excel Estate Planning Templates for downloading. A very few of the spreadsheet templates use functions that will required the purchase of ZCalc (which I highly recommend anyway) at a cost of around $100. If you are an Excel user and an estate planner, ZCalc is well worth the money.

RBD Calculations Final Regs.xls

Templates Memo.htm, Templates Memo.doc

AgesRBD59etc.xls
IceZMinDis.xls
IceZMinDisOnSteroids.xls
zMinDisOriginal.xls

MRD Calculator

More Templates Coming Soon