Using the Assignment 6.5 Workbook (attached), prepare a financial analysis for Fresnel Enterprises:
Create pro forma income statements for each year of the proposed project.
Create a working capital analysis, showing needed working capital investments for each year of the proposed project.
Determine the free cash flow expected for each year of the project.
Calculate the project’s NPV, BCR, and IRR.
Finally, based on your analysis, briefly explain whether you believe the company should pursue this project and why.
Be sure your Excel spreadsheet is prepared in a professional manner, with answers clearly indicated and all your calculations shown. Full credit will not be
given if your process for arriving at the answer is not fully displayed, including any intermediate steps.