Financial Investment
Reconciliation Statement
Statement Number: FIRS-2024-003
Date: [Date]
Prepared for: [Investor Name]
Prepared by: [Department Name]
Part I: Investment Summary
Investment Category | Beginning Balance | Additions | Disposals | Gains / Losses | Ending Balance |
Stocks | $100,000 | $20,000 | $15,000 | $10,000 | $115,000 |
Bonds | $50,000 | $5,000 | $2,000 | $3,000 | $56,000 |
Real Estate | $150,000 | $30,000 | $20,000 | $25,000 | $185,000 |
Mutual Funds | $70,000 | $10,000 | $5,000 | $7,000 | $82,000 |
Others | $30,000 | $5,000 | $3,000 | $2,000 | $34,000 |
Total | $400,000 | $70,000 | $45,000 | $47,000 | $472,000 |
Part II: Reconciliation Details
Stocks: The stock portfolio began with a balance of $100,000. During the period, $20,000 was added through new purchases, while stocks worth $15,000 were sold. The portfolio experienced a gain of $10,000, resulting in an ending balance of $115,000.
Bonds: Bond investments started at $50,000. Additional purchases of $5,000 were made, and bonds worth $2,000 were disposed of. Interest and market adjustments led to gains of $3,000, bringing the ending balance to $56,000.
Real Estate: The real estate investment began at $150,000. New investments amounting to $30,000 were made, and sales of $20,000 occurred. Property value appreciation contributed to a gain of $25,000, resulting in an ending balance of $185,000.
Mutual Funds: The mutual fund portfolio had an initial value of $70,000. Contributions totaling $10,000 and redemptions of $5,000 were recorded. The funds gained $7,000 in value, ending the period at $82,000.
Other Investments: Other types of investments, starting at $30,000, saw additions of $5,000 and disposals totaling $3,000. The category experienced a gain of $2,000, ending at $34,000.
Part III: Performance Analysis
The investment portfolio showed a robust performance, with an overall net gain of $47,000. This represents a combined increase of approximately 11.75% from the beginning balance. Realized gains, primarily from stock and real estate sales, contributed significantly to the portfolio's growth, accounting for $35,000 of the net gain. Unrealized gains, particularly in stocks and mutual funds, added $12,000 to the portfolio's value.
When compared to the relevant market benchmarks, the portfolio's performance was favorable. The stock component outperformed the S&P 500 index, while the real estate investments surpassed regional property value growth rates. The bond investments aligned closely with the Bloomberg Barclays US Aggregate Bond Index, reflecting a stable and risk-averse strategy. Mutual funds performance was on par with their respective fund benchmarks, indicating sound fund selection.
Reviewed By:
[Reviewer's Name]
[Reviewer's Position]
[Date]
Finance Templates @ Template.net