- Please Use Excel And Show Functions Used 1 (46.75 KiB) Viewed 28 times
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
3. (20 points) Three public investment proposals with the same service life are under consideration: P1, P2, and P3. Their respective total benefits, initial investment, and recurring costs are given as present worth: Present Worth Proposal P1 Proposal P2 Proposal P3 B $40,000 $80,000 $60,000 1 $10,000 $30,000 $20,000 C' $10,000 $20,000 $14,000 a) Do all proposals have an acceptable B/C ratio? b) If there is no do-nothing alternative, which proposal would you select based on incremental investment?
3. (20 points) Three public investment proposals with the same service life are under consideration: P1, P2, and P3. Their respective total benefits, initial investment, and recurring costs are given as present worth: Present Worth Proposal P1 Proposal P2 Proposal P3 B $40,000 $80,000 $60,000 1 $10,000 $30,000 $20,000 C' $10,000 $20,000 $14,000 a) Do all proposals have an acceptable B/C ratio? b) If there is no do-nothing alternative, which proposal would you select based on incremental investment?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!