This case study is to be completed individually. You will estimate future cash flows and determine current value

of a firm using the NPV$.$ Please review the case study titled "Hansson Private Label" found in your course pack.

You should submit two documents: an excel spreadsheet with your future cash flows and calculations and a

one page word document describing your assumptions, findings, and interpretation of what your findings mean

to the company.

The key to the case is utilizing data to predict future cash flows, determining what discount factor to use, and

perform NPV analysis utilizing the info provided in the case. This is what I should see on your spreadsheet. In

your one page write up$,$ you should explain any assumptions you made to predict the cash flows and discount

rate as well as your findings from your analysis.

excel spreadsheet with your future cash flows and calculations and a

one page word document describing your assumptions, findings, and interpretation of what your findings mean

to the company.