the question should bu solved by explaining step by step and should be written in excel.

1.) 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