Use the given information to compute the investment rate (IR) and Growth Rate (g). Estimate the projected NOPAT, Net Investment, and Free Cash Flow along the timeline. Calculate the Use the given information to compute the investment rate (IR) and Growth Rate (g). Estimate the projected NOPAT, Net Investment, and Free Cash Flow along the timeline. Calculate the company's value using both discounted cash flow approach and economic profit approach. Make your calculations only in the green cells highlighted below. Do not type in numerical data into a cell or fucntion. Instead, make a reference to the cell in which the data is provided.

I had just gotten stuck on these 2. I restarted trying my formulas but kept getting e

Use the given information to compute the investment rate (IR) and Growth Rate (g). Estimate the projected NOPAT, Net Investment, and Free Cash Flow along the timeline. Calculate the company's value using both discounted cash flow approach and economic profit approach. Make your calculations only in the green cells highlighted below. Do not type in numerical data into a cell or fucntion. Instead, make a reference to the cell in which the data is provided. WACC ROIC 10% 20% 1. Low Growth Investment Rate (IR) Growth Rate (g) Year NOPAT Net Investment Cash flow 5 6 8 9 10 11 12 1 $100 $25 Discounted Cash Flow Approach Value Economic Profit Approach Initial Invested Capital Economic Profit at Year 1 Value Use the given information to compute the investment rate (IR) and Growth Rate (g). Estimate the projected NOPAT, Net Investment, and Free Cash Flow along the timeline. Calculate the company's value using both discounted cash flow approach and economic profit approach. Make your calculations only in the green cells highlighted below. Do not type in numerical data into a cell or fucntion. Instead, make a reference to the cell in which the data is provided. WACC ROIC 10% 20% 1. Low Growth Investment Rate (IR) Growth Rate (g) Year NOPAT Net Investment Cash flow 5 6 8 9 10 11 12 1 $100 $25 Discounted Cash Flow Approach Value Economic Profit Approach Initial Invested Capital Economic Profit at Year 1 Value