Comments by jellybeannn (Top 2 by date)

double[] values = new double[73];

DataTable dt = new DataTable("Details");
DataSet ds = new DataSet();
ds.Tables.Add(dt);

for (int i = 1; i <= 240; i++)
{
dt.Columns.Add("Month" + i, typeof(string));
}

dt.Columns.Add("End", typeof(string));

DataRow dr = dt.NewRow();
dr["Month1"] = String.Format("{0:#,###,###,###.##}", H30_Out);
dt.Rows.Add(dr);

DataRow row1 = dt.NewRow();
DataRow row2 = dt.NewRow();
DataRow row3 = dt.NewRow();
DataRow row4 = dt.NewRow();
DataRow row5 = dt.NewRow();
DataRow row6 = dt.NewRow();
DataRow row7 = dt.NewRow();
DataRow row8 = dt.NewRow();
DataRow row9 = dt.NewRow();

dt.Rows.Add(row1);
dt.Rows.Add(row2);
dt.Rows.Add(row3);
dt.Rows.Add(row4);
dt.Rows.Add(row5);
dt.Rows.Add(row6);
dt.Rows.Add(row7);
dt.Rows.Add(row8);
dt.Rows.Add(row9);

for (int i = 1; i <= 240; i++)
{
double num = 0.0;
double num2 = 0.0;

if (i == 13 || i == 25 || i == 37 || i == 49 || i == 61 || i == 73 ||
i == 85 || i == 98 || i == 109 || i == 121 || i == 133 || i == 145 ||
i == 157 || i == 169 || i == 181 || i == 193 || i == 205 || i == 217 ||
i == 229)
{
num = (C146_Calc * G158_In) / 100;
num2 = (C148_Calc * G164_In) / 100;
}
C146_Calc += num;
C148_Calc += num2;
C150_Calc = C146_Calc + C148_Calc;

if (i == 13 || i == 25 || i == 37 || i == 49 || i == 61 || i == 73 ||
i == 85 || i == 98 || i == 109 || i == 121 || i == 133 || i == 145 ||
i == 157 || i == 169 || i == 181 || i == 193 || i == 205 || i == 217 ||
i == 229)
{
C151_Calc = -(C150_Calc * G176_In) / 100;
}

double C152_Calc = C150_Calc + C151_Calc;

double BW154_Calc = 0.0;
if (i == 72)
BW154_Calc = (C152_Calc * 12 / G169_In) * 100;
if (i == 240)
BW154_Calc = (C152_Calc * 12 / G170_In) * 100;

num3 += BW154_Calc;

// calculate 6 year IRR
if (i == 1)
C158_Calc = H30_Out + C152_Calc;
if (i >= 2 && i <= 72)
C158_Calc = C152_Calc;
if (i == 73)
C158_Calc = C152_Calc + num3;

// total 6 year IRR
for (int j = 1; j == values.Length - 1; j++)
{
values[j] = C158_Calc;
}

// calculate 20 year IRR
double C160_Calc = 0.0;
if (i == 1)
C160_Calc = H30_Out + C152_Calc;
else
C160_Calc = C152_Calc;

row1["Month" + i] = String.Format("{0:#,###,###,###}", C146_Calc);
row2["Month" + i] = String.Format("{0:#,###,###,###}", C148_Calc);
row3["Month" + i] = String.Format("{0:#,###,###,###}", C150_Calc);
row4["Month" + i] = String.Format("{0:#,###,###,###}", C151_Calc);
row5["Month" + i] = String.Format("{0:#,###,###,###}", C152_Calc);
row6["Month" + i] = String.Format("{0:#,###,###,###}", BW154_Calc);
row7["Month" + i] = String.Format("{0:#,###,###,###}", C158_Calc);
row8["Month" + i] = String.Format("{0:#,###,###,###}", C160_Calc);
}

B162_Calc = Financial.IRR(ref values, 0.1);
row9["Month1"] = String.Format("{0:#,###,###,###.##}", B162_Calc);

return ds;