Stewardship Reports

1. Group Guide Stewardship Reports

2. Deliverables • Client Report • Title Page • Summary of Assets • Transactions Record • Income Statement • Management Report • Management Report Summary • Brokerage Statement

3. Group Guide

4. Group Dynamics • UISES guy downloads the statement, prepares the balance. • Excel guy sets up the client report. • Audit guy audits the statement for completeness and balance. • Proofreader guy proofreads the paper copy and prints the final copy for submission.

5. #1:UISES Guy • Download the Stewardship report template. • Download the UISES statement, formats it, and incorporates it into the Stew • Enters the balance totals into the Management Report sheet. • Sends the stew to Excel Guy

6. Notes for UISES guy • Make sure you download the UISES statement for the correct date • The UISES Statement is a source document. Make sure you sort and calculate subtotals (formatting) but do not adjust or alter the data in any way.

7. Notes for UISES guy • Sort positions • Alpha order by description • Sort transactions • Alpha order by description • Date order within each issue

8. #2: Excel Guy • Enters the information into the client report • Title page (do this first) • Data sheet (do this second) • Income Statement • Transaction • Stewardship • Make sure the report balances • Sends the stew to Audit guy

9. Notes for Excel Guy • Before you enter anything in a cell, make sure you are not overwriting a formula. • Financial Spreadsheets are color coded • Blue = input • Black = calculation • Use Copy, PasteValues from theStewardship Ribbon so that youdon't overwrite formats

10. Notes for Excel Guy • If you need to enter rows make sure you copy the formulae properly. • In the Transactions tab the position, book value, and BVS columns have formulae that look at the previous row and the following row. Make sure you don't introduce unintended gaps. • Formulae will only work if indate order within issues

11. Book Value Out of Balance Out of Balance • The Stewardship Report template contains balance points that raise a red flag if the balance condition is not met. Book Value Out of balance

12. OUT OF BALANCE • An out of balance flag is a symptom of a problem – so dig out the cause of the problem, don’t just paper over the symptom

13. Audit guy • Verifies • Title Page: • Company Name & correct date • UISES: • Subtotals have been correctly calculated from the right data • Management Report: • Balances

14. Audit guy • Verifies: • Income Statement • Dividend data with dividend.com • Interest on cash • Transactions Statement • Properly reflected and calculated • Cash properly calculated and balanced • Stewardship Report • Properly reflected and calculated • Rate of return for each month is correctlycalculated

15. Notes for Audit guy • Remember that the template is a tool designed to assist you, it is not a plug-and-play guarantee. It is your responsibility to ensure that your stewardship report is clean and accurate.

16. Proofreader guy • Prepares the file to print properly • Prints the report • Makes sure the report is clean and professional.

17. Notes for Proofreader guy • Stewardship Report Ribbon to manage • Consistent font and font size, • Footers, • Page layout.

18. Font Size • Use a font of no less than 8 pts. PRINT AT 100% ON ALL PAGES If you print fit-to-page the font becomes microscopic and neither you, I, nor the client, can read it without using a magnifying glass. If in any doubt whatsoever stick with the Arial Narrow 10 in the template. Anything smaller will not be accepted. Print size is controlled in the [File][Page Setup] applet. • Use a font of no less than 8 pts. PRINT AT 100% ON ALL PAGES If you print fit-to-page the font becomes microscopic and neither you, I, nor the client, can read it without using a magnifying glass. If in any doubt whatsoever stick with the Arial Narrow 10 in the template. Anything smaller will not be accepted. Print size is controlled in the [File][Page Setup] applet.

19. Do not use fit-to-page Font Size It's never a good idea to insult the intelligence of your client by giving him tiny print inside a huge white space

20. Notes for Proofreader guy • Use [Page Setup] [Page] to set Landscape Set to 100%

21. Notes for Proofreader guy • Use [Page Setup] [Header/Footer] to set Custom Footer Contact Information Client

22. Notes for Proofreader guy • Use [Page Setup] [Sheet] to set Print area Repeat Headers for when you go to multiple pages

23. Notes for Proofreader guy • Use [Hide Rows] to hide empty rows from print • Use [Unhide Rows] to open them up again • Use [Breaks] to force Excel to break pages in a logical place

24. Notes for Proofreader guy • ALWAYS proofread the printed copy • Adjust column width to fit • NEVER break a page horizontally These book values go with what assets?????

25. Notes for Proofreader guy • If it's not good enough to show a recruiter as an example of your work then it's not good enough.

26. Signatures Signatures

27. Management Report • Signatures, • not printed names, • not typewritten • All of you

28. Signatures • If the same person prepares, audits, and proofreads you won't catch the errors and omissions.

29. Professionalism • Having one person prepare, audit, and proof and then having different people sign as preparer, auditor, and proofreader constitutes fraud. • If we don't get you, Sarbanes Oxley will.

30. Group Contract

31. The End Stewardship Reports