Home

User`s Manual - Appraise Utilities

1. RROIU HALPER HALSET L URUP SCIENC SIDSIL HFPIEZ HHHHHH LUCILL PIERCE UTRUST Total Estate Portfolios I3 OUI DJ UC OH L3 CJ CJ CJ r DJ CJ UJ p Total Estate Partfalias View Archived Partfalin Exit Programmi Set the Archive directory by selecting the drive you want to store your data from the Archive Drive drop down menu Select the folder by clicking on an existing folder or click on Create New Directory When selecting Create New Directory be sure you have the appropriate permissions to do so 91 ARCHIVE x _Cancel_ Enter the name of the new directory you want to create under the directory J amp PPRAISE MAR CHOS Once the Source Directory and Archive Directory are set check Save Archive Directory w Archive Portfolios inl xl Source Directory Portfolio Types v Save Archive Directory Archive Directory EXC Estate Portfolios Curt C3y APPRAISE E Price Portfolios APPRAISE jw Save Portfolio Type C Basis earch Portfolios Portholio Sort Source Drive By Last Modified Date Save Portfolio Sort Archive Drive E c C By Portfolio Name L SAPPRHAISESDATA Deantz D 5VlISMS D 3550711 D lz e65M D MIEEUS D lz 6b5B Db 003 09 0 FOO03 09 05 2003 09 08 003 09 08 B693875 D EELLYO D EVLSEVS D DUPLIC D Total Estate Portfolios View Source Portfolios 423 Total Portfalia s Selected in Total Estate Portfolios Archive the selected por
2. sar EZPRIC fo 02 05 2004 02 05 2004 on 02 05 2001 Us Portfolio Mame Issue smee EZPRICE Research No Gust k Shares Par 1 001957505 500 UnPriced Save Portfolio Cancel Create PortFalia nter the SHARES PAR VALLIE Far item number 1 The Portfolio Name field is optional hit lt enter gt to advance the cursor Enter the Valuation Date Appraise will advance the cursor to the first item CUSIP field Continue to enter CUSIPS and shares and when finished Click Save Portfolio 58 The basic usage of the EZPrice module is the same as the Estate amp Gift Tax module please refer to that section for detailed instructions Please note EZPrice portfolios do not provide dividends or accruals so if you require that information use the Estate amp Gift Tax module What do you do if you created an EZPrice portfolio but realize that you should have created an Estate portfolio Appraise has a Convert portfolio feature to address such a need Modify the portfolio you wish to convert APPRAISE Create an EZPrice portfolio SAMPLE EZPRICE File Switch Paste Copy this Portfolio s Created Last Update Last User Valuation Date p Delete this Portfolio Is 727004 02 05 2004 hion 0270572001 Us Open another Portfolio alia Name ENT Create a Mew Portfolio Research 1 001951505 500 0000 UnPriced Insert before the Selected Security Print Portfolio Convert bo Estate Exit Delete Selected UnFrice Portfolio
3. Finish Portfolio ID Valuation Date 252885 1272172003 When all of the fields required for an Appraise portfolio have been selected click on the Finish button to create the Appraise portfolio 98 ial x The list below contains the APPRAISE partfalia name s estate name s valuation date s and security quantities for the import file you selected The APPRAISE portfolios will be created once vau click on the Create Partfalia s button below you can alter the Portfolio Mame Estate Name and the Valuation Date for each portfolio by clicking on the data in the list bos The default settings will create APPRAISE Estate portfolios but you can change that by clicking on the Type column of the portfolio you want to change to an EzFrice portfolio Port ID Estate Name Val Date Qoy Type Z5ZSBSB5 PAULINE W GRAHAM lz 31 z 03 az Est Abort Import Now click on Create Portfolio s The next screen lets you know that the Import File has been converted to an Appraise portfolio Click on the Yes button to import another file or click on the No button to exit the program More Import Files X processed Click on Ehe Yes button to import another File click in the Ma button to exit the Universal Import 2 The data From the Import File has been converted into APPRAISE portfolios Are there more Import Files to be d Program Mo To process the import file open the Appraise program select the type of portfoli
4. Portfolio ID Count Date Created Last Update Last User Date of Death Contact sar PORTFO le 01 23 2004 01 23 2004 99 Fri 10 10 2003 Le Estate Name Issue sais PURTEOLIU Research No Cusip Shares Par status Add Security Es Create Alternate 1001957505 0000 UnPriced Fortfolio 459200101 450 0000 UnPriced Iaer orate nie 3 87675R721 10 0000 UnPriced Print Portfolio Selected Security 4362320103 750 0000 UnPriced Delete Selected 5172967101 250 0000 UnPriced Securit LInPrice Portfolio ecurity 6077853109 65 0000 UnPriced Edit Selected View Portfolio Security Save Portfolio Price Portfolio Add Mema File Corrections f you make an error and or need to go back to any data previously entered click on the Save portfolio button before making modifications To correct a CUSIP number or shares click on the appropriate field Use the backspace or delete buttons of your keyboard to erase the incorrect data and then enter the correct data Some of the options may be grayed out Clicking on a security can activate most of the options Click anywhere on a security line to select the security That security can now be modified deleted or another security inserted before it CUSIP Lookup If you need help finding CUSIP numbers to input into your portfolio use our Issue Research program Please refer to the Capital Changes lssue Research section for further details 19 Add Security i
5. Stock amp Bond Valuations for Estate amp Gift Tax Returns A Security Pricing System For Estate amp Gift Tax Evaluations Single Security Pricing amp Portfolio Reporting Reorganization Information Cost Basis Accounting IRS Mode Evaluation Services I nc 180 Old Tappan Road Bldg 4 Old Tappan NJ 07675 201 784 8500 WWwW appraisenj com Table of Contents Welcome to Appraise Asp A Pre installation Requirements B Creating Appraise Asp Directory Structure C Initializing Appraise Asp D E A B D E IV V VI VII VII I X X Setting Appraise Asp Directories Printer Driver Information Appraise Asp System Setup Estate amp Gift Tax Creating an Estate Portfolio Adding a Security Inserting a Security Deleting a Security Editing a Security Sending a Portfolio for pricing Printing viewing a portfolio Issue Research Modifying an existing portfolio Copying an Estate Portfolio Deleting an Estate Portfolio Sending Multiple Portfolios for pricing Printing Estates Portfolios Creating an Alternate Portfolio Inventory Transactions on Alternate Ezprice Convert Portfolio Foreign Security Pricing Basis earch Capital Changes lssue Research Capital Changes Dividend Data Issue Research Stock Split Printing Capital Changes Dividend Reinvestor 1040 1041 Income Calculator Florida Intangible Tax Unitrust Pricing NJ Estate State Tax I Archive Manager Universal Imp
6. 10 10 2003 Us Estate Mame Issue Research Si snares Par 1459200101 250 0000 UnPriced Add Security Insert before the Selected Security Delete Selected Security Edit Selected Security Save Portfolio Cancel Adding Portfolio Print Portfolio LInPrice Portfolia View Portfolio Price Portfolio Add Memo File Securities Click on Add Security and then click on Paste to insert the CUSIP from the Issue Research program APPRAISE Modify an Estates portfolio SAMPLE ACCOUNT File Switch Paste Portfolio ID Count Date Created Last Update Last User Smee ACCOUR A foiso5 2004 01 22 2004 YE Estate Mame Date of Death Eee Feri 1071072003 e Us Issue Research JOHN DOE Creake Alternate We teri W Sharec Far Add Security 1459200101 250 0000 UnPriced e eeu f 2001957505 ee nni Next enter the number of shares and continue to create your portfolio as normal When finished adding securities click on Cancel Adding Securities and then Save Portfolio Please note you can only copy 1 CUSIP number at a time To print a list of CUSIPS researched refer to the Capital Changes lssue Research section 37 Modify an existing Estates portfolio The main reasons for modifying an Estate portfolio are to create an alternate valuation report and to add delete or modify existing information To modify an existing portfolio go to the Estates main menu and click on Modify an existin
7. 6 999999014 0000 User sian Edit Selected View Portfolio Security Save Portfolio Price Portfolio Edit Memo File lick on this bukban to send this portfolio to Evaluation Services Inc For pricing 24 w Sending Estates portfolio s for pricing Portfolio File Name SAMPLE ACCOUNT Porttolia Estate Mame JOHM DOE Total This Portfolio Total Securities Tatal Priced Total UnPriced 4 1 5 Total Securities Sent Tat Portfolios Sent Tat Securities Sent 1 8 Send Far Pricing Send Far Pricing WwiDetail Reorg Cancel tO add oe There are two pricing options available Send for Pricing and Send for Pricing with Detail Reorg Send for Pricing will connect you to our database instantly and all pricing data the high low and mean price including accrual and dividend data will be available within seconds Send for Pricing with Detail Reorg will connect to our database instantly and include all the pricing data as above and also capital changes details for all items in the portfolio in the date range of one month prior and nine months after the valuation date There is an additional charge of 0 20 per security for this feature The process for sending is the same for either option Click on Send for Pricing 25 Send for Pricing 180 Old Tappan Road Bldg 4 Old Tappan New Jersey 076 7b Tel 201 784 8500 Fax 201 784 9685 Welcome E amp PPRAISES SENDING YOUR PORTFOLIO S FOR PROCESSING ACCOUNT PORT s
8. Death and Alternate Valuation Sometimes certain transactions such as sales mergers and name changes occur between the date of death and the alternate date You can account for these occurrences by using our alternate inventory transaction feature Before proceeding to post transactions please insure that you Nave all required information such as dates CUSIPS shares and prices To post transactions click on the specific CUSIP number and then click Sales Mergers Etc Sales Mergers Etc Alternate Inventory Transaction s Portfolio Mame AMPLE Date of Death o lna zn n0z Alternate Date floyszoos Security Shares held on DOD Price Value 001957505 50 0000 00000 00 Exchange Shares held on Alt Price value amp 0 0000 00000 00 Name Chg Date Sold Shares Sold Price per Share Total Transaction Value Redeemed 01 20 2003 50 0000 25 00000 1 250 00 Remark Bev Split nter the price per share Far this transaction IF you enter a price per share the transaction value il be calculated automatically IF you do not know the price per share enter zero and you will be prompted For a total transaction value and the price will be calculated automatically Spin Off Split Transfer In Transfer Out Sold 50 0000 shares on OL 40 2003 at 5 00000 per share Tot Val 1 250 00 Cancel 4dd Delete Transaction Edit Transaction Post Transaction There is a listing of 17 transaction types to choos
9. GA Search U yFolders 4 Ae D x e EE Address Appraise o Horton AntiVirus Data Import le objectis n bytes is Local intranet Initializing Appraise Asp Go to www appraisenj com Under the Application tab select Appraise Asp Or click on Logon to Appraise Asp on the right hand side beneath Contact Us Next Click on Start Appraise Asp Now Citrix will attempt to download a file click Yes Security Warning x Do pou want to install and run Citris ICA 32 bit Windows Chent signed on 10 20 2003 7 51 PM and distributed by Litris Systems Inc Publisher authenticity verified bu YernSign Class 3 Code Signing 2001 CA Caution itis Systeme Ine asserts that this content is safe You should only install view this cantent if you trust Citrix Systems Inc to make that assertion F amp lways trust content from Citrix Systems Inc Yes More Info Citrix will download and install on your computer the Citrix ICA Web Client this allows you to connect to our access server to run Appraise over the nternet Upon successful download of the web client a Logon Window will appear Enter your User name and Password provided by Evaluation Services Inc Your User name and Password are case sensitive and must be entered using ALL CAPS Logon Information A WE i Terminal Server Edition 1981 1998 Micrazoft Corp All rights reserved This product is protected by US and international copyright laws a
10. SEND enter the portfolio name character by character until the portfolio name appears in the portfolio list box Once the portfolio name appears in the portfolio list box click on the portfolio name and then click the OK Button IF vou do not know Ehe portfolio name of khe portfolio that you wank to SEND use the up and down arrows or the thumb until Ehe portfolio name you want to SEND appears in the portfolio list box click on Ehe portfolio name khen click on Ehe OK button Next send the portfolio for pricing 61 Foreign Security Pricing Appraise allows you to price foreign securities To price a foreign security using EZPrice you must obtain the Sedol number associated with the security Sedol stands for Stock Exchange Daily Official List Sedol numbers represent foreign securities that have a CUSIP number and do not trade in the US Most Sedol numbers are six or seven digits When inputting a Sedol number enter the first six digits and then add two zeros For example if you have a foreign security with a Sedol number of 438713 you would enter the first six characters 438713 followed by two zeros 43871300 Appraise will automatically enter the check digit Prices for equities are in US Dollars Foreign bond pricing is the price from the specific exchange it is traded on and will need to be manually converted APPRAISE Modify an EZPrice portfolio FOREIGN File Switch Paste Portfolio ID Count Date Created Last Update L
11. Security Edit Selected View Portfolio Security Save PortFolia Price Portfolio Add Memo File lick on this button to add a new security to the end of this portfolio At the upper left hand corner click Files Convert to Estate Lonvert this portfolio to an Estate Portfolio Is the APPRAISE EzPrice portfolio SAMPLE EZPRICE displayed abowe the one that you want to convert to an Estate Portfolio 59 Confirm that this is the portfolio you wish to convert by clicking Yes If not click No and select another portfolio to convert If Yes you will be prompted to enter the portfolio ID File Switch Paste ParkFalia ID Count Date Created Last Update Last User Valuation Date ante SAMPLE EZPRIC 0270572004 0270572094 Tx eon 02 70572001 Portfolio Mame SAMPLE EZPRICE Research Mew Portfolio ID Count Date Created Last Update Last User Valuation Date conver Po f fion ozv05 2001 Mew Estate Mame sire EZPRICE Cancel Conversion nter the PORTFOLIO MAME Far this Estate Portfolio The PORTFOLIO WAME can consist of any combination of letters A Z and numbers 0 9 The PORTFOLIO NAME must be between Four 4 and Forty 40 characters long If you would like to keep the portfolio ID the same hit either the tab or enter key If you would like a different portfolio ID enter the new Portfolio ID and hit the enter key to advance to the New Estate Name field Hitting tab or enter will advance the cursor and then enter the v
12. Select an Estates portfolia s to PRINT oj x File Mame Folders CAAPPRAISEIDATA SAMPLE ACCOUNT D Ec SAMPLE IRS D SY APPRAISE SAMPLE IBS2 D Total Fil Available Disk Drives otal Mes c D 2Date af Death Portfolio A A lternake Date Portfolio List Files of Type Portfolio Count Estates it D 7 42 File Mame Date of Death Alternate Date Portfolios to be Printed SAMPLE 10 10 2003 SAMPLE ACCOUNT D Estate Mame SAMPLE IBS2_D SAMPLE PORTFOLIO D SAMPLE PORTFOLIO IF vau know the name of the portfolio that vau want to print enter the portfolio name character by character until the portfolio name appears in the portfolio list box Once the portfolio name appears in the portfolio list box click on the portfolio name and then click the OK button IF you do nat know Ehe portfolio name of Ehe portfolio khat you want bo print use the up and down arrows or the thumb until the portfolio name vau want bo print appears in the portfolio list box click on the portfolio name then click on the OK button El Click each of the portfolios that you would like to print The portfolio file name will appear in the Portfolios to be Printed box The Portfolio Count box will indicate the number of portfolios to be printed When all the information is correct click on OK 45 Estate Print Defaults Default Printer HP LaserJet 1200 Series PCL 6 chro et Orientation Copies Change Printer Landscape z
13. To add additional securities click on the Add Security button This will create a new field to enter additional data When you finish adding your securities and share values click on Cancel Adding Securities button and the Save Portfolio button If your date of death portfolio has an existing alternate report Appraise will indicate that a security has been added to the DOD and then ask you if you would like to add this new entry to the alternate portfolio Yes will automatically add the same security to the alternate portfolio while No will leave the alternate portfolio in its original state Insert before the Selected Security If you need to add a security to a specific location click on the security you wish to insert before then click on Insert before the Selected Security After you have finished inserting securities click on Cancel I nserting Securities and the Save portfolio button Delete Selected Security To delete an entire security including the CUSIP number and the shares along with all pricing data click on the security and then click Delete Selected Security If your date of death portfolio has an existing alternate portfolio Appraise will indicate that a security has been deleted from the date of death portfolio and then ask if you would like to delete this entry from the alternate portfolio Yes will automatically delete the same security from the alternate portfolio while No will leave the alternate portfolio in its
14. ag E C Portrait Report Type Print Method Estate Tax Valuation f Print the Report Portfolio valuation Asset Percentage Rpt C Save the Report to a text File Distribution Report C Save the Report to a data File Gift Tax Valuation C Valuation Report Mo Security Value C Accrual Report Mo Principal Sort Method f No Sort Order Entered C Sort by Cusip Number C Sort by Security Type and Cusip Number O Sort by Security Description The Estate Print Defaults screen is where you can choose a printer determined by the operating system paper orientation portrait or landscape number of copies 1 or more report type print method and sort method Selecting a Printer When you print a portfolio it will automatically print to your system s default printer However you have the option to change the output media for your report by clicking on the Change Printer button and using the drop down arrow keys to indicate the desired printer You must highlight to select the printer by clicking in the Default Printer box This printer change is only temporary the program will always default back to your system s default printer Number of Copies You also have the option of printing more than one copy of the portfolio s To determine the number of copies click on the plus or minus signs to increase or decrease the number of copies Orientation Select either Landscape or Portrait by highlighting your choice Our def
15. be Deleted aoo lz 31 zu 0z Oe s0 2003 Estate Mame joooo07 Click on each portfolio that you would like to permanently delete The portfolios file name will appear in the Portfolios to be Deleted box along with a number indicating the number of portfolios to be deleted in the Portfolio Count box Next click on OK For each portfolio that you have chosen you will be prompted to verify your decision to delete 42 Delete this portfolio You have selected the Estates alternate date portfolio 000006 displayed above to be deleted Are wou sure you want to delete this Estates altermate date portfolio Send Estates portfolio s for pricing This section allows you to send one or multiple portfolios at the same time Sending more than one saves time Click on Send Estates portfolio s for pricing Next click on each of the portfolios you would like to send for pricing w Select an Estates portfolio s to Price File Mame Folders CAAPPRAISEIDATA OO4100 D O1O8208_4 O1O8208_D Total Fil Available Disk Drives oral Fries eS c 477 D Date af Death Portfolio A Alternate Gate Portfolio List Files of Type Portfolio Count Estates e D A File Mame Date of Death Alternate Date Fortfolios Ea be Priced 0114394 loyfzze z002 0472272003 oloszog_ az Estate Mame o1lo08708_D O1l14s94_ 4 HASSELL PETER IF you know the name of the portfolio that you wank to SEND enter the portfolio name character b
16. change the drive where you store the data 14 When you have made all your selections click on Done You are now ready to use the Appraise program m MAIN MENU APPRAISE Ver 7 2 402 Ioj x BEN rg Ds Client Name Estate amp Gitt Tax Basis earch Capital Changes Issue Research Exit APPRAISE Estate amp Gift Tax is used for IRS Form 706 and 709 reports Ezprice is used for historical security pricing Basis earch is used for cost basis accounting and multiple date pricing Capital Changes Issue Research provides reorganization information stock dividends CUSIP Lookup and stock split history System Setup is used to customize your program settings 15 Estates amp Gift Tax Use our Estate module to prepare the IRS 706 Form for Estate taxes This program will calculate and then create a report that will display the high ask low bid mean and accrual dividend interest information required to complete your tax forms The report is so thorough that you can simply print the report and attach it to your schedule To begin click on the Estate amp Gift Tax tab on the Appraise Main Menu im MAIN MENU APPRAISE Ver OF xj Client Number bros Session ID ho s Client Name PO Estate amp Gift Tax E Price apital Changes Issue Research System Setup Exit APPRAISE 16 Creating an Estate Portfolio In order to create an estate portfolio click on the Create an Estate portfolio ta
17. have selected the field For a Portholio ID which is the file name used for APPRAISE partfalia files The minimam size i four 4 characters the masimurm size is Forty 40 characters f the portion of the feld that is highlighted is NOT the portion of the Field vau want to use as a Portholio ID use the Start Pas in Field scroll bar below to adjust the start position of the highlighted data and the Length of Field scroll bar below to adjust the number of characters in the highlighted data Click on the Column OF Record Fiel button when the Portfolio ID is correct Sample Column Data 25288540 Start Pos in Field Length of Field is File Back Hert Finish Portfolio ID m If clicking on the portfolio ID field you may be prompted to further define the field Define the start position and the length of field then click Column OK Step 6 All fields selected Allof the Fields required for an APPRAISE portfolio file have been selected Click on the Finish button to create the APPRAISE portfolio file s Record Field 1 Field z Estate Name Field 4 31 25258540 25256540 25258540 25256540 eS258540 25256540 25268540 25268540 252688540 25268540 eS268540 25268540 PAULINE PAULINE PAULINE PAULINE PAULINE PAULINE GRAHAM GRAHAM RAHAM GRAHAM GRAHAM GRAHAM Las02262003 19802262003 13802262002 ee L9so2262003 15802262002 eee 19802262003 Eee Save Settings far this file Back M est
18. may be left with partial shares Most merger terms include cash in lieu rates for fractional shares If you received some form of cash along with shares of a new company you must post the cash on the merged company s CUSIP Highlight the new CUSIP and then click on Sales Mergers Etc Select cash tn lieu from the transaction list box The program will prompt you for the cash received date and the fractional shares Alternate Inventory Transaction s Portfolio Mame ETST Date af Death 1n0f 1 0 z 0z Alternate Cate i 04 10 2003 Security Shares held on DOD value 255100105 aaau u n 0 Shares held an Alt ice Value Fee Matured 100 2750 00 Merger Name Cha Date Cash Received Fractional Shares Price per Share Total Transaction value Bedeemed 02 02 2003 3150 25 00000 9 38 Remark Rev Split Saoald Spin Off Split Exchange nter the price per share For this transaction IF you enter a price per share the transaction value ill be calculated automatically IF you da not know the price per share enter zero and you will be prompted Far a total transaction value and Ehe price will be calculated automatically Transfer In Transfer Out Transaction Postings Merger from security 001957505 on O2 02Z 2003 received 100 3750 shares Cash In Lieu 3750 shares on O2f02 2003 ac z5 00000 per share Tot Val 3 38 Cancel Add Delete Transaction Post Transaction Before posting a merger or name change
19. new Estate Portfolio You are initially prompted to enter a portfolio ID This file name must be alphanumeric and between 4 and 40 characters including spaces and hyphens The estate name field is optional Hit lt enter gt to advance to the date of death field Enter the date as MM DD YYYY You are now ready to enter the CUSIP and shares 56 APPRAISE Create an Estates portfolio IRS MODE f File Paste Portfolio ID CounE Date Created Lask Update Last User Date of Death Contact ms HODE A 0270372004 02 03 2004 99 rue 12 31 2002 Us Estate Mame Issue res MODE Research No CUSIP Shares Par Status Rep Yal Rep Div Int Rep Div Int Rep Div Int 1001957505 500 0000 UnPriced 13 180 00 90 00 Save Portfolio nter the REPORTED DIVIDEMD IMTEREST For item number 1 Cancel Create Portfolio Enter the CUSIP for item number 1 Appraise will automatically advance the cursor to the Shares par field Input the number of shares and hit enter The status of item number 1 is UnPriced Next enter the Reported value of the security and the reported dividends or interest Appraise supplies three fields for dividends and interest If you only have one dividend to report hit enter in the subsequent reported dividend interest fields to advance the cursor Next click on Save Portfolio To receive the actual value of the security click on Price Portfolio located at the lower right After pricing is complete view the portfolio to c
20. on View Portfolio The view default screen allows you to choose orientation report type and sort method Estate View Defaults Orientation Landscape C Portrait Estate Tax Valuation C Portfolio Valuation Asset Percentage Rot t Distribution Report C Gift Tax Valuation C Valuation Report Mo Security Value C Accrual Report Mo Principal Report Tvpe Sort Method f No Sort Order Entered C Sort by Cusip Number C Sort by Security Type and Cusip Number C Sort by Security Description These view options are flexible and reversible They can be changed without adversely affecting pricing data When all options have been selected click on View 31 Viewing an Estate Portfolio SAMPLE PORTFOLIO PortFalio Mame Page Pages Totals Next Previous Size Size acta Page Page Page E SAMPLE PORTFOLIO Ja Ja ESTATE TAX SECURITIES VALUATION ACCOUNT SAMPLE PORTFOLIO Name of Estate SAMPLE PORTFOLIO DATE OF DEATH Friday October 10 2003 ITEM CUSIP NO SHARES f DESCRIPTION PRICE HIGH ASE LOW BI PAR VALUE DATE PRICE PRICE 1 001957505 50 AT amp T CORP 10 10 20 3600 20 11 COM DIV 0 2375 EX 09 26 2003 REC 09 30 2003 PAY 11 03 2003 455200101 INTERNATIONAL BUSINESS M W5 10 10 53 1800 32 36 COH S16 TSR 1 TAX EXEMP SECS TE 10 10 50 68 UT Ph TE 120 M DIV 54 3300 EX 03 23 2003 REC 10 01 2003 PAY 10 15 2003 LAREYUVER ACCRUAL 52 04 UNIT 172967101 CITIGROUP INC 10 10 43 2400 47 71 COH There are button
21. original date and enter a new date or if the date is to remain the same hit enter at the date prompt 40 After you input the date you will see a Copy Completed box COPY COMPLETED The portfolio SAMPLE PORTFOLIO has been copied to the portfolio COPY OF SAMPLE successtully Click on OK to retum ta the APPRAISE main menu Click OK to return to the Estate amp Gift Tax Main Menu Note if you had created the copy from the modify screen you will be returned to the portfolio If your copy has a different date than the original you must send it for pricing to obtain the correct values that specifically pertain to the new date If the date was never changed all the pricing data will be the same as the original portfolio 41 Delete Estates portfolio s This section is used to delete portfolios from the Appraise data directory Use this function only if you are absolutely sure that the portfolio is no longer needed Once a portfolio is deleted it cannot be recovered You can choose one or more portfolios to delete at a time Click on Delete Estates portfolio s w Select an Estates portfolio s to DELETE mi x File Mame Folders C 4PPRATSEVDAT 4 yc aarp PAISE Estate Mames Total Files available Disk Drives D Date of Death Portfolio epee calles Em 472 A Alternate Date Portfolio List Files of Type Portfolio Coun Estates 1027 41 File Mame Date of Death Alternate Date Portfolios bo
22. security value are all excluded from this 47 report The client name is displayed under the heading Name of Estate and the date is classifies as Date of Death Sort Method The sort method decides the order in which the securities will be printed on the report When you sort by Security type and CUSIP number Appraise will divide the portfolio into sections based upon security type it will provide a header such as Common Stock Mutual Fund Corporate Bonds etc for that corresponding group of securities It will also subtotal the values of each security type Total Common Stock after each section while still providing a grand total of all the securities at the end of the report Sort by CUSIP Number is in ascending order while Sort by Security Description is in alphabetical order 48 Creating An Alternate Portfolio The alternate valuation date portfolio is always created from within the original date of death portfolio To create an alternate valuation portfolio click on the Modify an Estate Portfolio button and choose the estate portfolio for which you need an alternate While inside of the date of death portfolio click on Create Alternate Portfolio APPRAISE Modify an Estates portfolio SAMPLE PORTFOLIO File Switch Paste Portfolio ID Count Date Created Last Update Last User Date of Death ETE sare PORTFO E 0172372004 01 30 2004 In xi 1071072003 Ls Estate Mame Issue sire PORTFOLIO Research i eee ae Add Security AIS
23. the entire portfolio Print Portfolio To print a portfolio click on Print Portfolio The print portfolio screen offers a wide variety of format options for the report This screen allows you to choose the printer the paper orientation and number of copies sort method report type and print method Estate Print Defaults Default Printer HF LaserJet 1200 Series PCL 6 coro ee Orientation Copies Change Printer f Landscape z Xp L f C Portrait Report Tvpe Print Method Estate Tax Valuation f Print the Report Portfolio Valuation Asset Percentage Rpt C Save the Report to a text File C Distribution Report C Save the Report to a data File Gift Tax Valuation C Valuation Report Mo Security Value C Accrual Report Mo Principal Sort Method f No Sort Order Entered C Sort by Cusip Number C Sort by Security Type and Cusip Number C Sort by Security Description To change to a different printer click on Change Printer and then use the drop down arrow keys to indicate the desired printer Next highlight to 30 select the printer by clicking on the default printer box To change any of the other options click on the appropriate boxes The options are flexible and reversible they can be changed as many times as you like without adversely affecting the pricing data To print specific page numbers refer to the viewing a portfolio section View Portfolio To preview the report prior to printing click
24. verify that all information is correct Once a merger name change Is posted the security cannot be edited without first deleting the security that resulted from the transaction The merged company no longer exists and has been changed into the other company With name change the company no longer exists under the old name All subsequent transactions should be done under the company s new name Fee Use this option to account for fees such as broker commissions or transaction costs Appraise will prompt you for date cash received and dollar amount We also provide a field required to describe the origin of the fee After entering the description hit lt enter gt and then Post Transaction On the finished report all fees are represented as a negative number and will reduce the final security value 54 You can add several transactions to a single security by continuing to click on Add Transaction and then selecting a transaction Exceptions are Name Change and Merger as explained above Alternate Inventory Transaction s ParkFalio Mame sampur Dake oF Death 10 10 2002 Alternate Date 04102003 Security Shares held on DOD Price Value nza071201 1 020 0000 00000 Shares held an Alt Price Value 130 0000 000 Transaction Postings Split z n0 0 00 for 1 on lz z 7 z z applied to Alt shares 53 922 50 a r A m Sold 1 000 0000 shares on 3 s3 z 03 at 75 00000 per shar
25. 1 02 1968 Last Price Date lssue in Look Up Dividend Database Es lssue in Look Up Split DataBase No pu an a line of data in this box to display the detailed information Far the secrity Geach Hew Search Print E xit There are 250 securities that match your request AT amp T CORP COM AT amp T CORP COH NEW TAAG TIMOTHY PLAN THERMAL ABALATION TECH CP TRANSALTA CORP HANCOCK JOHN CA TAXFEEE INC ED TAC INC THC AGROWIERLD CORP Note Each time you click on a security description you will incur a charge When you are ready to research another security click New Search to clear the screen If you would like a list of the CUSIPS researched click Print after each search When finished click Exit In order to print you must exit completely from the Capital Changes Issue Research program See Printing in Capital Changes lssue Research 74 This feature allows you to view the stock split history for a particular security Click on Stock Splits Appraise will search our database for stock split information This data includes the security name and description split rate and the splits ex record and payment date Any changes resulting from a stock split are reflected on the ex date Cusip Number 00155710 Securty Name ATT CORP Securty Description kox Split Type Stock dividend in stock of another issue or company spin off Stock split Stock dividend in ztock of another issue or company spin off Reverse spli
26. 10 DAYTON HUDSON CORP 01 14 00 3 23915310 DAYTON HUDSON CORP 01 13 00 7 60705910 MDBIL CORP 12 20 99 9 78387G10 SBC COMMUNICATIONS INC 03 30 00 9 78387G10 SBC COMMUNICATIONS INC 02 25 00 Ex Capital Changes Report The Appraise Capital changes report shown above is available with all Estate portfolios regardless of the pricing method you choose If you selected to Send for Pricing w Detail Reorg you will receive the detail reports at the end of the portfolio APPRAISE DETAILED CAPITAL CHANGES Portfolio SAMPLE PORTFOLIO Date Prepared 03 10 2004 The Corporate and Municipal Capital Changes cover the period fram 09 10 2002 to 07 10 2003 From Date 09 10 2002 One 1 month prior to the Valuation date To Date 07 10 2003 the Valuation date up to the last pricing date Maximum of nine 9 months 1 00195750 Text Number 715097 Date Entered 06 30 2003 OPT 01 ATST CORPORATION UPOTEXT 654245 0099 SHE INFORMATION SERVICES EXTENDED THE OFFEF TO PURCHASE SHARES OF ATST CORPORATION COMMON STOCK FROM HOLDERS OF 9 9 OR FEWER SHARES HELD AS OF RECORD DATE NOVEMBER 18 2007 UNTIL AUGUST 29 2003 TERMS HOLDERS WILL RECEIVE CASH AT A ERATE TO BE DETERMINED LESS A PROCESSING FEE OF 0 50 PER SHARE THE OFFER WILL EXPIRE ON AUGUST 29 2003 05 00 PH EDT THERE IS NO PROTECT PERIOD OF WITHDEWAL PRIVILEGE AVAILABLE NOTE HOLDERS MAY PURCHASE ADDITIONAL SHARES TO REACH 100 AT A DEPOSIT PRICE TO BE DETEEMIHED PLUS A 0 90 P
27. APPRAISE partfalia i in the disk drive files box double click an it ta select the file and start the import process IF the file is not displayed to the disk drive files bos vau may need to change the file type using the files of type bos below au can limit the number of Files displayed by entering a file search criteria will display all files TT will only display files ending in FAT TT DAT will display all tiles ending in TT and DAT Check this bos to make the selected file typeles the default ou can select the default APPRAISE portfolio type that this import program will create The default will create either E Price or Estate Portfolios but you can override the default later Exit Import Pragram The first screen will allow you to select the disk drive that contains the file you want to import into an Appraise portfolio You can also save the drive and folder as the default directory of import files Next double click on the import file 94 i Select Heading Lines for c APPRAISE UT TASSPORTseL DAT IF the import File you have selected has a heading we must know where the data starts Using the Start Import at Haw bos below select the first line of data after the heading for this file IF there is no heading then leave the setting at line 1 and click on the Start Import Row Box ar click an the Nest button Start Import at row Record If your import file has a heading use the list box to
28. Disk Dbrive Bemote Disk Drive Bemote Disk Drive The list box above is displaying all of the drives available to your local system Drives followed by Remote are network dives Click on the drive letter that you want to use as your APPRAISE home directory This directory will be used to stare working files temporary files and other data You need full access rights to this directory You are now ready to set the directories Click on the Appraise Home Directory button then click on the appraise folder located to the right in the Local Disk Directory List This will set Appraise as the Home directory Next click on the Appraise Data Directory button on top then select Data Do the same for the Import directory then click Done Note the V drive listed in the Local Disk Directory List represents your drive on our Access Server Printer Driver I nformation When a user logs on to our access server to run Appraise Asp all the printer s on the user s system will be mapped to our server providing that the driver is installed on our server If a specific printer were not listed as a choice on the Appraise Asp program we would need that printer s driver information To determine which driver your printer uses go to Start Settings Printers Next right mouse click on the printer icon and go to its properties Depending on your operating system look for the advanced or details tab and find print using the following driver Provide this inf
29. E IOE ERE E Create Alternate ata Fortfolio 2595200101 9000 Data Insert before the l 3876758721 0000 Data Selected Security Print Portfolio 172967101 0000 Data Delete Selected 5077853105 0000 Data Em sd 6399999014 000 0000 User Man Edit Selected 7 o02824100 0000 Data Security 8024071201 020 0000 Data I 0000 Data Sese Sle leila 101121101 0000 Data EET 0000 Data 12205881102 0000 Data 13 294 741103 0000 Data lick an this button to view this portfolio UnFrice Portfolio View Portfolio aoe Price oer Edit Memo rere The Appraise program will automatically create an alternate portfolio with a valuation date for 6 months after the date of death COPY COMPLETED The Date of Death portfolio SAMPLE PORTFOLIO has been copied to the Alternate Date portfolio SAMPLE PORTFOLIO successfully Click an GE to retum to the SPPRAISE main menu 49 The alternate screen is similar to the date of death screen with a few differences The alternate screen will list the date of death and the alternate valuation date There is now a Switch to DOD ALT Portfolio button on the upper right which allows you to toggle between the date of death and alternate date portfolios The alternate portfolio has an option to report any activities between the date of death and alternate valuations APPRAISE Modify an Alternate portfolio SAMPLE PORTFOLIO File Switch Paste Portfolio ID Add Securi
30. ER SHAPE PROCESSING FEE THE OFFER I5 NOT REGISTERED WITH THE SEC A MAXIMUM NUMBER OF 10 000 SHARES PER WEEK WILL BE ACCEPTED OW A FIRST COME FIRST SERVED BASIS DEPOSITARY SHE INFORMATION SERVICES TEL 305 986 1331 ee 00195750 Text Number 68970 Date Entered 1 01 2003 OPT 01 ATAT CORPORATION WPITEXT 659299 0099 EXTENDED THE OFFER TO PURCHASE SHARES OF ITS COMMON 654245 STOCK FROM HOLDERS OF 35 OF FEWER SHARES FUT MORE THAN 20 21 29 HELD AS OF RECORD DATE NOVEMBER 22 2002 UNTIL MAY 30 2003 TERMS HOLDERS WILL RECEIVE AN AVERAGE MABKET PRICE PER SHARE LESS A PEDCESSIHG FEE OF 270 00 PER ACCOUNT THE OFFER WILL EXPIBE OW MAY 30 2003 05 00 PH EDT THERE IS NO PROTECT PERIOD OF WITHDERUIAL PRIVILEGES AVALLABLE INFORMATION AGENT GEORGESON COMPANY TEL 800 733 8485 DEPOSITARY SHAREHOLDER COMMUNICATIONS CORPORATION ADDRES 5 110 WALL STREET 11TH FLOOR NEW YORE NY 10005 TELEPHONE 212 105 2807 Example Detail Reorg 29 UnPrice ParkFalia IMPORTANT This is a feature in which the results are irreversible f you would like to unprice a security in order to re send for pricing you must click on the security and then click on Unprice Security If you need to unprice the entire portfolio click on Unprice Portfolio Your entire portfolio except for manual entries will lose all of its previous pricing information Use this feature only if necessary Please note that modifying the valuation date also unprices
31. ORTFOLIO Research No Cusip Ticker Shares Par Status 3r Ticker Firm Hame Dezscription Cusip TELUS CORP COM 87971Ml 0 TELUS CORE NUN VTG SHS 897971H95 AT amp T CORP COM 00195750 AT amp T CORP Portfali COM 00195710 I P E J TIRE TRANSALTA CORP COM S859345Dbl 0 Cancel Create Portfolio he box on khe right contains a list of ticker symbols that begin with the character s entered Double click on the icker symbol vau want ta select or press the lt ENTER gt key to select the bop security Appraise Asp will accept CUSIP numbers or Ticker Symbols Enter a ticker symbol by typing the ticker in the CUSIP Ticker field As you begin entering a list will appear with possible choices for that ticker In the above example the ticker symbol for AT amp T was entered The box on the right contains a list of ticker symbols that begin with the character s entered Double click on the ticker symbol you want to select or press the lt ENTER gt key to select the top security If a ticker symbol does not appear on the list you will need to enter a CUSIP number Next enter the number of shares then press the ENTER key Enter the next CUSIP Ticker and the shares par values Continue this until you are finished entering all of the data then click Save Portfolio 18 You will now see a new screen with several new options APPRAISE Create an Estates portfolio SAMPLE PORTFOLIO File Switch Paste
32. a fixed length tle with HO delimiters and HO predefined fields Click the Next button IF the format selected is nat corect you can return to select another format using the Back key nu have selected field 6 s start position Click on the start of field number 7 Click on the zMest button if all af the fields have been selected Click on the BACE button to redefine field B IF Field number is the SHARES PARVALUE field use the end of field number 6 as the start position for field number 7 FIELD 2222 25208540 25288540 PAULINE W GRAHAM l198 0226z2z 0 035 001957109 koo ononon Back HM ext If the format selected is not correct you can return to select another format using the Back button If all the fields are correctly selected click the Next button 96 Step 2 Select Shares Par Value field Locate and double click an the field below that contains the Shares Par Value that you want ta import into an APPRAISE portfolio file Be certain that the field is numerics only Record Field 1 252608540 252688540 252588540 25289540 25268540 252688540 Field 25268540 eS28e540 25285540 eo28e540 25268540 eS285540 Field 3 PAULINE PAULINE PAULINE PAULINE PAULINE PAULINE Field 4 19802262003 13802262003 138022462003 138022462003 13802262003 Field 6 30000 5 0n0 0 0 euu suu 9600 oo0000 oo00000 oo0000 ddadl oo0000 15802262002 ee Save Settings for this file M est Fi
33. al Changes Dividend Data Issue Research or Stock Splits you must enter a six character billing reference code in the Billing Reference box This code will appear on your bill so that you can identify the LookUp charges The LookUp billing is done after you click the Exit button so only one reference code can be used per Lookup session After the billing code is entered you will be allowed full access to all the features of the program 68 Capital Changes provides current or historical information for a company by entering either the company s name or CUSIP There are two options to search for capital changes 1 You can search for all years or 2 You can set a range of years By default the program searches for reorganization information for all years To limit your search to specific years click on the circle marked Search Range of Years Use the arrows to specify the high year then click on it to select it Next specify the low year and click on it to select it If you would like Appraise to search all the years on the database no action is necessary REORG DATA Capital Changes Gorporate Database Migh veaj Low ear z Tears to Search Search All ears High Y r Po Uto Intt High rear ELI v Search Range af ears Low yr Tent cuip Nano Entry Date Remark Text ND Cusip Number Total Records Print Exit Description Total Records Input either a CUSIP number or a description of th
34. aluation date COPY COMPLETED I The EZPrice portfolio CHAPPRAISEIDATAWSAMPLE EZPRICE E has been converted to the Estate portfolio CA4PPRAISEIDATSICOMVERT OD successfully Click an GK to retum to editing the APPRAISE portfolio CHAPPRAISEIDATAVWSSMPLE EZPRICE E Click OK at the Copy Complete message box 60 Next to modify or price the converted portfolio go to Switch Switch to Estates portfolio APPRAISE Modify an EZPrice portfolio SAMPLE EZPRICE File Switch Faste Eee Eee rene ated Last Update Last User valuation Date pat sata Switch bo EzPrice 004 0270572004 hn hon 02 05 2001 Us Switch to Basistearch Mame leone SAMPLE EZPRICE Research EEEE Add Security i 001957505 500 0000 UnPriced This will return you to the Estate amp Gift Tax main menu The converted portfolio will need to be sent for pricing Click on Send an Estate portfolio for pricing and then select the converted portfolio w Select an Estates portfoalia s En Price E Oo x File Name Folders SAMPLE F CHAPPRAISE DATA SAMPLE EZPRICE D Gc APPRAISE Estate Mames Tatal Fil Available Disk Drives oral Fries E D Date af Death PartFalia A Alternake Date Portfolio List Files of Type Portfolio Count Estates cee os File Mame Date of Death Alternate Dake Portfolios Ea be Priced SAMPLE 02 05 2001 SAMPLE EZPRICE D Estate Mame SAMPLE EZPRICE IF you know the name of the portfolio that vau want to
35. ast User Valuation Date Contact FORELGH A 0171272004 0171272004 Iun ri 1071072003 Us Portfolio Mame Issue FOREIGN SECURITIES Research No Cusip W Shares Par ale Seeley 1432712000 525 000 0000 UnPriced Tm 2549445005 7 240 0000 UnPriced Insert before the Selected Security Print Portfolio Delete Selected UnPrice Portfolio Security Edit selected View Portfolio Security Save Portfolio Price Portfolio Add Memo File lick on this button to print this portfolio Continue to follow this procedure until all of your securities are entered When you are finished save the portfolio and then send for pricing If you need foreign security pricing for an estate and gift tax portfolio you would first obtain the values in our EZPrice module and then manually add the items into an Estate portfolio 62 Exchange Rates Appraise EZPrice can provide exchange rate data in U S Dollars You must have the country s four digit currency code followed by four zeros APPRAISE Create an EZPrice portfolio EXCHANGE File Switch Paste Portfolio ID Count Date Created Last Update Last User Valuation Date Contact EXCHANGE A 01 12 2004 01 12 2004 rea 12721 2003 Us Portfolio Mame EXHAHGE EATE mo cuip W snares Par 1102300001 1 0000 Data 2 1 0000 Data a 109100003 1 0000 Data Print Portfolio Delete selected UnPrice Portfolio Security Edit Selected View Portfolio Security Price Portfolio Add Mema Fil
36. ation Asset Percentage Rpt Save the Report to a text File Distribution Report Qi Save the Report to a data File Gift Tax Valuation Valuation Report Ma Security value Accrual Report Mo Principal Sort Method OF No Sort Order Entered Sort by Cusip Number Sort by Security Type and Cusip Number Sort by Security Description Do not save the printing defaults Exit Appraise 101 Next open Microsoft Excel Open file and then browse to the directory of the file or type in the filename Open Look in i 1 3 Fes FEE t mle z 1 KB X File B TESTOL 2 KB TRN File 5 5 2003 11 33 AN Cancel TESTOL 1 KB D File 552003 11 33 AF E Advanced E TESTU1 1 KB RDT File 552003 11 33 AM E TZ2FMNFM 1 KB DDT File 552003 10 47 AM 223540 1 KB D File 552003 8 58 AM 223240 Z KB ROT File 5 5 2003 8 58 AM E 223240 1 KB BLD File 5 5 2003 8 51 AM 223540 z KB DOT File 5 5 2003 8 51 AM ez324U0 1 KB REO File 5 5 2003 8 51 AM Find Files thak match these search criteria File name Text or property Find Mow Files of type are H Last modified fany time New Search 2543 File s Found In this example TestO1 was selected Note the file extension of ddt 102 This brings you to the Text Import Wizard Select Delimited then click Next Text Import Wizard Step 1 of 3 Windows NSD m E m A Gi rii A RI Check comma then click Next 103 Text Import Wiza
37. ault setting is Landscape Print Method The print method will default to Print the Report This will produce a Hard Copy of the report This is the print method most often used 46 Appraise also offers two other print methods Save the report to text file saves the report in ASCII format ASCII format gives you a facsimile of the actual report You can open the file using such programs as Microsoft Word WordPad Notepad etc Appraise will attach the extension dut for date of death or aut for alternate valuation to the portfolio file name and then save it in the Appraise data directory Save the report to a data file Saves the report to a comma delimited format which you can use to import into soreadsheets and accounting software Appraise will attach the extension ddt for date of death or adt for alternate valuation to the portfolio file name and then save it in the Appraise data directory Report Type The Estates program offers several report types The type of report determines the header to be used and how the valuation date Is classified It also determines what information will be displayed in the report Estate Valuation This report type is the most common and has a header of Estate Tax Securities Valuation and lists the clients name under the heading Name of Estate The date is classified as Date of Death It displays the high low and mean price and security value including accrued dividends and interest Dist
38. ave Portfolio Cancel Create nter the estate name Far this new portfolio The estate name can be any information pertinant Ea Ehe portfolio and n mast cases Would be the decedents name You are initially prompted to enter the portfolio ID The Portfolio ID can bea minimum of 4 and a maximum if 40 alphanumeric characters and may include spaces and hyphens Enter the portfolio name and then click enter 64 APPRAISE Create a Basis earch portfolio SAMPLE BASIS File Switch Paste Portfolio ID Count Date Created Last Update Last User ENSE SPLE BASIS lo 02 06 2004 02 06 2004 Us PortFolio Mame Issue smee BASIS Research E rw a 001957209 SIN X VUnPriced 0019571039 45No X VUnPriced No UnPriced Save Portfolio Cancel Create nter the SHARESIPAR VALLIE Far item number 1 Enter the CUSIP and shares and then hit lt enter gt You are prompted with the following message Current Shares X c 2 Are Ehe shares you entered For this security the current shares You would select Yes if these were the amount of shares owned as of today For example your client owns 45 shares of AT amp T currently You need to know how many shares did they originally purchase in 1985 and what is the Cost basis You would select No if these were the amount of shares that was owned on the requested pricing date For example your client purchased 45 shares of AT amp T in 1985 You need to know how many shar
39. b APPRAISE Create an Estates portfolio File Switch Paste Portfolio ID Count Date Created Last Update Last User Date of Death ESTEE o 01 23 2004 01 23 2004 soo f f Us Estate Mame Issue Research You are initially prompted to enter a Portfolio ID The Portfolio ID can bea minimum of 4 and a maximum of 40 alphanumeric characters and may include spaces and hyphens An Estate portfolio will normally price based on the mean price and show dividend accruals A Portfolio ID ending in ZZ or YY is a special case where the pricing is based on the Closing price A ZZ code will show dividend accruals while an YY code will not show accruals 17 After entering the Portfolio ID you are then prompted to enter the name of the estate When finished inputting the estate name hit the ENTER key The name of estate field is optional If you do not choose to name an estate press enter to advance to the next field Please note the decedents name is not included during file transfer The next field to complete is the valuation date Enter the date of death as mm dd yyyy After the year is entered a screen will appear to enter the CUSIP Ticker and shares for the portfolio APPRAISE Create an Estates portfolio SAMPLE ASP PORTFOLIO Ale Sintehy Baste Portfolio ID Count Date Created Last Update Last User Date of Death C ontact suere ASP POC fo 05 22 2004 05 22 2004 ri 1071072003 Us Estate Mame Issue smere P
40. ce 2 Low Price 2 Mean Price 2 Days Future fof Mean Price Security Value 0 00000 0 00 Add Dividend Data The top portion of the screen will indicate the CUSIP number shares par value valuation date status and item number These items cannot be changed Click on the Security Name field and enter a description Choose a security type by clicking on the drop box of the Security Type field Click in the Security Type box to select the security type This will change the field to accommodate the kind of security type selected We have a total of 18 security types to choose from Here is a listing of security types available Common Stock Treasury Security FHLMC Gold Corporate Bond Promissory Note FNMA Municipal Bond Miscellaneous FHMLC 75 day Preferred Issue Common Trust Fund UIT Mutual Fund Text CMO Demand floating GNMA type pool GNMA type II Pool rate note Remember that it is necessary to click on the actual security type box to highlight the selection and to change the field 22 Next fill in all the necessary information The total security value will be recalculated automatically to reflect the new prices without re sending for pricing When all manual entries are complete click on Save Security Cancel your entry by clicking on Cancel Changes Click on the Finished button to exit out of the edit security screen Users of Appraise commonly use the text entry to input items such as Cash Money Markets and CDs This will al
41. date Last User Date of Death Contact SAMPLE PORTFO 13 Jois23 2004 0172772004 un frei 10 10 2003 Us Estate Mame Issue sm LE PORTEOLIO Research You can change the name of the estate by highlighting the Estate Name that is in the estate name field and input the new estate name You will not have to re send the portfolio for pricing You can change the valuation date of the portfolio Click in the date of death field Modify the date of death IF you modify the date of death For this partFalio it will hawe to be resent For pricing Do vou want to modify the date of death If you modify the date of death for this portfolio it will have to be resent for pricing f you want to change the date click Yes Next highlight the entire date and hit the delete key on your keyboard Then enter the new valuation date You will have to re price the entire portfolio If you would like to keep all data for a portfolio based on a certain date and price all the same securities as of another date use the Copy feature Refer to the Copying an Estate portfolio section for detailed instructions To change a CUSIP Ticker or shares simply click on the appropriate field and re enter the information and then click Save Portfolio 39 Copy an Estates porttolio This function allows you to copy an existing Date of Death portfolio to another portfolio you cannot copy alternates You may want to do this for several reasons including chan
42. e Insert Cancel Please note the dividend reinvestor portfolio must be priced before adding manual inputs 82 Print or Print Preview After pricing is complete you are returned to the view modify screen Click on the Printer Icon located on the top toolbar You are now at the print preview screen Prnt Preview APPRAISE DIVIDEND REINVESTOR Portfolio Name SAMPLE DRIP PORTFOLIO Portfolio ID z SAMPLE Page 1 Issue INTERNATIONAL BUSINESS MACHS Significance 3 Issue Description COM Dividend Pule Ex Dividend Dat Cusip Number 459z 0 010 Price Rule Use closing price Start Date 04 15 2005 End Date O04 15 2004 SHARE DESCRIPTION PRICE O4 15 2003 BUT OS O7 2003 REINVEST DIVIDEND 08 06 2003 REINVEST DIVIDEND 11 06 2003 REINVEST DIVIDEND O24 06 2004 REINVEST DIVIDEND O4 15 2004 END DATE Click on the Printer Icon on the lower toolbar to print the portfolio 83 To Open an existing Portfolio Click on the Open Icon select Open located on the top toolbar or go to File then A listing of existing portfolios appears Click on the portfolio to select it and then click on Open Select location and Portfolio File z Bap Peer mrs pori To Delete a Portfolio Open the portfolio by clicking on the Open Icon on the top toolbar or go to File then select Open A list of existing portfolios will appear Select the portfolio then click on Delete You are asked are you sure you want to delete por
43. e lick on this Button to view this portfolio In the above portfolio the currency codes for Great Britain Pound Swiss Franc and Japanese yen have been entered Next click on Price Portfolio After receiving pricing data view the portfolio In this example 1 Pounds Sterling is worth 0 5586 U S Dollars VALUATION DATE Wednesday DBecember 31 7003 Security Value based on High Ask Price LUV BID CLOSE SMEAN SECURITY EST ANNUAL YIELD 1 102300001 5586 0 5586 2 1209700006 1 2368 1 2368 3 209100008 107 1700 107 1700 Grand Totals 63 Basis earch is used for cost basis accounting Use this program when you need the original cost basis and know the current shares or you need the current basis but only know the original shares Basis earch also permits a single portfolio to be priced using multiple issues and multiple pricing dates Basis earch reports include the unit price and total price at date of purchase current split adjusted shares the total split factor and cost basis From the main menu of Appraise click on Basis earch and then click on Create a Basis earch portfolio Create a new Basis earch portfolio APPRAISE Create a Basistearch portfolio SAMPLE BASIS l File Switth Paste Portfolio ID Count Date Created Last Update Last User Contact SAMPLE BASIS o o2 06 2004 o2 70672004 999 Ls Portfolio Mame Issue sai BASZIZ Research equired Portfolio Data Pe Porcholiog kile Mame S
44. e Tot Val 75 000 00 Add Transaction Delete Transaction Edit Transaction Cancel Selection If you need to delete or edit a transaction click on the transaction and then click either delete or edit transaction The Delete Transaction will delete all of its contents Use the Edit Transaction to make modifications to an existing transaction Try not to add a security to the alternate that did not exist on the date of death report without using the Sales Merger s Etc button This will help you explain all account changes that occurred between the date of death and alternate valuation date 55 IRS Mode This option will allow you to enter reported values and reported accruals per security and compare the differences between the actual values and the reported values To run the Appraise program in IRS Mode you must first change the setting in system setup From the Main Menu of Appraise click on System Setup On the Methodology page click on the Run IRS Mode tab and toggle to Y and then click Done Pun IRS APPRAISE Iv Run APPRAISE in the IRS made with reported values You will notice a truncated version of Appraise limited to run Estate amp Gift Tax portfolios only in IRS Mode im MAIN MENU APPRAISE Ver 7 2 402 ml x E ul Client Mame Estate amp Gift Tax Capital Changes Issue Research Exit APPRAISE Create a new Estates portfolio To begin click on Estate amp Gift Tax and then click on Create a
45. e from 51 Below is an explanation of a few of our 17 transaction types Sold This is our most popular feature Use this to account for any sales of securities between the date of death and alternate dates You will be prompted to input the date of the sale the number of shares sold and either the price per share of the security value of the sale When you are prompted to enter a price enter either the price per Share or the total security value If you have the price per share enter that value and hit enter You are then prompted to enter a security value Ignore that field by hitting enter Appraise will then calculate the value for you Or vice versa if you do not have the price per share but only the security value hit enter at the Price per Share field and enter the security value only Appraise will automatically calculate the price per share The sale transaction feature will adjust your alternate shares accordingly You can do multiple sales sell partial shares or sell all shares However you will not be allowed to sell more shares than what were owned as of the date of death portfolio Spin Off Sometimes a company decides to spin off part of the parent company sometimes a division or group to form a new company Shareholders receive shares of the new company resulting with owning shares of both companies This should be shown on the alternate report You will be prompted to give the date of the spin off the CUSIP fo
46. e security that you are researching If you supplied sufficient data for a successful search a Reorg Data screen will appear displaying all the information that applies to that company or CUSIP number as well as remarks summarizing each entry 69 REORG DATA Capital Changes Coporate Database High rear 2004 Low Year Haag un to Search nM 3 a Search All Years I erumpere ttr Migh rear Low Year Search Range of Years Low ri 2004 Cnt Cusip Hame Entry Date Remark Text H I 0019257109 AT amp T CORPO 12 2 02 TERMINATION 6589521 001957105 AT amp T CORPO 12 2 02 REVERSE s s 659046 001957105 AT amp T CORPO 11 27 02 REVERSE 5 5 6598420 001957105 AT amp T CORPO 11 19 02 SPIN OFF 655887 001257109 AT amp T CORPO 11 18 02 REVERSE 5 5 6557166 001957105 AT amp T CORPO 11 12 02 SPIN OFF 655767 001957105 AT amp T CORPO 11 15 02 SPIN OFF 655148 0019257109 AT amp T CORPO 11 14 02 SPIN OFF 65413507 001957105 ATAT CORPO 11 14 02 REVERSE 5 5 654911 001957105 AT amp T CORPO 11 7 02 REVERSE Z 5 653215 001957105 AT amp T CORPO 11 7 02 SPIN OFF 653276 001957105 AT amp T CORPO 11 1 02 REVERSE 5 5 651916 13 001957109 ATST CORPO 10 31 02 SPIN OFF 651581 1 2 3 4 5 6 7 9 ME FEE j Pa S S SS S 5 S 5 5 5 5 5 5 z r Cusip Number Total Records Print E xit Description Total Records Soo The letter U appearing under IND signifies the most up to date entry To view the entry s detailed information click on the li
47. e the Up Down buttons to resize the report window so that vou can view the instructions at the bottom of the form Estate Name i 50 7296 00 ODD LOT THDR DISTRIBUTION REJECTION DISTRIBUTION DISTRIBUTION Company VODAFONE GROUP PLC NEW Company WAL MART STORES INC CAPITAL CHANISES UP own ail QOC Shares 2 150 00 Dates Declared 112 2002 11 0572972003 Ib 1 075 00 Save the report to Ms Excel or Ms Word before printing to ensure you are only billed once for the report When finshed click on the Back button to exit 0 0750 0 0500 0 0900 0 0300 x HCD 5 ave Print 11 14 2002 127 03706 2003 M3 06705 2003 05 05 24 4005 10 The report will display on screen Use the Up amp Down buttons to resize the screen if necessary Be sure to save the report either to an Excel or Word document before printing to ensure you are only billed once for the report This file will be saved to your Appraise Data directory Click on the Back button to exit the report 88 A person who makes Florida his or her principal residence or domicile may have a duty to file an intangible tax return with the Florida Department of Revenue no later than June 30 of each year The return must report all intangible personal property owned as of January 1 of that year which is not exempt Shares of stock of corporations regularly listed on any public stock exchange or regularly traded over the counter are subj
48. earch criteria will appear on the bottom of the screen Description farene 2nd Description com new O Exchange New York Stock Exchange Security Type Common Stock SiC Code as13_ Communications 15T Frice Date 01 02 1968 Last Price Date pooo zu LUsip 00195750 lseue in Look Up Dividend Database xs lssue in Look Up Split Database N Total Security Hits ie 1 50 Total Bill Click on the Exit button to return to the APPRAISE program without the selected cusip number New Search Copy Cusip E xit Billing Reference sample There are 250 records that match your search criteria AT amp T CORP COM AT amp T CORP COM NEW TIMOTHY PLAN THERMAL ABALATION TECH CP TRANSALTA CORP HANCOCK JOHN CA TAXFEREE INC FD TAC INC THC AGROWORLD CORP Using the up down arrows scroll down until you see the item that matches your criteria In this example we are searching for AT amp T common stock Choose the line that reads AT amp T Corp Com New Now click on the item to get its full description including the CUSIP If you would like this CUSIP included in the portfolio click on Copy Cusip and then Exit You will be returned to the modify portfolio screen where you can Paste in the CUSIP 36 APPRAISE Modify an Estates portfolio S4MPLE ACCOLNT File Switch Paste Portfolio ID JOHN DOE Count Date Created SAMPLE accom fa o170572004 0170572004 N a Last Update Last User Date of Death pamm prs
49. ect to this intangible tax at the value as of the closing price on the last business day of the previous calendar year Bonds regularly listed on any public stock exchange or regularly traded over the counter are subject to this intangible tax at the value of their closing bid prices on the last business day of the previous calendar year The Florida Intangible Tax program automatically provides the closing bid price for each security See the section on EZPrice for instructions on using this service The fair market value of assets held in an Unitust are re valued annually Our UniTrust program will provide the high low and mean price of securities held in the trust See the section on Estate amp Gift Tax for instructions on using this service Our NJ State Estate Tax program will provide asset values for securities compliant with the State of New Jersey Estate tax regulations See the section on Estate amp Gift Tax for instructions on using this service 89 Archive Manager Appraise Asp clients will first have to download this free utility from our website and then run the installation program Our Archive program will store your Appraise Portfolios to other directories allowing you to organize your data and free up space in your current directory This will greatly enhance performance during your Appraise Asp session To begin double click on Archive icon located on your desktop ARCHIVE E The first window wil
50. el Import Care fet Report Clear Select a portfolio from the list by either typing the portfolio ID Blue Box or using the scroll bar Next double click on the portfolio then Get Report To import an existing portfolio click on Import and then select a portfolio from the list by either typing the portfolio ID in the blue box or using the scroll bar Double click the portfolio and then click Open 86 1040 1041 Income Report Yaluation Date 07 22 2003 Estate Mame JAMES TRACY Cusip f Ticke The following 3027316102 securities 670928100 525204271 311621106 755111606 746778109 06423n103 296209EHM7 1101227108 17125671101 25413687106 310442105 401693105 459140100 E were not imported because there were no dividends reported in the To create new pori Portfolio date range date estate name CUSIP Tick ck on Get Repor OF lf you need to modify a portfolio click Open To add or delete use the insert and delete buttons of your keyboard To Import an existi ck on Import be Securities with no dividends reported in the portfolio date range will not be imported and a list of those securities will be displayed click OK Next click on Get Report 87 Report Valuation Date jor 1 2003 10 23 2003 0972972003 0722r 2003 06730 2003 0373172003 ltem Cusip T 3285710 ltem Cusip B 33114210 4 Dividend data for form 1040 1041 ts available for 1 55 per security Us
51. es do they have now and what is the cost basis 65 After answering Yes or No you are prompted to enter the pricing date When all data has been entered click on Save Portfolio Next click on Send Portfolio This will send your portfolio to our database when all processing is done click on Download Complete BASISSEARCH VALUATION ACCOUNT SAMPLE BASIS Portfolio Name SAMPLE BASIS ITEM CUSIP PRICING ORIGINAL CURRENT ADJ ORIG SECURITY NO NUMBER DESCRIPTION DATE SHARES PAR CLOSE MEAN SHARES PAR CLOSE MEAN FACTOR VALUE 1 001957109 AT amp T CORP 09 05 1985 150 0000 21 1250 45 0000 70 4167 0 3000 3 168 15 COM 2 001957109 AT amp T CORP 09 05 1985 45 0000 21 1250 13 5000 70 4167 0 3000 950 63 COM Shares Marked with an asterisk were the shares entered by the user Grand Totals Basis earch also allows you to price multiple issues on multiple dates Create a portfolio as before and input the CUSIPS shares and dates APPRAISE Modify a Basis earch portfolio MULTIPLE DATES 01 File Switch Paste Fortfolio ID Count Date Created Last Update Last User Contact MULTIPLE DATE l 02 06 2004 02 06 2004 In Ls Portfolio Mame Issue BASISSEARCH SAMPLE REPORT Research Ro cuip Shares Par ue 369604103 100 0000 No 12 31 1918 UnPriced 599331107 50 0000 Yes 04 10 1992 UnPriced Eso Print Eso x ssoooio 200 0000 Yes 01 02 1925 UnPriced BORED Delete UnPrice Selecked Portfo
52. g Estate portfolio w Select an Estates portfolio to MODIFY na x File Mame Folders zal CAAPPRAISETDATA SAMPLE ACCOUNT D P SAMPLE IRS D SY APPRAISE SAMPLE IRSZ D SAMPLE PORTFOLIO D x J dataz Estate Mames Total Fil Available Disk Drives otal Fires EJ o D2Date af Death Portfolio A A lternake Date Portfolio List Files of Type Estates pU DIT A File Mame Date of Death Alternate Date DL E BM eee Estate Mame c IF you know the name of the portfolio that you want to modify enter the portfolio name character by character until the portfolio name appears in the portfolio list box Once the portfolio name appears in the portfolio list box click on the portfolio name and then click the Ok button IF vou do not know Ehe portfolio name of the portfolio thak wou wank to modify use the up and down arrows or the thumb until the portfolio name you want to modifs appears in the portfolio list box click on the portfolio name then click an the OK button Choose the portfolio you want to modify by either typing in the file name or scrolling the up down arrows and highlighting the selected portfolio All date of death portfolios are indicated by an extension of d and all alternate portfolios are indicated by an extension of a When you have made your selection click OK 38 APPRAISE Modify an Estates portfolio SAMPLE PORTFOLIO File Switch Paste Portfolio ID Count Date Created Last Up
53. ging the portfolios file name and or the valuation date Do not use this function to create alternate valuations Please refer to the section on alternate portfolios for instructions There are two ways to copy a portfolio If you are already in the portfolio you want to copy then go to File Copy this portfolio From the main menu select Estate amp Gift Tax and then click on Copy an Estate portfolio Select the portfolio to copy and click OK Either way will lead you through the same process Copy this portfolio Is the APPRAISE Estates portfolio SAMPLE PORTFOLIO displayed abowe the one that WOU Want bo copy You will be prompted if this is the portfolio you want to copy If this is the correct portfolio click Yes if not click No and reselect your correct portfolio LPPRAISE Copy an Estates portfolio SAMPLE PORTFOLIO File Switch Paste Portfolio ID Counk Date Created Last Update Last User Date of Death a ih Sain RNNEE Contact SAMPLE PORTFO 1s 01 23 2004 01 23 2004 haa Fri 10 1072003 Us Estate Mame SAMPLE FORTEOLIO Mew Portfolio ID Count Date Created Last Update Last User Date of Death COPY OF SaMPL 13 fois29 2004 E hya frei 101072003 Mew Estate Name SAMPLE PORTFEOLI U You must give the copy a different file name from the original Next you are placed at the estate name prompt You can leave the estate name the same or change it by typing in a new name Hit enter to advance to the date field Delete the
54. ia H MH D While sending for pricing you will see blue boxes at the bottom of the screen along with messages summarizing the progress of your pricing When pricing is complete the bar will reach 100 26 A new screen will indicate which portfolios are loaded priced successfully along with any CUSIPS that were unsuccessfully priced Any CUSIPS that were unable to be priced will appear under Exceptions i Receiving Portfolios from pricing z iol x Portfolios Loading Portfolio Security Count Portfolios Loaded ls AMPLE P 1 NotLoaded SAMPLE PORTE Exceptions Prices all O for Cusip 45960020 Click on the Download Complete button when highlighted After clicking on this button you will be placed back into your portfolio 27 APPRAISE Modify an Estates portfolio SAMPLE PORTFOLIO File Switch Paste Portfolio ID Count Date Created Last Update Last User Date of Death Contact sme PORTFO le 01 23 2004 02 19 2004 In nu 1071072002 Us Switch to Alt Estate Mame Issue Portfolio SAMPLE PORTEOLIO Research No cuip W Shares Par 50 Add Security 1001957505 0000 Data 0000 Data M je 5455600201 0000 u LInPrice Portfolio ecuri H 6 999999014 9000 Uszer Man Edit Selected View Portfolio Security Save Portfolio Price Portfolio Edit ema File bef h 2455200101 450 0000 Data Insert before the i Print Portfolio Selected Security 3 7675 amp 721 10 0000 Data 4j172967101 lick on this button b
55. ired between the date of death and the alternate valuation In such a case you may receive pricing information as of the date of death but not on the alternate date Appraise allows you to show the merger and obtain pricing for the company of acquisition Click on the appropriate CUSIP and then click on Sales Mergers Etc Select merger from the transaction list box The program will prompt you for the acquisition date the new CUSIP and the number of shares for the new company Next click on Post Transaction and then Finished Appraise will then automatically add the new company to the portfolio Alternate Inventory Transackion s ET Called Portfolio Mame ETST Date of Death 15 15 2007z Alternate Date Ina 10 52003 Cash Security Shares held on OOD Price Value Cash In Lieu Dist 001957505 c0 0000 _oo000g Exchange Shares held on Alt Price value Fee Matured O0_ 0000 00000 Name Chg Merger Date Mew Cusip Number Merger Shares Redeemed 02 02 2003 25510010 100 3750 Bemark Bev Split sold epin Off nter the number of shares that were received with this new security Split Transfer In Transfer Out Merger of security 255100109 on Of 02 2003 received l 0 3750 shares Cancel Add Delete Transaction Edit Transaction Post Transaction 53 Sometimes as a result of a merger a shareholder will obtain shares of a new stock and or cash Many times after the share conversion you
56. ithout closing this program using the Company Information and Mail menu selection There are two 2 options for sending email 1 Use your current email provider 2 Use the built in email function of the Dividend Reinvestor Program Your email will be sent when you send a portfolio for pricing Click on Save to save any settings otherwise your changes would not be saved Click on Exit to exit Dividend Reinvestor To Create a Dividend Reinvestor Portfolio Click on the new portfolio icon to create a new portfolio I gt Click on the button to create a new Portfolio E Enter a Portfolio name Enter a unique six character filename Enter a CUSIP number or click on the button to the right of the CUSIP Number field to search by ticker symbol or security description Select the significance number Select the dividend rule to use for calculating dividend data for this security Select the price rule close bid low or average price Enter the start and end dates Our Dividend Reinvestor program can calculate going forward or backward 78 Create New Portfolio Portfolio Mame SAM PLE DRIP PORTFOLIO Portfolio id samre Click on the Button to get initial price Cusip Number a5920010 me Significance Ma 3 Dividend Aules E dividend date Initial Purchase Price Per Share o2 FOO Price Rules Use closing price Share Amount E Start D ate 02 15 2003 i in Dollar Amount 41 395 00 Eh End Da
57. l display your source drive and directory m Archive Portfolios Source Directory Portholia Types i Save Archive Directory Archive Directory a C EzPrice Portfolios Save Portfolio Type C3 APPRAISE E DATA C Basistearch Portfolios hi J didis El Portfolio Sort l Source Drive By Last Modified Date Save Portfolio Sort Archive Drive E c C By Portfolio Name Create Mew Directory 3 EvAL SERV 81SEXT2 LC appraisesD AT A amp PPRAISE marchUu3 Total Estate Portfolios Total Estate Portfolios View Source Portfolios View Archived Portfolios Exit Program The source directory in the example above is C appraise data Click on the Portfolio type you want to archive Estate EZPrice or Basis earch Click on the Sort Method Last modified date or Portfolio name and then click on View Source Portfolios 90 im Archive Portfolios Source Directory Portfolio Types Estate Portfolios EzPrice Portfolios Basis earch Portfolios ae El Portfalia Sort Source Drive By Last Modified Date Save Portfolio Sort Archive Drive Sc C By Portfolio Name Create New Directory S t MEVAL_SERV_STSEXT2 L appraisesD TA amp PPRAISE W Save Archive Directory Archive Directory Save Partfolia Type 2000 08 24 sample 2002 02 21 TZFNFH 2002 02 21 2002 02 25 2002 03 04 2002 03 15 2002 03 22 2002 05 21 2002 05 30 2002 06 10 2002 06 10 2002 06 11 2002 06 11 2002 06 11 WHITNY
58. lio Edit View Selecked Portfolio Save Price Portfolio Portfolio lick on this button to print this portfolio Click on Price Portfolio to send for pricing When processing is done click Download Complete Next click on View Portfolio or Print Portfolio to see the following report 66 BASISSEARCH VALUATION ACCOUNT MULTIPLE D Portfolio Name BASISSEARCH SAMPLE REPORT ITEM CUSIP INAL CURRENT ADJ NO NUMBER CLOSE MEAN SHARES PAR CLOSE MEAN FACTOR 1 589331107 MERCK amp CO INC 04 10 1992 50 0000 152 3750 299 9400 25 4009 5 99388 COM 2 459200101 INTERNATIONAL BUSINESS MACHS 01 02 1985 50 0000 121 0000 200 0000 30 2500 4 0000 6 050 00 COM 3 431076102 HDME DEPOT INC 04 16 2003 100 0000 26 6500 100 0000 26 6500 1 0000 2 665 00 COM Shares Marked with an asterisk were the shares entered by the user Grand Totals 16 333 75 In the above example Merck had 50 original shares and 299 9400 current adjusted shares On April 10 1992 the close mean unadjusted price was 152 370 and the adjusted current close mean price is 25 4009 The adjustment factor is 5 9988 which reflects the splits between the original date and the current date International Business Machines has 200 current shares the adjustment factor is 4 and the original shares are 50 The unadjusted close mean price of 121 00 is for the January 2 1985 and the current adjusted close mean price is 30 25 Because the adjustmen
59. located on the upper right of the create or modify screen When you click on Issue Research you will connect to our Issue Research program automatically Because of our fees a special billing feature has been added Before you can enter any information you must first enter a six character billing reference code in the Billing Reference box This code will appear on your invoice so that you can identify the charges Issue Research 2nd Description si Exchange Security Type SiC Code fC 15T Price Date Last Price Date 0 Ticker pa CUSip lseue in Look Up Dividend Database in Look Up Split DataB ssue in Look Up Split DataBase Total Security Hits 1 50 Total Bill ou must enter a st 6 character billing reference code that will appear an your bill so you can identify the Look Up charges The Look Up billing ts done after vau click the Exit button so only one T1 reference code can be used ner Look Uo session Search Copy asin Exit Biling Reference 34 First enter your six character billing reference and then enter a description or a ticker symbol of the security you are researching Next click on Search Issue Hesearch Pop yas If our program cannot find an adequate CUSIP based on the information that you provided you will be notified that There are no records that match your search criteria Issue Research 35 If the search is successful several records that match your s
60. low the user to enter a description of the item and input the total security value and or accrual information Text entries do not multiply security value by the number of shares the value that you input will be the value reflected on the valuation report im Edit Text Security X Cusip Number Shares Par Value Valuation Date Status Item Mo 339999014 25 000 0000 Eri 10 10 2003 user Man 7 Security Type Exchange pamar Cancel Changes Text Line 2 Total Security Value 25000 00 Total Accrued value 250 00 If you do not need any accrual information and want to reflect the high low price use any of the other options 23 Price Portfolio Before you send the portfolio for pricing the status column will indicate UnPriced To send a portfolio for pricing click on the Price Portfolio button located on the lower right corner on the modify portfolio screen APPRAISE Modify an Estates portfolio SAMPLE PORTFOLIO File Switch Paste Portfolio ID Count Date Created Last Update Last User Date of Death Contact Smee PORTFO le 01723 2004 02 19 2004 9n ru 10 10 2002 Us Estate Mame Issue SAMPLE PORTEOLIO Research No cuip Shares Par 50 Add Security 001957505 0000 UnPriced 259200101 450 0000 UnPriced Insert before Ene i Print ParkFalia Selected Security 3 DIETE TEE 10 0000 UnPriced 172567101 0000 UnPriced Delete Selected 5455600201 0000 UnPriced LInPrice Portfolio Securit r
61. n allows you to maximize the window screens 12 I mport Export w APPRAISE Ver setup program Methodology Printing Import Export colors Directories Export Data Import Data FF This section allows you to interface Appraise with 706 software vendors including FPS Faster Systems and Lackner Use the drop arrow keys to scroll to the appropriate program and click in the box to select it Both the import and export boxes should refer to the accounting software of your choice If you have another proprietary system that is not included on this list you can use our Universal I mport Program to import your CUSIP numbers and shares 13 Colors m APPRAISE Ver setup program Methodology Printing Import Export Colors Directories Button Background Button Foreground eee Text Background Text Foreground Restore APPRAISE Restore Windows Default Colors Default Colors This section allows you to change the colors used in the presentation of the Appraise program You can change the form background foreground the button background foreground and the text background foreground You have a choice of 48 colors Experiment until you find the perfect combination To restore Appraise back to its original color scheme click the restore defaults button Directories During the initialization of Appraise Asp we set the directories found in this section Refer to Setting Appraise Asp Directories if you need to
62. ne of the entry under the CNT column A Reorg data screen will appear describing the entry in detail 70 REORG DATA Capital Changes Coporate Database High rear 2004 Low Year o3 Tears to Search High rr Search All Years 2004 rmi hber Aigh Year Low ear Search Range of Years Low YT 2o04 TARGET CUSIP a glis571035 TARGET TEXT 658420 ENTRY DATE L1lfer foe ATT CORPORATION UPDTEXT 604528 COMMON STOCE ECLARED ONE FOR FIVE REVERSE STOCK SPLIT NEW RATE 1 a00000 ECLARATION DATE NOVEMBER 15 2002 OLD BATE 5 000000 Ex DATE NOVEMBER 15 4002 RECORD DATE NOVEMBER 15 002 PAYABLE DATE NOVEMBER 15 002 RATE O 2000000000 EW CUSIP NUMBER 001957505 OTE THE DETERMINED EFFECTIVE DATE IS NOVEHMBER 15 002 PHYSICAL EXCHANGE OF STOCK IS REQUIRED CASH WILL BE PAID IN LIEU OF FRACTIONAL SHARES HOLDERS OF 4 OR FEWER SHARES HUST SUBMIT CERTIFICATES TO RECEIVE CASH IN LIEU REFER TO PTC FOR PROCEDITRES UPDATED NOTE In this example AT amp T declared a one for five reverse stock split on November 18 2002 Appraise provides all the pertinent information regarding dates rate and the new CUSIP number If you would like to save this information click on Print If you do not wish to save this information click on Return to List to research other capital changes When finished researching capital changes click Exit Note To print your selections you must completely exit f
63. nigh S0000 000000 Follow the onscreen instructions to select the fields to import Step 3 Select Partfalia ID field Locate and double click on the field below that contains the Portola ID that vau want to use as the name of the APPRAISE portfolio file IF the import file does not contain a Portfolio ID field pou must enter a minimum of four 4 to a maximum of forty 40 character Portfolio ID in the text bas labeled Portfolio ID below If the field containing the Portfolio ID is greater than forty 40 characters you will be asked to select the forty 30 characters you want to use as the Portfolio ID Record Field 1 26258540 26268540 26268540 26288540 242500540 25268540 Field 2 Field 3 25285540 PAULINE 25288540 PAULINE 252858540 PAULINE 25255540 PAULINE 252658540 PAULINE 25268540 PAULINE Field 4 l9a2n02z2ze62z 003 l9an0zzez u3 12802262007 MERERI pusipoNe shares Per l9a2an0zzezu uu3 l198n02ze62 003 15802262002 BEER Save Settings for this file Hent Finish Portfolio ID m 97 mi xi Step 3 Select Portfolio ID field Locate and double click an the field below that contains the Portfolio ID that you want to use as the name of the APPRAISE portfolio file IF the import file does not contain a Portfolio ID field vau must enter a minimum of four 4 to a maximum of Forty 40 character Portfolio Il E ni x than forty 40 characters vou will E Mmdibibebiblla Tou
64. nutes during a session you will be disconnected After selecting Appraise a message about missing directories is displayed click OK Select data Drive and Directory There are missing directores on your system The APPRAISE home directory is missing The APPRAISE data directory is missing The APPRAISE import directory is missing Click on the OF button below and follow the instructions For selecting the disk dive and directories This will bring you to the directory tab of the system setup As you click on the drive where your data will be stored a file access window will pop up ICA Client File Security server application iz tying to access your local client files What access should be allowed No Access Read Access Full Access Do you want to be asked again f Always ask me once per connection t Never ask me again for this application t Never ask me again for any application It is imperative to answer this question as Full Access You may also want to select Never ask me again for this application to prevent other users from selecting No or Read Access Setting Appraise Asp Directories im APPRAISE Ver setup program Methodology Printing Import Export Colors Directories APPRAISE Home Dir C APPRAISE APPRAISE Data Dir LSAPPRAISESDA TA APPRAISE Import Dir FFRAISE IMP URT Local Disk Drive List Local Disk Directory List Local Disk Drive Local Disk Drive Bemote
65. o created Estate amp Gift Tax or EZPrice and then send the portfolio for pricing Refer to the portfolio type section for usage information The Import file in the above example is a fixed length file Universal Import supports file of type dat txt prn csv etc The screens may vary depending on the type of Import File If you need assistance using this utility contact Technical Support 99 APPRAISE ASP TIPS PRINTING This printing process can be greatly improved by printing to a text file then importing the file into Microsoft Word or Wordpad 1 Select the portfolio you wish to print 2 Choose print to a text file on the print default page 3testapp Citrix ICA Client Estate Print Defaults 3 Exit Appraise Asp The next steps do not require that you to be logged on to Appraise 4 Launch Microsoft Word or Wordpad 5 Navigate to the Appraise data directory and open your portfolio with the file extension dut dod or aut alt 6 Select All Control A then Bold 7 Set font to 8 8 File gt Page setup gt margins 0 5 9 File gt Page setup gt Select Landscape 10 Save As gt Save as type Word Document 100 Importing A Portfolio Into A Spreadsheet Go to Appraise and select a portfolio to print In the Print Method box select Save the Reports to Data file then click print Estate Print Defaults Report Type lt r Frin Method QV Estate Tax Valuation a Print the Report Portfolio Valu
66. o print this portfolio The status column will indicate whether or not a portfolio has been priced A security with Data in the status column denotes successful pricing User Man in the status column indicates that the user provided pricing information manually An 0 means that the security was unable to be priced This could be caused by various factors such as mergers name changes expiration dates or invalid CUSIP numbers Please check the Appraise Capital Changes report that accompanies each valuation report that you price This report gives you a summary of corporate and municipal capital changes up to 6 months prior to the valuation date 28 APPRALSE CAPITAL CHANGES Portfolio SAMPLE A Date Prepared 02 19 2004 The following securities contained in this portfolio have additional information available Capital Changes for any security can be accessed using the Capital Changes Cusip Look Up button on the APPRALSE main menu The Corporate and Municipal Capital Changes cover the period fram 10 08 1999 to 04 08 2000 From Date 10 08 1999 Six 6 months prior to the Valuation date To Date 04 08 2000 the Valuation date Item CUSIP DESCRIPTION ENT DATE REMARKS 1 03095410 AMERITECH CORP NEW 10 18 99 COMPLETION 1 03095410 AMERITECH CORP NEW 10 11 99 COMPLETION 2 78387G10 SBC COMMUNICATIONS INC 03 30 00 EXPIRATION 2 78387G10 SBC COMMUNICATIONS INC 02 25 00 3 23915310 DAYTON HUDSON CORP 01 28 00 3 239153
67. of a CUSIP number is a check digit for the first eight characters If you choose option N Appraise will automatically input the ninth character Tip Use N to help double check the accuracy of your entries Sort Portfolios F Display the portfolio by portfolio file name or N Display the portfolio by estate name This option will determine whether your portfolio selection will be displayed by using the portfolio s file name or by using the estate name Our default setting is F Common Trust Funds A Use actual days between the price dates and the valuation dates or T Use trade days between the price dates and the valuation dates This option will allow you to select either actual or trade days weekdays when determining the number of days between the valuation date amp the pricing dates Our default setting is A Accrue Non Priced This option will allow you to print accruals for a non priced security If this option is set to N any non priced securities will not calculate accrual data Setting this option to Y will print and calculate accrual data for non priced securities Our default setting is N Adjust For Stk Splits This option will allow you to adjust the shares on an alternate portfolio for stock splits that occurred between the date of death and the alternate If this option is set to Y the alternate shares will automatically be adjusted in the occurrence of a stock split If set to N Appraise WILL NOT adju
68. ompare the differences between the actual security value and the reported security value ESTATE TAX SECURITIES VALUATION Name of Estate IRS MODE DATE OF DEATH Tuesday December 31 2002 EM CUSIP NO SHARES DESCRIPTION PRICE HIGH ASK LOW BID MEAN CRUED PAR VALUE DATE PRICE PRICE PRICE DIV INT DIV INT 1 001957505 500 AT amp T CORP 12 31 26 7000 26 0300 26 36500 13 182 50 13 180 00 COM DIV 0 1875 EX 12 27 2002 REC 12 31 2002 PAY 02 03 2003 90 00 TOTAL OF SECURITIES VALUED 13 182 50 13 180 00 93 75 TOTAL OF DIVIDEND INTEREST 90 00 TOTAL PORTFOLIO VALUE 13 276 25 13 270 00 5 E Price If you re interested in single security pricing and portfolio reporting use EZPrice EZPrice has historical pricing for more than 3 million global securities When you price securities using EZPrice you will create a report that will supply the high ask low bid close mean security value estimated annual income and yield percentage EZPrice is also used to price foreign securities From the Main Menu of Appraise click on EZPrice Next click on Create a new EZPrice portfolio Create a new EZPrice portfolio You will be prompted to enter the portfolio s ID The Portfolio ID can be a minimum of 4 and a maximum of 40 alphanumeric characters and may include spaces and hyphens APPRAISE Create an EZPrice portfolio SAMPLE EZPRICE 7 File Switch Paste Portfolio ID Count Date Created Last Update Last User Valuation Date TESI
69. original state Edit Selected Security Use this feature to manually price items such as CDs money markets and sparsely traded stock by inputting a dummy user CUSIP number You may want to edit a priced security for various reasons such as inputting a name or price for a security that is either not in our service or unable to be priced Warning Once you change the pricing information for a priced security and Save the changes it will override all pricing information received through our pricing service and cannot be reversed To use this feature click on the security you want to edit and then click on Edit Selected Security 20 w Edit Security E4 001957505 rry 450 00 feri f10710 2003 funPricea I 1 M M Finished Price Manually The first screen will display the ticker symbol CUSIP shares valuation date the status and item number All of these items are grayed out and cannot be modified from this screen If you need to change any of these items do so from the modify an estate portfolio screen If these items are correct click on price manually 21 m Edit Security E x Cusip Number Shares Par value Valuation Date Status Item Mao 339999014 25 000 0000 Eri 10 10 2003 user Security Mame Security Description ae rer Security Type Exchange Common Stock user Cancel Changes Past Date High Price 1 Low Price 1 Mean Price 1 Days Past ra 10 10 2003 o ooooo f Future Date High Pri
70. ormation to techsupport appraisen net so we can load the driver on our server Appraise Asp Now that you have initialized Appraise Asp successfully you are ready to use the program im MAIN MENU APPRAISE Ver OR x Client Number hrooa Session ID ho s Client Mame Estate amp Gift Tax Capital Changes Issue Research Exit APPRAISE Estate amp Gift Tax is used for IRS Form 706 reports EZPrice is used for historical security pricing If you need cost basis accounting information or multiple date pricing use Basis earch Click on Capital Changes lssue Research for reorganization information stock dividends issue research and stock split history System Setup is used to customize your program settings methodology to interface with accounting software import export to set print options printing to set data directories and to change the background and font colors colors SYSTEM SETUP The system setup section of the Appraise program allows you to customize the program The Appraise setup program consists of five sections methodology printing import export colors and directories w APPRAISE Ver setup program Methodology Printing Import Expart Colors Directories w004 Adjust Far Stk Splits Run IRS APPRAISE Accrue up to and including the date of death Enter the FaceJpar value For a mortgage backed security Enter cusip numbers without check digits 8 chars Display Ehe p
71. ort Appraise Asp Enhancements Welcome to APPRAI SE Asp This WebTop version of Appraise allows you full access to our complete software package with one simple click of a button Appraise Asp offers 128 bit encryption allows long filenames and accepts both Ticker Symbols and CUSIP numbers Appraise Asp Application Service Provider means the application is running on the host computer The data is stored on your computer When you logon with your username and password the appraise directory on your computer is uploaded to our secure host computer When the user is finished the data is moved back to the local computer and is deleted from the host computer Pre I nstallation Requirements Internet connection faster than 100kb DSL Cable ISDN T1 Firewall Port 1494 open for inbound outbound traffic Creation of folder s Appraise Appraise Data Appraise l mport Full access to the appraise folder Microsoft Internet Explorer 5 or greater Ability to access www appraisenj com Creating Appraise Asp Directory Structure Create the Appraise directories by clicking on the My Computer icon on your desktop Select the drive you want to store your data Go to file select New then Folder Name this folder Appraise Double click on the Appraise folder go to file and select New then Folder Name this folder Data Do this once more and name the folder Import Inixi File Edit View Favorites Tools Help Back mp
72. ortfolios by portfolio File name Use actual days between the price dates and the valuation date Print div int accruals on zero priced securities if available Adjust alternate portfolio shares For stack splits Do nat run APPRAISE in the IRS made with reported values A F N 3 in v g I Local Data Directory LS FFRAISESDATA Methodology Client Number This number is assigned to you by Evaluation Services for the use of this software and cannot be changed Client Name By entering your firm s name here the company name will appear on all of your reports If you do not wish to have your company s name appear on the reports leave this section blank 10 The following tabs allow you to toggle between two options Accrual Method 1 Accrue up to and not including the date of death or 2 Accrue up to and including the date of death Please check the current IRS regulations for the correct setting CMO GNMA Factor F Enter the face par value for mortgage backed securities or P Enter the paydown amount for mortgage backed securities TI P Use F if you are entering whole numbers for bonds GNMA s such as 10 000 Use P if you are entering partial numbers such as 9000 56 A partial number usually indicates that the paydown factor has already been applied Enter Check Digit N All CUSIP numbers will be entered with 8 characters or Y All CUSIP numbers will be entered with 9 characters The ninth character
73. prior to sending by clicking on the magnifying glass icon on the toolbar When all information is correct click on the Telephone Icon on the top toolbar to send your portfolio for pricing 80 When the portfolio has finished processing you will be returned to the view portfolio window You will see each dividend reinvested transaction date and the share price The program will automatically calculate the share amount of the reinvested dividend Dividend Reinvestor CLIENT ID W004 Yiew Portfolio SAMPLE Estate of SAMPLE DRIF PORTFOLIO lw LEE Y ou can nat edit item number 6 because itis the Last item Issue INTERNATIONAL BUSINESS MACHS Issue Descr CoM Cusip No I You can change the significance Dividend Rule Ex Dividend Date value andy ar the price rule Significance Price Bule Use closing price Start Date 04 15 2003 End Day 04 15 2004 Portfolio Name SAMPLE DRIP PORTFOLIO feasasfeoca mm pars Si 39 5 4 81 Manual I nputs You can manually input reinvested dividends corporate actions sales or additional purchases by clicking on the Notebook icon This will bring up a new window to enter the new information Be sure to have the appropriated information available before selecting manual inputs Manual transaction date must be between 01 02 1795 and 05715 2003 Transaction Date Er ae H Transaction Descnption TEENEST DWIDEND F Dividend Hate Dividend Pric
74. r the new company and the shares now owned of the new company The CUSIP and shares will be automatically added to the alternate portfolio Name Change A company may undergo a name change This transaction feature will indicate this action You will be prompted to give the date of the name change along with the CUSIP number Appraise will add the new CUSIP number to the portfolio The new CUSIP will have the same number of shares as the original because the company simply changed their name Please do not confuse this transaction with a merger Note If you need to post multiple transactions to a security that has had a name change you must post the name change last Once you post a name change transaction to a security you will not be able to post edit or delete any transactions for the security until you first delete the CUSIP that was added as a result of the name change Iransaction Postings Sold 100 0000 shares on ll 0l z z z ac 60 00000 per share Tot Val 6 000 00 Sold 250 0000 shares on ll lb z z at 50 00000 per share Tot Val 12 500 00 Name Chg from security 4559200101 to security 459200200 on 12 01 2002 1O0 0000 To delete or edit the name change transaction you must first delete the new CUSIP from the portfolio 52 Merger Many companies venture into acquisitions and or merge to form new companies If a company is acquired it ceases to exist under its old entity Often a company may be acqu
75. rd Step 2 of 3 This screen lets you set the delimiters your data contains You can see how your text is affected in the preview below elimiters l Treat consecutive delimiters as one M Tab Semicolon Space Other Text Qualifier 5 Text Import Wizard Step 3 of 3 This screen lets you select each column and set alumn data Format the Data Format O Garsel General converts numeric values to numbers date Text values to dates and all remaining values to text T2FHFH ARAE SAER B3755HJUS l Cancel z Back Next gt Einish Select the fields and data format type Click Finish Arrange Cell as needed 104 If you have any questions or concerns still remaining after reviewing this manual please contact Technical Support to set up a training session customized to meet your needs Technical Support 201 784 8500 x 107 techsupport appraisenj net 105
76. report click on Print then Exit You must exit the program completely to print the report See Printing in Capital Changes lssue Research 72 This feature is used to research CUSIP numbers Appraise will provide an 8 character CUSIP number the ninth character which is the check digit Is not provided To start click on the Issue Research button Enter either a ticker symbol or a description of the security Next click Search Issue Research 2nd line lssue Type E Exchange E SiC Code First Price Date Last Frice Date lssue in Look Up Dividend Database lssue in Look Up Split DataBase pe an a line of data in this bos to display the detailed information for the secrity UE HTC New Search Print There are 250 securities that match your request AT amp T CORP AT amp T CORP TIMOTHY PLAN THERMAL ABALATION TECH CP TRANSALTA CORP HANCOCK JOHN CA TAXFREE INC FD TAC INC THC AGRKOWIRLD CORP At the bottom of the screen is a listing of all securities that match your search criteria Click on and highlight the security to display the detailed information 73 All the information related to that security would be displayed such as the issue type exchange first last pricing dates SIC code ticker symbol and CUSIP Issue Research 2nd line cor NEw lssue Type Common Stock Exchange New York Stock Exchange SiC Code 4213 Communications First Price Date 0
77. ribution Report This report type displays the same information as the estate valuation but has a header of Distribution Valuation The client name is listed under the heading Portfolio Name and classifies the date as Distribution Date Portfolio Valuation Asset Percentage Report This report type displays the same information as the two above reports but has a header of Portfolio Valuation lists the client name under the heading Portfolio Name and classifies the date as the Valuation Date This report also prints out a separate page that shows the allocation of the securities For Example Security Type Percentage Security Type Percentage Val ue of Value In v Int of Div Int Total Grand Total Total Grand Total Common Stockis 174 410 39 71 269 611 73 67 149 Mutual Fwund z 25 153 20 14 109 63 70 6 ti Text 25 000 00 14 3271 250 00 26 180 GRAND TOTALS 174 564 08 100 000 354 93 100 000 Gift Tax Valuation This report type displays all the information as an Estate Valuation but has a header of Gift Tax Valuation and lists the client name as Portfolio Name and the date is classified as Gift Date Valuation Report This report type displays all the information of an Estate Valuation except the security value and has a heading of Estate Report Without Security Value The client name is under the heading Name of Estate Accrual Report This report type displays only the accrual dividend information the prices and the
78. rom Capital Changes Issue Research See Printing in Capital Changes lssue Research 71 If you would like dividend information on a stock click on Dividend Data Enter the CUSIP number to search for dividend data The data includes the security name and description total number of dividends listed the dividend rate and the dividends ex record and pay date FYI A security s price drops on the ex date Dividend Review Cusip Number las920010 Security Name INTERNATIONAL BUSINE Security Description icon Cnt uice 2 m lcm iP E ei jek pak M fe me 4 payment payment payment payment payment payment payment payment payment payment payment payment Dividend Type Search results 39 Div Eate 25000 25000 29000 295000 25000 25000 25000 295000 35000 35000 35000 35000 Ex Date 05 05 1954 05 04 1994 11 04 1554 02 06 1955 05 04 1995 OF OF 19595 11 08 1995 02 07 19556 05 08 1956 08 07 1996 11 06 1556 02 06 1257 Rec Date 05 11 1954 08 10 1954 11 10 1954 02 10 1955 05 10 1995 08 10 1955 11 10 1995 02 09 1956 05 10 1956 08 09 1956 11 03 1956 02 10 1957 Pay Date a 06 10 1554 09 10 1954 17 10 1554 03 10 1535 06 10 1995 02 09 1395 12 09 1995 03 02 1256 06 10 1556 09 10 1556 12 10 1556 03 10 1557 d Please enter an eight 8 character cusip number This program will only search for a full cusip number If you would like to save the
79. s appropriate User name wa O04 Password m Cancel Help Sub D This will bring you to a screen asking you to select a product r 34 4 13 So ij IBINLILL EE p PE orm mi ETE Y H TE 4 WE n TF F T Tim valuation Services Inc n E a r elect a product The Appraise Program is used for Estate amp Gift Tax as well as Historical Pricing Cost Basis Capital Changes and Issue Research The Dividend Reinvestor Program is used for calculation of dividends that were reinvested Reorg From To collects all Reorganization data within a specified date range 1040 1041 Income Calculator provides the necessary information to assign dividends to a decedent s final income tax return and to the estate or trust return including capital changes Florida I ntangible Tax provides closing prices on equities and bid pricing on bonds UniTrust provides mean pricing for UniTrust valuations lf this is your first time using our service select Appraise NEWS NEWS NEWS PLEASE READ minutes to respond or you will be disconnected IF disconnected all unsaved work will be last IF vau are disconnected from amp PPRAISE ASP ar esit incorrectly vou can now reenter APPRAISE ASP if pau reconnect using the same workstation d An IDLE TIMER has been implemented After fifteen 15 minutes a warning will be issued You will have two 2 This message informs you that if you are Idle for 15 mi
80. s located at the top of the screen that provide several functions View each page by clicking on Next Page or Previous Page Increase or decrease the viewing screen by clicking on the Size or buttons The view screen allows for single page printing by clicking Print this Page or Print All Pages to print the entire portfolio To exit out of the view screen click on Finished 32 Add Memo File Appraise allows you to attach a memo to your portfolio You may find this feature useful if there is important information associated with this portfolio and would like to share with the recipient of the portfolio This feature can also be used to explain manual entries and unpriced securities To use this feature click on Add Memo File im Portfolio Memo File Type in your information here and then click Update Memo File Delete Memo File Update Memo File To save the memo click on Update Memo File If you have a memo already associated with the portfolio you can edit or delete it by clicking on the Edit Memo File button located on the modify screen All Memo files are listed on a separate page 33 Issue Research The Issue Research program contains common stocks mutual funds and some corporate bonds from the NYSE AMEX amp NASDAQ exchanges This feature gives you access to CUSIP numbers with the click of a button and will allow you to cut and paste the CUSIP number into the portfolio The Issue Research button is
81. select the IF your import file has a heading use the list bos to select the row af data immediately after the heading Import File Data es26e540 25268540 es28e540 es2683540 25205540 25268540 252895540 252608540 25288540 252895540 e5288554U0 25268540 PAULINE PAULINE PAULINE PAULINE PAULINE PAULINE GRAHAM GRAHAM GRAHAM GRAHAM TRAHAN GRAHAM l9a 02zzezu us3 L9602262003 l9a 022zez2 0u03 l9a 022zez u3 l9as 022ze62 uu03 l98 02zez u3 Back Mengt immediately after the heading then click Next 001957105 002094106 008457100 ns4s5vzu3 l5l3lc0cHl 053459105 row of data 95 i Accept Import File Fields for c APPRAISEUTITASSPORTSsei DAT The Import File is a fied length File with NO delimiters and NO predefined Fields Click the Next button IF the format selected ix nat corect you can return to select another format using the Back key au have selected field 1 s start position Click on the start of field number 2 Click on the lt Next gt button if all of the fields have been selected Click an the BACK button to redefine Field 1 IF field number 2 is the SHARES PARVALLIE field use the end of field number 1 as the start position For Field number 2 25258540 25285540 PAULINE W CRAHAM 13802462003 001957109 B00 000000 Follow the onscreen instructions for selecting fields w Accept Import File Fields for cz APPRAISE SUI STASSPORTSsei DAT T he Import File is
82. st alternate portfolio shares for stock splits We highly recommend that this option be set to Y Run IRS Appraise N Do not run Appraise in the IRS mode with reported values or Y run Appraise in the IRS mode with reported values Use this mode for value comparison 11 Printing w APPRAISE Ver setup program Methodology Printing Import Export Colors Directories Print ESI s name of the bottom of all reports Do not print an estimated bill after each report g J IN Do not print each portfolio immediately after it is received v g Print the report processing date in the report headings Print Processing Date Do not maximize Ehe window screens This option will allow you to print each partfalia immediately after itis recereed Click on the Print After Receive button ta change this option Print ESI This option allows you to select whether or not the name Evaluation Services Inc will be printed on the bottom of all the Appraise reports Print Estimated Bill This gives you the option to print an estimated bill of the charges for each evaluated portfolio The estimated bill is located at the end of the portfolio The actual bill is mailed at the end of each month Print After Receive This gives you the option to print each portfolio immediately after it is received from pricing Print Processing Date This option allows you to print the processing date in the report headings Maximize Screens This optio
83. t Stock dividend in stock of another issue or company spin off Splt Rate Ex Jate Eec Date Pay Date 1 32408 10 01 1596 09 11 1556 09 30 1996 1 50000 04 16 1999 03 31 1995 04 15 1995 1 32180 01 05 2001 06 22 2001 07 05 2001 1 20000 1 32350 11 15 2002 11 18 2002 Please enter an eight 8 character cusip number This program will only search for a full cusip number pontem To save the Stock Split report click on Print and then Exit See Printing in Capital Changes lssue Research 75 Printing Capital Changes Issue Research To print any information from Capital Changes lssue Research click on the Print button This function will place items in a clipboard fashion to file called printlu txt located in the Appraise directory After you exit the Capital Changes Issue Research you will be prompted to indicate whether you want to print the information x w Look Up Data Print Data Page Net Page Default Printer Hp_LASERS Pages ji Change Printer Print LOOK UP data a xX 2 While vou were in LOOK UP vau selected items to print These item are displayed on this screen now Click on the Print Data button bo print them to your default printer Security Name WEBB INTERACTIVE amp 8YCS INC Description COM Security Type Common Stock Exchange NASDAQ Industrial If you would like to print your research click the OK button and then click Print Data You can change the default printer by clicking Change Prin
84. t factor of 1 for Home Depot represents no splits between the original date and the current date the pricing is the same 67 Capital Cha nges Issue Research When accurate portfolio pricing depends on access to current reorganization data the first place to look is Appraise Capital Changes lssue Research This feature includes Capital Changes mergers acquisitions tenders etc Stock dividend and UIT principal payout history since 1992 Stock split history since 1968 Recent reorganization data up to three months prior for any issue in your report Reorganization data between Date of Death and Alternate Date Issue Research CUSIP Lookup To begin go to the Appraise Main Menu and click on Capital Changes lssue Research You will immediately connect to our access server Appraise LookUp Action Welcome Connection Status Time Logged Off 0 Time Logged On 10 51 43 AM Total Dividend Hits 1 50 Total Stock Split Hits 1 50 Total Capital Changes Hits 0 75 Total Cusip Lookup Hits 1 50 Biling Reference Total Charges ou must enter a i b character billing reference code that will appear on your bill so you can identify the Look Up charges The Look Up billing is done after vau click the E sit button so only one 1 reference code can be used per Look Up session All items are grayed out except for the Exit button Because of our fees a special billing feature has been added Before you can access Capit
85. te o2 15 2004 MI zy BY Cancel Enter the Price per share on the start date if known then enter Enter the number of shares owned on the starting date The dollar amount will be calculated If you do not know the price per share on the start date or the dollar amount enter the share amount then click on the calculate value button located to the right of the share amount field Or if you do not know the Share amount but do know the total dollar amount enter the dollar amount and then click on the calculate value button located to the right of the dollar amount field Click on the Safe Icon to save the portfolio You are now at the view modify screen The start date is represented as Buy and the end date as End Date in the Transaction Description field You will also see the dollar amount share price and share amount You can change the significance value and or the price rule by clicking on the appropriate drop down box 79 Dividend Remyvestor CLIENT ID W004 Issue Issue Descr Tou can change the significance Cusip No 453270010 Dividend Rule Ex Dividend Date value and or the price rule Significance 2 Price Bule Use closing price Start Date 04 15 2003 End Day 04 15 2004 Portfolio Name SAMPLE DRIP PORTFOLIO 04 15 2003 raa y oe roms sore rne fen t SS 04 15 2004 END DATE ay 53 90 You can edit portfolio information such as share price share amount and dollar amount
86. ter and then selecting a printer from the drop down menu by highlighting the new printer Next click Print Data All researched items will print at this time 76 Dividend Reinvestor calculates the cost basis and capital gains for dividend reinvestment plans Before using Dividend Reinvestor you must setup the directories where you will store the data Go to File and then select Settings Settings Settings contain options for selecting directories changing company name and email First click on the drive letter then select the appraise home directory then the data directory located to the left This directory will be used to store working files temporary files and other data You will need full access rights to this directory Please select destination where your files will be stored aS Manual Input Local Disk Drive A qv Select location where you store Local Disk Drive J APPRAISE our data files Data directory Bemote Disk Drive must not be mare then Remote Disk Drive B eight characters lang Bemote Disk Drive Bemote Disk Drive Settings 1 Exit Change Company Hame Print Company Mame in the Report Change Company Name You can change the firm name by clicking in the Change Company Name field and typing in the new name Print Company Name in the Report If you check this box your Company Name will appear on the printed Dividend Reinvestor report 71 Email You can send us an email w
87. tfolia s gt Exit Progra Lreate New Directory EP MMEVAL_SERY_STSEXT2 S PPRAISE SDT e n3f 09 04 454545 D eg aaf 0l1 l16 o29600_ D og View Archived Portfolios To archive files click on each of the portfolio you wish to archive then click on Archive the selected Portfolios All of the selected portfolios will be removed from appraise data to the new archive folder 92 iBl x ig Archive Portfolios Source Directory Archive Directory Portfolio Types Save Archive Directory Estate Portfolios Cur EzPrice Portfolios CX APPRAISE C Basistearch Portfolios ee marchiz qc CX APPRAISE Save Portfolio Type Partfalia Sort By Last Modified Date By Portfolio Name CWAPPRAISESDAT 4 Save Portfolio Sort Archive Drive Create Mew Directory Et MEVAL SERV 51 EXT2 4 PFRAISE marchll3 2001 07 26 Deant D F002 de HALPER DLD HALSEY D TRIER SR RE MARCH 4 z 03 D MARCH 5 Foo3_D MUT O OS D SAV aTe e ES C OOP LCP SRE Source Drive 2o03 05 05 2003 09 05 2003 05 08 2003 09 08 2o03 05 08 2003 09 08 eo03 09 09 2O03 09 11 2003 09 11 693875 EELLY B5ylavas DUPLIC TEMAMA YYYSET L NGFI 116956 W23601 Io ot op Cd DI DJ UJ E r C3 2002 03 03 2003 0916 2003 09 16 e n3fu9s 15 2003 09 23 2O03 05 235 MCWILLIAMS DB T7ABAB D BVSZBS D JEREYO D MIFE44_0 ZOOS 03 03 2003 08 29 4003 09 02 2003 03 03 FOOs 09 03 we
88. tfolio click yes 84 The Appraise 1040 1041 Income Calculator is a great time saving program t s for trust tax professionals who are responsible for preparation of the deceased s personal income tax and estate or trust fiduciary income tax returns Appraise 1040 1041 Income Calculator provides the information that s necessary to assign dividends to a decedent s final income tax return and to the estate or trust return including capital changes Click on 1040 1041 Income calculator to begin 1040 1041 Income Report Valuation Date Lf f Calendar Year Report Beginning Date Pu C Fiscal Year Report E state Mame f Ticker Shares Open 1 Import cave ret Report Clear To create new portfolios enter a valuation date estate name CUSIP Tickers and shares Next click on Get Report To Import an existing Appraise portfolio click on Import If you need to modify a portfolio click Open To add or delete use the insert and delete buttons of your keyboard F To create a portfolio enter a valuation date Estate name CUSIP Ticker and shares Click on Save This will save a listing of the securities not the detailed report To open this portfolio click on Open then double click on the portfolio to select it Next click on Get Report 85 Import an Existing Portfolio 1040 1041 Income Report ES Valuation Date i Calendar Year Report Beginning Date Pe C Fiscal Year Report Estate Name Canc
89. ty Insert before the Selected Security Delete Selected Security Edit Selected Security Save Portfolio Counk Date Created Smee PORTFO 13 Jois30 2004 01723072004 Ina Estate Mame No Cusip W Shareo Par 50 0000 UnPriced 450 10 0000 UnPriced 0000 UnPriced 0000 User 0000 UnPriced 0000 UnPriced 0000 UnPriced 0000 UnPriced 0000 UnPriced 0000 UnPriced 0000 UnPriced 1 001957505 459200101 ne 172967101 5077853105 6 999999014 7 002824100 s o24071201 9057224107 10101121101 11075860102 12205227102 13 294 741103 lick on this button Eo print this portfolio Last Update Last User Date of Death Contact ru 10 10 2002 Ls Switch Ea Alternate Date Dod Issue PortFolia sire PORTFOLIO rna 04 10 2003 Research 0000 UnPriced 0000 UnPriced Sales Mergers Etc Frink Portfolio UnFrice Portfolio View Portfolio Price Portfolio Edit Memo File Remember the date of death portfolio and the alternate portfolios are two separate reports They do however have the same file name distinguished by the file extension The date of death has a file extension of D while the alternate has an A Any additions to the portfolio should be entered in the date of death portfolio The Appraise program will then automatically include the CUSIP and shares to the alternate portfolio 50 Alternate I nventory Transactions Activity Between Date of
90. y character until the portfolio name appears in the portfolio list box Once the portfolio name appears in the portfolio list box click on the portfolio name and then click Ehe Ok button IF vou do not know Ehe portfolio name of the portfolio thak you want to SEND use the up and down arrows or the thumb until the portfolio name you want to SEND appears in the portfolio list box click an Ehe portfolio name then click on Ehe OK button lad The portfolios file name will appear in the Portfolios to be Priced box The Portfolio Count box indicates the number of portfolios to be sent When all the information is correct click on OK 43 w Sending Estates portfoliofs for pricing SAMPLE ILS Le uc mr SAMPLE PORTFOLIO gt gt Click on Send for I mmediate Pricing While sending for immediate pricing you will see blue boxes at the bottom of the screen along with messages summarizing the progress of your pricing When pricing is complete the progress bar will reach 100 The next screen will indicate which portfolios were loaded priced successfully along with any CUSI PS that were unsuccessfully priced Click on Download Complete located at the bottom of the screen You will be returned to the Estate amp Gift Tax main menu You can now view print or modify your portfolio s 44 Print Estates portfolio s This section allows you to print one or more portfolios at a time Click Print Estate portfolio s w
91. zttb B5BVlIS8MSZ 3550711 D Lz0 6s7 D lz2 0565M D 1s Total Portfolio s Selected a Total Estate Portfolios Total Estate Portfolios Unarchive the selected portfolios Exit Program To restore archived files select the portfolio by clicking and highlighting the portfolios then click Unarchive the selected Portfolio When finished click on Exit Program View Archived Portfolios View Source Portfolios 93 Universal I mport Appraise Asp clients will have to download and install this free utility from our web site Save time entering data with Appraise Universal Import utility Universal Import allows you to import CUSIPS and shares from another file into an Appraise portfolio Start Universal Import by double clicking the UI icon located on your eg Universal eppart m Import File Selection al x 1 Select the letter of the disk drive that contains the File you want to import inta an APPRAISE portfolio desktop Disk Drive Letter E e Disk Drive Folders p PEE JAPPRAISE Save Selected drive and folder as default Disk Drive Files CUSIP prn CUSIP xls DAYVIDW THT Ekzubal cdat tassport dat tazssport new TASSP URTZsei DAT Files of Type Save Selected file type as default Partfalia Type Estate Portfolios E EzPrce Portfolios Check this box ta make the selected Disk Drive and Folder the default SUF the file You want to import inta an

User`s Manual - Appraise Utilities

Contents

Download Pdf Manuals

Related Search

Related Contents