Annexure II (A) ‐ DSCR & IRR Calculation

Case 1 ‐ Bidding Stage 

Annuity Receivable 600 Case Particulars IRR  % Change 

Debt  75% 450 1 At Bidding Stage 13.44%
Equity 20% 120 2 Post COD 7.91% ‐41.13%
Bank Rate  @ Bidding June 2016 7.00% 3 MCLR as Benchmark 11.08% ‐17.61%
HAM ROI  10.0% 4 G Sec Benchmark 11.74% ‐12.68%
Bank MCLR 9.15%
Spread between HAM ROI and MCLR 0.85%
Spread during Construction  1.25%
Spread after COD 1.00%
Cost of Debt During Construction  10.40%
Cost of Debt Post COD 10.15%
G Sec Rate 7.48%
Spread between HAM ROI and G Sec rate 2.52%

Date 31‐Mar‐20 30‐Sep‐20 31‐Mar‐21 30‐Sep‐21 31‐Mar‐22 30‐Sep‐22 31‐Mar‐23 30‐Sep‐23 31‐Mar‐24 30‐Sep‐24 31‐Mar‐25 30‐Sep‐25 31‐Mar‐26 30‐Sep‐26 31‐Mar‐27 30‐Sep‐27
Annuity Schedule 2.10% 2.17% 2.24% 2.31% 2.38% 2.45% 2.52% 2.60% 2.68% 2.76% 2.84% 2.93% 3.02% 3.11% 3.20%
Annuity amount 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Outstanding Annuity  600 587.40 574.38 560.94 547.08 532.80 518.10 502.98 487.38 471.30 454.74 437.70 420.12 402.00 383.34 364.14
Debt Schedule 2.50% 2.85% 2.95% 3.00% 3.15% 3.25% 3.25% 3.35% 3.50% 3.50% 3.60% 3.70% 3.75% 3.65% 3.70%
Debt Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Outstanding Debt 450 438.75 425.93 412.65 399.15 384.98 370.35 355.73 340.65 324.90 309.15 292.95 276.30 259.43 243.00 226.35
Inflows
Annuity 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Interest 30.00 29.37 28.72 28.05 27.35 26.64 25.91 25.15 24.37 23.57 22.74 21.89 21.01 20.10 19.17
Total Inflows 42.60 42.39 42.16 41.91 41.63 41.34 41.03 40.75 40.45 40.13 39.78 39.47 39.13 38.76 38.37
Outflow
Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Interest Cost  22.84 22.27 21.62 20.94 20.26 19.54 18.80 18.05 17.29 16.49 15.69 14.87 14.02 13.17 12.33
Total Outflows 34.09 35.09 34.89 34.44 34.43 34.16 33.42 33.13 33.04 32.24 31.89 31.52 30.90 29.59 28.98

Net Cash Flows ‐120 8.51 7.30 7.27 7.47 7.20 7.18 7.60 7.62 7.41 7.89 7.89 7.95 8.23 9.17 9.38
DSCR 1.25 1.21 1.21 1.22 1.21 1.21 1.23 1.23 1.22 1.24 1.25 1.25 1.27 1.31 1.32

Date 31‐Mar‐28 30‐Sep‐28 31‐Mar‐29 30‐Sep‐29 31‐Mar‐30 30‐Sep‐30 31‐Mar‐31 30‐Sep‐31 31‐Mar‐32 30‐Sep‐32 31‐Mar‐33 30‐Sep‐33 31‐Mar‐34 30‐Sep‐34 31‐Mar‐35
Annuity Schedule 3.30% 3.40% 3.50% 3.61% 3.72% 3.83% 3.94% 4.06% 4.18% 4.25% 4.25% 4.44% 4.71% 4.75% 4.75%
Annuity amount 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Outstanding Annuity  344.34 323.94 302.94 281.28 258.96 235.98 212.34 187.98 162.90 137.40 111.90 85.26 57.00 28.50 0.00
Debt Schedule 3.75% 3.85% 3.95% 4.00% 4.10% 4.20% 4.25% 4.10% 4.10% 4.10% 4.10% 5.80% 0.00% 0.00% 0.00%
Debt Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Outstanding Debt 209.48 192.15 174.38 156.38 137.93 119.03 99.90 81.45 63.00 44.55 26.10 0.00
Inflows
Annuity 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Interest 18.21 17.22 16.20 15.15 14.06 12.95 11.80 10.62 9.40 8.15 6.87 5.60 4.26 2.85 1.43
Total Inflows 38.01 37.62 37.20 36.81 36.38 35.93 35.44 34.98 34.48 33.65 32.37 32.24 32.52 31.35 29.93
Outflow
Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Interest Cost  11.49 10.63 9.75 8.85 7.94 7.00 6.04 5.07 4.13 3.20 2.26 1.32 0.00 0.00 0.00
Total Outflows 28.36 27.96 27.53 26.85 26.39 25.90 25.17 23.52 22.58 21.65 20.71 27.42 0.00 0.00 0.00

Net Cash Flows 9.64 9.66 9.67 9.96 10.00 10.03 10.27 11.46 11.90 12.00 11.66 4.81 32.52 31.35 29.93
DSCR 1.34 1.35 1.35 1.37 1.38 1.39 1.41 1.49 1.53 1.55 1.56 1.18 0.00 0.00 0.00

AVERAGE DSCR 1.30
Count for DSCR less than 1.15 0.00
XIRR 13.44%
 Annexure II (B)‐ DSCR & IRR Calculation
Case 2 ‐ Post COD 

Annuity Receivable 600 Case Particulars IRR  % Change 

Debt  75% 450 1 At Bidding Stage 13.44% 0
Equity 20% 120 2 Post COD 7.91% ‐41.13%
Bank Rate ‐ At First annuity Actual 4.25% 3 MCLR as Benchmark 11.08% ‐17.61%
HAM ROI 7.25% 4 G Sec Benchmark 11.74% ‐12.68%
Bank MCLR 7.25%
Spread between HAM ROI and MCLR' 0.00%
Spread during Construction  1.25%
Spread after COD 1.00%
Cost of Debt During Construction  8.50%
Cost of Debt Post COD 8.25%

Date 31‐Mar‐20 30‐Sep‐20 31‐Mar‐21 30‐Sep‐21 31‐Mar‐22 30‐Sep‐22 31‐Mar‐23 30‐Sep‐23 31‐Mar‐24 30‐Sep‐24 31‐Mar‐25 30‐Sep‐25 31‐Mar‐26 30‐Sep‐26 31‐Mar‐27 30‐Sep‐27
Annuity Schedule 2.10% 2.17% 2.24% 2.31% 2.38% 2.45% 2.52% 2.60% 2.68% 2.76% 2.84% 2.93% 3.02% 3.11% 3.20%
Annuity amount 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Outstanding Annuity  600 587.40 574.38 560.94 547.08 532.80 518.10 502.98 487.38 471.30 454.74 437.70 420.12 402.00 383.34 364.14
Debt Schedule 2.50% 2.85% 2.95% 3.00% 3.15% 3.25% 3.25% 3.35% 3.50% 3.50% 3.60% 3.70% 3.75% 3.65% 3.70%
Debt Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Outstanding Debt 450 438.75 425.93 412.65 399.15 384.98 370.35 355.73 340.65 324.90 309.15 292.95 276.30 259.43 243.00 226.35
Inflows
Annuity 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Interest 21.75 21.29 20.82 20.33 19.83 19.31 18.78 18.23 17.67 17.08 16.48 15.87 15.23 14.57 13.90
Total Inflows 34.35 34.31 34.26 34.19 34.11 34.01 33.90 33.83 33.75 33.64 33.52 33.45 33.35 33.23 33.10
Outflow
Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Interest Cost  18.56 18.10 17.57 17.02 16.46 15.88 15.28 14.67 14.05 13.40 12.75 12.08 11.40 10.70 10.02
Total Outflows 29.81 30.92 30.84 30.52 30.64 30.51 29.90 29.75 29.80 29.15 28.95 28.73 28.27 27.13 26.67

Net Cash Flows ‐120 4.54 3.39 3.42 3.67 3.47 3.51 4.00 4.08 3.95 4.49 4.57 4.71 5.08 6.11 6.42
DSCR 1.15 1.11 1.11 1.12 1.11 1.12 1.13 1.14 1.13 1.15 1.16 1.16 1.18 1.23 1.24

Date 31‐Mar‐28 30‐Sep‐28 31‐Mar‐29 30‐Sep‐29 31‐Mar‐30 30‐Sep‐30 31‐Mar‐31 30‐Sep‐31 31‐Mar‐32 30‐Sep‐32 31‐Mar‐33 30‐Sep‐33 31‐Mar‐34 30‐Sep‐34 31‐Mar‐35
Annuity Schedule 3.30% 3.40% 3.50% 3.61% 3.72% 3.83% 3.94% 4.06% 4.18% 4.25% 4.25% 4.44% 4.71% 4.75% 4.75%
Annuity amount 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Outstanding Annuity  344.34 323.94 302.94 281.28 258.96 235.98 212.34 187.98 162.90 137.40 111.90 85.26 57.00 28.50 0.00
Debt Schedule 3.75% 3.85% 3.95% 4.00% 4.10% 4.20% 4.25% 4.10% 4.10% 4.10% 4.10% 5.80% 0.00% 0.00% 0.00%
Debt Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Outstanding Debt 209.48 192.15 174.38 156.38 137.93 119.03 99.90 81.45 63.00 44.55 26.10 0.00
Inflows
Annuity 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Interest 13.20 12.48 11.74 10.98 10.20 9.39 8.55 7.70 6.81 5.91 4.98 4.06 3.09 2.07 1.03
Total Inflows 33.00 32.88 32.74 32.64 32.52 32.37 32.19 32.06 31.89 31.41 30.48 30.70 31.35 30.57 29.53
Outflow
Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Interest Cost  9.34 8.64 7.93 7.19 6.45 5.69 4.91 4.12 3.36 2.60 1.84 1.08 0.00 0.00 0.00
Total Outflows 26.21 25.97 25.70 25.19 24.90 24.59 24.03 22.57 21.81 21.05 20.29 27.18 0.00 0.00 0.00

Net Cash Flows 6.79 6.92 7.04 7.45 7.62 7.78 8.16 9.49 10.08 10.36 10.19 3.52 31.35 30.57 29.53
DSCR 1.26 1.27 1.27 1.30 1.31 1.32 1.34 1.42 1.46 1.49 1.50 1.13 0.00 0.00 0.00

AVERAGE DSCR 1.22
Count for DSCR less than 1.15 9.00
XIRR 7.91%
 Annexure II (C ) ‐ DSCR & IRR Calculation

Case 3 ‐ MCLR as Benchmark 

Annuity Receivable 600 Case Particulars IRR  % Change 

Debt  75% 450 1 At Bidding Stage 13.44% 0
Equity 20% 120 2 Post COD 7.91% ‐41.13%
MCLR @ First annuity  7.25% 3 MCLR as Benchmark 11.08% ‐17.61%
HAM ROI  8.10% * Spread to be kept similar to spread at time of Bidding 4 G Sec Benchmark 11.74% ‐12.68%
Bank MCLR 7.25%
Spread during Construction  1.25%
Spread after COD 1.00%
Cost of Debt During Construction  8.50%
Cost of Debt Post COD 8.25%

Date 31‐Mar‐20 30‐Sep‐20 31‐Mar‐21 30‐Sep‐21 31‐Mar‐22 30‐Sep‐22 31‐Mar‐23 30‐Sep‐23 31‐Mar‐24 30‐Sep‐24 31‐Mar‐25 30‐Sep‐25 31‐Mar‐26 30‐Sep‐26 31‐Mar‐27 30‐Sep‐27
Annuity Schedule 2.10% 2.17% 2.24% 2.31% 2.38% 2.45% 2.52% 2.60% 2.68% 2.76% 2.84% 2.93% 3.02% 3.11% 3.20%
Annuity amount 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Outstanding Annuity  600 587.40 574.38 560.94 547.08 532.80 518.10 502.98 487.38 471.30 454.74 437.70 420.12 402.00 383.34 364.14
Debt Schedule 2.50% 2.85% 2.95% 3.00% 3.15% 3.25% 3.25% 3.35% 3.50% 3.50% 3.60% 3.70% 3.75% 3.65% 3.70%
Debt Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Outstanding Debt 450 438.75 425.93 412.65 399.15 384.98 370.35 355.73 340.65 324.90 309.15 292.95 276.30 259.43 243.00 226.35
Inflows
Annuity 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Interest 24.30 23.79 23.26 22.72 22.16 21.58 20.98 20.37 19.74 19.09 18.42 17.73 17.01 16.28 15.53
Total Inflows 36.90 36.81 36.70 36.58 36.44 36.28 36.10 35.97 35.82 35.65 35.46 35.31 35.13 34.94 34.73
Outflow
Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Interest Cost  18.56 18.10 17.57 17.02 16.46 15.88 15.28 14.67 14.05 13.40 12.75 12.08 11.40 10.70 10.02
Total Outflows 29.81 30.92 30.84 30.52 30.64 30.51 29.90 29.75 29.80 29.15 28.95 28.73 28.27 27.13 26.67

Net Cash Flows ‐120 7.09 5.89 5.86 6.06 5.80 5.77 6.20 6.22 6.02 6.50 6.50 6.57 6.86 7.81 8.05
DSCR 1.24 1.19 1.19 1.20 1.19 1.19 1.21 1.21 1.20 1.22 1.22 1.23 1.24 1.29 1.30

Date 31‐Mar‐28 30‐Sep‐28 31‐Mar‐29 30‐Sep‐29 31‐Mar‐30 30‐Sep‐30 31‐Mar‐31 30‐Sep‐31 31‐Mar‐32 30‐Sep‐32 31‐Mar‐33 30‐Sep‐33 31‐Mar‐34 30‐Sep‐34 31‐Mar‐35
Annuity Schedule 3.30% 3.40% 3.50% 3.61% 3.72% 3.83% 3.94% 4.06% 4.18% 4.25% 4.25% 4.44% 4.71% 4.75% 4.75%
Annuity amount 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Outstanding Annuity  344.34 323.94 302.94 281.28 258.96 235.98 212.34 187.98 162.90 137.40 111.90 85.26 57.00 28.50 0.00
Debt Schedule 3.75% 3.85% 3.95% 4.00% 4.10% 4.20% 4.25% 4.10% 4.10% 4.10% 4.10% 5.80% 0.00% 0.00% 0.00%
Debt Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Outstanding Debt 209.48 192.15 174.38 156.38 137.93 119.03 99.90 81.45 63.00 44.55 26.10 0.00
Inflows
Annuity 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Interest 14.75 13.95 13.12 12.27 11.39 10.49 9.56 8.60 7.61 6.60 5.56 4.53 3.45 2.31 1.15
Total Inflows 34.55 34.35 34.12 33.93 33.71 33.47 33.20 32.96 32.69 32.10 31.06 31.17 31.71 30.81 29.65
Outflow
Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Interest Cost  9.34 8.64 7.93 7.19 6.45 5.69 4.91 4.12 3.36 2.60 1.84 1.08 0.00 0.00 0.00
Total Outflows 26.21 25.97 25.70 25.19 24.90 24.59 24.03 22.57 21.81 21.05 20.29 27.18 0.00 0.00 0.00

Net Cash Flows 8.34 8.38 8.42 8.74 8.81 8.88 9.16 10.39 10.88 11.05 10.78 4.00 31.71 30.81 29.65
DSCR 1.32 1.32 1.33 1.35 1.35 1.36 1.38 1.46 1.50 1.52 1.53 1.15 0.00 0.00 0.00

AVERAGE DSCR 1.28
Count for DSCR less than 1.15 1.00
XIRR 11.08%
 Annexure II (D) ‐ DSCR & IRR Calculation

Case 4 ‐ G‐Sec Rate as Benchmark 

Annuity Receivable 600 Case Particulars IRR  % Change 

Debt  75% 450 1 At Bidding Stage 13.44% 0
Equity 20% 120 2 Post COD 7.91% ‐41.13%
G Sec Rate @ First Annuity 5.75% 3 MCLR as Benchmark 11.08% ‐17.61%
HAM ROI  8.27% * Spread to be kept similar to spread at time of Bidding 4 G Sec Benchmark 11.74% ‐12.68%
Bank MCLR 7.25%
Spread during Construction  1.25%
Spread after COD 1.00%
Cost of Debt During Construction  8.50%
Cost of Debt Post COD 8.25%

Date 31‐Mar‐20 30‐Sep‐20 31‐Mar‐21 30‐Sep‐21 31‐Mar‐22 30‐Sep‐22 31‐Mar‐23 30‐Sep‐23 31‐Mar‐24 30‐Sep‐24 31‐Mar‐25 30‐Sep‐25 31‐Mar‐26 30‐Sep‐26 31‐Mar‐27 30‐Sep‐27
Annuity Schedule 2.10% 2.17% 2.24% 2.31% 2.38% 2.45% 2.52% 2.60% 2.68% 2.76% 2.84% 2.93% 3.02% 3.11% 3.20%
Annuity amount 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Outstanding Annuity  600 587.40 574.38 560.94 547.08 532.80 518.10 502.98 487.38 471.30 454.74 437.70 420.12 402.00 383.34 364.14
Debt Schedule 2.50% 2.85% 2.95% 3.00% 3.15% 3.25% 3.25% 3.35% 3.50% 3.50% 3.60% 3.70% 3.75% 3.65% 3.70%
Debt Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Outstanding Debt 450 438.75 425.93 412.65 399.15 384.98 370.35 355.73 340.65 324.90 309.15 292.95 276.30 259.43 243.00 226.35
Inflows
Annuity 12.60 13.02 13.44 13.86 14.28 14.70 15.12 15.60 16.08 16.56 17.04 17.58 18.12 18.66 19.20
Interest 24.81 24.29 23.75 23.19 22.62 22.03 21.42 20.80 20.15 19.49 18.80 18.10 17.37 16.62 15.85
Total Inflows 37.41 37.31 37.19 37.05 36.90 36.73 36.54 36.40 36.23 36.05 35.84 35.68 35.49 35.28 35.05
Outflow
Repayment 11.25 12.83 13.28 13.50 14.18 14.63 14.63 15.08 15.75 15.75 16.20 16.65 16.88 16.43 16.65
Interest Cost  18.56 18.10 17.57 17.02 16.46 15.88 15.28 14.67 14.05 13.40 12.75 12.08 11.40 10.70 10.02
Total Outflows 29.81 30.92 30.84 30.52 30.64 30.51 29.90 29.75 29.80 29.15 28.95 28.73 28.27 27.13 26.67

Net Cash Flows ‐120 7.60 6.39 6.35 6.53 6.26 6.23 6.64 6.65 6.43 6.90 6.89 6.94 7.22 8.16 8.38
DSCR 1.25 1.21 1.21 1.21 1.20 1.20 1.22 1.22 1.22 1.24 1.24 1.24 1.26 1.30 1.31

Date 31‐Mar‐28 30‐Sep‐28 31‐Mar‐29 30‐Sep‐29 31‐Mar‐30 30‐Sep‐30 31‐Mar‐31 30‐Sep‐31 31‐Mar‐32 30‐Sep‐32 31‐Mar‐33 30‐Sep‐33 31‐Mar‐34 30‐Sep‐34 31‐Mar‐35
Annuity Schedule 3.30% 3.40% 3.50% 3.61% 3.72% 3.83% 3.94% 4.06% 4.18% 4.25% 4.25% 4.44% 4.71% 4.75% 4.75%
Annuity amount 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Outstanding Annuity  344.34 323.94 302.94 281.28 258.96 235.98 212.34 187.98 162.90 137.40 111.90 85.26 57.00 28.50 0.00
Debt Schedule 3.75% 3.85% 3.95% 4.00% 4.10% 4.20% 4.25% 4.10% 4.10% 4.10% 4.10% 5.80% 0.00% 0.00% 0.00%
Debt Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Outstanding Debt 209.48 192.15 174.38 156.38 137.93 119.03 99.90 81.45 63.00 44.55 26.10 0.00
Inflows
Annuity 19.80 20.40 21.00 21.66 22.32 22.98 23.64 24.36 25.08 25.50 25.50 26.64 28.26 28.50 28.50
Interest 15.06 14.24 13.39 12.53 11.63 10.71 9.76 8.78 7.77 6.74 5.68 4.63 3.53 2.36 1.18
Total Inflows 34.86 34.64 34.39 34.19 33.95 33.69 33.40 33.14 32.85 32.24 31.18 31.27 31.79 30.86 29.68
Outflow
Repayment 16.88 17.33 17.78 18.00 18.45 18.90 19.13 18.45 18.45 18.45 18.45 26.10 0.00 0.00 0.00
Interest Cost  9.34 8.64 7.93 7.19 6.45 5.69 4.91 4.12 3.36 2.60 1.84 1.08 0.00 0.00 0.00
Total Outflows 26.21 25.97 25.70 25.19 24.90 24.59 24.03 22.57 21.81 21.05 20.29 27.18 0.00 0.00 0.00

Net Cash Flows 8.65 8.67 8.69 8.99 9.05 9.10 9.36 10.57 11.04 11.19 10.89 4.09 31.79 30.86 29.68
DSCR 1.33 1.33 1.34 1.36 1.36 1.37 1.39 1.47 1.51 1.53 1.54 1.15 0.00 0.00 0.00

AVERAGE DSCR 1.29
Count for DSCR less than 1.15 0.00
XIRR 11.74%