5. (10 points) Your staff has provided their forecast of the following financial areas of OST Supply Corporation (in the table below) for 2021, but did not complete the Proforma Statements that result from the forecasts. 2020 OST Supply Corp. - Forecasts Sales Net Profit Margin Dividends Total Assets Long Term Debt Common Stock 2021 125,425,000 3.15% 0 71,671,429 35,835,714 18,459,000 Last year's (2020) Retained Earnings 11,250,000 a. Using this data, complete the proforma financial statements below (next page) by filling in the appropriate (white/unshaded) blanks. You do not need the other (dark grey) blanks. b. Based on your proforma financial statements, what is the firm's estimated Additional Funds Needed for 2021? OST Supply Corporation Proforma Financial Statements 2020 2021 Income Statements (000s). Sales Cost of goods sold Gross profit Operating Expenses Advertising Depreciation EBIT Interest EBT Taxes EAT Dividends 2020 2021 Balance Sheets (000s) Cash Accounts receivable Inventory Total current assets Land Buildings and equipment Less: accumulated depreciation Total fixed assets Total assets Accounts payable Bank notes Total current liabilities Long-term debt Common stock Retained earnings Total liabilities & equity AFN 5. (10 points) Your staff has provided their forecast of the following financial areas of OST Supply Corporation (in the table below) for 2021, but did not complete the Proforma Statements that result from the forecasts. 2020 OST Supply Corp. - Forecasts Sales Net Profit Margin Dividends Total Assets Long Term Debt Common Stock 2021 125,425,000 3.15% 0 71,671,429 35,835,714 18,459,000 Last year's (2020) Retained Earnings 11,250,000 a. Using this data, complete the proforma financial statements below (next page) by filling in the appropriate (white/unshaded) blanks. You do not need the other (dark grey) blanks. b. Based on your proforma financial statements, what is the firm's estimated Additional Funds Needed for 2021? OST Supply Corporation Proforma Financial Statements 2020 2021 Income Statements (000s). Sales Cost of goods sold Gross profit Operating Expenses Advertising Depreciation EBIT Interest EBT Taxes EAT Dividends 2020 2021 Balance Sheets (000s) Cash Accounts receivable Inventory Total current assets Land Buildings and equipment Less: accumulated depreciation Total fixed assets Total assets Accounts payable Bank notes Total current liabilities Long-term debt Common stock Retained earnings Total liabilities & equity AFN
