public static MarketFilter FromParameters(MarketParameters parameters)
{
return(new MarketFilter
{
MarketId = parameters.MarketId,
Action = parameters.Action
});
}
public FreeCashFlowCollection CalculateFreeCashFlow(string symbol, int year, int yrsToProject, IncomeStatementCollection incomeStatementProjection)
{
FreeCashFlowCollection fcfs = null;
MarketParameters mktParms = MarketParametersBL.Instance.GetMarketParameters();
BalanceSheetProjectionBL bsProjectionBL = new BalanceSheetProjectionBL();
BalanceSheetCollection bsProjections = bsProjectionBL.ProjectBalanceSheets(symbol, year, yrsToProject, incomeStatementProjection);
if (incomeStatementProjection != null && bsProjections != null)
{
fcfs = new FreeCashFlowCollection();
for (int i = year + 1; i < year + yrsToProject + 1; i++)
{
IncomeStatement inc = incomeStatementProjection.Find(i);
BalanceSheet bs = bsProjections.Find(i);
BalanceSheet lastYrBs = bsProjections.Find(i - 1);
if (inc != null && bs != null)
{
fcfs.Add(new FreeCashFlow(
symbol,
i,
inc.NOP(mktParms.TaxRate),
inc.NetIncome,
(bs.Ppe - lastYrBs.Ppe + inc.Depreciation),
bs.WorkingCapital,
bs.WorkingCapital - lastYrBs.WorkingCapital,
inc.Depreciation,
bs.InvestedCapital
));
}
}
}
return(fcfs);
}
public MarketParameters GetMarketParameters()
{
MarketParameters svparams = null;
//Execute Query
using (MySqlDataReader rdr = MySqlHelper.ExecuteReader(MySqlHelper.SV_CONN_STRING, SQL_SELECT_SVPARAMETERS))
{
Dictionary <string, MarketParameter> svPrms = new Dictionary <string, MarketParameter>();
if (rdr.Read())
{
do
{
string parameterKey = MySqlHelper.ConvertReaderToString(rdr, "PARAMETER_KEY");
string parameterValue = MySqlHelper.ConvertReaderToString(rdr, "PARAMETER_VALUE");
MarketParameter svpara = new MarketParameter(parameterKey, parameterValue);
svPrms.Add(parameterKey, svpara);
}while (rdr.Read());
}
svparams = new MarketParameters(svPrms);
}
return(svparams);
}
public MarketParameters GetMarketParameters()
{
MarketParameters svParams = _dao.GetMarketParameters();
return(svParams);
}
