Another task for the fund accounting team is valuation of the portfolio. Valuation is an exercise to estimate the value of the portfolio using the closing market price of the valuation day. The main component is the closing price. For global account, exchange rates is another main component. It is a common practice to use London 4 pm exchange rate as the standard exchange rate.
Valuation (Trade Date)
Most valuation is based on trade date. This means that if we bought some shares on the valuation day. We would consider it as our holdings even though the actual settlement happens later. We would proceed to place the valuation using the market closing price.
Fund managers, traders, clients and other investment parties all uses trade date valuation.
Valuation (Settlement Date)
Valuation based on settlement date reflects the actual transaction of the securities and cash payment. Once a BUY trade is made, the securities would be posted as receivables and the equivalent cash is posted into cash payable. Only when the securities are place with the custodian, then the securities are considered as asset.
Although settlement date valuation is seldom used, it provides an accurate picture of the cash movement for a portfolio. It also allows fund managers to know the actual cash on hand.
Gross and Net Valuation
When valuing a portfolio, we can price the total asset plus the management fees. This type of valuation is known as gross of fee valuation. Some clients would like to know the actual fund valuation after taking into consideration of management fees and other expenses. Net of fees valuation is basically total fund valuation less accrued management fees and other accrued fees.
A standard valuation report sum up all assets, value at the closing market price of the valuation day, including all cash position using standard exchange rate (London 4 pm) plus all the receivables (such as cash dividend) and less all the fees payable. Therefore a standard valuation report is a net of fees valuation.
Sometimes, fund manager would like to know the fund valuation gross of management fee since the management fee is the largest component of the expenses. Some fund managers would argued that management fee is part of the earned return unlike custodian fee which is a necessary cost of operation. To calculate gross of management fee, you just need to add the accrued management fees to the net valuation.
Profit and Loss Statement
Before we proceed to discuss about profit and loss we need to consider how we should value the cost of our asset. If a portfolio bought GE at $15 for 50,000 shares, the cost of asset would be 15 x 50,000 + commission and other transaction expenses. What happen if this portfolio bought GE at different time and at different price?
Assume that Portfolio A bought GE at various periods as shown (assuming transaction cost of 2.1%):
|
GE
| |
P X Qty
|
Trans Cost
|
Tot Cost
|
May-05
|
$35
|
20,000
|
$700,000.00
|
$14,700.00
|
$714,700.00
|
Jun-06
|
$37
|
15,000
|
$555,000.00
|
$11,655.00
|
$566,655.00
|
Apr-07
|
$32
|
30,000
|
$960,000.00
|
$20,160.00
|
$980,160.00
|
| |
65,000
| | |
$2,261,515.00
|
Total cost of GE would be about $2.26 million. Based on the total cost if we divided $2.26 million with 65,000 shares, the average cost per share would be $34.79.
What happen if there is a sell trade? How do you account for that? There are two methods, the first is to use average pricing and the second method is to use Fist-In-First-Out (FIFO) method.
Average Pricing
As we have computed earlier the average price of GE is $34.79. If we sell 20,000 share at $12, the net proceed after taking into consideration of 2.1% expenses (commission and tax) would be $234,960. Based on the average cost of $34.79; the net loss is $234,960 - (20,000 x $34.79) = $234,960 - $695,850.77 = -$460,890.77
FIFO Method
Fist-In-First-Out method will not use average costing. Any share we sell will be deducted from the first block of share we bought. Therefore we are selling the first 20,000 shares based on the cost of $714,700. The net loss will be $234,960 - $714,700 = -$479,740.00.
As you can see the net loss is different depending on the costing method. There are additional costing methods such as Last-In-First-Out (LIFO) and activity based costing which is seldom used in traditional fund management business.
The computation of profit and loss is to compute each sale of securities less the cost of security. The net gain and net loss in aggregate will be your total trading profit or loss. Interest income from your fixed income securities and cash dividend are also considered as profit.
One example of the profit and loss statement would be:
Profit and Loss Statement for Portfolio A
Income
Sales of Securities xxx
Less: Cost of Securities xxx
Trading Gain / (Loss) xxx
Interest Income xxx
Cash Dividend xxx
Income Receivables xxx
Less: Expense
Management Fees xxx
Other expenses xxx
Interest expenses (margin a/c) xxx
Traditionally, assets are value at cost. Therefore, the profit and loss statement will be reported based on historical costing method. The fund valuation used earlier does not based on historical costing approach; instead it is mark to market value. There will be significant differences when you compare the valuation report against the profit and loss statement based on historical costing approach.
We can also use mark-to-market approach for profit and loss statement. First the remaining securities on our assets ledger should be value at market prise. Since the asset is computed based on cost, the differences between the market value and cost would be unrealized gain (loss). We posted the unrealized gain (loss) into a separate earnings ledger. Such item will be incorporated into the income statement as shown
Income
Sales of Securities xxx
Less: Cost of Securities xxx
Trading Gain / (Loss) xxx
Interest Income xxx
Cash Dividend xxx
Income Receivables xxx
Less: Expense
Management Fees xxx
Other expenses xxx
Interest expenses (margin a/c) xxx
-----
Profit (Loss) xxx
Unrealized Capital Gain (Loss) xxx
In normal accounting, the profit will be posted to retained earnings ledger; however, in portfolio investment, all available cash must be reinvested. Therefore, it is meaningless to maintain a retained earnings ledger. The profit will be only reflected in the income statement.
Unrealized capital gain (loss) will be posted in a special ledger similar to an income ledger. This item will also be posted on the balance sheet together with equity.
Balance Sheet
For balance sheet, we would have securities asset, cash account, cash receivables, asset receivables, income receivables listed as assets. Liabilities would be asset payable, cash payable and accrued expenses.
The valuation of cash, cash receivables, income receivables, accrued expense is straight forward. Valuation of asset payable, resulting from sales transaction, will be based on the net settlement amount.
To value the securities asset and asset receivables, we would value them based on the transacted cost. For mark-to-market balance sheet, the securities will be value at market price and the differences will be posted as unrealized gain or loss.
*****