Kaplan acc499 unit 4 assignment (part 1 and 2)

Kaplan ACC499 unit 4 assignment (part 1 and 2)

Question
Unit 4 Practice Activity: Financial Report

Analysis – Rainbow Paint Co.

Note:This is a practice activity to be performed before completing the Assignment for this unit. Also,this is the data to be used as the basis for your Unit 9 Final Project. The solutions for the Unit 4 Practice activity are located here.

Rainbow Paint Co.’s comparative financial statements for the years ending December 31, 2013 and 2012 are as follows. The market price of Rainbow Paint Co.’s common stock was $30 on December 31, 1999 and $25 on December 31, 2013.

Rainbow Paint Co.

Comparative Income Statement

For the Years Ended December 31, 2013 and 2012

2013

2012

Sales

$ 5,125,000

$ 3,257,600

Sales returns and allowances

125,000

57,600

Net sales

$ 5,000,000

$ 3,200,000

Cost of goods sold

3,400,000

2,080,000

Gross profit

$ 1,600,000

$ 1,120,000

Selling expenses

650,000

464,000

Administrative expenses

325,000

224,000

Total operating expenses

$

975,000

$

688,000

Income from operations

$

625,000

$

432,000

Other income

25,000

19,200

Income before Interest & Taxes

$

$

451,200

650,000

Other expense (interest)

105,000

64,000

Income before income tax

$

545,000

$

387,200

Income tax expense

300,000

176,000

Net income

$ 245,000

$

211,200

========

========

Rainbow Paint Co.

Comparative Retained Earnings Statement

For the Years Ended December 31, 2013 and 2012

2013

2012

Retained earnings, January 1

$

723,000

$

581,800

Add net income for year

245,000

211,200

Total

$

968,000

$

793,000

Deduct dividends:

On preferred stock

$

40,000

$

40,000

On common stock

45,000

30,000

Total

$

85,000

$

70,000

Retained earnings, December 31

$

883,000

$

723,000

========

========

Unit 4 [AC499: Bachelor’s Capstone in Accounting]

Rainbow Paint C0,

Comparative Balance Sheet

December 31, 2013 and 2012

Assets

2013

2012

Current assets:

Cash

$ 175,000

$

125,000

Marketable securities

150,000

50,000

Accounts receivable (net)

425,000

325,000

Inventories

720,000

480,000

Prepaid expenses

30,000

20,000

Total current assets

$ 1,500,000

$

1,000,000

Long-term investments

250,000

225,000

Property, plant, and equipment (net)

2,093,000

1,948,000

Total assets

$ 3,843,000

$ 3,173,000

========

========

Liabilities

Current liabilities

$ 750,000

$

650,000

Long-term liabilities:

Mortgage note payable, 10%, due 2016

$ 410,000

Bonds payable, 8%, due 2017

800,000

$

800,000

Total long-term liabilities

$ 1,210,000

$

800,000

Total liabilities

$ 1,960,000

$

1,450,000

Stockholders’ Equity

Preferred 8% stock, $100 par

$ 500,000

$

500,000

Common stock, $10 par

500,000

500,000

Retained earnings

883,000

723,000

Total stockholders’ equity

$ 1,883,000

$

1,723,000

Total liabilities and stockholders’ equity

$ 3,843,000

$

3,173,000

========

=========

Instructions: Determine the following measures for 2013:

1. Working capital

2. Current ratio

3. Quick ratio

4. Accounts receivable turnover

5. Number of days’ sales in receivables

6. Inventory turnover

7. Number of days’ sales in inventory

8. Ratio of fixed assets to long-term liabilities

Unit 4 [AC499: Bachelor’s Capstone in Accounting]

9. Ratio of liabilities to stockholders’ equity

10. Number of times interest charges earned

11. Number of times preferred dividends earned

12. Ratio of net sales to assets

13. Rate earned on total assets

14. Rate earned on stockholders’ equity

15. Rate earned on common stockholders’ equity

16. Earnings per share on common stock

17. Price-earnings ratio

18. Dividends per share of common stock

19. Dividend yield

Unit 4 Assignment: Management Tools

Application

Step 1: Practice

Complete the AC499 Financial Report Analysis – Rainbow Paint Co. as practice for the Unit 4 Assignment. The solutions for the review problem can be found here.

Step 2: Review Ratio Sheet

Review the AC499 Financial Report Analysis Unit 4 Ratio Sheet.

Step 3: Financial Analysis

Complete a financial analysis of the company financials for Quixote Consulting. Use the Excel Template titled: “Unit 4 Financial Report Analysis Template.” Be sure to review the Excel tab titled “Hints & Instructions” before you attempt the Assignment tab.

Note: This Quixote Company file will be your graded Unit 4 Assignment,notthe Rainbow CompanyPractice Assignment.

When you are ready, you may submit your Quixote Ratio Analysis Excel template to the Unit 4 Dropbox page.

Note:Include your name in the filename of the Assignment.

Very Important Note:The Practice Set isbased on data for “Rainbow Paint Company.” Do NOTsubmit the Rainbow solutions in the Unit 4 Assignment Dropbox.

The Unit 4 Assignment is based on the Quixote data accumulated in Units 2 and 3. However, The Rainbow Paint Company data will be a VITAL and integral component of your Unit 9 Final Project. So, please complete the Practice Exercise AND keep your work saved in a file for later use.

Attachments
Assignment_Part_Two_(1).xlsx (19.1 KB)

Semester Papers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.