Projected Remainder Amounts

$image\seealso.gif$

Projected Remainder Amounts lets you estimate how much a gift or group of gifts may be expected to distribute to charity and when.

Three different reports are available:

Projected Remainder Amounts by Year
This report displays how much each gift will distribute to your charity and when. Information is grouped first by year of distribution, then optionally by designated purpose within each year, then by gift type within each designated purpose. The values for each year, and optionally each designation within it, are subtotaled. This organization provides a powerful tool for analyzing how much income from planned gifts will be distributed throughout your organization and when.
Projected Remainder Amounts by Gift
This report also displays how much each gift will distribute to your charity and when. Unlike the Projected Remainder Amounts by Year report, however, this report includes full detail on each gift, but does not group or subtotal by projected year of distribution. The additional detail at the gift level makes it easy for reviewers to associate each specific projected benefit with a specific gift.
Life Expectancies/Term End
This report estimates the number of years each gift will last beyond a specified date. It is useful for making an educated prediction of when each gift will terminate and distribute its proceeds. Unlike the other variations, projected distribution amounts are not included.

To produce any of these reports, follow the steps below.

1. Open the Review/Analysis menu in the Menu bar.

2. Click Projected Remainder Amounts.

3. Enter the report format, calculation, and selection information required to produce the report you desire. Enter a custom filter to select a more specific group of gifts. There is help available on each field.

Note that only bequests with a status of Current and a living donor can be included in the report.

4. Click the OK button to view the report. If you see an error log, see Notes below.

5. To print the report: $image\print.gif$ Click the Print button in the Toolbar of the report view screen. In the Print Setup window, choose the printer, paper, and orientation options you prefer, then click OK. In the Print window, choose the report pages and number of copies you wish to print, then click the OK button to print the report.

To save the report to a file: $image\export.gif$ Click the Export button in the Toolbar of the report view screen to open the Export window. Choose the Format and Destination of the file, then click OK. Choose the pages you wish to save, then click OK. If you choose Disk File as the Destination, a standard Windows Save dialog box will open in which you can choose the drive, folder, and file name in which to save the file. When done, click Save.

To export the report to Microsoft Word: $image\export.gif$ Click the Export button in the Toolbar of the report view screen to open the Export window. Choose Word for Windows Document as the Format and Application as the Destination, then click OK. Your report will open as a document in Word.

6. $image\closebox.gif$ Click the close box when done viewing the report to return to the Projected Remainder Amounts screen.

7. Click the Close button.

Notes:

· For a gift to be included in the calculations, the following must be true in addition to any selection criteria entered in the function window:

Gift Date is less than or equal to Valuation Date
Gift Status is Currrent or Gift Status is Finished/Severed and Account Closed Date is greater than or equal to Valuation Date
Person Status of at least one associated person is Current/Missing or Person Status of at least one associated person is Deceased and Date of Death is greater than Valuation Date

· For gifts that will last for the remaining lifetime of one or more beneficiaries, the year they will distribute their proceeds to your charity equals their joint life expectancy. The joint life expectancy is based on the ages of the living beneficiaries on the Valuation Date for the report and the mortality table selected.

· If you see an error log, fix the errors it identifies, then run Projected Remainder Amounts again.

To print the error log, click the Print button, then click the OK button in the standard Windows Print dialog box. Alternatively, you may save the log in a file that you can print or review later. When done, click the Cancel button.