Question Details

(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

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now