Public Policy Analysis

profilebrittneydenise
Data1.xlsx
Home>Mathematics homework help>Numerical analysis homework help>Public Policy Analysis

Projec A.

Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 Y10 Y11 Y12 Y13 Y14 Y15
Cost $0.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Benefit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00
Discount Rate 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5%
Discount Factor 0.9524 0.907 0.8638 0.8227 0.7835 0.7462 0.7107 0.6768 0.6446 0.6139 0.5847 0.5568 0.5303 0.5051 0.481

Project B.

Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 Y10 Y11 Y12 Y13 Y14 Y15
Cost $0.00 $100,000,000.00 $0.00 $0.00 $0.00 $0.00
Benefit $0.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00 $50,000,000.00
Discount Rate 5% 5% 5% 5% 5% 5%
Discount Factor 0.9524 0.907 0.8638 0.8227 0.7835

Project C.

Y0 Y1 Y2 Y3 Y4 Y5 Y6 Y7 Y8 Y9 Y10 Y11 Y12 Y13 Y14 Y15
Cost $0.00 $100,000,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Benefit $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00 $20,000,000.00
Discount Rate 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% 5%
Discount Factor 0.9524 0.907 0.8638 0.8227 0.7835 0.7462 0.7107 0.6768 0.6446 0.6139 0.5847 0.5568 0.5303 0.5051 0.481