To determine the net fixed assets, you will have to use the vlookup function. Each year's long term debt will be determined by company's debt to equity ratio policy. The book value of stock outstanding will be determined as previous year's book value of stock outstanding plus the value of new stock issued. Accumulated retained earnings are equal to the previous year's accumulated retained earnings plus this year's retained earnings. Amount of new stock issued is determined in such a way as to make the balance sheet balance, i.e., total assets equal total liabilities plus equity.
Stock price is determined by discounting future dividends.
Your pro forma statements will tell you the dividend per share for years up to 2000. After that assume the long term growth in dividends per share. Estimate the discount rate using the CAPM and the other information provided. The number of shares issued equal the amount of new stock issued divided by the share price. Total number of shares outstanding equals previous year's shares outstanding plus the number of new shares issued.