Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PPN NUMBER GENERATION STATION 1: 100005 DESCRIPTION START DATE COMPLETION DATE PROJECT_TOTAL_COST Capital Percent IDC XYZ COST 2011 CASH FLOW 2011 Q1 2011 Q2
PPN NUMBER GENERATION STATION 1: 100005 DESCRIPTION START DATE COMPLETION DATE PROJECT_TOTAL_COST Capital Percent IDC XYZ COST 2011 CASH FLOW 2011 Q1 2011 Q2 2011 Q3 2011 Q4 2012 Q1 2012 Q2 2012 Q3 2012 Q4 2012 Project 04/01/2011 08/01/2011 479,980 100% 4,167 $ 100033 Project 2 02/01/2009 12/01/2014 2,682,765 100% 81,170 484,147 $ 2,763,935 484,148 259,967 2,402 128,531 14,017 355,617 51,931 100034 Project 3 01/01/2011 12/01/2011 225,917 100% 225,917 225,917 191,617 225,917 510,319 875,249 830,030 288,368 2,503,966 100038 Project 4 01/01/2011 09/01/2011 507,590 100% 16,830 524,420 524,419 285,982 194,612 43,825 100061 Project 5 01/01/2011 04/01/2011 35,094 100% 35.094 35,093 22,248 12,845 100080 Project 6 01/01/2011 06/01/2011 30,597 100% 30,597 30,598 3,594 27,004 100099 Project 7 01/01/2011 05/01/2011 190,038 100% 100101 Project 8 01/01/2011 12/01/2011 3,339,386 100% 100,182 190,038 3,439,568 190,037 50,698 139,339 3,439,566 359,602 1,326,233 1,347,658 406,073 100001 Project 9 01/01/2011 12/01/2011 295,592 100% 7,390 302,982 302,980 31,803 117,183 118,763 35,231 100018 Project 10 01/01/2008 06/01/2015 3,076,392 27% 112,134 942,760 69,053 5,601 10,610 20,031 32,811 100027 Project 11 04/01/2009 12/01/2014 1,239,446 100% 54,226 1,293,672 459,673 38,815 144,123 276,735 47,492 338.459 62,386 284,483 75,780 157,117 86,141 53,938 271,799 833,997 100053 Project 12 01/01/2011 10/01/2011 449,823 100% 7,103 456,926 456,926 6,802 113.912 309,738 26.474 100092 Project 13 01/01/2011 09/01/2011 191,448 100% 4,308 195,756 195,756 40,327 112,623 42,806 100093 Project 14 01/01/2011 12/01/2011 101,990 100% 3,060 105,050 105,047 10,982 40,505 41,158 12.402 100050 Project 15 01/01/2011 12/01/2011 118,818 100% 3,921 122,739 122,741 12,802 47,240 48,078 14,621 STATION 1 TOTAL $ 394,491 $ 11,113,601 $ 6,901,921 $ 832,843 $ 2,323,469 $ 2,523,728 $ 1,221,881 $ 896,270 $ 1,222,118 $ 1,062,927 $ 428,447 $ 3,609,762 STATION 2: 150070 150082 150050 Project 1 01/01/2011 12/01/2011 35,907 100% $ Project 2 01/01/2011 12/01/2011 197,677 100% 35,907 $ 197,677 35,907 197,677 35,907 - 150017 Project 3 Project 4 01/01/2009 12/01/2012 2,513,480 100% 100,384 2,613,864 362,859 5,047 19,916 77,120 197,677 260,776 606,343 876,966 638,812 128,884 2,251,005 01/01/2011 12/01/2011 384,786 100% 3,037 387,823 387,823 16,975 370,848 150018 Project 5 01/01/2011 12/01/2011 822,513 100% 11,690 834,203 834,205 17,849 325,299 STATION 2 TOTAL $ 115,111 $ 4,069,474 $ 1,818,471 $ 491,057 75,778 $ 716.063 $ 568,177 $ 458,453 $ 606,343 $ 876,966 $ 638,812 $ 128,884 $2,251,005 STATION 3: 200022 Project 01/01/2011 12/01/2011 1,245,607 100% $ 200052 Project 2 01/01/2009 12/01/2012 4,623,597 100% 74,043 526,518 $ 2,028,437 526,518 232,250 3,600 200053 Project 3 01/01/2011 12/01/2011 1,027,466 100% 8,229 442,539 442,537 3,810 13,621 47,509 49,541 526,518 165,488 398,145 631,266 568,323 198,451 1,796,185 226,566 164,652 200054 200020 Project 4 01/01/2011 12/01/2011 154,120 100% 1,234 66,380 66,384 573 7,127 33,986 24,698 Project 5 01/01/2010 12/01/2014 8,039,389 100% 128,745 3,526,995 403,832 6,260 23,686 86,139 287,747 STATION 3 TOTAL $ 212,251 $ 6,590,869 $ 1,671,521 $ 14,243 $ 91,943 $ 396,232 $ 692,285 1,097,631 1,169,103 $ 1,090,430 $ 1,728,897 $ 988,186 1,556,509 $ 345,061 3,123,163 543,512 $ 4,919,348 GENERATION TOTAL $ 721,853 $ 21,773,944 $ 10,391,913 $ 922,864 $ 3,131,475 $ 3,488,137 $ 2,849,437 $ 2,593,043 $ 3,827,981 $ 3,258,248 $ 1,100,843 $ 10,780,115 PPN NUMBER HEADQUARTERS DESCRIPTION START DATE COMPLETION DATE PROJECT TOTAL COST Capital Percent IDC XYZ COST 2011 CASH FLOW 450028 Project 01/01/2011 12/01/2011 36,915 100% $ 450029 Project 2 01/01/2011 12/01/2011 36,915 100% 36,915 $ 36,915 36,915 36,915 36,915 36,915 450030 Project 3 01/01/2011 12/01/2011 8,560 100% 8,560 8.560 8,560 450031 Project 4 01/01/2011 12/01/2011 8,560 100% 8,560 8,560 8,560 450032 Project 5 01/01/2011 12/01/2011 6,420 100% 6,420 6,420 6,420 450033 Project 6 01/01/2011 12/01/2011 6.420 100% 6,420 6,420 6,420 450431 Project 7 01/01/2011 12/01/2011 42,800 100% 42.800 42,800 42,800 450435 Project 8 01/01/2011 12/01/2011 21,400 100% 203 21,603 21,601 2.521 19,080 450005 Project 9 01/01/2011 12/01/2011 165,315 100% 165.315 165,315 165,315 450347 Project 10 01/01/2011 12/01/2011 32,100 100% 32.100 32,100 32,100 450348 Project 11 01/01/2011 12/01/2011 32,100 100% 32,100 32,100 32,100 450349 Project 12 01/01/2011 12/01/2011 35,033 100% 35,033 35,033 35,033 450350 Project 13 01/01/2011 12/01/2011 34,775 100% 34,775 34,775 34,775 450314 Project 14 01/01/2011 12/01/2011 1,786,900 100% 1,786,900 1,786,900 1,786,900 450432 Project 15 01/01/2011 12/01/2011 58,850 100% HEADQUARTERS TOTAL $ 203 $ 58,850 2,313,266 $ 58,850 58,850 2,313,264 $ HEADQUARTERS TOTAL TRANSMISSION $ 203 $ 2,313,266 $ 2,313,264 $ 170,511 $ 170,511 $ 190,538 $ $ 1,952,215 $ $ $ $ $ 190,538 $ $ 1,952,215 $ $ $ $ $ TRANS 1 250099 Project 1 01/01/2011 12/01/2011 171,374 100% TRANS 1 TOTAL $ 1,468 1,468 $ 85,956 85,956 $ 85,954 85,954 $ 1,278 1,278 $ 21,409 21,409 $ 58,254 58.254 $ 5,013 5,013 $ $ $ $ $ TRANS 2 250047 Project 1 01/01/2011 12/01/2011 1,825,649 100% 11,170 $ 782,872 $ 782,870 8,671 126,595 491,298 156,306 250009 Project 2 01/01/2011 12/01/2011 67,685 100% 28,611 28,611 28,611 250082 Project 3 01/01/2011 12/01/2011 54,117 100% 22,875 22.875 22,875 250120 Project 4 01/01/2011 12/01/2011 118,230 100% 1,649 51,625 51,624 5,385 19,869 20,222 6,148 250129 Project 5 01/01/2011 12/01/2011 54,060 100% 22,851 22,851 22,851 250135 Project 6 01/01/2011 12/01/2011 513,158 100% 216,912 216,912 216,912 250137 Project 7 01/01/2011 12/01/2011 56,331 100% TRANS 2 TOTAL $ 12,819 $ 23,811 1,149,557 $ 23,810 1,149,553 $ 14,056 $ 146,464 $ 511,520 $ 23,810 477,513 $ $ $ $ $ PPN NUMBER DESCRIPTION START DATE COMPLETION DATE PROJECT TOTAL_COST Capital Percent IDC XYZ COST 2011 CASH FLOW TRANS 2 CONT. 250028 250043 Project 8 Project 9 01/01/2008 12/01/2013 17,046,294 100% 01/01/2011 12/01/2011 43,564 100% 250044 Project 10 01/01/2008 12/01/2014 11,697,378 100% 526,382 250046 Project 11 01/01/2011 12/01/2011 987,201 100% 15,587 250053 Project 12 01/01/2011 12/01/2011 96,074 100% 1,517 250005 Project 13 01/01/2008 12/01/2013 8,127,379 100% 245,903 250008 Project 14 01/01/2011 12/01/2011 127,207 100% 250012 Project 15 01/01/2011 12/01/2011 42,081 100% 968,668 $ 18,014,962 $ 43,564 12,223,760 1,002,788 97,591 8,373,282 127,207 42,081 374,005 43,564 2,474,899 14,081 43,075 93,709 1,002,791 8,656 107,877 505,164 514,151 97,589 1,169,692 127,207 1,453 24,329 16,298 64,228 66,153 248,655 223,140 43,564 1,969,735 372,107 5,654 840,511 531,490 1,131,863 2,059,801 3,133,784 3,458,001 3,510,938 2,104,852 675,073 6,856,938 9,748,864 1,952,497 2,817,881 2,037,792 395,423 7,203,593 127,207 42,081 42,081 250015 Project 16 01/01/2011 12/01/2011 180,932 100% 2,571 183,503 183.505 1,167 33.293 135,957 13,088 250021 Project 17 01/01/2009 12/01/2013 169,950 100% 3,488 173,438 6,398 477 250022 Project 18 01/01/2010 12/01/2013 3,790,761 100% 179,514 250023 Project 19 01/01/2009 12/01/2015 3,837,623 100% 199,904 3,970,275 4,037,527 168,986 4,478 14,592 38,705 60,522 441 250032 Project 20 01/01/2011 12/01/2011 1,520,710 100% 28,813 1,549,523 250035 Project 21 01/01/2008 12/01/2014 4,203,859 100% 295,917 250089 Project 22 01/01/2011 12/01/2011 39,460 100% 250094 Project 23 01/01/2011 12/01/2011 193,140 100% 6,374 4.499,776 39.460 199,514 1,549,525 1,628,706 39,460 13,343 6,215 166,350 15,571 793,312 488,214 - 5,921 111,211 38,295 576,520 1,140,492 39,460 44,584 282,784 100,248 97,653 576,681 237,460 24,802 905.582 470,551 167,039 1,031,918 756,107 2,796,965 1,564,366 1,101,640 820,573 509,790 269,997 2,702,000 199,514 20,808 250100 Project 24 01/01/2011 12/01/2011 160,923 100% 2,795 163,718 163,719 2,436 76,789 40,776 78,152 23,765 110,958 9,549 250130 Project 25 01/01/2011 12/01/2011 54,060 100% 54,060 54,060 54,060 250133 Project 26 01/01/2011 12/01/2011 39,385 100% 39,385 39,385 39,385 250134 Project 27 01/01/2011 12/01/2011 56,470 100% 56,470 56,470 56,470 250136 Project 28 01/01/2011 12/01/2011 57,311 100% 57,311 57,311 57,311 250140 Project 29 01/01/2011 12/01/2011 571,408 100% 571,408 571,408 571,408 250142 Project 30 01/01/2011 12/01/2011 102,707 100% 102,707 102,707 21,529 81,178 250219 250227 Project 31 01/01/2011 12/01/2011 92,037 100% 92,037 92,038 804 10,005 47,541 Project 33 01/01/2011 12/01/2011 70,103 100% TRANS 2 TOTAL $ 2,477,433 $ 70,103 55,785,450 $ 70,103 10,375,645 $ 105,494 $ 782,488 $ 3,136,719 $ TRANSMISSION TOTAL $ 2,491,720 $ 57.020.963 $ 11,611,152 $ 120,828 $ 950,361 $ 3,706,493 $ 33,688 70,103 6,350,944 $ 6,833,470 $ 7,471,244 $ 9,193,049 $ 8,113,170 $ 6,262,302 $ 31,039,765 7.471.244 $ 9,193,049 $ 8,113,170 $ 6,262,302 $ 31,039,765 GRAND TOTAL $ 3,213,776 $ 81,108,173 $ 24,316,329 $ 1,214,203 $ 4,272,374 $ 7,194,630 $ 11,635,122 $ 10,064,287 $ 13,021,030 $ 11,371,418 $ 7,363,145 $ 41,819,880
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started