A company is coesidering two mutualy exctuslve expansion ptans. Phan 4 requires a 539 milion expengiture on a large scale integrated plant that wobld provide expected cach bows of s6.2? milson per year for 20 years, man B requires a 513 million expendeure to build a someveliat less efficient, msin labor tintensive plant weth an-expected cush flow of s2.91 milion per year for 20 . years. The firm's WACC is 11W. The data has been collected in the Micreseft Excel Online file belaw. Open the spireadiheet and perform the required analyis to answer the questions below. Open spresdsheet a. Calcutate each projects tipv, Round your ansmers to two decimal phaces. Do not found your intermed ate calculations. Enter your answers in milions. For example, an anwwer of sto,5so,0o0 should be entered as 10.55 : PanA:5Fana:smilionmiliton: Calculate each project's IrR, Round your answer to two decinal places. PtanA: tan ni: b. Dy graphing the hapV profilas for plan A and plan 8 , approximate the crowsover rate to the neareet percent, c. Calculate the crostover rate where the two projects' woVs are equal: Round your answer to two decimal places. Instructoe: Aipe proties werce 1400% Dan A bran 0 Primet bos Caltalations ifre 1+41 NPY frotlest. oncourt Hates