The questions should be solved by explaining step by step and should be written in excel.

1.) Calculate the value of the firm (enterprise value). You might want to change some important inputs to see how the value that you calculated is affected (i.e., conduct sensitivity analyses) (Create data tables)

2.) Calculate the equity value of the firm, find the price per share. Based on your valuation, decide whether the company stock is undervalued, overvalued or at a rational price level.

Current assets: Short-term Investments Accounts Receivable, net Inventary, Net 6 Trepaid Lxpense and Other Assets, Current 7 Assets, Current 8 Long-term investments 9 Equity Investments 10 Property, Plant and Equipment, Net 11 Operating Lease, Right-of-Use Asset 12 Dereited Imbirie Tax Assels, NeL 13 Other Assets, Noncurrent 14 Intangible Assets, Net (Excluding Goodwill) 15 Goodwill 6 Assets 17 20 Current assets: Short-term Investments Accounts Receivable, net Inventary, Net 6 Trepaid Lxpense and Other Assets, Current 7 Assets, Current 8 Long-term investments 9 Equity Investments 10 Property, Plant and Equipment, Net 11 Operating Lease, Right-of-Use Asset 12 Dereited Imbirie Tax Assels, NeL 13 Other Assets, Noncurrent 14 Intangible Assets, Net (Excluding Goodwill) 15 Goodwill 6 Assets 17 20