Dewars Inc. is considering two mutually exclusive projects with widely differing lives. The company's cost of capital is 11%. The project cash flows are summarized as follows:

Project A Project B

C₀ ($30,000) ($30,000)

C₁ $17,000 $ 7,500

C₂ $17,000 $ 7,500

C₃ $17,000 $ 7,500

C₄ $ 7,500

C₅ $ 7,500

C₆ $ 7,500

C₇ $ 7,500

C₈ $ 7,500

C₉ $ 7,500

a. Compare the projects by using Payback.

_____________________________________________________________________________________________

b.Compare the projects by using NPV.

_____________________________________________________________________________________________

c.Compare the projects by using IRR.

d.Chose a project and justify your choice.

___________________________________________________________________________

(Advice on how to solve these problems using excel is appreciated)