Can someone use Excel and explain how this is completed thank you
Problem 4: Forecasting You have an idea for a new calke shop, but you want to get an idsa of how your business could grow by capturing portions of the potential maket in the nuxt 5 vears (60 montha). Construct a forecasting worksheet to calculate: - the number of new clients each momth (poriod), and - the total dient base [cumulative number of clients signed up] each month. There are the thee key parameters values that impact your projections (Figure 5): 1. Total market potemial 2. Sremaining captured/month 3. Market growth/momth Agure 5: Foncouth Paramiona In your model, make projections for 60 months based on these parameters for the two separate scenarios described below to project the number of new customers (Figure 6). Scenario 1: Constant Market - Total maiket potential is 5,000,060 oustomers. Each month you sign up 1.0K of customers in the market that have not yet siyned up. Scenario 2: Growing Market - Total market potential is initlally 5,000,000 customers but grows at 2 * per month. Each month yousign up 1% of customers in the market that have not yet signed up. Both scenarios begin at month 0 and have 0 new dients and 0 total clients. 1. The Constant Mevket scenario: Menth 1 (and onwards), caloulations must consider the previous month's Toted Clients values as well as the current month's values resulting from capturing New Clients. 2. The Grewing Merhet Scenario: starting from Meneh 2 the Totel_Market calculations must also account for the Market growth/month parameter value. Page 5 of 7 Agure E. Two Sennariar of Marker Captore (Portial Wewe) Note: Whenever you nevd to reference a value calculated in a previous row you need to use its cell addres, not a range name; but remember that the rest of the formula should make use of named ranges Problem 4: Forecasting You have an idea for a new calke shop, but you want to get an idsa of how your business could grow by capturing portions of the potential maket in the nuxt 5 vears (60 montha). Construct a forecasting worksheet to calculate: - the number of new clients each momth (poriod), and - the total dient base [cumulative number of clients signed up] each month. There are the thee key parameters values that impact your projections (Figure 5): 1. Total market potemial 2. Sremaining captured/month 3. Market growth/momth Agure 5: Foncouth Paramiona In your model, make projections for 60 months based on these parameters for the two separate scenarios described below to project the number of new customers (Figure 6). Scenario 1: Constant Market - Total maiket potential is 5,000,060 oustomers. Each month you sign up 1.0K of customers in the market that have not yet siyned up. Scenario 2: Growing Market - Total market potential is initlally 5,000,000 customers but grows at 2 * per month. Each month yousign up 1% of customers in the market that have not yet signed up. Both scenarios begin at month 0 and have 0 new dients and 0 total clients. 1. The Constant Mevket scenario: Menth 1 (and onwards), caloulations must consider the previous month's Toted Clients values as well as the current month's values resulting from capturing New Clients. 2. The Grewing Merhet Scenario: starting from Meneh 2 the Totel_Market calculations must also account for the Market growth/month parameter value. Page 5 of 7 Agure E. Two Sennariar of Marker Captore (Portial Wewe) Note: Whenever you nevd to reference a value calculated in a previous row you need to use its cell addres, not a range name; but remember that the rest of the formula should make use of named ranges
