Part A: Historical Portion Place the Balance Sheet and Income Statement of: Luxio Golf Corp. in Excel See Luxio Golf Income Statement and Balance Sheet file Part B: Financial Planning - Pro Forma Statements 1. Using the financial statements for 2009 as your 'base', assume that Luxio's sales are 20% higher for 2010. Use this projection to prepare the pro forma statements following the requirements listed below. Assume the change in sales is permanent. 2. For the Income Statement: I Cost of Goods Sold is expected to remain constant; I 'Depreciation' and 'Interest paid' expenses are expected not to change; I The Tax rate is expected to decrease to 32%; and I Management is expected to increase the amount of dividends paid by 5% (therefore, the Dividend payout rate will increase by 5%). 3. For the Balance Sheet: I 'Current assets' change in direct proportion to sales; I 'Fixed assets' are being operated at 100% of capacity; I 'Accounts payable' changes in direct proportion to sales; I 'Notes payable' and 'Other' current liabilities do not change; I 'Common stock' remains unchanged; and I Use 'Longterm debt' as the plug variable. 4. Determine the amount of External Financing Needed (EFN) under the pro forma assumptions. Detail how this external financing is distributed