can someone help me with my assignment Excel Spreadsheet and solve problem? I am new to excel spread sheet. so how i type the values in the formula in column (e.g B2*B3

Problem 6: Forecasting You have an idea for a new service that offers customized training for subscribers, but you want to get an idea of how your business could grow by capturing portions of the potential market in the next 5 years (60 months). Construct a forecasting worksheet to calculate: the number of new clients each month (period), and the total client base (cumulative number of clients signed up) each month (period). There are the three key parameters values that impact your projections (Figure 12): Total market potential 1. 2. remaining coptured/period 3. Market growth/period A B D Forecasting and Charting 2 Total market potential % remaining captured/period Market growth/period 2,000,000 1.2% 4 0.30% Figure 12- Forecasting Parameters In your model, make projections for 60 Periods (Months) based on these parameters for the two separate scenarios described below to project the number of new customers (Figure 13) Scenario 1: Constant Market - Total market potential is 2,000,000 customers. Each month you sign up 1.2 % of customers in the market that have not yet signed up. Scenario 2: Growing Market - Total market potential is initially 2,000,000 customers but grows at 0.3% per month. Each month you sign up 1.2 % of custom ers in the market that have not yet signed up. Both scenarios initially (Period 0) have 0 new customers and 0 total customers. Beginning Period 1, calculations must take into account the previous period's Total_Clients values as well as the current period's New Clents values. In the case of Scenario 2, the Period 2 Total_Market calculations accounts for the Market growth/period parameter value. Hint: Whenever you need to reference a value calculated in a previous row you need to use its cell address, not a range name; but remember that the rest of the formula should make use of named ranges Scenario 1: Constant Market 26 Scenario 2: Growing Market Total Market New Clients Total Clients 27 Period New Clients Total Clhents Period 28 0 0 0 0 0 0 24,000 29 1 24,000 1 2.000,000 24.000 24,000 30 23,712 47,712 2 2.006.000 23,784 47,784 31 3 23,427 71,139 3 2,012,018 23,571 71,355 23,146 32 4 94,286 4 2,018,054 23,360 94,715 33 22,869 117,154 5 2,024,108 23,153 117.868 34 6 22,594 139,749 6 2,030,181 22,948 140,816 35 7 22,323 162,072 7 2,036,271 22,745 163,561 36 8 22,055 184,127 8 2,042,380 22,546 186,107 37 9 21,790 205,917 2,048,507 22,349 208.456 38 10 21,529 227,446 10 2,054,653 22,154 230,610 39 11 21,271 248,717 11 2,060,817 21,962 252,573 269.732 40 12 21.015 12 2,066,999 21,773 274,346 41 13 20,763 290,495 13 2,073,200 21,586 295,932 42 14 20,514 311,009 14 2,079,420 2,085,658 21,402 317,334 43 15 20,268 331,277 15 21,220 338,554 20,025 44 16 351,302 16 2,091,915 21,040 359,594 45 17 19,784 371,086 17 2,098,191 20,863 380,457 401,146 46 18 19.547 390,633 18 2,104,485 20,688 47 19 409.946 19,312 19 2,110,799 20,516 421,661 48 20 19,081 429,026 2.117,131 20 20,346 442,007 49 21 18,852 447,878 21 2,123,482 20,178 462,185 7130 eg a e Figure 13- Two Scenarios of Market Capture (Partial View)