Need formulas and answers!

WHITE & PINKMAN CORPORATION Historical and Projected Balance Sheets Historical Dec 31, 2018 Projected Dec 31, 2019 Projection with AFN/ Excess Financing Incorporated ASSETS Current Assets: Cash Marketable Securities Accounts Receivable (gross) Less: Allowance for Bad Debts Accounts Receivable (Net) Inventory Prepaid Expenses Total Current Assets Plant and Equipment (gross) Less: Accumulated Depreciation Plant and Equipment (net) TOTAL ASSETS $9,000,000 $8,000,000 $1,200,000 $200,000 $1,000,000 $20,000,000 $1,000,000 $39,000,000 $20,000,000 $9,000,000 $11,000,000 $50.000.000 WHITE & PINKMAN CORPORATION Historical and Projected Balance Sheets Historical Dec 31, 2018 Projected Dec 31, 2019 Projection with AFN/ Excess Financing Incorporated ASSETS Current Assets: Cash Marketable Securities Accounts Receivable (gross) Less: Allowance for Bad Debts Accounts Receivable (Net) Inventory Prepaid Expenses Total Current Assets Plant and Equipment (gross) Less: Accumulated Depreciation Plant and Equipment (net) TOTAL ASSETS $9,000,000 $8,000,000 $1,200,000 $200,000 $1,000,000 $20,000,000 $1,000,000 $39,000,000 $20,000,000 $9,000,000 $11,000,000 $50.000.000