Need help with your Discussion

Get a timely done, PLAGIARISM-FREE paper
from our highly-qualified writers!

glass
pen
clip
papers
heaphones

Cuyamaca MKT Capitalization Total Revenues Operating Income & Net Income Excel Task

Cuyamaca MKT Capitalization Total Revenues Operating Income & Net Income Excel Task

Cuyamaca MKT Capitalization Total Revenues Operating Income & Net Income Excel Task

Question Description

Part I Individual Company Report (3 to 5 pages)

Each member of the team is required to prepare this portion of the assignment individually and without assistance from the other members of the group.

1. Identify overall corporate objectives of your company and strategies implemented to achieve those objectives.

To best understand and respond to the above question, I recommend that you first think through the overall business model of your company, including its targeted customers, products and/or services, markets, key business processes (internal allocation of resources), key alliance relationships (partnerships with external organizations), and external forces that impact the company’s ability to meet its strategic objectives. These items are a checklist of what is generally important to a company’s economic operations BUT it is not exhaustive – you will need to analyze your company to identify what affects the overall business model – these items are a good starting place. To the extent you find them important, they should be described in your paper.

2. Identify the significant risks that potentially could impede your company from achieving each objective. This includes risks inherent in the industry, the company and even accounting policy choices.

The 10-K lists a large number of risks in Part 1A. Not all of these risks are significant. You need to consider what your company does and identify the risks that are unique to that industry or that company specifically. For example, the following is not a significant risk:

“Adverse economic and geopolitical conditions and dislocations in the credit markets could have a material adverse effect on our financial condition, results of operations, cash flow and per share trading price of our common stock.”

Almost all companies will have this risk disclosure (or something similar) – this is like saying “If a meteor hits earth and destroys all living things, our business may be adversely affected” – no kidding. Find something more unique and explain how it affects the strategies you identified.

3. Select one (you can always select moreif you think necessary) of the significant accounting policies and explain why this policy is important to your company.

Risk assessment also occurs at the financial statement level. Identify what you consider to be the significant accounting policy areas for your company. “Significant” implies two characteristics: (1) the policy surrounds a transaction or operating characteristic that is material to the company and (2) there exists some complexity with regards to the accounting policy choice.

For example, almost all notes to the financial statements contain an accounting policy note (almost always Note 2) – most will also refer to an accounting policy on cash and cash equivalents. Unless your company uses cash in some unique fashion, this is a boilerplate disclosure that really is meaningless. Find a footnote that matters – one that has an effect on the strategies you described in part a. You can also review the “MD&A,” management’s discussion and analysis, for items that may be useful.

Provide a detailed explanation of the technical guidance with respect to this policy. How does your company’s choice with respect to this accounting policy compare with that of your company’s competitors? Are there other alternatives or choices that might be selected for these types of transactions? Do these accounting policies seem aggressive or conservative? To respond to this question, you are almost certainly going to have to review the accounting guidance on the type of transactions you selected – don’t be shy – use the Accounting Standards Codification to gather the current guidance on your policy.

4. Find the investor relations website and listen to at least the most recent analysts’ call on earnings.

Include a description of the issues the analysts discuss with the company leadership and have provided in any analysts’ reports. Provide your own interpretation.

5. Provide a conclusion that includes a buy/hold/sell recommendation for your company’s stock.

Provide a summary analysis that supports your recommendation.

Most if not all of the information can be found in the company’s Form 10-K for the most recent year. Public documents filed with the Securities and Exchange Commission can be found in the EDGAR system at www.sec.gov (for additional info go to: http://www.sec.gov/edgar/quickedgar.htm#.U9qvMuNkR…. Most companies also have an investor relations section of their website with information. The Bloomberg machines located in the Wells Fargo Financial Markets Lab in the Love Library also have the SEC filings (see the Excel-based project in Part 2 for more information). You should provide proper citations using either MLA or APA style (you may choose either, but be consistent. For tips:

https://owl.english.purdue.edu/owl/section/2/

You will have a strong urge to copy and paste from the source documents – avoid the temptation. I want YOUR assessment and analysis of the public information provided not simply a regurgitation of the information in a 10-K.

The final report & Excel (see below) should be submitted to Turnitin on November 24thby 9PM.

Part II: Individual Excel-based report

In addition to the written report, you will also need to prepare an excel-based report that presents the information in the table below. This information can be found in a number of places, including through the Love Library Mergent Online portal at: http://www.mergentonline.com.libproxy.sdsu.edu/bas….

You should download the necessary information into a “base” excel spreadsheet. You must then build the table and charts using links to the underlying data (no “typing” amounts into the final tables). In addition, you should format your tables to maximize a professional presentation when printed.

Submit your completed excel file to Turnitin on or before the scheduled due date.

The format should be clean and neat, similar to if you were presenting the information to a group of potential investors, your boss, or a client.

Prepare the following excel charts and tables:

1. Page 1 –

a. A five-year line chart with the following lines:

i. Your company’s stock price, and

ii. The mean stock price of your company’s five closest competitors.

b. Bottom of Page – a table showing for your company and each of the five nearest competitors:

i. Total Current Market Capitalization

ii. And for the most recent year:

1. Total Revenues

2. Operating Income

3. Net Income

2. Page 2 –

a. Top half of page – data table showing the growth ratesin percentages for your company over the most recent one, three- and five-year periods of time:

i. Revenue %

ii. Operating income %

iii. Earnings per share %

iv. Dividends %

v. Book Value/Share %

vi. Stock Total Return %

b. Bottom half of page – Profitability analysis table showing your company current and most recent five-year average and the most recent year end for the five nearest competitors:

i. Return on equity %

ii. Return on assets %

iii. Revenue/Employee $

iv. Fixed asset turns

v. Inventory turns

Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."

Order Solution Now

Our Service Charter


1. Professional & Expert Writers: Eminence Papers only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Eminence Papers are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Eminence Papers are known for the timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Eminence Papers, we have put in place a team of experts who answer all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.

We Can Write It for You! Enjoy 20% OFF on This Order. Use Code SAVE20

Stuck with your Assignment?

Enjoy 20% OFF Today
Use code SAVE20