Cost Analysis

Calculate your investment costs relative to capital at risk and return. Tables below describe the information you get from the excel file. download the excel file.

Input Cells
Billing Account size	$100,000
Minimum Funding	$50,000
Margin (BAS)	$30,000
Margin (MFL)	$15,000

 

 

 

 

 

 

 

Data Input	Last	$108,604	$58,604	$58,604		2
Date	ROR	$100,000	$50,000	$30,000	P&L	Count If
Jan-99	3.04%	$103,040.0	$53,040.0	$53,040.0	$3,040.0	1
Feb-99	5.40%	$108,604.2	$58,604.2	$58,604.2	$5,564.2	2

 

 

 

 

Tables above are examples of data input. Directly below is the output table for evaluating return relative to cost at three different funding levels. Help files are written as comments, identified as "Read Me" in the excel file.

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%