Provide 1 year Financial forecast for 2023 for Prctr& Gamble (PG) stock.

262 Status uO 263 1. Balance Sheets 264 Assets 265 Cash 266 Short-tem investments 267 Accounts receivable 268 Inventories 269 Total current assets 270 Net PP&E 271 Total assets [TA) 272 Liabilities and equity 273 Accounts payable 274 Notes payable 275 Accruals 276 Line of credit 277 Total CL 27d Long-term bonds 2 79 Total liabilities 280 Preferred stock 281 Common stock 282 Retained earnings 283 Total common equity 284 Total liabs. & equity 285 286 Z Income Statement 287 288 Netsales 289 COGS (excl. depr.) 290 Depreciation 291 Other operating expenses 292 Cost of strategic initiatives 293 EBIT 294 Less: Interest on notes 295 Interest on bonds 296 Interest on LOC 297 pre-tax earnings 298 Taxes (25%) 299 NI before pref. div. 300 Preferred dividend 301 Net income 302 Regular common dividends 303 Special dividends 304 Addition to RE Most Recent 2021 $100.0 10.0 500.0 1,000.0 $1,610.0 2,000.0 $3,610.0 $200.0 150.0 400.0 0.0 $750.0 520,0 Sl,270.o $100.0 500.0 1,740.0 $2,240.0 $3,610.0 Most Recent 2021 $5,000.0 3,900.0 200.0 500.0 0.0 $400.0 10.0 50.0 0.0 3340.0 85.0 $255.0 7.0 $248.0 $60.0 so.o $188.0 In ut Basis for 2022 Forecast 2.00% x 2022 sales Set to zero 10.00% 2022 sales 20.00% 2022 sales 40.00% x 2022 sales 4.00% x 2022 sales Carry over from previous year 8.00% x 2022 sales Draw on LOC if financing deficit Carry over from previous year Carry over from previous year Cany over from previous year Previous RE + Add. to RE Check: TA- Total Liab.&E . = 2022 $110.00 so.oo $550.00 $1,100.00 $1,760.00 $2,200.00 $3 960.00 $220.00 $1 so.oo -$440.00 S7d.oo $888.00 $520.00 $1,408.00 $100.00 $500.00 $1,952 $2,452 $3,960 $0.00 Forecast In ut Basis for 2022 Forecast 2022 110% x 2021 sales 78.00% x 2022 sales 10.00% x 2022 Net PP&E 10.00% x 2022 Sales Cost of implementation 8.00% 10.00% 9.50% 25.00% 7.00% 105% x Avg notes Avg bonds x Beginning LOC * pre-tax earnings x Avgpref. stock x 2021 Dividend pay if financing surplus Net income Dividends 305 3. Elimination o the Financial De citorSur lus 306 Increase in spontaneous liabilities (accounts payable and accruals) 307 + Increase in notes payable, long-term bonds, preferred stock, and common stock 30B + Net income minus regular common dividends 309 Previous line of credit 310 Increase in financing 311 Increase in total assets 312 Amount of deficit or su lus financin . 313 If deficit in financing (negative), draw on line of credit 314 If su lus in financin ositive a s ecial dividend S Line of credit ecial dividend $5,500.00 4,290.00 220.00 550.00 0.00 $440.00 $12.00 $52.00 $0.00 $376.00 S94.oo $282.00 $7.00 $275.00 $63.00 so.oo $212.00 $60.00 $0.00 $212.00 so.oo $272.00 S350.oo -$78.00 S78.co so.oo