Purchase Solution

Financial analysis on Target's most recent annual report

Not what you're looking for?

Ask Custom Question

Use an Excel spreadsheet to perform financial analysis on Target's most recent annual report to include liquidity, profitability ratios, asset management, debt management, and market returns. (See list of ratios below to be completed.) Use the formulas and cell links to show your work. Based on your analysis, write a 700-1,050-word report identifying the key strengths and weaknesses of the company's financial position. Include in your report recommendations on what should be included in the company's future plans in order to improve their financial performance.
________________________________________
(See attached files for full problem description)

I am needing help performing a financial analysis and my textbook is very vague. The instructions, ratios, and specifics are attached.

Purchase this Solution

Solution Summary

This provides the steps to calculate the Financial analysis on Target's most recent annual report

Solution Preview

INSTRUCTIONS:

Financial Analysis Paper

Use an Excel spreadsheet to perform financial analysis on Target's most recent annual report to include liquidity, profitability ratios, asset management, debt management, and market returns. (See list of ratios below to be completed.) Use the formulas and cell links to show your work. Based on your analysis, write a 700-1,050-word report identifying the key strengths and weaknesses of the company's financial position. Include in your report recommendations on what should be included in the company's future plans in order to improve their financial performance.
________________________________________

RATIOS TO COMPLETE:

Liquidity Ratios
Current ratio
Quick ratio

Asset Management Ratios
Receivables turnover
Days' sales outstanding
Inventory turnover
Days' cost in inventory
Payables turnover
Days' payables outstanding
Cash conversion cycle
Net fixed asset turnover
Total asset turnover

Debt Management Ratios
Debt to Equity
Debt to Assets
Debt to Capital
Times interest earned

Profitability Ratios
Gross profit margin
Operating profit margin
Net profit margin
Return on total assets
Return on common equity
Return on invested capital

OVERVIEW OF THE COMPANY

Target Corporation was founded in Minnesota in 1902. It is the sixth largest retailer in the United States and is ranked 27th on the 2005 Fortune 500. It sells more gift cards than any other retailer in the United States and is also the third-largest seller of music in the United States.
(WIKIPEDIA)
Target subcategories include SuperTarget and Target Greatland, account for approximately 80 percent of Target Corporation's revenue. For the nine ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.