Sample Reports Grace

|
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
 6 views
of 59

Please download to get full document.

View again

Description
1. Sample Reporting Catalog 2. Copyright Notice The software described in this document is furnished under a license agreement or non-disclosure statement. The software…
Share
Transcript
  • 1. Sample Reporting Catalog
  • 2. Copyright Notice The software described in this document is furnished under a license agreement or non-disclosure statement. The software may be used or copied only in accordance with the terms of the agreement. It is against the law to copy the software on any medium except as specifically allowed in the license or non-disclosure agreement. No part of this manual may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording, for any purpose without the expressed written permission from PortfolioShop Inc. Copyright © 2010 by PortfolioShop Inc. All Rights Reserved Disclaimer The information displayed in the sample reports contained herein is not indicative of any actual firm’s management. The data created was for sample use only.
  • 3. Table of Contents About FixQ Reporting 3 Automated Packaging & Distribution 4 Widget Gateway 5 Appraisal Portfolio Appraisal 7 Tax Lot Portfolio Appraisal 8 Portfolio Appraisal (Multicurrency) 9 Appraisal by Asset Class 10 Appraisal by Security Type Summary 11 Liquidity Analysis 12 Appraisal with CUSIP 13 Maturity Alerts 14 Appraisal by Sector and Industry 15 Appraisal by Sector and Industry Summary 17 Appraisal Ranked by Market Value 18 Appraisal Ranked by Market with Percent Gain/Loss 19 Appraisal Ranked by Percent Gain/Loss 20 Appraisal by Underlying Security 21 Fixed Income Segment Appraisal 22 Transaction Transaction Summary 23 Commission Transaction Summary 24 Commission Transaction Detail 25 Income and Expenses 26 Purchases and Sales Recap 27 Contributions and Withdrawals 28 Dividend Accruals 29 Interest Accruals 30 Cash Ledger Cash Ledger 31 Cash Ledger (Multicurrency) 32 1
  • 4. Performance Performance Summary 33 Performance TR Summary 34 Performance TR Management Summary 35 Performance Attribution by Sector and Industry 36 Performance Attribution by Sector/Industry Summary 37 Historical Performance Analytics 38 Year-to-Date Performance 39 Performance Snapshot 40 Profit & Loss Detail 41 Realized Gains & Losses by Security 42 Turnover 43 Management Client Billing 44 Security Cross Reference 45 Rebalance Rebalance to Source 46 Rebalance to Allocation Profile 47 Rebalance Trade Ticket 48 Fund Administrator Balance Sheet 49 Statement of Operations 50 Assets Under Management 52 Risk Risk Analysis - Market Driven Moves 53 Risk Analysis - Market Linear Moves 54 Option Analysis 55 Market Exposure Summary 56 2
  • 5. About FixQ Reporting A robust reporting system is key to any investment management system, because reports are the means by which the voluminous amount of data maintained by the portfolio management system is organized and made available. Clear, structured reports provide the link between information and action. With a wide array of reports and many options for report dissemination, FixQ offers your firm an effective, uncomplicated business information platform. Broad Coverage Packaging & Distribution You and your clients demand In addition to on-demand reporting, financial information that is at once FixQ allows you to create Macros, comprehensive and comprehensible. groups of reports that can be FixQ’s diverse suite of reports gives combined into a single document, you myriad axes on which to analyze with a table of contents, and financial data. With over 200 reports, scheduled for automatic e-mail ranging from high-level performance distribution on a regular basis. overviews to in-depth risk simulations, Any report you run is also saved FixQ provides you the details you to the Recent section of the Easy need to effectively understand the Reporting tool for instant retrieval at status of investments. a later date. Ease of Use Real-Time Knowledge FixQ is designed to streamline the The Easy Reporting tool is the nexus for FixQ When you activate FixQ’s real-time reporting process. With the simple Reporting. Users can request any report, features, reports can be delivered create and schedule their own macros, or Easy Reporting tool, users can with up-to-the-minute accuracy, review reports that recently completed. generate any available report in just enabling you make the most of a few clicks. dynamic information. 3
  • 6. Automated Packaging & Distribution The creation of reports is but one step in sharing and acting on information. FixQ’s Macros provide a powerful delivery mechanism, allowing you to schedule recurring operations and reports to take place smoothly in the background, and automatically send them via e-mail to any individuals. Your clients can receive appraisal and performance information regularly, managers can arrive in the morning to pertinent compliance data, and portfolio maintenance operations can be performed without any human intervention. Convenient Scheduling With a broad selection of scheduling options, you can ensure that your clients and staff have access to crucial information as soon as possible. You can schedule reports and similar tasks to run at any time and day, so you can share the day- to-day progress with your client, and automatically distribute period- end reports to managers quickly. You can schedule macros for any time interval, or add them to a queue for one-step scheduling. In addition to e-mailing macros, you can send them directly to any user’s Easy Reporting tool. Macros can also be executed as Packaged Documents Custom Macros part of queues, eliminating the need to select specific time intervals for Macros combine a group of reports Using the Easy Reporting tool, individual macros in favor of running into a single file, indexed with users can create and maintain their a large group of macros in a single bookmarks and a cover page, to own macros and schedule them into task at a time of your choosing. form a cohesive, readily consumable any available queues, which means document. increased flexibility for your clients. 4
  • 7. Widget Gateway Even though FixQ’s assortment of reports offer many avenues for investment analysis, sometimes you and your clients want a quick, digestible snapshot of portfolio status. FixQ’s home page is designed to put all the information about a portfolio at your fingertips in a highly customizable console. The tools on the home page grant instant access to portfolio status and relevant news, as well as the ability to run any report, control account preferences, and assess risk and performance. Winners and Losers At a Glance Easy Reporting • Top and bottom five positions, • High-level portfolio overview • Generate any available report ranked by P&L • Account and security-level detail • Create and manage macros • View month-to-date, quarter-to- • Intraday results available • Review recently completed date, and year-to-date results reports Historical Performance • Compare long-term performance against four indexes • Uses linked rate of return or cumulative growth 5
  • 8. Portfolio Composition Risk User Preferences • Visual analysis of a portfolio by • Analyze risk metrics for portfolio • Change user name, e-mail, type, currency, country, sector, and its individual holdings password, and other defaults. and industry • Break out VaR on three axes. • Select custom reporting logo • Test hedging strategies and assess impact on risk. News • Links to pertinent news, tailored to each portfolio’s holdings. 6
  • 9. Portfolio Appraisal The Portfolio Appraisal is the fundamental report in FixQ, providing per-position valuation as of a given date. The information is sorted by security type and broken out by security. Appraisal Grace FinancialPortfolio General Sample Group 4/15/2010 Quantity Security Symbol Unit Cost Price Total Cost Market Value Unrealized % Port LONG COMMON STOCK 19,500 CLOROX CO CLX 50.681 64.730 988,271.40 1,262,235.00 273,963.60 37.67 2,046 JOHNSON & JOHNSON JNJ 61.902 64.900 126,652.00 132,785.40 6,133.40 3.96 1,114,923.40 1,395,020.40 280,097.00 41.63 SHORT COMMON STOCK -300 ISHARES DOW JONES DVY 43.000 46.220 -12,900.00 -13,866.00 -966.00 -0.41 SELECT DIVID -12,900.00 -13,866.00 -966.00 -0.41 LONG CORPORATE BONDS 138,000 CHESAPEAKE ENERGY 165167BU0 93.566 85.750 129,120.90 118,335.00 -10,785.90 3.65 CORPORATION 6.875% DUE 11-15-20 Accrued Interest 3,953.13 129,120.90 122,288.13 -10,785.90 3.65 SHORT EQUITY CALL OPTIONS -15 [CLX] CLX APR 10 50 C 189054DAR 9.191 11.300 -13,787.09 -16,950.00 -3,162.91 -0.51 -13,787.09 -16,950.00 -3,162.91 -0.51 CASH & EQUIVALENTS CASH - US DOLLARS CASH 1.000 1,745,555.24 1,745,555.24 0.00 52.10 1,745,555.24 1,745,555.24 0.00 52.10 LONG FUTURES 25 JUN 10 EMINI S&P 500 .PES0000010F 1,191.000 1,208.500 1,488,750.00 1,510,625.00 21,875.00 0.65 LONG FUTURES Total 1,488,750.00 1,510,625.00 21,875.00 0.65 ADDED TO GRAND TOTAL 0.00 21,875.00 LONG COMMON STOCK - GREAT BRITAIN 2,500 MOTHERCARE ORD GBP 0.50 MOTGBBF 11.202 11.763 28,004.82 29,407.49 1,402.67 0.88 5,000 NORSEMAN GOLD PLC NOGFF 6.114 9.262 30,571.19 46,311.00 15,739.81 1.38 58,576.01 75,718.49 17,142.48 2.26 CASH - GREAT BRITAIN 13,595 CASH - BRITISH POUNDS CASH 1.609 1.544 21,874.50 20,986.42 -888.08 0.63 21,874.50 20,986.42 -888.08 0.63 Total 67778 3,043,362.96 3,350,627.67 303,311.59 100.00 Summary: Long Securities 2,791,370.31 3,099,698.89 92.5 Short Securities -1,515,437.09 -1,519,566.00 -45.4 Net Cash Equivalents 1,767,429.74 1,766,541.66 52.7 Accrued Dividends 0.00 0.00 0.0 Accrued Interest 3,953.13 0.1 Total Account 3,043,362.96 3,350,627.67 100.0 67778 Run Date: 5/26/2010 10:46:59AM Page 1 of 2 (107) 7
  • 10. Tax Lot Portfolio Appraisal Like the regular Portfolio Appraisal, the Tax Lot Portfolio Appraisal provides a per-position valuation as of a given date, however tax lots of each position are displayed individually. Appraisal Grace Financial Group General Sample Portfolio 4/15/2010 Quantity Security Date Symbol Lot Location Unit Total Price Days Market Unrealized Accr Pct Acquired Cost Cost LT Value Int Port LONG COMMON STOCK (csus) 18,000 CLOROX CO 02/20/09 CLX 1 gsec 50.026 900,464.40 64.730 1,165,140.00 264,675.60 0.00 34.8 1,500 CLOROX CO 09/10/09 CLX 2 gsec 58.538 87,807.00 64.730 149 97,095.00 9,288.00 0.00 2.9 19,500 CLOROX CO Total 50.681 988,271.40 64.730 1,262,235.00 273,963.60 0.00 37.7 100 JOHNSON & JOHNSON 02/24/10 JNJ 3 gsec 60.000 6,000.00 64.900 316 6,490.00 490.00 0.00 0.2 1,946 JOHNSON & JOHNSON 03/02/10 JNJ 4 gsec 62.000 120,652.00 64.900 322 126,295.40 5,643.40 0.00 3.8 2,046 JOHNSON & JOHNSON Total 61.902 126,652.00 64.900 132,785.40 6,133.40 0.00 4.0 LONG COMMON STOCK Total 1,114,923.40 1,395,020.40 280,097.00 0.00 41.6 SHORT COMMON STOCK (csus) -300 ISHARES DOW JONES 02/24/10 DVY 18 gsec 43.000 -12,900.00 46.220 316 -13,866.00 -966.00 0.00 -0.4 SELECT DIVID SHORT COMMON STOCK Total -12,900.00 -13,866.00 -966.00 0.00 -0.4 LONG CORPORATE BONDS (cbus) 138,000 CHESAPEAKE ENERGY 04/15/10 165167BU0 1 gsec 93.566 129,120.90 85.750 366 118,335.00 -10,785.90 3,953.13 3.6 CORPORATION 6.875% Due 11-15-20 LONG CORPORATE BONDS Total 129,120.90 118,335.00 -10,785.90 3,953.13 3.6 SHORT EQUITY CALL OPTIONS (clus) -1 CLX APR 10 50 C 09/10/09 189054DAR 1 gsec 9.191 -919.14 11.300 149 -1,130.00 -210.86 0.00 0.0 -14 CLX APR 10 50 C 09/10/09 189054DAR 2 gsec 9.191 -12,867.95 11.300 149 -15,820.00 -2,952.05 0.00 -0.5 67778 Run Date: 5/26/2010 10:47:14AM Page 1 of 3 (107) 8
  • 11. Portfolio Appraisal (Multicurrency) The Multicurrency Portfolio Appraisal shows per position cost basis and valuation separated by currency as of a given date. The information is sorted by currency, security type and broken out by security. Appraisal ForeignFinancial Group Grace Assets 4/15/2010 Reporting Currency: US Dollar Local Currency Reporting Currency Pct. Quantity Security Symbol Unit Cost Total Cost Price Market Value Market Value Unrealized Port UK Pound (FX = 1.5437) LONG COMMON STOCK - GREAT BRITAIN 1,000 MONITISE PLC CMN MONIF 10.00 10,000.00 10.20 10,200.00 15,745.74 -344.36 2.18 10,000.00 10,200.00 15,745.74 -344.36 2.18 UK Pound Total 10,000.00 10,200.00 15,745.74 -344.36 2.18 European Monetary Unit (FX = 1.3541) LONG COMMON STOCK - EURO 1,200 ASM INTL NV ASMIZ 20.00 24,000.00 22.12 26,544.00 35,943.23 17,913.04 4.97 5,000 EUROFINS SCIENTIFIC EUFSF 67.00 335,000.00 69.25 346,250.00 468,857.13 13,817.73 64.90 359,000.00 372,794.00 504,800.36 31,730.77 69.87 CASH - EURO 141,000 CASH - EURO cash 1.00 141,000.00 1.00 141,000.00 190,927.56 -596.48 26.43 141,000.00 141,000.00 190,927.56 -596.48 26.43 European Monetary Unit Total 500,000.00 513,794.00 695,727.92 31,134.29 96.30 Japanese Yen (FX = 92.9060) LONG COMMON STOCK - JAPAN 1,000 TOSHIBA MACHINE tshmf 422.71 422,707.50 445.29 445,290.00 4,792.91 284.41 0.66 422,707.50 445,290.00 4,792.91 284.41 0.66 CASH - JAPAN 577,292.500 CASH - JAPAN cash 1.00 577,292.50 1.00 577,292.50 6,213.73 56.47 0.86 577,292.50 577,292.50 6,213.73 56.47 0.86 Japanese Yen Total 1,000,000.00 1,022,582.50 11,006.64 340.88 1.52 Total FGN789 722,480.29 31,130.82 100.00 FGN789 Run Date: 5/26/2010 10:46:45AM Page 1 of 2 (107) 9
  • 12. Appraisal by Asset Class The Appraisal by Asset Class report shows the cost, local price, FX rate, and value of positions in a portfolio as of the selected date, sorted by asset class. Appraisal by Asset Class Foreign Assets Group Grace Financial 4/15/2010 Quantity Security Symbol Cusip Local Price Local Market Value USD Market Value FX Rate Long Equities 1,200 ASM INTL NV ASMIZ 5165294 22.12 26,544.00 35,943.23 1.3541 5,000 EUROFINS SCIENTIFIC EUFSF 5972643 69.25 346,250.00 468,857.13 1.3541 1,000 MONITISE PLC CMN MONIF B1YMRB8 10.20 10,200.00 15,745.74 1.5437 1,000 TOSHIBA MACHINE tshmf 6897262 445.29 445,290.00 4,792.91 92.9060 Total Long Equities 525,339.00 Total Equities 525,339.00 Long Cash and Equiv. 141,000 CASH - EURO cash 000000999 1.00 141,000.00 190,927.56 1.3541 577,292.500 CASH - JAPAN cash 1.00 577,292.50 6,213.73 92.9060 Total Long Cash and Equiv. 197,141.29 Total Cash and Equiv. 197,141.29 Total FGN789 722,480.29 FGN789 Run Date: 5/26/2010 10:49:37AM Page 1 of 1 (167) 10
  • 13. Appraisal by Security Type Summary The Appraisal by Security Type Summary report shows the cost and value of positions in a portfolio as of the selected date, summarized and aggregated by security type. Appraisal by Security Type Summary GeneralFinancial Group Grace Sample Portfolio 4/15/2010 % Cur. Est. Annual Security Type Total Cost Market Value Unrealized Asset Yield Income LONG COMMON STOCK 1,114,923.40 1,395,020.40 280,097.00 41.63 0.00 0.00 SHORT COMMON STOCK -12,900.00 -13,866.00 -966.00 -0.41 0.00 0.00 LONG CORPORATE BONDS 129,120.90 122,288.13 -10,785.90 3.65 8.02 9,487.50 SHORT EQUITY CALL OPTIONS -13,787.09 -16,950.00 -3,162.91 -0.51 0.00 0.00 CASH & EQUIVALENTS 1,745,555.24 1,745,555.24 0.00 52.10 LONG FUTURES 1,488,750.00 1,510,625.00 21,875.00 0.65 LONG FUTURES Total ADDED 0.00 21,875.00 TO GRAND TOTAL LONG COMMON STOCK - GREAT BRITAIN 58,576.01 75,718.49 17,142.48 2.26 0.00 0.00 CASH - GREAT BRITAIN 21,874.50 20,986.42 -888.08 0.63 0.00 0.00 Total 67778 3,047,316.08 3,350,627.67 303,311.59 100.00 0.20 9,487.50 Summary: Long Securities 2,791,370.31 3,099,698.89 92.51 Short Securities -1,515,437.09 -1,519,566.00 -45.35 Net Cash Equivalents 1,767,429.74 1,766,541.66 52.75 Accrued Dividends 0.00 0.00 0.00 Accrued Interest 3,953.13 3,953.13 0.12 Total Account 3,047,316.08 3,350,627.67 100.00 67778 Run Date: 5/26/2010 10:49:51AM Page 1 of 1 (169) 11
  • 14. Liquidity Analysis The Liquidity Analysis is used to rank holdings in a portfolio in terms of how many days it would take to liquidate each position, based on its 30, 60, and 90-day average daily trading volume. Liquidity Analysis Grace Financial Group Demonstration Portfolio 3/31/2010 Pct of 30 Day Pct of Days to Symbol Security Quantity Port Avg Volume Daily Volume Liquidate 50% Very Liquid - less than 3% SPY AMEX S & P DEPOSITARY RECEIPTS -1,000 -11.845 190,365,811 -0.001 0 ADP AUTOMATIC DATA PROCESSING INC 4,000 18.070 3,406,685 0.117 1 C CITIGROUP INC 3,000 1.237 409,234,943 0.001 1 CLX CLOROX CO 1,500 9.837 1,076,483 0.139 1 GIS GENERAL MLS INC 800 5.768 1,901,183 0.042 1 HON HONEYWELL INTL INC 2,100 9.744 4,897,052 0.043 1 TLT ISHARES 20+ YEAR TREASURY INDE 500 4.525 3,583,831 0.014 1 DVY ISHARES DOW JONES SELECT DIVID -300 -1.405 410,012 -0.073 0 JNJ JOHNSON & JOHNSON 100 0.657 11,035,954 0.001 1 LLY LILLY ELI & CO 2,000 7.274 6,160,902 0.032 1 MKC MCCORMICK & CO NON-VTG 1,500 5.819 633,218 0.237 1 MRK MERCK & CO INC 2,000 7.600 14,748,780 0.014 1 RTN RAYTHEON CO (NEW) 1,000 5.820 2,356,750 0.042 1 SO SOUTHERN CO 100 0.336 4,043,765 0.002 1 DIS THE WALT DISNEY COMPANY 2,000 7.112 12,647,424 0.016 1 XRX XEROX CORP 30,000 29.451 13,487,473 0.222 1 4VFT Run Date: 7/19/2010 1:05:20PM Page 1 of 1 (162) 12
  • 15. Appraisal with CUSIP The Appraisal with Cusip report shows the cost and value of positions in a portfolio as of the selected date, with an emphasis on current yield. Appraisal with CUSIP Grace Financial Group Demonstration Portfolio 7/23/2010 Cur. Est. Annual Quantity Security Symbol CUSIP Unit Cost Price Total Cost Market Value Unrealized Yield Income % Port LONG COMMON STOCK 4,000 AUTOMATIC DATA ADP 053015103 37.944 41.840 151,775.20 167,360.00 15,584.80 3.23 5,400.00 48.59 PROCESSING INC 3,000 CITIGROUP INC C 172967101 3.000 4.020 9,000.00 12,060.00 3,060.00 0.00 0.00 3.50 1,500 CLOROX CO CLX 189054109 58.538 65.250 87,807.00 97,875.00 10,068.00 3.07 3,000.00 28.42 100 JOHNSON & JOHNSON JNJ 478160104 60.000 57.490 6,000.00 5,749.00 -251.00 3.50 201.00 1.67 2,000 LILLY ELI & CO LLY 532457108 33.953 35.050 67,905.00 70,100.00 2,195.00 5.59 3,920.00 20.35 322,487.20 353,144.00 30,656.80 3.55 12,521.00 102.53 SHORT EQUITY CALL OPTIONS -15 [CLX] CLX APR 10 50 C 189054DAR 189054DAR 9.191 0.050 -13,787.09 -75.00 13,712.09 0.00 0.00 -0.02 -10 [WMT] WMT JUN 10 45 C 931142FAJ 931142FAJ 6.544 8.650 -6,544.00 -8,650.00 -2,106.00 0.00 0.00 -2.51 -20,331.09 -8,725.00 11,606.09 0.00 0.00 -2.53 Total 4VFT 302,156.11 344,419.00 42,262.89 3.64 12,521.00 100.00 Summary: Long Securities 322,487.20 353,144.00 102.53 Short Securities -20,331.09 -8,725.00 -2.53 Net Cash Equivalents 0.00 0.00 0.00 Long Accrued Dividends 0.00 0.00 0.00 Short Accrued Dividends 0.00 0.00 0.00 Accrued Interest 0.00 0.00 Total Account 302,156.11 344,419.00 100.00 4VFT Run Date: 7/26/2010 4:02:39PM Page 1 of 1 (163) 13
  • 16. Maturity Alerts The Maturity Alert reports provides analysis of time-sensitive instruments, like bonds and options, sorted by time remaining until expiration, facilitating action on those positions.  Grace Financial Group                                                                                                              
  • Related Search
    We Need Your Support
    Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

    Thanks to everyone for your continued support.

    No, Thanks