Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions