Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need a 12 month proforma income statement and a 12 month cash flow statment based off this balance sheet. this balance sheet is the

I need a 12 month proforma income statement and a 12 month cash flow statment based off this balance sheet. this balance sheet is the end of the year total

Assets

Current assets:
Cash 6,000 1.9
Accounts Receivable 12,000 3.9
Inventory 135,000 44
Prepaid expense 6,000 1.9
Short Term Investments 6,000 1.9
Total Current Assets 165,000 53.4
Fixed Assets
Building 120,000 38.9
Equipment 30,000 9.7
Leasehold improvements 15,000 4.9
other fixed assets 10,000 3.25
gross fixed assets 175,000 56.8
Less: accumulated depreciation 32,000 10.4
Net Fixed Assets 143,000 46.4
Total Assets 308,000 100
Liabilites & owners equity
Current Liabilities:
Accounts Payable 60,000 19.5
Accruals 8,000 2.6
Current Portion of Long Term Debt 18,000 35
Other current Liabilities 7,000 2.3
Total Current Liabilities 93,000 30.2
Longterm Liabilties
Mortgage loan 110,000 36
Term Loan 40,000 13
Total Long Term Liabilities 150,000 49
total Liabilities
Owners Equity
paid in Capital 70,000 23
retained Earnings 15,000 49
Total Owners Equity 85,000 28
Total liabilities and owners equity 308,000 100

Income

% of sales

Net Sales

500,000

100

Cost of goods sold

140,000

28

Gross Profit on sales

360,000

72

Expense

salaries expense

15,000

3.33

advertising

6,000

1.2

delivery and freight

15,000

2.33

misc expense

1,000

0.02

administrative expense

licenses

600

1.012

insurance

2,500

1.05

Nonsales salaries

35,000

7

payroll taxes

7,000

1.4

Rent/mortgage

14,000

2.8

Utilities

8,000

1.6

Legal fees

2,000

0.4

Depreciation

45,000

9

misc Administrative Expenses

1,000

0.02

Total Expenses

152,100

30.4

Income from operations

22,000

4.4

Other income

Interest income

500

0.1

Other expenses

16,000

3.2

Net profit before taxes

7,050

1.41

income taxes

5,000

1

net profit after taxes

6,000

1.2

note

51,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Apple Blossom Cologne Company Audit Case

Authors: Jack Paul

5th Edition

0072844507, 978-0072844504

More Books

Students also viewed these Accounting questions

Question

Persuading Your Audience Strategies for

Answered: 1 week ago