(solution) Balance Sheet Rolling Acres Brewery LLC Date: Assets 2016 Current

(solution) Balance Sheet Rolling Acres Brewery LLC Date: Assets 2016 Current

The instructions  below explain the paper and the financial statements needed.  It is a 3 page paper APA formatted with 3 references cited.  There will need to be in text citations as well.  I have attached the financial statements the only one that isn’t finished is the income statement, the income statement needs to be finished using the data from the other sheets.  The paper is for a craft brewery named Rolling Acres Brewery LLC.  

In part I, using Microsoft Excel worksheets create 3 years of income statements, balance sheets, and cash flow statements.

In part 2, using Microsoft Word®, create a 3-4 page financial summary detailing your income statements, balance sheets, and cash flow statements.

When you are ready, submit your Microsoft Word Document and Excel file on the Dropbox page. *Note, include your name in the file name of each Assignment.

Assignment checklist Items:

  • Create an income statement and balance sheet.
  • Create cash flow analysis.
  • Create an Excel spreadsheet that includes the financial aspects associated with your Final Project, including income statements, balance sheets, and cash flow statements.
  • Complete a financial summary on Excel Spreadsheet financial reports.

For help using the Dropbox, click on Academic Tools above then Dropbox Guide.

Aspect Percentage of assignment Score MT499 Assignment Criteria Content, Focus, use of Research 50% (30pts) Addresses all assignment requirements, indicates depth of knowledge about the topics and key areas, contains a clear and concise introduction with a thesis statement, comprehension body of paper, closing summary, and includes a minimum of three cited and referenced resources (APA 6th edition).

Analysis

and

Critical

Thinking

30% (18pts) Analysis and critical thinking indicates optimal reasoning with a defined purpose, based on assumptions, writer’s point of view, discusses the advantages and disadvantages, and uses data, information, and concepts/ideas to address the assignment topics or key areas in the paper.

Writing

Style,

Grammar,

APA

Format

20% (12pts) The capstone uses the APA (6th edition) writing style using active voice, which is in third person and concisely written. The paper is free from incorrect punctuation, use of jargon/clichés, incorrect grammar and mechanics, and is correctly formatted based on APA 6th edition guidelines.Total Points100% (60pts)

Balance Sheet Rolling Acres Brewery LLC Date: Assets 2016 Current Assets
Cash
Accounts receivable
Inventory
Prepaid expenses
Short-term investments 2015 2014 11,874
.
3
Total current assets Fixed (Long-Term) Assets
Long-term investments
Property, plant, and equipment
(Less accumulated depreciation)
Intangible assets 11,877 – – 1,208
15,340
(2,200)
Total fixed assets 14,348 – – Total Other Assets – – – 26,225 – – – – – – 11,567 – – 26,222 – – Other Assets
Deferred income tax
Other Total Assets
[42] Liabilities and Owner's Equity
Current Liabilities
Accounts payable
Short-term loans
Income taxes payable
Accrued salaries and wages
Unearned revenue
Current portion of long-term debt
Total current liabilities
Long-Term Liabilities
Long-term debt
Deferred income tax
Other
Total long-term liabilities
Owner's Equity
Owner's investment
Retained earnings
Other
Total owner's equity Total Liabilities and Owner's Equity 8,060
3,145 11,205
3,450 3,450
7,178
4,389 {42} {42} Common Financial Ratios
Debt Ratio (Total Liabilities / Total Assets)
Current Ratio (Current Assets / Current Liabilities)
Working Capital (Current Assets – Current Liabilities)
Assets-to-Equity Ratio (Total Assets / Owner's Equity)
Debt-to-Equity Ratio (Total Liabilities / Owner's Equity) 0.56
1.06
672
2.27
1.27 – – Rolling Acres Brewery LLC For the Years Ending [Dec 31, 2016, Dec 31, 2015, and Dec 31,20 Revenue
Gross sales
(Less sales returns and allowances) Net Sales Cost of Goods Sold
Beginning inventory
Goods purchased or manufactured
Total Goods Available
(Less ending inventory)
Cost of Goods Sold Gross Profit (Loss)
[42] Expenses
Advertising
Bad debt
Commissions
Depreciation
Employee benefits
Furniture and equipment
Insurance
Maintenance and repairs
Office supplies
Payroll taxes
Rent
Research and development
Salaries and wages
Software
Travel
Utilities
Web hosting and domains
Other
Total Operating Expenses Operating Income (Loss)
Non-operating revenues, expenses, gains, losses
(Less interest expense)
Income Before Taxes
(Less income tax expense) Income From Continuing Operations
{42} Below-the-Line Items
Income from discontinued operations
Extraordinary items
Cumulative effect of accounting changes Net Income Income Statement 31, 2016, Dec 31, 2015, and Dec 31,2014] 2014 2015 2016 520,652
(26,785) 721,412
(32,568) 1,130,562
43,687 493,867 688,844 1,174,249 15,000
360,706
375,706
2,000
377,706 2,000
360,706
362,706
3,250
365,956 3,250
360,706
363,956
5,314
369,270 116,161 322,888 804,979 3,600
3,000
1,525
10,500 13,333
13,658
6,320
3,896
4,500
1,985
13,000 13,333
14,698
21,540
4,562
8,965
3,154
14,783 5,800
42,000 7,256
52,000 8,632
83,000 10,000 13,333
12,000 5,400
420
107,578 3,450
6,200
560 6,432
7,456
765 126,158 187,320 8,583 196,730 617,659 135,000
(25,600)
117,983
(1,069) 116,914 98,000
(25,600)
269,130
(1,069) 268,061 (25,600)
592,059
(2,138) 589,921
[42] [42] 116,914 268,061 589,921 Rolling Acres Brewery LLC
3-Year Cash Flow
For the Year Ending 12/31/2014 12/31/2015 12/31/2016
Cash at Beginning of Year (796,370) (649,993) (365,966)
Cash at End of Year (649,993) (365,966)
246,923 Operations
Cash receipts from
Customers
Other operations
Cash paid for
Inventory purchases
General operating and administrative expenses
Wage expenses
Interest
Income taxes Net Cash Flow from Operations
[42] 2014 2015 2016 520,652 721,412 1,130,562 (211,000)
(57,600)
(42,000)
(25,600)
(10,500) (245,610)
(62,300)
(52,000)
(25,600)
(13,000) (276,850)
(78,324)
(83,000)
(25,600)
(20,750) 173,952 322,902 646,038 Investing Activities
Cash receipts from
Sale of property and equipment
Collection of principal on loans
Sale of investment securities
Cash paid for
Purchase of property and equipment
Making loans to other entities
Purchase of investment securities Net Cash Flow from Investing Activities 135,000 98,000 0 (200,000) (174,300) (27,000) (65,000) (76,300) (27,000) Financing Activities
Cash receipts from
Issuance of stock
Borrowing
Cash paid for
Repurchase of stock (treasury stock)
Repayment of loans
Employee Profit Sharing Net Cash Flow from Financing Activities
Net Cash Flow 37,425
0 37,425
0 37,425
(43,574) 37,425 37,425 (6,149) 146,377 284,027 612,889