i did the project all i need the summary report

and here is my project and the instruction for the summary report so please when you write the 2 page summary for the project i attach

U ce lieu 2010. In addition, each student will write a minimum 2-page - maximum 5 page summary report that must include a presentation of each project, an explanation of the analysis supported with graphs and tables, and a final recommendation on which project appears to be most suited. The summary report should have the following structure: 1. Introduction: This section will briefly present each project and compare the cash flow structure. This portion should be accompanied by a graphical representation of each project's cash flows. 2. NPV Analysis: This section will present the Net Present Value analysis. The NPV of each project given the proposed constraints will be presented in table formats, accom- panied with appropriate figures. Explanations must accompany tables and figures. 3. Annual Cash Flow Analysis: This section will present the Annual Cash Flow Analysis analysis. The EUAW of each project given the proposed constraints will be presented in table formats, accompanied with appropriate figures. Explanations must accompany tables and figures. 4. Rate of Return Analysis and Payback Period: This section will present the Rate of Return Analysis. Each project's IRR will be calculated and compared to the proposed rates. You will also calculate each project's discounted payback period. 5. Sensitivity and Risk: This section will use the date described in the sensitivity and risk section and calculate each project's NPV under the available scenario. You should also calculate each project's expected value and standard deviation using the correct probabilities. 6. Conclusion: This section will conclude and give the final recommendation using all available metrics. You can included a discussion on the production capacity of each. Indeed, while a project will seem more attractive than the others, each project pro- duction differs and may need to be considered. Each student will therefore submit two documents: the summary report in PDF format) and the supporting calculations (Excel or package using the analysis). Each document will be graded separately and respectively constitute 50% of the grade. Failure to submit either document will result in a 0 for the whole project. 20.0 C . w w - W HO LRT LUSI HUHE TILL LE TEMPERATURE CH WAKE w LIG IN BASE w WEN SRL ONEC w . M HA AMESILO ELEMENTET ESTI FARMERS TUT BAR SELAMA SEPTEMBRIE CLERC LIRULLILA LE B. RO SAMIR IL TE HETTI UN TTTTTTTTTTTTTHETETLUSTELUT TIT ELITE D . 000 WE HUN ENTRETENIBILITAT ST HONOR TU 4.000.000 LUMIININEN NING Decision Criterion Interest Rate NPV EUAW IRR Payback (in years) Discounted Payback Design A Design B Design C Design D 10.00% 10.00% 10.00% 10.00% $7,872,977 $550,517.56 $5,840,683.76 $6,847,367.38 $924,757 $64,664 $686,045 $804,289.20 10.89% 10.05% 10.77% 10.84% 10.62 13.82227445 10.220593146 11.593824938 18.56 19.93114158 18.603441308 18.89517251 Cash Flows Decision Criterion In Rate o Orden NA 25000 000 2 05 1 90 2.250 000 370.000 19 16 10 12.000.000 0 000 Design Years initial Costa OAM C Banait Salve Value Net CF Discounted CF Payback Discounted Pwyback 0 SS 90 2.750 000 S10 12.500.000 183090 0 S 1150 000 NA NA 54.000,00 05 of DESH CHES 03 + 000 $7,000,000 -17.000.000 17.000.000 387 300 14.100.000 14.454545 192.100.000 1255456 10 100 510 102.290 30 17.12.20 14.4 350 5643 15.30 $4413 223 -57700 3123 35 53.250.000 $11.9129 10 37,36 1443,10 - 6200 1.431,00 440 100 15 $3.500.000 51223771 50 18,721,771 546 SO 158 1763 143940 570011 000 -373737,701 1 1.14 H25 3312 -55142 IM |6oriacous 20 64.100 - HT - 150 $6.05 SAT -54 rest Rate 19.00 ular NA 190.000.000 . 7 1 . 10 0$ 03 120.000 12.00% NA NA Design Years Intial Costa OAN Costs benefits Salvage Value Net CF Discounted CF Paybach Discounted Payback 33.500.000 57022.60 $0 33700.000 $6.213.000 $0 52.515.000 32 072,512 50 14.100.000 1735 33 15 500 000 $3.500,000 $5.500.000 SO 52.000.00 $1.10.182 -16.000000 DO 5300000 1670 121 30 SO -598.000.000 -590.000.000 -100 000 000 30 000 000 15.00 DO 0 11,122,150 12319 14.300.000 os 10 14.6 OS 32.100.215 -573, 512 57027 13.03 1219 5,117 01.10.00 14.100.000 310 19 35.633.33 $310 16 15.18 -375 140 000 $11.490) 30 1670.735 5344 44.54 14.500.000 $12.930,330 30 58030.330 $1,750.407 $57 SOM 10 $5.100.000 3141 10 10.111.443 14.01 HIN - OLOST COL 30 311 31 14.36 2.30 3587 513.110, 11 14 616 DET II WESIS BOSH TH SWT SI 1 Interest 10.00 1 2 3 T 0$ 05 os TO 0$ 12 Gradiere NA $350.000 LDON NA NA 0 Design Years Initial Cote OLM Costs Benefits Salvage Vale Net CF Discounted CF Payback Discounted Paybach $1.000.000 $8.500.000 06 53.350.000 59.180,000 5 $0 1.400.000 $11.954,150 53.700.000 50914400 34.000.000 $10.02 . 30 H0.000 31242.22 55,100,000 $12,02 50 35,450.000 $140 150.000 $16. 380.000,00 30 39 90 380.000.000 300.000.000 0 000.000 -5800000 05 05 06 os 10 10.000 23 30 112 06 of 55.100.000 55,830,000 $5.000.000 1.100 400 000 8.670.000 75.000.000 -570,151 16,214,400 $4.60TI -562.65000 -8512541 1467 14,547.190 3557 S50 37.166.150 340463.377 -40 550 17.11.20 S68.627 HO $52.458 1.188.432 304682 3325007 -S4744054 99 35 300.000 3157000 so 55,932, 54.212.522 -5134954 130 98,117.500 542533 23.388.665 -54300 11 SO H0 000 STRONG 19 $11,500 H1095 120 011 510, 141,532 14,178 121814209 95 Interest Rate Design D Years In Costa OEM Costa 3 s 7 . 10 12 10.00 1 10 32.500.000 $5.500.000 11 10 172.000.000 $0 2 10 $2.950 000 5.1 500 05 05 1410000 1250 06 33.850,000 S71015 $5.200.000 $11150076 36.550.000 51587 TO 450.000 D90 0$ 1110200 0 65 Salvage Value Net CF Discounted CF 0$ $3 400 000 $5.000, 50 11.500.000 $2,675. 12.2013 01 372.000.000 $3,000.00 573 000 000 52.727272 -372.000.000 0.000000 -372.000.000 272.727 $137.500 52.675 520 105 12.500 0 39.101 4300000 38. 9 $4,508,937 $2.800,3 -365 710.5 -SSL.293 13.181055 52.71.610 550.2000 -1200 600 400 $9.91 179 $0 55,161,179 52.913.351 - 430 $55 488.342 1122 to $ 100.000 114.111 BIS 10 SLO 15 13.397.70 US SI $5.850 000 512543.835 50 14.83.835 51210.05 3.3. S4219058F $5.950, $3,063,330 $42.599.312 -$51.05.12 125.2 $30 11 1 $10.00 24 33.0 AT -57 SOTO BE Discounted Payback CALES 226799 ion Criterion 10 11 12 CH 14 16 17 18 $ US 20 15 $0 35.300 000 120 739 08 3320 111,112515 0 17519 181 SES 4952 10 34.500.000 338 383.429 $3.500 000 112723773 30 18.721.771 S4614 540.520 350 30 3 750 000 $13148 10 39.636,140 4523303 10272 356202 $4.000000 $14,70 30 $10,710 TS 545307 -2006 HEMS 54.250,000 510 2009 30 $1201889 14.64 8. 24 $6.000.000 531705314 10 so 35.000.000 521.685,150 $0 $16,455.150 H2405 $370, 714 2005 54 $57.895823 SO $13,0823 $4,095 50 35.115.085 -537 193 05 34.750.000 SI5 19 $14.916. SOS $4,750.231 $20.051.558 SU 150.000 123.820,671 99 $16.50 671 H40 20 558.2775 -52311310 TO DO 128 123,012 $9 523,073.012 $80200 590.033.1 3131377 530 702,73 $ 575.580.124 318.150.2 PIESES 18.250 000 47 MS 0 528 625845 55 148,510 3953 35429 -0.001 te 50.000 $42.1 120.000 S42 SO 1222 17.12.1 53136418 35200.25 $185.7724 32.300.30 S. 51249 30522 10 O 05 17 01 00015 CELSIONS 14.700.000 111450 735 12 SO 55,700.000 $21,007 238 54.900.000 12,009.30 1 50 56.100.000 52499901 15 . 56.300,000 330 441 0$ 16 30 58.500.000 1.700.000 18870.290 $0 37.100.000 150414 05 11 $0 35.500.000 $18.619, 121 10 513.170.121 1466007 31952250 -5544 55100 000 $140.43 30 $51.443 Hot 34201610 $700.000 358 06 55,100 000 SSN 231 9 $11,222.231 543211 $320 09 35.631.3 5,17,104 11 12 30 55.500,000 R3877 15 517,18 377 $5. $13.8154 544 05 05 16.7.TS 314641 1454 0$ DS 02.10 53710 407 -53,000 -547,144 000 000 $ SERVELESS $15.37.229 H4906034 -54.134.00 -87519 120.833,00 55 487 576 134,854915 3273 $24141,139 15.779.97 55. MOSA -1 127,308,487 56.071 524 S05.04542 527 2.6 30 H.D.000 23.420 19 $17,021,425 . $15.08.200 $14.99 $13,170.230 $8.354.720 $15832 121054 142,533.474 $6.9545 17.994620 $198421734 $352 207580 . 7 . 12 0 13 0$ 16 13 21 SU 600 10 30 50.150,000 316 30 15.100.000 5112 50 11 10 9.500,000 31.10.12 0$ $2200 000 321.434,440 15 so 37.500.000 524146 30 15 500.000 $15.732.SOT so 10.332.907 1422.522 30. 30 38.250.000 26.37 39100 000 $23.00, 180 $ os 55.450 DOO $147.500 59 11.11.30 S4234 12 3230 05 14 30 57.550.000 22.116.30 30 $15.564.502 54.990 225 $31.996.23 512.00 06 5.850.000 $19. 30 $12.68,331 54.132 122.2005 126 12.00 05 It 17 TB 19 18.600.000 380.000 $31.460.153 0 $20,520,512 $22.500,153 54,00 S016. 3108276.593077702 -50.000 510.845,50 $478.33 20142 54345 53301 547 05 311850.342 54.163.655 $9.2300 -33114480 $14.204.446 22 136.410.000 $17.056,145 $40.500 $19.02.08 11401300 11071,437 54,072 SO 547756.606 -S10 543 39.000 450 31. 18.534 0241 $14.06.168 54033115 $11.23 $1,50916 11 13 10 14 05 10 20.000 Str. 1 DOCTORS 30 $8.350,000 30 37.900.000 $22.904,30 $0 10.000 35.876,702 SO 30.325,72 33.94 100.000 11411315 30 18.01.18 13.772 95 HERS 51210025 17 SLT 31.053 0312 17.000.000 517200 30 $10.200 18.606.457 9 13 50 STO 500 000 145.225.500 17450.000 $200,00 50 312.643,735 2825 55.135.100 114017 15 $ H.100,000 SMO SO $13.00 62 14.142.00 720229 16 17 18 SO 10 10 1.200,000 19 T0 000 $1,150.000 $32.11.17 536.207 10.733.00 30 10 30 $22.4 157376 136,583.800 14,90 55 24442 55.000 93.00 $101.70.361 36675414 $ $17. H49684 $1470419 54.341 $19.30 5301120 300.000 151.53 30.000 H00172 56.241 CC 32 322629 $35 233.1 15 5171 656 PCS DEVUS 3341 342 EPI U ce lieu 2010. In addition, each student will write a minimum 2-page - maximum 5 page summary report that must include a presentation of each project, an explanation of the analysis supported with graphs and tables, and a final recommendation on which project appears to be most suited. The summary report should have the following structure: 1. Introduction: This section will briefly present each project and compare the cash flow structure. This portion should be accompanied by a graphical representation of each project's cash flows. 2. NPV Analysis: This section will present the Net Present Value analysis. The NPV of each project given the proposed constraints will be presented in table formats, accom- panied with appropriate figures. Explanations must accompany tables and figures. 3. Annual Cash Flow Analysis: This section will present the Annual Cash Flow Analysis analysis. The EUAW of each project given the proposed constraints will be presented in table formats, accompanied with appropriate figures. Explanations must accompany tables and figures. 4. Rate of Return Analysis and Payback Period: This section will present the Rate of Return Analysis. Each project's IRR will be calculated and compared to the proposed rates. You will also calculate each project's discounted payback period. 5. Sensitivity and Risk: This section will use the date described in the sensitivity and risk section and calculate each project's NPV under the available scenario. You should also calculate each project's expected value and standard deviation using the correct probabilities. 6. Conclusion: This section will conclude and give the final recommendation using all available metrics. You can included a discussion on the production capacity of each. Indeed, while a project will seem more attractive than the others, each project pro- duction differs and may need to be considered. Each student will therefore submit two documents: the summary report in PDF format) and the supporting calculations (Excel or package using the analysis). Each document will be graded separately and respectively constitute 50% of the grade. Failure to submit either document will result in a 0 for the whole project. 20.0 C . w w - W HO LRT LUSI HUHE TILL LE TEMPERATURE CH WAKE w LIG IN BASE w WEN SRL ONEC w . M HA AMESILO ELEMENTET ESTI FARMERS TUT BAR SELAMA SEPTEMBRIE CLERC LIRULLILA LE B. RO SAMIR IL TE HETTI UN TTTTTTTTTTTTTHETETLUSTELUT TIT ELITE D . 000 WE HUN ENTRETENIBILITAT ST HONOR TU 4.000.000 LUMIININEN NING Decision Criterion Interest Rate NPV EUAW IRR Payback (in years) Discounted Payback Design A Design B Design C Design D 10.00% 10.00% 10.00% 10.00% $7,872,977 $550,517.56 $5,840,683.76 $6,847,367.38 $924,757 $64,664 $686,045 $804,289.20 10.89% 10.05% 10.77% 10.84% 10.62 13.82227445 10.220593146 11.593824938 18.56 19.93114158 18.603441308 18.89517251 Cash Flows Decision Criterion In Rate o Orden NA 25000 000 2 05 1 90 2.250 000 370.000 19 16 10 12.000.000 0 000 Design Years initial Costa OAM C Banait Salve Value Net CF Discounted CF Payback Discounted Pwyback 0 SS 90 2.750 000 S10 12.500.000 183090 0 S 1150 000 NA NA 54.000,00 05 of DESH CHES 03 + 000 $7,000,000 -17.000.000 17.000.000 387 300 14.100.000 14.454545 192.100.000 1255456 10 100 510 102.290 30 17.12.20 14.4 350 5643 15.30 $4413 223 -57700 3123 35 53.250.000 $11.9129 10 37,36 1443,10 - 6200 1.431,00 440 100 15 $3.500.000 51223771 50 18,721,771 546 SO 158 1763 143940 570011 000 -373737,701 1 1.14 H25 3312 -55142 IM |6oriacous 20 64.100 - HT - 150 $6.05 SAT -54 rest Rate 19.00 ular NA 190.000.000 . 7 1 . 10 0$ 03 120.000 12.00% NA NA Design Years Intial Costa OAN Costs benefits Salvage Value Net CF Discounted CF Paybach Discounted Payback 33.500.000 57022.60 $0 33700.000 $6.213.000 $0 52.515.000 32 072,512 50 14.100.000 1735 33 15 500 000 $3.500,000 $5.500.000 SO 52.000.00 $1.10.182 -16.000000 DO 5300000 1670 121 30 SO -598.000.000 -590.000.000 -100 000 000 30 000 000 15.00 DO 0 11,122,150 12319 14.300.000 os 10 14.6 OS 32.100.215 -573, 512 57027 13.03 1219 5,117 01.10.00 14.100.000 310 19 35.633.33 $310 16 15.18 -375 140 000 $11.490) 30 1670.735 5344 44.54 14.500.000 $12.930,330 30 58030.330 $1,750.407 $57 SOM 10 $5.100.000 3141 10 10.111.443 14.01 HIN - OLOST COL 30 311 31 14.36 2.30 3587 513.110, 11 14 616 DET II WESIS BOSH TH SWT SI 1 Interest 10.00 1 2 3 T 0$ 05 os TO 0$ 12 Gradiere NA $350.000 LDON NA NA 0 Design Years Initial Cote OLM Costs Benefits Salvage Vale Net CF Discounted CF Payback Discounted Paybach $1.000.000 $8.500.000 06 53.350.000 59.180,000 5 $0 1.400.000 $11.954,150 53.700.000 50914400 34.000.000 $10.02 . 30 H0.000 31242.22 55,100,000 $12,02 50 35,450.000 $140 150.000 $16. 380.000,00 30 39 90 380.000.000 300.000.000 0 000.000 -5800000 05 05 06 os 10 10.000 23 30 112 06 of 55.100.000 55,830,000 $5.000.000 1.100 400 000 8.670.000 75.000.000 -570,151 16,214,400 $4.60TI -562.65000 -8512541 1467 14,547.190 3557 S50 37.166.150 340463.377 -40 550 17.11.20 S68.627 HO $52.458 1.188.432 304682 3325007 -S4744054 99 35 300.000 3157000 so 55,932, 54.212.522 -5134954 130 98,117.500 542533 23.388.665 -54300 11 SO H0 000 STRONG 19 $11,500 H1095 120 011 510, 141,532 14,178 121814209 95 Interest Rate Design D Years In Costa OEM Costa 3 s 7 . 10 12 10.00 1 10 32.500.000 $5.500.000 11 10 172.000.000 $0 2 10 $2.950 000 5.1 500 05 05 1410000 1250 06 33.850,000 S71015 $5.200.000 $11150076 36.550.000 51587 TO 450.000 D90 0$ 1110200 0 65 Salvage Value Net CF Discounted CF 0$ $3 400 000 $5.000, 50 11.500.000 $2,675. 12.2013 01 372.000.000 $3,000.00 573 000 000 52.727272 -372.000.000 0.000000 -372.000.000 272.727 $137.500 52.675 520 105 12.500 0 39.101 4300000 38. 9 $4,508,937 $2.800,3 -365 710.5 -SSL.293 13.181055 52.71.610 550.2000 -1200 600 400 $9.91 179 $0 55,161,179 52.913.351 - 430 $55 488.342 1122 to $ 100.000 114.111 BIS 10 SLO 15 13.397.70 US SI $5.850 000 512543.835 50 14.83.835 51210.05 3.3. S4219058F $5.950, $3,063,330 $42.599.312 -$51.05.12 125.2 $30 11 1 $10.00 24 33.0 AT -57 SOTO BE Discounted Payback CALES 226799 ion Criterion 10 11 12 CH 14 16 17 18 $ US 20 15 $0 35.300 000 120 739 08 3320 111,112515 0 17519 181 SES 4952 10 34.500.000 338 383.429 $3.500 000 112723773 30 18.721.771 S4614 540.520 350 30 3 750 000 $13148 10 39.636,140 4523303 10272 356202 $4.000000 $14,70 30 $10,710 TS 545307 -2006 HEMS 54.250,000 510 2009 30 $1201889 14.64 8. 24 $6.000.000 531705314 10 so 35.000.000 521.685,150 $0 $16,455.150 H2405 $370, 714 2005 54 $57.895823 SO $13,0823 $4,095 50 35.115.085 -537 193 05 34.750.000 SI5 19 $14.916. SOS $4,750.231 $20.051.558 SU 150.000 123.820,671 99 $16.50 671 H40 20 558.2775 -52311310 TO DO 128 123,012 $9 523,073.012 $80200 590.033.1 3131377 530 702,73 $ 575.580.124 318.150.2 PIESES 18.250 000 47 MS 0 528 625845 55 148,510 3953 35429 -0.001 te 50.000 $42.1 120.000 S42 SO 1222 17.12.1 53136418 35200.25 $185.7724 32.300.30 S. 51249 30522 10 O 05 17 01 00015 CELSIONS 14.700.000 111450 735 12 SO 55,700.000 $21,007 238 54.900.000 12,009.30 1 50 56.100.000 52499901 15 . 56.300,000 330 441 0$ 16 30 58.500.000 1.700.000 18870.290 $0 37.100.000 150414 05 11 $0 35.500.000 $18.619, 121 10 513.170.121 1466007 31952250 -5544 55100 000 $140.43 30 $51.443 Hot 34201610 $700.000 358 06 55,100 000 SSN 231 9 $11,222.231 543211 $320 09 35.631.3 5,17,104 11 12 30 55.500,000 R3877 15 517,18 377 $5. $13.8154 544 05 05 16.7.TS 314641 1454 0$ DS 02.10 53710 407 -53,000 -547,144 000 000 $ SERVELESS $15.37.229 H4906034 -54.134.00 -87519 120.833,00 55 487 576 134,854915 3273 $24141,139 15.779.97 55. MOSA -1 127,308,487 56.071 524 S05.04542 527 2.6 30 H.D.000 23.420 19 $17,021,425 . $15.08.200 $14.99 $13,170.230 $8.354.720 $15832 121054 142,533.474 $6.9545 17.994620 $198421734 $352 207580 . 7 . 12 0 13 0$ 16 13 21 SU 600 10 30 50.150,000 316 30 15.100.000 5112 50 11 10 9.500,000 31.10.12 0$ $2200 000 321.434,440 15 so 37.500.000 524146 30 15 500.000 $15.732.SOT so 10.332.907 1422.522 30. 30 38.250.000 26.37 39100 000 $23.00, 180 $ os 55.450 DOO $147.500 59 11.11.30 S4234 12 3230 05 14 30 57.550.000 22.116.30 30 $15.564.502 54.990 225 $31.996.23 512.00 06 5.850.000 $19. 30 $12.68,331 54.132 122.2005 126 12.00 05 It 17 TB 19 18.600.000 380.000 $31.460.153 0 $20,520,512 $22.500,153 54,00 S016. 3108276.593077702 -50.000 510.845,50 $478.33 20142 54345 53301 547 05 311850.342 54.163.655 $9.2300 -33114480 $14.204.446 22 136.410.000 $17.056,145 $40.500 $19.02.08 11401300 11071,437 54,072 SO 547756.606 -S10 543 39.000 450 31. 18.534 0241 $14.06.168 54033115 $11.23 $1,50916 11 13 10 14 05 10 20.000 Str. 1 DOCTORS 30 $8.350,000 30 37.900.000 $22.904,30 $0 10.000 35.876,702 SO 30.325,72 33.94 100.000 11411315 30 18.01.18 13.772 95 HERS 51210025 17 SLT 31.053 0312 17.000.000 517200 30 $10.200 18.606.457 9 13 50 STO 500 000 145.225.500 17450.000 $200,00 50 312.643,735 2825 55.135.100 114017 15 $ H.100,000 SMO SO $13.00 62 14.142.00 720229 16 17 18 SO 10 10 1.200,000 19 T0 000 $1,150.000 $32.11.17 536.207 10.733.00 30 10 30 $22.4 157376 136,583.800 14,90 55 24442 55.000 93.00 $101.70.361 36675414 $ $17. H49684 $1470419 54.341 $19.30 5301120 300.000 151.53 30.000 H00172 56.241 CC 32 322629 $35 233.1 15 5171 656 PCS DEVUS 3341 342 EPI