Financial Analysis/ Ratios

AC499_U4A.pdf

Home >Business & Finance homework help >Accounting homework help >Financial Analysis/ Ratios

AC499: Bachelors Capstone in Accounting | Unit 4

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. Review the solutions for the review problem. 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, not the Rainbow Company practice 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 is based on data for “Rainbow Paint Company.” Do NOT submit 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.

Once completed, submit your assignment to the Unit 4 assignment Dropbox. The assignment is due Tuesday 11:59 p.m. ET of their assigned unit.

AC499 Unit 4 Assignment: Management Tools Application

Item criteria: Points Possible

Points Earned

1. Prepare the Adjusting entries A–F. 5

2. Journalize and Post the adjusting entries. 5

3. Prepare: a. an income statement

b. a statement of owner's equity

c. a balance sheet

5 5 10

4-Journalize and post the closing entries. 5

5-Prepare a post-closing trial balance. 5