Working in the attached Excel Workbook, complete the Financing and Investing worksheet. The Financing and Investing worksheet contains information about present value, revenue, expenses, and cash flows, as well as questions that will help Frank guide the client in selecting the best financing option.

When you have completed the Financing and Investing worksheet, at the conclusion of your project, Frank requests a report based on your analysis and recommendations in the previous steps. He is planning on using this report to provide the client, McCormick & Company, with guidance on the potential acquisition of an additional factory. This report, along with citations for any sources you use, should be about three to five pages. The report should highlight your analysis and recommendations based on the work you completed in the Project 4 Excel Workbook. Be creative and use charts, graphs, or any other tools you feel would be useful to convey your analysis and recommendations. Post your report to management in the submission folder located in the final step of this project.