using excel

8-15 Evaluate these mutually exclusive alternatives with a horizon of 15 years and a MARR of 12%. A B Initial investment Annual savings Annual costs $9,500 3,200 1,000 6,000 $18,500 5,000 2,750 4,200 $22,000 9,800 6,400 14,000 Salvage value Use the following: (a) Conventional B/C ratio (b) Modified B/C ratio (c) Present worth analysis (d) Internal rate of return analysis (e) Payback period