Suppose that ABC organization's current Sales = 20,000. Also, suppose ABC has forecast the following values:

Cost of Goods Sold (% of sales)	0.85
General, Selling and Admin Exp (% of sales)	0.10
Cash and Securities (days sales cash)	15
Accounts Receivable (collection period)	50
Inventories (inventory turnover)	10
Accounts Payable (payabels period)	60

Where days sales cash = cash / (sales/day), the collection period = AR / (sales/day), and the payables period = AP / (cost of sales/day).

Complete the template below before solving for the additional funds, or the external funding, needed to finance a 30% increase in sales.

Income Statement
Sales
Cost of Goods sold
Gross profit
Expenses:
General, selling, and admin exp
Net Interest Expense	100
Earnings before taxes
Tax
Earnings after tax
Balance Sheet
Assets
Currrent Assets:
Cash and securities
Accounts receivable
Inventories
Prepaid Expense	20
Total Current Assets
Net fixed Assets	300
Total Assets
Liabililities and owners equity
Current liabilities
Bank Loan	0
Accounts payable
Current portion of long term debt	100
Accrued wages	30
Total Current Liabilities
Long term debt	70
Common stock	150
Retained earnings	1500
Total liabilities and owners equity
External Funding Required	???