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

Question

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

Accepted Answer

The Answer is in the image, click to view ...

Question

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

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Personal Finance

Students also viewed these Finance questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question