I need help solving the highlighted sections. Please include the formula and steps.

ASSUMPTIONS
	NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials.
1	The Sharks gave you the $1,000,000 in funding you requested in exchange for 25% ownership of your company's profits.
2	All the following are complete by March 31, 2023: 1) your shark funding has been received, 2) new capital investments have been purchased and set up, and 3) additional labor has been hired and trained.
3	SELLING & ADMINISTRATIVE EXPENSE: Use a3-year average Percent-of-Sales to forecast S&A expenses. (HINT: Find what percent S&A expense is for each of 2020, 2021, and 2022, and average the 3 results together. Use the resulting average S&A Percent-of-Sales to forecast S&A into the future.)
4	RENT EXPENSE:Rent expense is a fixed cost in the amount of $15,000 per year in 2020-2022, increasing to $200,000 per year in 2023.
5	DEPRECIATION EXPENSE:Depreciation expense is a fixed cost in the amount of 10% of Plant & Equipment each year.
6	INTEREST EXPENSE: This is a Fixed cost, and is 10% of Long-term Liabilities.
7	TAXES:Because you live in a business-friendly State (Wyoming), you don't have to pay state taxes on your LLC's income. You do, however, still have to pay Federal taxes. Also, in 2022, higher tax rates were passed for the 2023 tax year, pushing income over $400,000 into the 39.6% tax bracket. Because of this, use36% as your effective tax rate. (NOTE: If the taxes shown for 2020-2022 seem high, it's because you had income from another job that threw your LLC income into a slightly higher tax bracket. However, you'll quit that job IF the sharks fund you!)
8	SHARES:Issued 26,000 $1-par shares to the sharks for a 25% ownership stake.
9	CASH:Increases to $50,000 in 2023 and stays at that level.
10	MARKETABLE SECURITIES:Plan to keep Marketable Securities at 60% of Cash levels.
11	ACCOUNTS RECEIVABLE:Use a 3-year average Receivables Turnover ratio to forecast.(HINT: Find the formula for Receivables Turnover (RTO) in your Week 2 Chapter readings, and solve for RTO for each of 2020, 2021, and 2022. Average the 3 results together. Plug your Average RTO into the RTO formula for each future year, along with your other known number from your financial statements, to find your forecasted Accounts Receivable amounts. This is demonstrated in your Week 2 Lesson!)
12	INVENTORY: Compute a 3-year average of inventory as a Percent-of-Sales, and then use that figure to forecast inventory levels through 2027.
13	PLANT & EQUIPMENT: There is a new capital expenditure of $750,000 dollars in 2023, paid for from the $1M in funding from the sharks, rather than with new debt. (All capital expenditures are assumed to occur on January 1st of the year of purchase, and no equipment is sold or salvaged during the forecasted period.)
14	ACCUMULATED DEPRECIATION:Each year, 10% of the total amount ofPlant and Equipmentis added to the depreciation amount.
15	ACCOUNTS PAYABLE:Use the 3-year average Current Ratio to forecast.(HINT: The Current Ratio will help you forecast TOTAL Current Liabilities, not Accounts Payable. Find Total Current Liabilities and Accrued Expenses first, and then you can solve for Accounts Payable.)
16	ACCRUED EXPENSES:Use the 3-year average Percent-of-Sales method to forecast.
17	LONG-TERM LIABILITIES: Pay down $100,000 of old debt every year starting in 2023.
18	COMMON STOCK ($1 Par): Increase by the dollar value of shares issued to sharks (26,000 shares at $1 par).
19	CAPITAL PAID IN EXCESS OF PAR: The shark's full investment of $1M must be reflected on the Balance Sheet. The stock received by the shark, worth $26,000 (at Par value of $1 per share), is already reflected under Common Stock. The rest of the shark's investment value is added to this account.
20	RETAINED EARNINGS: This amount is whatever it takes to make the Balance Sheet balance! (HINT: Remember Total Liabilities + Stockholder's Equity is equal to Total Assets. Once Total L + SE is determined, Total SE can be solved. Finally, once Total SE is solved, Retained Earnings can be solved.)
21	DIVIDENDS: You do not pay dividends now and do not plan to while in a growth stage.

MILESTONE 2 FORECASTED FINANCIALS Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both clearly labeling your work. All your work must be shown on th sheet, not on a separate tab. Forecasted Income Statement (20 points: 5for showing work, 15for accuracy} 2020 2021 2022 2023 2024 2025 2026 2027 Sales (all on credit) 1,200,000 1,500,000 1,875,000 5,625,000 7,031,250 8,789,063 10,986,328 13,732,910 Cost of Goods Sold (800,000) (1,040,000) (1 105,000) 3,093,750 3,867.188 4.833.984 6.042,480 7,553,101 Gross Profit 400,000 460,000 770,000 8,718,750 10,898,438 13,623,047 17,028,809 21,286,011 Selling and Administrative Expense (224,900) (270,500 (363,700) 4,715,100 6,149,450 7,568,965 9,423,743 11,869,080 Rent Expense (15,000) (15,000) (15,000) 200,000 200,000 200,000 200,000 200,000 Depreciation Expense (65,000) (76,500) (139,000) 214,000 214,000 214,000 214,000 214,000 Operating profit (EBIT) 95,100 98,000 252,300 3,589,650 4,340,988 5,640,082 7,191,066 9,002,931 Interest expense (35,000) (45,000) (85,000) 60.390 50.390 40.390 30.390 20.390 Net Income before Taxes 60,100 53,000 167,300 3,529,650 4,290,598 5,599,692 7,160,676 8,982,541 Taxes (36,900) (49,200) (55,600) 1 270.534 1,544.615 2,015.889 2.577.843 3.233,715 Net Income 23,200 3,800 111,700 2,258,726 2,745,983 3,583,803 4,582,833 5,748,826 Shares 60,000 60,000 78,000 104,000 104,000 104,000 104,000 104,000 Earnings per Share $0.39 $0.26 $2.38Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2020 2021 2022 2023 2024 2025 2026 2027 ASSETS Cash 30,000 40,000 30,000 50,000 50,000 50,000 50,000 50,000 Marketable Securities 20,000 25,000 30,000 30,000 30,000 30,000 30,000 30,000 Accounts Receivable 170,000 259,000 360,000 ####### 1,177,031 2.250,527 2,872,760 3,556,892 Inventory 230 000 261 000 290 000 975.938 Total Current Assets: 450,000 585,000 710,000 ####### 1,257,031 2.330,527 2,952,760 3,636,892 Plant and equipment 650,000 765,000 1,390,000 ####### 2.140,000 2.140,000 2.140,000 2.140,000 Less: accumulated depreciation 65 000) (141.500) (280.500) Net Plant and equipment 585 000 623.500 1108.500 Total Assets 1035 000 1208 500 1 819 500 LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable 200,000 310,000 505,000 Accrued Expenses 20 400 30 000 35 000 Total Current Liabilities 220,400 340,000 540,000 Long-term Liabilities 325 000 363 600) 703.900 603.900 503.900 403 900 303 900 203.900 Total Liabilities 545,400 703,600 1,243,300 Common Stock ($1par) 60,000 60,000 78,000 104,000 104.000 104,000 104,000 104,000 Capital paid in excess of par 190,000 130,000 262,000 Retained Earnings 238 600 254 900 235 600 Total Stockholder's Equity 489 600 504 900 575 600 Total Liabilities & Stockholder's Equity 1035 000 1208 500 1 819 500MILESTONE 2 METRICS SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, or to the side or below -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. 1 points: 5 for showing work, 10 for accuracy Based upon your financial forecast for the years 2023 - 2027, compute the following ratios, placing your final results in the yellow highlighted area: Industry Averages 2023 2024 2025 2026 2027 a Profit Margin 12.20% 78.97% 17.88% 26.52% 26.88% 26.48% b ROA 8.75% 375000000% 140625000.00% 175781250.00% 219726562.50% 274658203.13% C ROE 22.42% d Current ratio 2.33X Quick ratio 1.45X Debt-to-Total Asse 43.05% Times Interest Ear 10.28X (HINT: Enter Interest Expense as a positive number for TIE)15 2 points: 5 for showing work, 10 for accuracy Compute Required New Funds (RNF) for each year (HINT: See Formula 4-1 in your Week 3 Chapter readings) OPTIONAL: It would be very helpful to fill out the table below identifying the necessary variables before attempting to compute RNF. 2023 2024 2025 2026 2027 A/S = Total Current Assets/Sales AS = Current Sales - Last year's Sales L/S = Total Current Liabilities/Sales P = Profit Margin (see 10 above!) 52 = Sales in the current yr D = Dividend Payout Ratio =MILESTONE 2 QUESTIONS 1 Ratio Analysis (HINT: See Week 2 Chapter readings) (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) a. Are your profitability ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? b. Are the sharks likely to challenge your figures? Why or why not? (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) c. Are your liquidity ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? d. Regardless of your answer to question 1c, what can happen to a company with poor liquidity?(5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) e. Are your debt utilization ratios better or worse than the Industry Averages shown on your Milestone 2 Metrics worksheet? f. What is the difference between what a debt utilization ratio measures and what a liquidity ratio measures? 2 Required New Funds (RNF) (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) a. You asked the sharks for $1M. Looking at your RNF results, is it enough? How do you know? b. Regardless of your answer to 2a, where you could pull funds from if you needed extra funds? (HINT: Look at your Assumptions to see where you could change a decision and free up funds.)