Question: please show how to work in excel spreadsheet. This must be completed with excel so i can learn how to input things into excel for
8s.3 Auburn Recreation and Parks Department is considering two mutually exclu- sive proposals for a new softball complex on a city-owned lot. Alternative Seating Annual Annual Required Design Capacity Benefits Costs Investment A1 3,000 $194,000 $87,500 $800,000 4,000 $220,000 $105.000 A2 $1,000,000 The complex will be useful for 30 years and has no appreciable salvage value (regardless of seating capacity). Assuming an 8% discount rate, which of the following statements is incorrect? (a) Select A1 because it has the largest B/C ratio. (b) Select A1 because it has the most benefits per seating capacity. (c) Select A1 because it has the largest PW. (d) Select A1 because the incremental benefits generated from A2 are not large enough to offset the additional investment ($200,000 more than A1)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
