Using the data set in column A., calculate R&Es projected external funding required for 2023. Net Sales for 2023 is based on Forecast 2022 Net Sales. How does forecasted external funding required for 2023 compare to the 2022 forecasted external funding required? Write your answer and observation in Box A.A.300B.Using the data set in column B., perform a Sensitivity Analysis on your Forecast 2023 assuming a change in COGS/Net Sales. Net Sales for Sensitivity 2023 is based on Forecast 2022 Net Sales. How does R&Es projected external funding required change if the ratio of cost of goods sold to net sales declines from 86.0 percent to 84.0 percent? Write your answer and observation in Box B.B.300C.Perform a scenario analysis using your Forecast 2023 results. How does R&Es projected external funding required change if a severe recession occurs in 2023? Net Sales for Scenario 2023 is based on Forecast 2022 Net Sales. Assume net sales decline 5 percent, cost of goods sold rises to 88 percent of net sales due to price cutting, and current assets increase to 35 percent of net sales as management fails to cut purchases promptly in response to declining sales.C.300Data Set - R&E SUPPLIESFacts and assumptions ($ thousands)A.B.C.ActualForecastForecastSensitivityScenario20212022202320232023Net sales$20,6135%Growth rate in sales25%30%Cost of goods sold/net sales86%86%84%88%Gen., sell., and admin. expense/net sales12%11%Long-term debt$760$660$560Current portion long-term debt$100$100$100Interest rate10%10%Tax rate45%45%Dividend/earnings after tax50%50%Current assets/net sales29%29%35%Net fixed assets$280$270Current liabilities/net sales14.5%14.4%Owners' equity$1,730