show detailed calculations in excel

According to the value-based management model, what is the stock price per share given the following data? Year 1: Revenue: 760 Fixed Costs: 90 Variable costs: 280 Additional investments in NWC: 3 Additional investments in operating long-term assets: 80 Depreciation: 75 Corporate tax rate: 0.40 WACC.com: 0.15 Growth rate per year. From year 1 through year 5: 0.08 After year 5: 0.06 Market value: Non-operating short-term assets: 10 Non-operating long-term assets: 20 Market value: Short-term debt: 0 Long-term debt: 700 Preferred Stock: Market price per share: 7 Number of shares: 10 I Common Stock: Market price per share: 15 Number of shares: 100 Select one: According to the value-based management model, what is the stock price per share given the following data? Year 1: Revenue: 760 Fixed Costs: 90 Variable costs: 280 Additional investments in NWC: 3 Additional investments in operating long-term assets: 80 Depreciation: 75 Corporate tax rate: 0.40 WACC.com: 0.15 Growth rate per year. From year 1 through year 5: 0.08 After year 5: 0.06 Market value: Non-operating short-term assets: 10 Non-operating long-term assets: 20 Market value: Short-term debt: 0 Long-term debt: 700 Preferred Stock: Market price per share: 7 Number of shares: 10 I Common Stock: Market price per share: 15 Number of shares: 100 Select one