Widget Products International 2022 2021 2020 S4,300,000 $3,850,000 $3,432,000 $3,609,108 53,250,000 $2,864,000 56190,892 $600,000 $568,000 5334,803 5330,100 $240,000 5100,000 $100,000 $100,000 $25,000 $20,000 $18.900 $231,090 $149,700 $209,100 $76,000 $76,000 $62,500 $155,090 $73,7005146,600 $62,036 $29,480 S58.640 $93,054 $44,220 $87,960 Sales Cost of Goods Sold Gross Profit Selling and G&A Expenses Fed Expenses Depreciation Expense EBIT Interest Expense Earnings Before Taxes Taxes Net Income Forecast Utilize the ferative process to calculate the required level of Long Term Debt needed to eliminate the Discretionary Financing Need 40.00% Notes Tax Rate Additional Depreciation Interest Rate 40.00% $5,000 11.70% Widget Products International 2022 2021 2020 Assets Cash and Equivalents $75,000 $70,000 $60,000 Accounts Receivable $444,505 $402,000 $351,200 Inventory $914,899 $836,000 $715,200 Total Current Assets $1,434,404 $1,308,000 $1,126,400 Plant & Equipment $577,000 $527,000 $491,000 Accumulated Depreciation $191,200 $166,200 $146,200 Net Fixed Assets $385,800 $360,800 $344,800 Total Assets $1,820,204 $1,668,800 $1,471,200 Liabilities and Owner's Equity Accounts Payable $189,051 $175,200 $145,600 Short-term Notes Payable $225,000 $225,000 $200,000 Other Current Liabilities $163,380 $140,000 $136,000 Total Current Liabilities $577,431 $540,200 $481,600 Long-term Debt $424,612 $424,612 $323,432 Total Liabilities $1,002,043 $964,812 $805,032 Common Stock $460,000 $460,000 $460,000 Retained Earnings $297,039 $225,988 $203,768 Total Shareholder's Equity $757,039 $685,988 $663,768 Total Liabilities and Owner's Equity $1,759,082 $1,650,800 $1,468,800 Forecast Discretionary Financing Needed D E F G G I H Total Assets $1,820,204 $1,668,800 $1,471,200 Liabilities and Owner's Equity Accounts Payable $189,051 $175,200 $145,600 Short-term Notes Payable $225,000 $225,000 $200,000 Other Current Liabilities $163,380 $140,000 $136,000 Total Current Liabilities $577,431 $540,200 $481,600 Long-term Debt $424,612 $424,612 $323,432 Total Liabilities $1,002,043 $964,812 $805,032 Common Stock $460,000 $460,000 $460,000 Retained Earnings $297,039 $225,988 $203,768 Total Shareholder's Equity $757,039 $685,988 $663,768 Total Liabilities and Owner's Equity $1,759,082 $1,650,800 $1,468,800 + Forecast Discretionary Financing Needed Notes: Net Addition to Plant & Equipment Life of New Equipment in Years New Depreciation (Straight-line) $50,000 10 $5,000