I need help with all the below, I am not quite understanding it or the formulas to use.

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. 115 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: NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials. 215 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. 14 ACCUMULATED DEPRECIATION: Each year, 10% of the total amount of Plant and Equipment is added to 15 16 the depreciation amount. 15 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.) 17 ACCRUED EXPENSES: Use the 3-year average Percent-of-Sales method to forecast. 17 18 19 20 21 COM par). 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. 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. 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. 115 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: NOTE: You will use a combination of Proforma, Ratios, and the Percent-of-Sales methods to create your forecasted financials. 215 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. 14 ACCUMULATED DEPRECIATION: Each year, 10% of the total amount of Plant and Equipment is added to 15 16 the depreciation amount. 15 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.) 17 ACCRUED EXPENSES: Use the 3-year average Percent-of-Sales method to forecast. 17 18 19 20 21 COM par). 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. 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