Week 7- Activity- Project Process

profileAmeychekka
GroupProject1_PrioritizationWorksheet.xlsx

Sheet1

Application Application 1
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (350,000.00) $ 65,000.00 $ 74,750.00 $ 89,700.00 $ 94,785.00 $ 95,126.85
Acceptable Rate of Return 10% $ - 0
Application Application 2
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (275,000.00) $ 52,000.00 $ 62,400.00 $ 68,640.00 $ 70,012.08 $ 71,413.06
Acceptable Rate of Return 10% $ - 0
Application Application 3
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (500,000.00) $ 75,000.00 $ 90,000.00 $ 220,000.00 $ 220,000.00 $ 220,000.00
Acceptable Rate of Return 10% $ - 0
Application Application 4
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (250,000.00) $ 120,000.00 $ 75,000.00 $ 80,000.00 $ 120,000.00 $ 120,000.00
Acceptable Rate of Return 10% $ - 0
Application Application 5
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (300,000.00) $ 130,000.00 $ 143,000.00 $ 145,860.00 $ 160,446.00 $ 170,072.76
Acceptable Rate of Return 10% $ - 0
Application Application 6
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (450,000.00) $ 82,000.00 $ 94,300.00 $ 95,243.00 $ 96,195.43 $ 100,043.25
Acceptable Rate of Return 10% $ - 0
Application Application 7
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (750,000.00) $ 230,000.00 $ 287,500.00 $ 301,875.00 $ 316,968.75 $ 323,308.13
Acceptable Rate of Return 10% $ - 0
Application Application 8
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (550,000.00) $ 325,000.00 $ 325,000.00 $ 93,330.00 $ 100,796.40 $ 103,820.29
Acceptable Rate of Return 10% $ - 0
Application Application 9
Year 0 1 2 3 4 5 Column2 Column1
Nominal Amount $ (250,000.00) $ 65,000.00 $ 85,800.00 $ 88,374.00 $ 93,676.44 $ 95,549.97
Acceptable Rate of Return 10% $ - 0