The dada has been collected in the Mierusuft Excel Orline file below. Open the spreadsheet and perform the required analyeis to ansmer the questions below.

Open spreadsheet

a$.$ What is each project's NPV$?$ Round your afower to the fearest cent. Do fot found your iftiemediate calculations.

Project A: $

Project B: $

b$.$ What is each project's IRo? hound your answer to two decimal places.

Projoct A$.$

&

Project B:

s

Project A:

$\%$

Projoct B:

$s$

d$.$ From your aftiwers to parts $2-$c$,$ which project mould be selected?

$]$

If the WACC mas $18\%,$ which project would be selected?

e$.$ Cofstruct NOV profiles for Projects A and B$.$ Round youf answers to the nearsit cont. Do fot round your intermediate caleulations. Negative value should be indicated by a minus sign.

f$.$ Caloulate the crosisover rate where the two projects' NPVs are equal. Round your afismer to two decimal places. Do not found your imtermediate calculatiofs.

$\%$

Project A$.$

s

Project B: