case analysis 433

Assume your responsibility is to analyze a pool of investment options from around the country. A capital budget with a cap of $435,000 is available. Using Excel, first, analyze the investments individually using three methods and rank them accordingly. Second, consolidate the results for all three methods on a single worksheet for additional analysis.