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

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 class and test purposes moving forward. please show how to work in excel spreadsheet. This must be completed

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!