Develop s spreadsheet and use weighed score model to choose between three methods of a,b,c of financing the acquisition of a major competitor

Business Sep 15, 2020

Develop s spreadsheet and use weighed score model to choose between three methods of a,b,c of financing the acquisition of a major competitor. The relative weights for each are shown in the following table as are the scores for each location on each criterion. A score of 1 represent unfavorable, 2 and 3 favorable.
category weight A B C
cost. 20. 1 2 3
risk. 20. 2. 3 1
opportunity 10. 2 1 3
profitability. 10. 3 3 2
sustainability 10 2 1 1
safety 25 1 2 3
competitiveness 10 2 2 2