Cost Analysis
Calculate your investment costs relative to capital at risk and return.
Login and download the excel file.
Input Cells Billing Account size $100,000 Minimum Funding $50,000 Margin (BAS) $30,000 Margin (MFL) $15,000
The excel file you download gives the following information. The table to your left is data input. Directly below is a data output tables for evaluating your managed account costs at three different funding levels.
Data Output Cells Billing Account Funding Level Margin Account BAStart: $100,000 FLStart: $50,000 MgnStart: $30,000 BALast: $108,604 FLLast: $58,604 MgnLast: $58,604 MgnBA: 30.0% MgnFL: 60.0% Mgn: 100.0% CostBA: 0.9% Cost/FL: 1.8% Cost/Mgn: 3.0% Total Cost: 0.15% Total Cost: 0.30% Total Cost: 0.50% BA-Return: 8.6% FL-Return: 17.2% Mgn-Return: 95.35%
