EIRR (%) = 46.910773670411 Benefit-Cost Ratio Computation Table 11 shows the discounted revenues and costs from year 2007-2012. Table 11. Total incremental revenues and costs discounted at 15%. Total DF @ Year Incremental Total Costs NPV Revenue NPV Cost 15% Revenues - 10,114,318 10,114,318 2007 1.00 26,160,000 10,333,784 22,747,826 8,985,899 2008 0.87 27,468,000 10,800,473 20,769,754 8,166,709 2009 0.76 28,841,400 11,290,497 18,963,689 7,423,685 2010 0.66 30,283,470 10,805,022 17,314,672 6,177,806 2011 0.57 31,797,644 11,345,273 15,809,049 5,640,606 2012 0.50 TOTAL 144,550,514 64,689,367 95,604,990 46,509,024 Given that discounted total revenues and total costs are derived, the formula for calculating BCR is shown as; Hence, BCR = 2.0556224
EIRR (%) = 46.910773670411 Benefit-Cost Ratio Computation Table 11 shows the discounted revenues and costs from year 2007-2012. Table 11. Total incremental revenues and costs discounted at 15%. Year Total Incremental Revenues Total Costs DF @ 15% NPV Revenue NPV Cost 2007 - 10,114,318 1.00 10,114,318 2008 26,160,000 10,333,784 0.87 22,747,826 8,985,899 2009 27,468,000 10,800,473 0.76 20,769,754 8,166,709 2010 28,841,400 11,290,497 0.66 18,963,689 7,423,685 2011 30,283,470 10,805,022 0.57 17,314,672 6,177,806 2012 31,797,644 11,345,273 0.50 15,809,049 5,640,606 TOTAL 144,550,514 64,689,367 95,604,990 46,509,024 Given that discounted total revenues and total costs are derived, the formula for calculating BCR is shown as; Hence, BCR = 2.0556224
sample_3.docx