PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
Posted: Sun May 08, 2022 9:47 am
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?
- Please Use Excel And Show Functions Used 1 (46.75 KiB) Viewed 30 times