Need help with Ratio Analysis

Due Date: Sunday of Unit 2 Total Points: 100 Evaluating Financial Performance – Ratio Analysis In this assignment, you will be comparing financial ratios between Wicked Good Cupcakes and the company you chose to blog about. Instructions: Using the attached Excel spreadsheet for Wicked Good Cupcakes (WGC) calculate the listed ratios.

1. Copy and paste your ratio calculation as a Table 1, inserted into the Word document.

2. What do these ratios suggest about the company’s performance during the period presented?

3. In Table 2 list the 5 ratios from your ‘blog company’ and corresponding ratios for WGC.

4. Are these ratios ‘comparable’ for these two companies? Explain why you think they are/not comparable.

5. Which ratios would a senior operational manager for WGC be most interested in following?

Requirements: .

• All questions posed must be addressed completely. • All sources used must be properly cited in APA format.

Be sure to read the criteria, by which your assignment will be evaluated,

before you write, and again after you write.

BUS522 Financial Tools for Managers

Unit 2 Assignment: Shark Tank: Wicked Good Cupcakes II

Evaluation Rubric for Unit 2 Assignment

CRITERIA Exemplary Proficient Deficient (9 – 10 Points) (7 – 8 Points) (0 – 6 Points)

Overview of the Two Companies

An overview is clearly presented including all key details.

An overview is presented, though key details may not be clearly or completely presented.

Does not provide an overview or the overview is missing key details.

(18 – 20 Points) (13 – 17 Points) (0 – 12 Points) Table 1 w/Evaluation of the Company’s Performance

Table 1 and evaluation are clearly presented including all key details.

Table 1 and evaluation are presented, though key details may not be clearly or completely presented.

Does not provide Table 1 and evaluation or is missing key details.

Table 2 The Table 2 is clearly presented including all key details.

Table 2 is presented, though key details may not be clearly or completely presented.

Does not provide Table 2 or missing key details.

Compare and Contrast Both Company’s Ratios

The comparison is clearly presented including all key details.

The comparison is presented, though key details may not be clearly or completely presented.

Does not compare and contrast or is missing key details.

Ratios Important to a Senior Operational Manager and Rationale

The important ratios and rationale are clearly presented including all key details.

The important ratios and rationale are presented, though key details may not be clearly or completely presented.

Does not provide important ratios and rationale or is missing key details.

(9 – 10 Points) (7 – 8 Points) (0 – 6 Points) Clear and Professional Writing and APA Format

Writing and format is clear, professional, APA compliant, and error free.

Few errors that do not impede professional presentation.

Errors impede professional presentation; guidelines not followed.