FastTrack has a very vocal user base and we get hundreds of feature/update requests a year. The latest enhancement is one of the most exciting features to make the cut in a long time.
Starting with v220.127.116.11, you can model leverage portfolios using static models. Leverage is a popular concept where you borrow money to purchase securities. If the securities purchased with borrowed money appreciate, you enhance your profits without using your own capital. If the purchased securities produce a loss, you repay the debt at par and magnify the loss on investment.
Leverage can greatly magnify gains and losses. Certain investors live and die by leverage, but it’s not something to employ lightly. I recently had a user describe it to me like this: “It’s like building a fire in the middle of your living room. While that fire will heat your house and keep you warm, if you don’t keep on top of it will burn the place down.”
Jumping right in, the controls are simple. You can find them on the (1) Data >> Static Model tab then look in the (2) lower middle of the screen for the leverage details.
To create a leveraged static model, allocate more than 100% to a static model. Below is an example of a 250% allocation.
In terms of a $100,000 portfolio, the above example would have the following positions:
SPY – $150,000
TLT – $100,000
Total – $250,000
The leverage info is shown on in the bottom center of the screen. The details for the above portfolio are below:
After clicking the “edit” button above the model info area, the margin rate becomes an input box. The leverage and cash positions are auto updated based on the static model inputs.
Margin rate is the cost of borrowing funds. This is expressed in an annual percentage rate. The interest compounds each time the portfolio rebalanced. A monthly rebalance has monthly compounding interest and a weekly model has weekly compounding interest.
Leverage is the total leverage on the portfolio. In the above 250% leverage example, $100,000 is the original capital position, and the $150,000 is the leveraged position. $150,000 / $250,000 = 150% leverage.
Cash position is the balance in cash for any models that have under 100% allocations. A model with a single SPY position of 80% will show a cash position of 20%.
Open Log will open the windows folder where all leveraged model logs are stored. The leverage log is a .CSV file that has the following columns:
- Date – Market date of values
- Non Levered Portfolio – value of the underlying non-levered static model. In the above 250% example, this would be the values of a 60% SPY, 40% TLT portfolio. To calculate the model FT Cloud creates a non levered static model with the following weightings: $150k / $250k = 60% SPY and $100k / $250k = 40% TLT portfolio. Once this 60/40 portfolio is calculated, then FT Cloud applies 150% leverage to the 60/40 portfolio.
- Running Total Non Levered Portfolio – The daily value of the un-levered portion of the portfolio. This is a “show your work” value. It acts odd by jumping in value at the beginning of every month. This is due to the resetting of the un-levered value to the previous day’s [Levered Portfolio Value] (plus the day’s price change)
- Original Borrowed Amount – amount borrowed at the beginning of the investment period. This value resets every time the portfolio is rebalanced. This value changes does not change throughout the period. ie. you borrow a fixed dollar amount on the first day of the month, then repay that same fixed dollar amount at the end of the period.
- Borrowed Amount Value – the daily value of the borrowed funds. On the first day, the original borrowed amount is invested with the same allocations as the non levered portfolio. Each day the [Borrowed Amount Value] changes according to the change of the [Non Levered Portfolio]
- Period Cost – the fractional portion of the annual interest charged over the investment period. This also remains unchanged during the period. Since we borrow a fixed value on day 1, the interest is charged off that fixed value. This is calculated as:
( [margin rate] / [rebalance frequency] ) * [Original Borrowed Amount]
- Daily Cost – the period cost divided by the number of market days in the investment period. For the same reasons, this value does not change during the investment period.
- Net Return on Borrowed Amount – This is the result of the following equation:
[Borrowed Amount Value] – [Original Borrowed Amount] – [Daily Cost]
- Levered Portfolio Value – This is the result of the following equation:
( [Previous Day Running Total Non Levered Portfolio] * [Daily return of Non Levered Portfolio] ) + [ Net Return on Borrowed Amount]
Click the link below for a google sheet log of the above leverage model. Columns A-I show the regular log values. Columns K-Q show the work of how the values are derived.