Free Financial Investment Reconciliation Statement Template
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]
