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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started