I need help making a pro forma income statement and balance sheet for PepsiCo Inc.

Create an pro forma Income Statement and Balance Sheet for the company's current fiscal year. Incorporate (a) the information provided in their current financial statements, (b) additional information obtained from financial ratios, and (c) guidance based on additional research. Provide a detailed rationale for each number based on research.

Here is their income statement and balance sheet from their most recent quarterly report (ending on Dec. 31, 2019):

Annual Data I Millions of US $ except per share data 2019-12-31 Revenue $67, 161 Cost Of Goods Sold $30,132 Gross Profit Lalil $37,029 Research And Development Expenses SG&A Expenses $26,738 Other Operating Income Or Expenses Operating Expenses Lolil $56,870 Operating Income $10,291 Total Non-Operating Income/Expense $-979 Pre-Tax Income Lolil $9,312 Income Taxes $1,959 Income After Taxes $7,353 Other Income Income From Continuous Operations $7,353 Income From Discontinued Operations Net Income $7,314 EBITDA $12,723 EBIT $10,291 Basic Shares Outstanding 1,399 Shares Outstanding 1,407 Basic EPS $5.23 EPS - Earnings Per Share Lalil $5.20Annual Data I Millions of US $ except per share data 2019-12-31 Cash On Hand $5,738 Notes And Loans Receivable Inventory $3,338 Other Current Assets Total Current Assets $17,645 Property, Plant, And Equipment $19,305 Long-Term Investments $2,683 Goodwill And Intangible Assets $31,544 Other Long-Term Assets $3,011 Total Long-Term Assets $60,902 Total Assets $78,547 Total Current Liabilities $20,461 Long Term Debt $29, 148 Other Non-Current Liabilities $9,979 Total Long Term Liabilities $43,218 Total Liabilities $63,679 Common Stock Net $23 Retained Earnings (Accumulated Deficit) $61,946 Comprehensive Income $-14,300 Other Share Holders Equity Share Holder Equity $14,868 Total Liabilities And Share Holders Equity $78,547