Question Details

[answered] BRYANT & STRATTON COLLEGE ACCT220 - FINANCIAL A


Please look over my numbers this is a portfolio project


BRYANT & STRATTON COLLEGE

 

ACCT220 - FINANCIAL ANALYSIS

 

PORTFOLIO PROJECT Introduction Page Click Below to Access the spreadsheet you are looking for:

 

Week 4

 

This spreadsheet will give you the account balances for Week 4.

 

Week 5 The Ratios to calculate in Week 5. Week 6 The management assumptions to use to complete the Pro Forma income statement o Forma income statement in Week 6. BRYANT & STRATTON COLLEGE

 

ACCT220 FINANCIAL ANALYSIS

 

PORTFOLIO PROJECT Click here to get back to the Introduction Page WEEK 4

 

ARRANGE THE FOLLOWING FINANCIAL INFORMATION INTO THE FOLLOWING:

 

1) Comparative Balance Sheets for 2010 vs. 2011.

 

2) Comparative Income Statements for 2010 vs. 2011.

 

3) Construct the 2011 Statement of Cash Flows using items 1 and 2.

 

2010 BALANCE

 

Selling and Adminstrative Expenses

 

Interest Expense

 

Accounts Receivable (net)

 

Taxes

 

Notes Payable

 

Capital paid in excess of par

 

Cost of Goods Sold

 

Cash

 

Common Stock, $1 par value

 

Sales

 

Plant and Equipment

 

Accumulated Depreciation

 

Depreciation Expense

 

Retained Earnings

 

Bonds Payable, 2016

 

Accounts Payable

 

Operating Income

 

Accrued Expenses

 

Investments

 

Inventory

 

Prepaid Expenses

 

2010 650,000

 

54,000

 

350,000

 

91,000

 

200,000

 

500,000

 

2,300,000

 

120,000

 

250,000

 

3,600,000

 

2,500,000

 

850,000

 

90,000

 

665,000

 

700,000

 

375,000

 

560,000

 

80,000

 

150,000

 

450,000

 

50,000

 

2011 2011 BALANCE

 

600,000

 

52,000

 

425,000

 

58,000

 

175,000

 

###

 

95,000

 

###

 

3,300,000

 

2,800,000

 

950,000

 

100,000

 

905,000

 

###

 

475,000

 

350,000

 

60,000

 

100,000

 

550,000

 

45,000 BRYANT & STRATTON COLLEGE

 

ACCT220 FINANCIAL ANALYSIS

 

PORTFOLIO PROJECT Click here to get back to the Introduction Page WEEK 5

 

Calculate the 5 Financial Ratios below for BOTH 2010 AND 2011.

 

1) 2) Profit Margin

 

2010

 

2011 9.72

 

12.88 Current Ratio

 

2010

 

2011 1.97

 

1.28 3) Receivables Turnover

 

2010

 

43

 

2011

 

51 4) Inventory Turnover

 

2010

 

1.09

 

2011

 

0.81 5) Return on Assets

 

2010 .10:1

 

2011 .46:1 see word doc

 

Word Report on Financial Statements and Ratios 5 GE

 

IS tion Page TH 2010 AND 2011. BRYANT & STRATTON COLLEGE

 

ACCT220 FINANCIAL ANALYSIS

 

PORTFOLIO PROJECT Click here to get back to the Introduction Page WEEK 6

 

You will need your final 2011 Income Statement from Week 4 for this assignment.

 

Use your 2011 Income Statement as your base, and then make the adjustments listed below in

 

order to construct a 2012 Pro Forma Income Statement.

 

Pro Forma Income Statement for 2012 includes the following Management assumptions.

 

1) Sales for existing business will remain at $3,300,000, but add $500,000 for new clothing line.

 

Pro Forma Income management has the opportunity to offer more goods and servicesreinvestment of

 

Statement

 

2) Cost of Goods Sold for existing business will remain at $2,250,000. Add $300,000

 

to Cost of Goods Sold for new clothing line.

 

3) Selling and Administrative Expenses will increase by 15% with new line.

 

600,000 *.15 adds 90,000 expenses

 

4) Assume Interest will be $50,000 in 2012.

 

It will add an additional 140,000

 

5) Assume Taxes will be 30% of Earnings Before Taxes for 2012. 1,140,000 in taxes Write a minimum of a 300 word report on your findings. Discuss the trends you see on the 2011 vs. 201

 

Income Statements. How much does profits increase as a result of adding the assumed clothing

 

Word Report on Pro line sales. Does it all seem worth it? What risks do you see with the company if sales that

 

Forma

 

management is assuming here are not achieved?

 

You may be creative with this report.

 

see wk 6 word doc

 

Write a minimum of a 300 word Reflection telling me what you learned from this 3 week assignment.

 

Word Reflection on Are financial statements easier to create and interpret as a result of this assignment?

 

Portfolio Project

 

Can you better see how financial ratios can illustrate the financial condition of the company? ents listed below in assumptions. or new clothing line. you see on the 2011 vs. 2012

 

he assumed clothing

 

ny if sales that this 3 week assignment. of the company?

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001005823.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

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 18, 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 YOUR SET DEADLINE.

Order Now