1. Use the following financial statements and financial data to create a pro forma income statement and balance sheet for Bo Knows Profit Corporation. Please determine if they will need additional funding or if they will have excess funding. Bo Knows Profit Corporation Income Statement for Year Ending 2011 Sales $8,800 Less: Costs 5,000 Depreciation 900 EBIT 2,900 Less: Interest 350 EBT 2,550 Taxes 850 Net Income $1,700 Bo Knows Profit Corporation Balance Sheets for End of Years 2010, 2011 2011 2010 2011 2010 Cash $110 170 Accounts Payable 120 135 700 500 Notes Payable Accounts Receivable 1,400 1,200 Inventory 1,000 1,24 Current Liabilities 1,520 1,335 Current Assets 1,810 1,910 Long-term Debt 2,620 2,005 Fixed Assets 3,500 2,000 Common Stock 200 100 (50 shares) Retained Earnings 970 470 Total Assets 5,310 3,910 5,310 3,910 Total Liab. & Equity Financial Data: oa (50 shares) Retained Earnings 970 470 Total Assets 5,310 3,910 5,310 3,910 Total Liab. & Equity Financial Data: 1) Assume that sales will grow by 20%. 2) Accounts Receivable will represent 15% of sales. 3) Inventory is expected to be 20% of sales. 4) Bo Knows will purchase $500 in fixed assets and book $640 in depreciation. 5) All other spontaneous accounts will grow in proportion to sales. 6) Dividend is expected to remain constant. (Hint: you can find current dividend from historical data) Question 3 (1 point) 2. Given above Income Statement and Balance Sheet for Bo Know only, forecast Bo Knows's 1st Pass additional funds needed (AFN) for the coming year. 1,168 674 975 993 607 Question 4 (1 point) 4. Find the projected addtion to Retained Earning of the second pass. 989 1,011 Question 4 (1 point) 4. Find the projected addtion to Retained Earning of the second pass. 989 1,011 0661 644 1,141 Question 5 (1 point) 5. Given above Income Statement and Balance Sheet for Bo Know only, forecast Bo Knows's 2nd Pass additional funds needed (AFN) for the coming year. - 15 1,141 Question 5 (1 point) 5. Given above Income Statement and Balance Sheet for Bo Know only, forecast Bo Knows's 2nd Pass additional funds needed (AFN) for the coming year. 0-15 35 17 39 79 1. Use the following financial statements and financial data to create a pro forma income statement and balance sheet for Bo Knows Profit Corporation. Please determine if they will need additional funding or if they will have excess funding. Bo Knows Profit Corporation Income Statement for Year Ending 2011 Sales $8,800 Less: Costs 5,000 Depreciation 900 EBIT 2,900 Less: Interest 350 EBT 2,550 Taxes 850 Net Income $1,700 Bo Knows Profit Corporation Balance Sheets for End of Years 2010, 2011 2011 2010 2011 2010 Cash $110 170 Accounts Payable 120 135 700 500 Notes Payable Accounts Receivable 1,400 1,200 Inventory 1,000 1,24 Current Liabilities 1,520 1,335 Current Assets 1,810 1,910 Long-term Debt 2,620 2,005 Fixed Assets 3,500 2,000 Common Stock 200 100 (50 shares) Retained Earnings 970 470 Total Assets 5,310 3,910 5,310 3,910 Total Liab. & Equity Financial Data: oa (50 shares) Retained Earnings 970 470 Total Assets 5,310 3,910 5,310 3,910 Total Liab. & Equity Financial Data: 1) Assume that sales will grow by 20%. 2) Accounts Receivable will represent 15% of sales. 3) Inventory is expected to be 20% of sales. 4) Bo Knows will purchase $500 in fixed assets and book $640 in depreciation. 5) All other spontaneous accounts will grow in proportion to sales. 6) Dividend is expected to remain constant. (Hint: you can find current dividend from historical data) Question 3 (1 point) 2. Given above Income Statement and Balance Sheet for Bo Know only, forecast Bo Knows's 1st Pass additional funds needed (AFN) for the coming year. 1,168 674 975 993 607 Question 4 (1 point) 4. Find the projected addtion to Retained Earning of the second pass. 989 1,011 Question 4 (1 point) 4. Find the projected addtion to Retained Earning of the second pass. 989 1,011 0661 644 1,141 Question 5 (1 point) 5. Given above Income Statement and Balance Sheet for Bo Know only, forecast Bo Knows's 2nd Pass additional funds needed (AFN) for the coming year. - 15 1,141 Question 5 (1 point) 5. Given above Income Statement and Balance Sheet for Bo Know only, forecast Bo Knows's 2nd Pass additional funds needed (AFN) for the coming year. 0-15 35 17 39 79