Sales Trend Analysis. Environmental Designs, Inc., produces and installs energy-efficient window systems in commercial buildings. During the past ten years, sales revenue has increased from $25 million to $65 million.
(a) Calculate the company's growth rate in sales using the constant growth model with annual compounding.
(b) Derive a five-year and a ten-year sales forecast.
Please provide instructions on how to solve this in excel