Using excel!

Question 3: Compare the alternatives shown below on the basis of their capitalized costs, using an interest rate of 14% per year a) What is the annual worth of the first cost for Project A? b) What is the annual worth of the first cost for Project B ? c) What is the annual worth of the first cost for Project C? d) What is the annual worth of the salvage value for Project A? e) What is the annual worth of the salvage value for Project B ? f) What is the annual worth of the salvage value for Project C ? g) What is the total annual worth for Project A? h) What is the total annual worth for Project B? i) What is the total annual worth for Project C? j) What is the Capital cost of Project A? k) What is the Capital cost of Project B? I) What is the Capital cost of Project C? m) Which project would you select? Question 3: Compare the alternatives shown below on the basis of their capitalized costs, using an interest rate of 14% per year a) What is the annual worth of the first cost for Project A? b) What is the annual worth of the first cost for Project B ? c) What is the annual worth of the first cost for Project C? d) What is the annual worth of the salvage value for Project A? e) What is the annual worth of the salvage value for Project B ? f) What is the annual worth of the salvage value for Project C ? g) What is the total annual worth for Project A? h) What is the total annual worth for Project B? i) What is the total annual worth for Project C? j) What is the Capital cost of Project A? k) What is the Capital cost of Project B? I) What is the Capital cost of Project C? m) Which project would you select