View the step-by-step solution to:

Professional Challenge Data Lowe's Income Statements Sales CGS Gross Profit Expenses SG&A Store Opening Costs Depreciation Interest Total

Use per store data together with the breakeven analysis formulas to generate the unit breakeven point and the sales breakeven point. The basic units are the number of transactions. The Breakeven Analysis Example (see link) using Home Depot data provides guidance
Professional Challenge Data Tom Steiner Consulting Page 1 04/13/2013 Lowe's Income Statements # 1/28/2005 1/30/2004 1/31/2003 Sales # 36,464 30,838 26,112 CGS # 24,208 21,269 18,164 Gross Profit # 12,256 9,569 7948 Expenses SG&A # 7,562 5,578 4,625 Store Opening Costs # 123 128 129 Depreciation # 859 739 640 Interest # 176 180 182 Total Expenses # 8,720 6,625 5,576 Pre-Tax Earnings # 3,536 2,944 2,372 Tax # 1,360 1,115 893 Earnings from continuing ops # 2,176 1,829 1,479 Discontinued ops # 0 15 12 Net Income # 2,176 1,844 1,491 Additional Metrics Number of Stores # 1,087 952 828 Square Footage # 124 109 95 Number of Employees # 161,964 147,052 120,692 Average ticket price for customers # 63.43 59.21 56.80 Shares outstanding # 774 787 782 LT Assets Land # 4,197 3,635 3,133 Building # 7,007 5,950 5,092 Equipment # 5,405 4,355 3,663 Estimated cost for one store # 19.77 16.55 Net working capital for one store # 1.15 2.44
Background image of page 01
Tom Steiner Consulting Page 2 04/13/2013 Lowe's Balance Sheet # 1/28/2005 1/30/2004 1/31/2003 Assets Current Assets Cash & Equivalents # 530 1,446 853 ST Investments # 283 178 273 Accounts Receivables # 9 131 172 Merchandise Inventory # 5,911 4,584 3,968 Def Inc Taxes # 95 59 58 Other CA # 75 289 244 Total current assets # 6,903 6,687 5,568 Net PPE # 13,911 11,945 10,352 LT Investments # 146 169 29 Other Assets # 178 241 160 Total Assets # 21,138 19,042 16,109 Liabilities and Shareholder Equity Current Liabilities Short term borrowings # 0 0 50 Current LT Debt # 630 77 29 Accounts Payable # 2,695 2,366 1,943 Employee retirement plans # 0 74 88 Accrued salaries and wages # 386 335 306 Self Insurance liability # 467 0 0 Def Revenue # 539 0 0 Other current liabilities # 931 1,516 1,162 Total current liabilities # 5,648 4,368 3,578 LTD # 3,060 3,678 3,736 Def Inc Taxes # 736 657 478 Other LT Liab # 159 30 15 Total Liabilities # 9,603 8,733 7,807 Total Shareholder Equity # 11,535 10,309 8,302 Total Liabilities and Shareholder Equities # 21,138 19,042 16,109
Background image of page 02
Show entire document
Sign up to view the entire interaction

Top Answer

Please see the attached... View the full answer

Copy of cf_PC_data.xls

Professional Challenge Data Lowe's Income Statements
Sales
CGS
Gross Profit
Expenses
SG&A
Store Opening Costs
Depreciation
Interest
Total Expenses
Pre-Tax Earnings
Tax
Earnings from continuing...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online