financial analysis 494654

In this task you will use the Competition Bikes Inc. Storyline case study to prepare a summary report based on your evaluation of the company s operations.

Task:

Don't use plagiarized sources. Get Your Custom Essay on

For $10/Page 0nly

Order Essay

Note: Be sure to submit a copy of your Excel workbook when submitting your JET2 Task 1 work. The evaluator will need a copy of your data to ensure correct evaluation.

A. Prepare a summary report in which you do the following:

1. Evaluate the company s operational strengths and weaknesses based on the following:

a. Horizontal analysis results

b. Vertical analysis results

c. Trend analysis results

d. Ratio analysis results

2. Analyze the working capital of Competition Bikes Inc. Consider the following in your analysis:

Ways to improve the working capital

Ways to use excess working capital to generate an increase in profits

3. Evaluate the internal controls for the Competition Bikes Inc. purchasing system.

a. Recommend corrective actions for any weaknesses.

b. Identify the risks to the company.

i. Discuss how to mitigate the risks arising from internal control weaknesses.

4. Analyze compliance with Sarbanes Oxley requirements.

a. Recommend corrective actions for noncompliant areas.

B. If you use sources, include all in-text citations and references in APA format

	Unsatisfactory	Needs Revision	Satisfactory	Score/Level
Articulation of Response (clarity, organization, mechanics)	The candidate provides unsatisfactory articulation of response.	The candidate provides weak articulation of response.	The candidate provides adequate articulation of response.
A1a. Horizontal Analysis	The candidate does not provide a logical evaluation of the company s strengths and weaknesses based on the horizontal analysis results.	The candidate provides a logical evaluation, with insufficient support, of the company s strengths and weaknesses based on the horizontal analysis results.	The candidate provides a logical evaluation, with sufficient support, of the company s strengths and weaknesses based on the horizontal analysis results.
A1b. Vertical Analysis	The candidate does not provide a logical evaluation of the company s strengths and weaknesses based on the vertical analysis results.	The candidate provides a logical evaluation, with insufficient support, of the company s strengths and weaknesses based on the vertical analysis results.	The candidate provides a logical evaluation, with sufficient support, of the company s strengths and weaknesses based on the vertical analysis results.
A1c. Trend Analysis	The candidate does not provide a logical evaluation of the company s strengths and weaknesses based on the trend analysis results.	The candidate provides a logical evaluation, with insufficient support, of the company s strengths and weaknesses based on the trend analysis results.	The candidate provides a logical evaluation, with sufficient support, of the company s strengths and weaknesses based on the trend analysis results.
A1d. Ratio Analysis	The candidate does not provide a logical evaluation of the company s strengths and weaknesses based on the ratio analysis results.	The candidate provides a logical evaluation, with insufficient support, of the company s strengths and weaknesses based on the ratio analysis results.	The candidate provides a logical evaluation, with sufficient support, of the company s strengths and weaknesses based on the ratio analysis results.
A2. Working Capital	The candidate does not provide a plausible analysis of the working capital of Competition Bikes Inc.	The candidate provides a plausible analysis, with insufficient support, of the working capital of Competition Bikes Inc.	The candidate provides a plausible analysis, with sufficient support, of the working capital of Competition Bikes Inc.
A3. Internal Controls	The candidate does not provide a logical evaluation of the internal controls for the Competition Bikes Inc. purchasing system.	The candidate provides a logical evaluation, with insufficient detail, of the internal controls for the Competition Bikes Inc. purchasing system.	The candidate provides a logical evaluation, with sufficient detail, of the internal controls for the Competition Bikes Inc. purchasing system.
A3a. Weakness Corrective Actions	The candidate does not provide an appropriate recommendation of corrective actions for any weaknesses.	The candidate provides an appropriate recommendation, with insufficient detail, of corrective actions for any weaknesses.	The candidate provides an appropriate recommendation, with sufficient detail, of corrective actions for any weaknesses.
A3b. Risks	The candidate does not identify the risks to the company.	Not applicable.	The candidate identifies the risks to the company.
A3bi. Risk Mitigation	The candidate does not provide a logical discussion of how to mitigate the risks arising from internal control weaknesses.	The candidate provides a logical discussion, with insufficient support, of how to mitigate the risks arising from internal control weaknesses.	The candidate provides a logical discussion, with sufficient support, of how to mitigate the risks arising from internal control weaknesses.
A4. Compliance	The candidate does not provide a plausible analysis of compliance with Sarbanes Oxley requirements.	The candidate provides a plausible analysis, with insufficient support, of compliance with Sarbanes Oxley requirements.	The candidate provides a plausible analysis, with sufficient support, of compliance with Sarbanes Oxley requirements.
A4a. Noncompliance Corrective Actions	The candidate does not provide an appropriate recommendation of corrective actions for noncompliant areas.	The candidate provides an appropriate recommendation, with insufficient detail, of corrective actions for noncompliant areas.	The candidate provides an appropriate recommendation, with sufficient detail, of corrective actions for noncompliant areas.
B. Sources	If the candidate uses sources, the candidate does not provide in-text citations and/or references for each source used.	If the candidate uses sources, the candidate provides appropriate in-text citations and/or references with major deviations from APA style.	If the candidate uses sources, the candidate provides appropriate in-text citations and/or references accurately or with only minor deviations from APA style, OR the candidate does not use sources.