please help me find the formulas for columns G&H !!! please

Forecast the financial statements using the following assumptions. (1) Operating ratios remain unchanged. (2) No additional notes payable, LT bonds, or common stock will be issued. (3) The interest rate on all debt is 10%. (4) If additional financing is needed, then it will be raised through a line of credit. The line of credit will be tapped on the last day of the year, so there will be no additional interest charges due to the line of credit. (On Tab 2 we relax this assumption and assume that the line of credit is accessed smoothly throughout the year.) (5) Interest expenses for notes payable and LT bonds are based on the average balances during the year. (6) If surplus funds are available, the surplus will be paid out as a special dividend payment. (7) Regular dividends will grow by 15%. (8) Sales will grow by 15%. This is called the "Steady" scenario because operations remain unchanged. The same assumptions apply to the Target scenario, except there are improvements in several areas of operations. Forecast the financial statements using the following assumptions. (1) Operating ratios remain unchanged. (2) No additional notes payable, LT bonds, or common stock will be issued. (3) The interest rate on all debt is 10%. (4) If additional financing is needed, then it will be raised through a line of credit. The line of credit will be tapped on the last day of the year, so there will be no additional interest charges due to the line of credit. (On Tab 2 we relax this assumption and assume that the line of credit is accessed smoothly throughout the year.) (5) Interest expenses for notes payable and LT bonds are based on the average balances during the year. (6) If surplus funds are available, the surplus will be paid out as a special dividend payment. (7) Regular dividends will grow by 15%. (8) Sales will grow by 15%. This is called the "Steady" scenario because operations remain unchanged. The same assumptions apply to the Target scenario, except there are improvements in several areas of operations