Answer & Explanation:Financial Analysis of Target Corporation as per Rubric. Please follow the guidelines in the attached file.
milestone_one_guidelines_and_rubric.docx
Unformatted Attachment Preview
MBA 520 Milestone One Guidelines and Rubric
Company is Target Corporation
This milestone assignment covers Modules One, Two and Three. After reviewing your chosen company’s organization context, you will conduct a financial analysis
of the company’s financial statements for the last three consecutive years. Your analysis should include the review and interpretation of data from the following
financial statements: the income statement, the balance sheet, statement of cash flow, and statement of retained earnings. Based on the review of the financial
statements, assess the organization’s financial performance and financial health. Provide support for your assessment.
Prompt: As a newly-hired manager at a company of your choosing, your first task is to review the company’s past and current financial performance and health and
make initial financial projections in order to begin planning for the upcoming year. Your report will include several financial tables, along with a comprehensive
narrative describing the organization’s context, financial performance, and health. Note that, in addition to the organization’s financial statements and website,
other authoritative news sources—such as annual reports and external sites like Bloomberg.com—may offer insights that facilitate analysis or provide information
on the organization’s priorities, challenges, and geographic distribution.
In particular, you must cover:
A. Organizational Context
1. What key features of the organization (e.g., major products or services, customers, location, etc.) help set the boundaries for business
decisions? In other words, what key goods or services does your organization provide, for whom, where, and why?
2. How is the company organized and managed (e.g., by product groups, geographic region, function, etc.)? How does that affect
accounting and financial information and subsequent business decisions?
B. Recent Financial Performance
1. Assess what the organization’s consolidated income statements for the last three years say about its financial performance. Use relevant
indicators, graphs, and spreadsheets to support your narrative. (Include all spreadsheets in an appendix.) For example, what do the
amounts and year-to-year changes in revenue, operating income, net profit or loss, and Earnings Before Interest, Taxes, Depreciation, and
Amortization tell you? Do any items stand out?
2. Assess what the organization’s consolidated cash flow statements for the same time period say about its financial performance. Use
relevant indicators, graphs, and spreadsheets to support your narrative. For example, what do the amounts and year-to-year changes in
cash from operating activities, cash from investing, cash from financing, and total cash flow tell you? Do any items stand out?
3. Assess the organization’s underlying financial performance. Support your answer with the analysis above and relevant research. For
example, is recent performance substantially affected by unusual events such as a major acquisition or spin-off? Is the business thriving
or struggling in its industry? How do you know?
C. Current Financial Health
1. Assess how the organization is capitalized and what that tells you about its financial health. Support your response with relevant graphs,
spreadsheets, and indicators such as “cash and cash equivalents,” total debt, shareholders’ equity, current ratio, debt/equity ratio, and Days
Sales Outstanding (DSO). For example, does the organization have enough cash for payroll and other bills? Does it have the right mix of debt
versus equity (stock)? How do you know?
2. Does the organization have the right amount of cash and other resources (e.g., key people, technologies, reputation, physical assets, etc.)
to fuel future growth? What does this suggest for business decisions? For example, if it has too much cash, should it pay a large dividend,
repurchase its own shares, or reinvest the excess funds?
3. Assess the financial value of the company using relevant indicators. What does your assessment imply for future business health and
performance? For example, what is the business’s current market value? What is its price-to-earnings ratio? What do these suggest
about investor perceptions of the business’s future?
Rubric
Guidelines for Submission: Your Financial Performance and Health report should be approximately 2–4 pages long (excluding title page, spreadsheets and
graphs, and references list). It should be double spaced, with 12-point Times New Roman font and one-inch margins, and should use the latest guidelines for APA
formatting for references and citations. Please also include your name, course name, and submission date on the title page.
Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information,
review these instructions.
Critical Elements
Exemplary (100%)
Financial: Context: Key Meets “Proficient” criteria and
Features
draws particularly insightful
connections between
organization’s financial and nonfinancial features and business
decisions
Financial: Context:
Meets “Proficient” criteria and
Organized
demonstrates especially keen
insight into relationships
between organization’s structure,
how financial information is
recorded, and impact on
business decisions
Proficient (90%)
Describes how key features of
organization help set boundaries
for business decisions
Financial:
Performance: Income
Assesses what consolidated
income statements for last three
years say about financial
performance, supported by
relevant indicators, graphs, and
spreadsheets
Meets “Proficient” criteria, and
analysis and supporting evidence
are particularly well-suited to
drawing meaningful conclusions
about financial performance
Analyzes how company is
organized and managed and
effect on accounting and
financial information and
subsequent business decisions
Needs Improvement (70%)
Describes how key features of
organization help set boundaries
for business decisions, but
response is cursory, contains
inaccuracies, or links to decision
making are weak or illogical
Analyzes how company is
organized and effect on
accounting and financial
information and decisions, but
response is cursory, contains
inaccuracies, or links between
organizational structure, finance,
and decision making are weak or
illogical
Assesses what consolidated
income statements say about
financial performance, supported
by indicators, graphs, and
spreadsheets, but response is
cursory, contains inaccuracies, or
support is not relevant
Not Evident (0%)
Does not describe how key
features of organization help set
boundaries for business
decisions
Value
15
Does not analyze how company
is organized and managed and
effect on accounting and
financial information and
subsequent business decisions
15
Does not assess what
consolidated income statements
for last three years say about
financial performance, supported
by relevant indicators, graphs,
and spreadsheets
9.5
Thank you for using www.freepdfconvert.com service!
Only two pages are converted. Please Sign Up to convert all pages.
https://www.freepdfconvert.com/membership
…
Purchase answer to see full
attachment
Order a plagiarism free paper now. We do not use AI. Use the code SAVE15 to get a 15% Discount
Looking for help with your ASSIGNMENT? Our paper writing service can help you achieve higher grades and meet your deadlines.
Why order from us
We offer plagiarism-free content
We don’t use AI
Confidentiality is guaranteed
We guarantee A+ quality
We offer unlimited revisions