Prepare an analysis report using excel based on items a

Assignment Help Finance Basics
Reference no: EM13862038

MBA520 - Project #3 - Financial Reporting and Analysis

Deliverables: 

Prepare an analysis report using Excel based on items a-s below.  Analyze the financials for 3M - 10-Ks for 2013 and 2014.  Your report should show your computations (including the inputs into each formula), as well as provide a brief explanation of each ratio, and brief explanation of what you learned from analyzing the 2013 and 2014 trend for each ratio.

Using Word summarize your findings in a 2 page memo to your instructor using your calculations in your analysis report to support your statements (items t, u, and v below can be explained here). 

When finished upload your files (1 Excel spreadsheet and 1 Word document) to the link in the Blackboard classroom...under Assignments, in the Project's folder. 

SEC EDGAR Instructions (reminder from project #1) - Log onto the SEC EDGAR search site using the following: https://www.sec.gov/edgar/searchedgar/webusers.htm  

Review 3M's 10-Ks for 2013 (filed 2/13/2014) and 2014 (filed 2/12/2015) and calculate the below items.  Use the Boolean search link; then type the following search parameters:  3M 10-K for the years 2013 (this is a drop down menu) - 2015 [the company name in the company name box along with the report you are searching for -10-K report]. Find 3M and click on the HTML link to the right. 

a. Compute net operating profit after tax (NOPAT) for 2013 and 2014.  Assume that the combined federal and state statutory tax rate is 37% (on page 70 of the 2014 10-K you will see a different combined rate, but to be consistent with Problem 4-36, use 37%).

b. Compute net operating assets (NOA) for 2013 and 2014.  If noncurrent investments are reported, treat them as nonoperating items.

c. Compute RNOA; also, compute net operating profit margin (NOPM) and net operating asset turnover (NOAT) for 2013 and 2014.  Confirm the relation: RNOA= NOPM X NOAT.

d. Compute net nonoperating obligations (NNO) for 2013 and 2014.  Confirm the relation: NOA = NNO + Stockholders' equity.

e. Compute the asset turnover for 2013 and 2014.

f. Compute the return on assets for 2013 and 2014.

g. Compute return on equity (ROE) for 2013 and 2014.

h. What is the nonoperating return component of ROE for 2013 and 2014.

i. Explain the difference between ROE and RNOA.  What inference can you draw from this comparison?

j. Compute the current ratio and quick ratio for 2013 and 2014.  Comment on any observed trends.

k. Compute times interest earned and liabilities-to-equity ratios for 2013 and 2014.  Comment on any changes.

l. Compute net working capital for 2013 and 2014.

m. Compute accounts receivable turnover for 2013 and 2014.

n. Compute inventory turnover for 2013 and 2014.

o. Compute operating cash flow to current liabilities for 2013 and 2014.

p. Compute operating cash flow to capital expenditures for 2013 and 2014.

q. Trend cash from operating, investing, and financing operations.  Comment on your findings.

r. Compute EPS and Diluted EPS for 2013 and 2014 - check your calculation to the reported EPS in the reported financials.

s. Who are the auditors for 3M?  Explain the auditors' findings for both years (2013 and 2014).

t. Summarize your findings about the company's liquidity and solvency.  Do you have any concerns about its ability to meet its debt obligations?  Explain.

u. Should your company invest in 3M?  Explain.

v. Would 3M make a good personal investment?  Explain.

Reference no: EM13862038

Questions Cloud

What are the maximum nu and corresponding processing gain n : If E=1 Joules and the maximum coverage distance r=1000 meters, what are the maximum Nu and corresponding processing gain N. If E=10 Joules and the maximum coverage distance r=1000 meters, what are the maximum Nu and corresponding processing gain N
What are the financial issues facing the hewlett foundation : What are the financial issues facing the Hewlett Foundation (HF)? Was HF's donor stock sale program a good idea? In your discussion you need to provide arguments in favor and arguments against the program.
A call option on euros is written with a strike price of $1 : A call option on euros is written with a strike price of $1.30/euro. Which spot price  maximizes your profit if you choose to exercise the option before maturity?  A) $1.20/euro  B) $1.25/euro
Business administration major interested highly focused : Business administration major interested highly focused and interested in Behavioral Finance. Behavioral Finance is a new study that focuses on applying contemporary psychological and human behavioral theories to business and finance fields, which ca..
Prepare an analysis report using excel based on items a : Prepare an analysis report using Excel based on items a-s below.  Analyze the financials for 3M - 10-Ks for 2013 and 2014.  Your report should show your computations (including the inputs into each formula), as well as provide a brief explanation of ..
What combinations of inputs can the firm buy : Suppose a firm has a fixed $100 to spend on K=10, W=5. What combinations of inputs can the firm buy? What is the equation for the line that represents all of these combinations?
Strong influence on the supply response of firm : Why would one be unable to associate particular amounts of calendar time with the concepts of market period, short-run period, long-run period and historical period? Why does marginal cost have such a strong influence on the supply response of a firm..
Donor plans to give equal amounts of money : A wealthy businessman wants to start a permanent fund for supporting research on sustainability. The donor plans to give equal amounts of money for each of the next five years, plus one gift now (i.e., six donations in total), so that $100,000 per ye..
Create a swot analysis of the location : Create a SWOT analysis of the location you have chosen for your Case Study Project. A SWOT analysis is an assessment of the strengths, weaknesses, opportunities, and threats facing this city/town.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Using the income statement previously prepared what was the

using the income statement previously prepared what was the 2008 taxable income ignoring taxable earning from savings

  At what price will the bonds sell in the marketplace

Coupon payments will be made annually. Investors buying the bonds today will earn a yield to maturity of 9.09 percent. At what price will the bonds sell in the marketplace.

  Thorpe mfg inc is currently operating at only 85 percent

thorpe mfg. inc. is currently operating at only 85 percent of fixed asset capacity. current sales are 630000. how much

  Assume interest rates for bonds today is 5 for an aaa rated

go to the yahoo finance bonds center.under bonds center click bond screenerclick the corporate check box under bond

  What are the types of plans

What are the types of plans? How are they distinguished from one another? Do you think plans with incremental objectives are more effective than those that contain stretch goals? Why or why not? Support your opinion with outside resources.

  Budget planning and control

Budget Planning and Control

  Convertible bond conversion premium

A $1000 par value convertible bond has a conversion price of $50. It is currently selling for $1,120 despite the fact that the bond's coupon rate and the market rate are equal. The common stock obtained upon conversion is selling for $54 per share..

  Convertible bond''s conversion premium

A $1000 value convertible bond with conversion price of $50. It sells for $1,120 despite the fact bond's coupon ate determine  the convertible bond's conversion premium?

  At what price should the bonds sell

Ryngaert Inc. recently issued noncallable bonds that mature in 15 years. They have a par value of $1,000 and an annual coupon of 5.7%. If the current market interest rate is 7.0%, at what price should the bonds sell?

  Mergers and team building

You've just been part of merger. You've each been chosen to head up your department and merge the two groups into a self-directed work team.

  Prime brokerage customers for use as working capital

Prime brokerage accounts were moved from Bear Stearns during the week of 2010. This was part of the run. These accounts were closed so Bear no longer had access to the funds deposited by their prime brokerage customers for use as working capital. tru..

  What is the discounted payback period

An investment project costs $15,000 and has annual cash flows of $4,300 for six years. What is the discounted payback period if the discount rate is 0%? What if the discount rate is 5%? If it is 19%?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd