Question: the financial statements you created for Assignment 1 and create pro forma statements in your spreadsheet software. Each pro forma statement should have a different
the financial statements you created for Assignment 1 and create pro forma statements in your spreadsheet software. Each pro forma statement should have a different projection. At least one should include a revenue increase and at least one should include the receipt of capital funding. The third is your choice. Include the following with your submission:
Pro forma income statement #1 1. INCOME STATEMENT, BALANCE SHEET, CASH FLOW STATEMENT ONE PRO FORMA PROJECTION WITH A PERCENTAGE INCREASE IN REVENUE. ANOTHER PRO FORMA PROJECTION 2.. INCOME STATEMENT , BALANCE SHEET, AND CASH FLOW STATEMENT WITH A $500,000 RECEIPT OF CAPITAL FUNDING. AND ANOTHER PRO FORMA STATEMENTS 3. INCOME STATEMENT, BALANCE SHEET, AND CASH FLOW STATEMENT FOR A $600,000 PURCHASE OF A BUILDING (ASSET) 3 PRO FORMA STATEMENTS FOR EACH CONDITION.
Pro forma income statement #2
| 3 Statements to answer the submitted question | ||||||||
| 3 | Sales Forecast | |||||||
| 4 | ||||||||
| 5 | Income Statement | |||||||
| 6 | Sales Revenue | 34,290 | ||||||
| 7 | less: Cost of Goods Sold | |||||||
| 8 | GROSS PROFIT | 34,290 | 0 | 0 | 0 | 0 | ||
| 9 | less: Selling Expenses | |||||||
| 10 | General and Administrative Expenses | 2,500 | ||||||
| 11 | Depreciation Expense | 7,500 | ||||||
| 12 | Other Operating Expenses | |||||||
| 13 | Total Operating Expenses | 10000 | 0 | 0 | 0 | 0 | ||
| 14 | OPERATING PROFIT | 24290 | 0 | 0 | 0 | 0 | ||
| 15 | less: Interest and Other Expenses | 2500 | ||||||
| 16 | plus: Interest and Other Revenues | |||||||
| 17 | PRE-TAX INCOME | 21790 | 0 | 0 | 0 | 0 | ||
| 18 | Income Tax | |||||||
| 19 | NET INCOME | 21790 | 0 | 0 | 0 | 0 | ||
| 20 | ||||||||
| 21 | Balance Sheet | |||||||
| 22 | ASSETS | |||||||
| 23 | Cash and Equivalents | 9,000 | 12,000 | |||||
| 24 | Accounts Receivable | 3,179 | ||||||
| 25 | Inventory | |||||||
| 26 | CURRENT ASSETS | 9000 | 15179 | 0 | 0 | 0 | 0 | |
| 27 | Net Fixed Assets | 747,300 | 763,800 | |||||
| 28 | TOTAL ASSETS | 756,300 | 778979 | 0 | 0 | 0 | 0 | |
| 29 | LIABILITIES AND EQUITY | |||||||
| 30 | Accounts Payable | 16,800 | 14,460 | |||||
| 31 | Notes Payable | |||||||
| 32 | Wages Payable | |||||||
| 33 | Taxes Payable | |||||||
| 34 | Current Portion of Long-Term Debt | |||||||
| 35 | CURRENT LIABILITIES | 16,800 | 14460 | 0 | 0 | 0 | 0 | |
| 36 | Long-Term Debt | 499,652 | 468,000 | |||||
| 37 | TOTAL LIABILITIES | 516,452 | 482,460 | 0 | 0 | 0 | 0 | |
| 38 | Common Stock | |||||||
| 39 | Retained Earnings | |||||||
| 40 | TOTAL EQUITY | 239,848 | 269,519 | 0 | 0 | 0 | 0 | |
| 41 | TOTAL LIABILITIES AND EQUITY | 756,300 | 778,979 | 0 | 0 | 0 | 0 | |
| 42 | ||||||||
| 43 | Cash Flow Statement | |||||||
| 44 | Net Income | 24,290 | ||||||
| 45 | Depreciation Expense | 7,500 | ||||||
| 46 | Net Income plus Depreciation Expense | 31790 | 0 | 0 | 0 | 0 | ||
| 47 | plus: Increase in Accounts Payable | |||||||
| 48 | Increase in Other Payables | |||||||
| 49 | less: Increases in Accounts Receivable | |||||||
| 50 | Increase in Inventory | |||||||
| 51 | OPERATING CASH FLOW | 26,790 | 0 | 0 | 0 | 0 | ||
| 52 | plus: Net Cash from Financing Activities | |||||||
| 53 | less: Net Investment Outlays | |||||||
| 54 | NET CASH FLOW | 26790 | 0 | 0 | 0 | 0 | ||
| 55 | plus: Beginning Cash | |||||||
| 56 | ENDING CASH BALANCE | 26790 |
Pro forma income statement #3
Continue with your 3 pro forma income statements and create 3 pro forma balance sheets and 3 pro forma cash flow statements in your spreadsheet software, based on those pro forma income statements. Each pro forma statement should have a different projection. Include the following with your submission:
Pro forma income statement #1 (revenue increase projection)
Pro forma balance sheet #1
Pro forma cash flow statement #1
Pro forma income statement #2 (capital funding projection)
Pro forma balance sheet #2
Pro forma cash flow statement #2
Pro forma balance sheet #3 PURCHASE OF A BUILDING (ASSET) FOR MY BUSINESS
Pro forma cash flow statement #3
Pro forma income statement #3 (your choice) QUESTIONS FOR THE 3 FINANCIAL STATEMENT FOR PRO FORMA Larry G. Heath
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
