Option #1: NPVReview the following data concerning the amount of capital investment and return of investment for two alternative projects.Project/Year01234A-$124,000$32,000$44,000$50,000$50,000B-$211,000$72,000$75,000$77,000$80,000Use Excel to calculate the NPV values for the two projects with the discount rates of 5%, 15% and 20% using proper formula in Excel.Provide a two-page narrative to:Describe the steps you took to calculate the NPV valuesExplain your findingsSpecify which project you would select for each of the discount rates of 5%, 15%, and 20%.Include an excerpt (showing your calculations and outcomes) from your Excel file in your narrative and specify the formula you used.Be sure to organize your writing properly and include the following:Cover pageIntroductionBody of your work with headings and subheadingsAnalysis and recommendationsConclusionList of references.Consult the Sample Paper template (Links to an external site.) for more information on how to organize the paper. Please note that Lynda.com is a great resource to learn how Excel can be used to utilize economic models (e.g., NPV, IRR).Support your assignment with a minimum of three schol
arly references. The CSU Global Library is a good place to locate these sources. The written section should follow the CSU Global Writing Center (Links to an external site.).Option #2: IRRReview the following data concerning the amount of capital investment and return of investment for two alternative projects.Project/Year01234A-$124,000$32,000$44,000$50,000$50,000B-$211,000$72,000$75,000$77,000$80,000Use Excel to calculate the IRR values for the two projects. Explain if choosing different discount rates of 5%, 15% and 20% will make a difference in the results.Provide a two-page narrative to:Describe the steps you took to calculate the IRR valuesExplain your findingsSpecify which project you would choose.Include an excerpt (showing your calculations and outcomes) from your Excel file in your narrative and specify the formula you used.Be sure to organize your writing properly and include the following:Cover pageIntroductionBody of your work with headings and subheadingsAnalysis and recommendationsConclusionList of references.Consult the Sample Paper template (Links to an external site.) for more information on how to organize the paper. Please note that Lynda