Explain how to solve

a$.$ Create pro forn$]5$ income statements for each year of the proposed pro

b$.$ Create a working capital analysis, showing needed working capital inve

c$.$ Determine the free cash flow expected for each year of the project.

d$.$ Calculate the project's NPV$,$ BCR$,$ and IRR.

e$.$ Finally, based on your analysis, briefly explain whether you believe the Be sure your Excel spreadsheet is prepared in a professional manner, with a shown. Full credit will not be given if your process for arriving at the answer