Expert answer:Operating profit margin Percentages of sales
Expert answer:Executive Summary•Total 5 year improvement•Sales:•Market share:•Operating profit margin Percentages of sales:*These are the three categories I need filled out for Ulta please.
20171013103033ulta_beauty_1.pptx
201710131030221.docx
Unformatted Attachment Preview
Ulta Beauty INC
Executive summary
USING ULTA’S CURRENT STATEMENTS FOR THE INFORMATION BELOW Document the
total 5 year business improvement in
• Total 5 year improvement
• Sales:
• Market share:
• Operating profit margin Percentages of sales:
Instructions for slide 4
This week, when thinking about your marketing plan, you should be working on your first
year’s income statement. This income statement should be prepared for each quarter of the
year, and should include gross revenues, cost of goods sold, gross profit, operating expenses
which include marketing expenses such as selling and advertising and any development
expenses that could be incurred, and finally operating profit. It is not necessary to estimate
taxes or show net profit. Your income statement need only reflect the INCREMENTAL
improvements in income that your marketing plan will contribute to your publicly traded
firm. In other words, if your firm has an annual operating profit of $10,000,000.00 and your
marketing plan will add $1,000,000 operating profit, you can show only the $1,000,000. The
most important aspect of this part of your marketing plan is developing your forecast, so be
sure to review the techniques for forecasting that were covered in Chapter 3.
Financials
• Forecasting
method used
(Ch 3)
• Why
chosen
Projected Income Statement
Base Year
Sales
Revenue
COGS
Gross
Profit
SG&A
New
marketing
expenses
New R&D
expense
Operating
Income
Qtr 1
Qtr 2
Qtr 3
Qtr 4
Full Year
Income Statement
Quarterly Income Statement (values in 000’s) Get Annual Data
Quarter:
Trend
2nd
1st
4th
3rd
Quarter Ending:
7/29/2017
4/29/2017
1/28/2017
10/29/2016
Total Revenue
$1,289,854
$1,314,879
$1,580,574
$1,131,232
Cost of Revenue
$820,528
$838,871
$1,035,666
$704,179
Gross Profit
$469,326
$476,008
$544,908
$427,053
Research and Development
$0
$0
$0
$0
Sales, General and Admin.
$283,427
$283,445
$316,266
$280,464
Non-Recurring Items
$6,099
$4,158
$4,412
$6,928
Other Operating Items
$0
$0
$0
$0
Operating Income
$179,800
$188,405
$224,230
$139,661
Add’l income/expense items
$555
$338
$116
$211
Earnings Before Interest and Tax
$180,355
$188,743
$224,346
$139,872
Interest Expense
$0
$0
$0
$0
Earnings Before Tax
$180,355
$188,743
$224,346
$139,872
Income Tax
$66,162
$60,520
$84,128
$52,310
Minority Interest
$0
$0
$0
$0
Equity Earnings/Loss
Unconsolidated Subsidiary
$0
$0
$0
$0
Net Income-Cont. Operations
$114,193
$128,223
$140,218
$87,562
Net Income
$114,193
$128,223
$140,218
$87,562
Operating Expenses
Quarter:
Trend
2nd
1st
4th
3rd
Quarter Ending:
7/29/2017
4/29/2017
1/28/2017
10/29/2016
Net Income Applicable to Common
Shareholders
$114,193
$128,223
$140,218
$87,562
Annual Income Statement (values in 000’s) Get Quarterly Data Balance Sheet
Period Ending:
Trend
1/28/2017
1/31/2016
1/31/2015
2/2/2014
Cash and Cash Equivalents
$385,010
$345,840
$389,149
$419,476
Short-Term Investments
$30,000
$130,000
$150,209
$0
Net Receivables
$88,631
$64,992
$73,220
$69,295
Inventory
$943,975
$761,793
$581,229
$457,933
Other Current Assets
$88,621
$72,548
$66,548
$55,993
Total Current Assets
$1,536,237
$1,375,173
$1,260,355
$1,002,697
Long-Term Investments
$0
$0
$0
$0
Fixed Assets
$1,004,358
$847,600
$717,159
$595,736
Goodwill
$0
$0
$0
$0
Intangible Assets
$0
$0
$0
$0
Other Assets
$0
$0
$0
$0
Deferred Asset Charges
$11,283
$8,145
$5,656
$4,294
Total Assets
$2,551,878
$2,230,918
$1,983,170
$1,602,727
$529,343
$396,227
$359,594
$266,811
Current Assets
Long-Term Assets
Current Liabilities
Accounts Payable
Period Ending:
Trend
1/28/2017
1/31/2016
1/31/2015
2/2/2014
Short-Term Debt / Current Portion
of Long-Term Debt
$0
$0
$0
$0
Other Current Liabilities
$0
$0
$0
$0
Total Current Liabilities
$529,343
$396,227
$359,594
$266,811
Long-Term Debt
$0
$0
$0
$0
Other Liabilities
$19,628
$10,489
$7,442
$4,474
Deferred Liability Charges
$452,689
$381,316
$368,625
$328,348
Misc. Stocks
$0
$0
$0
$0
Minority Interest
$0
$0
$0
$0
Total Liabilities
$1,001,660
$788,032
$735,661
$599,633
Common Stocks
$627
$641
$647
$647
Capital Surplus
$658,330
$621,715
$576,982
$548,194
Retained Earnings
$905,785
$832,215
$679,593
$462,378
Treasury Stock
($14,524)
($11,685)
($9,713)
($8,125)
Other Equity
$0
$0
$0
$0
Total Equity
$1,550,218
$1,442,886
$1,247,509
$1,003,094
Total Liabilities & Equity
$2,551,878
$2,230,918
$1,983,170
$1,602,727
Stock Holders Equity
Annual Income Statement (values in 000’s) Get Quarterly Data Cash Flow
Period Ending:
1/28/2017
1/31/2016
1/31/2015
2/2/2014
$409,760
$320,008
$257,135
$202,849
Depreciation
$210,295
$165,049
$131,764
$106,283
Net Income Adjustments
$46,398
$15,596
$25,408
$10,395
Accounts Receivable
($23,639)
($12,552)
($5,391)
($5,534)
Changes in Inventories
($182,182)
($180,564)
($123,296)
($96,808)
Other Operating Activities
$39,652
$25,015
$30,832
$66,929
Liabilities
$134,401
$43,322
$80,140
$43,611
Net Cash Flow-Operating
$634,685
$375,874
$396,592
$327,725
Capital Expenditures
($373,747)
($299,167)
($249,067)
($226,024)
Investments
$100,000
$20,209
($150,209)
$0
Other Investing Activities
$0
$0
$0
$0
Net Cash Flows-Investing
($273,747)
($278,958)
($399,276)
($226,024)
($330,821)
($149,722)
($30,872)
($16,078)
Net Income
Trend
Cash Flows-Operating Activities
Changes in Operating Activities
Cash Flows-Investing Activities
Cash Flows-Financing Activities
Sale and Purchase of Stock
Period Ending:
Trend
1/28/2017
1/31/2016
1/31/2015
2/2/2014
Net Borrowings
$0
$0
$0
$0
Other Financing Activities
$0
$0
$0
$0
Net Cash Flows-Financing
($321,768)
($140,225)
($27,643)
($2,700)
Effect of Exchange Rate
$0
$0
$0
$0
Net Cash Flow
$39,170
($43,309)
($30,327)
$99,001
Annual Income Statement (values in 000’s) Financial Ratios
Period Ending:
Trend
1/28/2017
1/31/2016
1/31/2015
2/2/2014
Current Ratio
290%
347%
350%
376%
Quick Ratio
112%
155%
189%
204%
Cash Ratio
78%
120%
150%
157%
Gross Margin
36%
35%
35%
35%
Operating Margin
13%
13%
13%
12%
Pre-Tax Margin
14%
13%
13%
12%
Profit Margin
8%
8%
8%
8%
Pre-Tax ROE
42%
35%
33%
33%
After Tax ROE
26%
22%
21%
20%
Liquidity Ratios
Profitability Ratios
…
Purchase answer to see full
attachment
How it works
- Paste your instructions in the instructions box. You can also attach an instructions file
- Select the writer category, deadline, education level and review the instructions
- Make a payment for the order to be assignment to a writer
- Download the paper after the writer uploads it
Will the writer plagiarize my essay?
You will get a plagiarism-free paper and you can get an originality report upon request.
Is this service safe?
All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades