Please solve question 1 and 2 using excel functions

Assignment.3 - Planning A company sells a product in four markets. The manager of decided to focus only on two markets instead on four markets. So, he reduced the production and decided that the Quantity Produced should be 7000 per market in the first year. The Quantity Produced is expected to grow by 6% every year. The Cost Per Unit is $180 and expected to decrease by 5% every year. The Price Per Unit is $500 and expected to decrease by 4% per year. The mangers Knows that the Quantity Sold and its Growth Rate is different in every market. So, he decided to develop a Planning Model and calculate the NPV for every market to find out which markets are going to be more profitable "best two markets": Qusetion1 "First Market": Develop an excel model that calculate the profits over 5 years for the First Market. Knowing that the Total Quantity Sold for year-1 should be forecasted and calculated from the below table (the price is given for each month, and the sale is depending on the period and price). Any $25 dollar change in price will change 150 units sold. Month n Price Qty Sold January $ 275 400 February $ 300 275 March 3 $ 270 422 April 4 $ 265 450 5 $ 294 289 May June $ 279 450 $ 204 ? July August $ 200 ? $ 204 ? September October November $ 270 ? 11 $ 230 ? December 12 $ 240 ? Qusetion2 "Second Market": Develop an excel model that calculate the profits over 5 years for the Second Market. Knowing that the Quantity Sold for year 1 expected to increase by 10% and it is shown as cubic function of the price: Price Quantity Sold 8000 7000 6000 5250 4500 $ 250 $ 350 $ 450 $ 500 $ 550 123 6789 SE essere es 10