Archive for September 24th, 2008

Model Portfolio Report for July 2008

September 24, 2008

The final contents of the Model Portfolio for June 2008 were:
$61,756.59 USD in the Doppler Treasury Money Market Fund
$80,052.95 HKD ($10,258.33 USD) in the Everbank Hong Kong Dollar CD
2 shares of BRKB ($8024.00 USD)
222 shares of DFJ ($9801.30 USD)
103 shares of FXY ($9671.70 USD)

The final value of the Doppler Model Portfolio for June 2008 was $99,511.92 USD.

The 1-month T-Bill yielded an average of 1.724% in June 2008, and the 3-month T-Bill yielded an average of 1.312% in April 2008. The average of these figures is 1.518%. Subtracting .3% gives us 1.218%. Thus, the yield of the Doppler Treasury Money Market Fund for July 2008 is 1.218%. The credited cash balance was $61,756.59 USD for the entire month, so the accrued interest was $63.89 USD (around $2.06 USD/day), bringing the total at the end of the month to $61,820.48 USD.

The credited balance of the Hong Kong Dollar CD remained at $79,950 HKD for the entire month. We entered the month with $102.95 HKD of accrued interest and added an additional $67.90 HKD of accrued interest. This brings the total balance in the Hong Kong Dollar CD to $80,120.85 HKD. At the exchange rate of 7.80340 HKD/USD at the end of the month, the total final balance of the Hong Kong Dollar CD equated to $10,267.43 USD.

At the end of July 2008, the 2 shares of BRKB were worth $7658.00 USD, the 222 shares of DFJ were worth $9463.86 USD, and the 103 shares of FXY were worth $9519.26 USD.

The final contents of the Model Portfolio for July 2008 were:
$61,820.48 USD in the Doppler Treasury Money Market Fund
$80,120.85 HKD in the Hong Kong Dollar CD ($10,267.43 USD)
2 shares of BRKB ($7658.00 USD)
222 shares of DFJ ($9463.86 USD)
103 shares of FXY ($9519.26 USD)

The total value of the Model Portfolio at the end of July 2008 was $98,729.03 USD. Compared to the $99,511.92 USD value at the start of the month, this was a drop of .8%.

Model Portfolio Report for June 2008

September 24, 2008

The final contents of the Doppler Model Portfolio for May 2008 were:
$61,694.68 USD in the Doppler Treasury Money Market Fund
$79,987.24 HKD in the Everbank Hong Kong Dollar CD ($10,246.37 USD)
2 shares of BRKB ($8996.00 USD)
222 shares of DFJ ($10391.82 USD)
103 shares of FXY ($9749.18 USD)

The final total value of the Doppler Model Portfolio for May 2008 was $101,078.05 USD.

The 1-month T-Bill yield averaged 1.759% in May 2008, and the 3-month T-Bill yield averaged 1.284% in March 2008. The average of these two figures is 1.521%, and subtracting .3% from this gives us 1.221%. Thus, the yield of the Doppler Treasury Money Market Fund was 1.221% for June 2008. The credited cash balance for the entire month was $61,694.68 USD, so the accrued interest was $61.91 USD (roughly $2.06 USD/day). This brought the final cash balance for June 2008 to $61,756.59 USD.

The credited balance of the Hong Kong Dollar CD remained at $79,950 HKD for the entire month. We entered the month with $37.24 HKD of accrued interest. An additional $65.71 HKD of interest accrued during the month (roughly $2.19 HKD/day), bringing the total accrued interest to $102.95 HKD and the total balance to $80,052.95 HKD, worth $10,258.33 USD at the rate of 7.8037 HKD/USD.

At the end of June 2008, the 2 shares of BRKB were worth $8024.00, the 222 shares of DFJ were worth $9801.30, and the 103 shares of FXY were worth $9671.70.

The final contents of the Model Portfolio for June 2008 were:
$61,756.59 USD in the Doppler Treasury Money Market Fund
$80,052.95 HKD ($10,258.33 USD) in the Everbank Hong Kong Dollar CD
2 shares of BRKB ($8024.00 USD)
222 shares of DFJ ($9801.30 USD)
103 shares of FXY ($9671.70 USD)

The final value of the Doppler Model Portfolio for June 2008 was $99,511.92 USD, compared to $101,078.05 USD for the end of May 2008. This was a loss of around 1.5%.

Model Portfolio Report for May 2008

September 24, 2008

The Treasury Bill data I use is at http://www.ustreas.gov/offices/domestic-finance/debt-management/interest-rate/yield_historical.shtml

The exchange rate I use for a given day is the average figure available at http://www.oanda.com/convert/fxhistory .

The stock price I use for a given day is the closing price available at http://bigcharts.marketwatch.com/historical/

The 1-month US Treasury Bill had an average yield of 1.072% in April 2008, and the 3-month US Treasury Bill had an average yield of 2.174% in February 2008. The average of these two figures is 1.623%, and .3% less than this is 1.323%. So we assume that the Doppler Value Treasury Money Market Fund yielded 1.323% in May 2008. The credited cash balance was $100,000.00 USD on May 8th ($3.62 USD/day of uncredited accrued interest), $79,966.58 USD on May 9th-11th ($2.90 USD/day of uncredited accrued interest), $71,736.58 USD on May 12th-14th ($2.60 USD/day of uncredited accrued interest), and $61,636.58 USD from May 15th-31st ($2.23 USD/day of uncredited accrued interest). The accrued interest for the month was $58.10 USD. So adding the total accrued interest ($58.10 USD) to the credited cash balance ($61,636.58 USD) brings the final cash balance of May 2008 to $61,694.68 USD.

The portfolio owned $0 HKD from May 8th-14th and $79,950 HKD from May 15th-31st. At an interest rate of 1%, interest accrued at the rate of $2.19 HKD/day for a total of $37.24 HKD. Adding the $37.24 HKD of accrued interest to the credited CD balance of $79,950 gave us a final balance of $79,987.24 HKD, worth $10,246.37 USD.

At the end of May 2008, the 2 shares of BRKB at $4498.00/share were worth $8996.00. The 222 shares of DFJ at $46.81/share were worth $10391.82. The 103 shares of FXY at $94.6522/share were worth $9749.18.

The final contents of the Doppler Model Portfolio for May 2008:
$61,694.68 USD in the Doppler Treasury Money Market Fund
$79,987.24 HKD in the Everbank Hong Kong Dollar CD ($10,246.37 USD)
2 shares of BRKB ($8996.00 USD)
222 shares of DFJ ($10391.82 USD)
103 shares of FXY ($9749.18 USD)

The final value of the Doppler Model Portfolio for May 2008 was $101,078.05, a return of nearly 1.1% in 24 days. Of course, as we now know, this wouldn’t last.