Question Details

[answered] A big part of the project is to put the company that you se


I have attached a sample on a project that I work on a few weeks ago. Hope this help, would you be able to help me. the assignment requires to go to Sec.gov and select 3 companies and then it requires to answer 10 question. I have attached what is the project about and a sample about a project we?work a few weeks ago.??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????


A big part of the project is to put the company that you select financial statements into Microsoft Excel. In the module four of the text book there is information about how to format that spreadsheet. See the section on vertical and horizontal analysis. You will notice that there is "common?sized" balance sheet and income statement. There are three years of financial numbers presented and then the related percentages. The percentages will allow you to compare different years to see trends. For instance is the company's cost of sales as a percentage of sales going up or down. Is net earnings as a percentage of sales going up or down. For the income statement each line is divided by the Sales to come up with the percentages. For the balance sheet each line is divided by the total assets to develop those percentages (the cash balance/total assets for example).

 

MBA Class Case assignment

 

Go to Sec.gov and click the filings menu. There is an instruction guide about using the filing database.

 

Select a public company, such as IBM or Apple and review their latest 10K filing. After you?ve picked that

 

company, select 2 competitors to that company as well.

 

As a result of your success after completing your MBA at UML, you are now CEO of a publically traded

 

company looking to acquire another company in your industry. Answer the following questions. Use

 

Word and embed Excel items into your Word file to complete your project. 1. Which company are you CEO for and who are the 2 acquisition targets?

 

My Company:

 

Target 1:

 

Target 2: 2. Although you are competitors, how does your target companies differ from your company? Do

 

they offer products you do NOT offer? Are they in geographies you are NOT in? 3. Who are the external auditors for each company? What opinions do the auditors give in these

 

financials? What year-ends do these companies use (yours and the acquisition targets)? 4. Create a spreadsheet in a common size income statement format for the most recent year and

 

the year before. Create a % of sales for each item next to the amounts that are given on the 10k

 

income statement. Do this for your company and the targets. 5. Create a spreadsheet in a common size Balance sheet format for the most recent year and the

 

year before. Create a % of total assets for each item next to the amounts that are given on the

 

10k balance sheet statement. Do this for your company and the targets. 6. Does your company have any intangible assets? If yes what are they? Do this for your company

 

and the targets. 7. What % of financing comes from non-owners and owners? Did the percentages change much

 

between the two years? Do this for your company and the targets. 8. Did sales (revenue) and profitability (net income) grow in your company from year to year? By

 

what percentage did sales and profitability increase or decrease? What contributed to the sales

 

and profit change year over year? 9. Calculate for both years the following ratios: Return on assets, Return on equity, Current ratio

 

10. Which company should you acquire and WHY?

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 18, 2020

PRICE: $15

Solution~0001003009.zip (25.37 KB)

Buy this answer for only: $15

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy from our tutoring website www.aceyourhomework.com (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 18, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now