Hello, please answer the following in excel format, the firm chosen is Exxon.

This is an individual assignment. Everyone needs to work on the firm that your team chooses $[$prefer simple business$]$ for your industry analysis. Follow

my class video, do the following:

compute your company's free cash flow for the past $3$ years. This requires you to compute each of the components in the FCF$.$ Compare your FCF for

the most recent year to that reported from the barchart website. Are you close? Explain why you cannot get close to it$.$ Note for MSFT that I did in

class, deferred tax is a big deal, it may not be a problem for you. NOPAT $=$ EBIT $-$ tax. Either find the line for tax, or do tax $=$ EBT $-$NI$.$ Also check their

cash flow statement and that should give you a clue of what to include.

do a free cash flow model to value your stock for next year. Is your price close to the current stock price? If not, what could be the reason?

do a sensitivity table by varying terminal growth $g$ and the WACC.

Upload your excel file with a sheet explaining your results. Always highlight what you want me to see please.