can you solve this for me please, all i need here is the formulas you use on excel to resolve the problem.

The discount nte is 13%. Diplay formular thed (1) Calculate NPVs for both project A and Project B. (10 points) (2) Mnke a Data Table to corspare the NOVs for project A and project B when discount nate vanes from 2%, to 2096 , incermenting by 29 e. Make a concected icatler dourt with dafterest discoust rates and both series of NpVi calculased an the same chart (10 points) (3) Binefly discts two quetions bolow (10 pointi) (a) When discount rase ts 13%, which project shoald Goodgrade invest in? Why? (b) Bused on the slopes in the groph, Whach project's NPV is more unnative to changes in discount ralem Can you discuss the reasen in terms of the differeoce betineen the it easb thows? The discount nte is 13%. Diplay formular thed (1) Calculate NPVs for both project A and Project B. (10 points) (2) Mnke a Data Table to corspare the NOVs for project A and project B when discount nate vanes from 2%, to 2096 , incermenting by 29 e. Make a concected icatler dourt with dafterest discoust rates and both series of NpVi calculased an the same chart (10 points) (3) Binefly discts two quetions bolow (10 pointi) (a) When discount rase ts 13%, which project shoald Goodgrade invest in? Why? (b) Bused on the slopes in the groph, Whach project's NPV is more unnative to changes in discount ralem Can you discuss the reasen in terms of the differeoce betineen the it easb thows