target corp

xlsx

School

Louisiana State University *

*We aren’t endorsed by this school

Course

1

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

18

Uploaded by JudgeTreeSheep41

Report
RATIO ANALYSIS Target Corp 2021 2020 2019 2018 2017 $ Percent $ Percent $ $ $ Income Statement Revenue 106,005 100.0% 92,400 100.0% 78,112 75,356 76,432 Cost of Goods Sold 74,963 70.7% 66,177 71.6% 54,864 Interest Expense 421 0.4% 977 1.1% 477 Tax Expense 1,961 1.8% 1,178 1.3% 921 Income from Cont Operations 6,946 6.6% 4,368 4.7% 3,269 4,110 4,224 Net Income 6,946 6.6% 4,368 4.7% Balance Sheet Cash 5,911 11.0% 8,511 16.6% 1,556 Short Term Investments 4,985 9.3% 7,644 14.9% 1,810 Accounts Receivable 631 1.2% 498 1.0% 0 Inventory 13,902 25.8% 10,653 20.8% 9,497 Current Assets 21,573 40.1% 20,756 40.5% 12,519 Long Term Investments 13,549 25.2% 11,536 22.5% Net Fixed Assets 28,813 53.5% 28,002 54.6% Other Assets 1,760 3.3% 1,592 3.1% Total Assets 53,811 100.0% 51,248 100.0% 41,290 Current Liabilities 21,747 40.4% 20,125 39.3% 15,014 Total Liabilities 40,984 76.2% 36,808 71.8% 29,993 Total Stockholders' Equity 12,827 23.8% 14,440 28.2% 11,297 Cash Flow Cash Flow from Operations 8,625 10,525 7,117 Dividends Paid 1,548 1,343 1,330 Interest Paid 414 939 492 Share Information Market Price at Year End 231.44 176.53 124.76 Earnings Per Share - Basic 14.23 8.72 6.39 Shares Outstanding 488,000 500,600 510,900
RATIO ANALYSIS Growth Ratios Sales Growth 14.7% 18.3% Income Growth 59.0% 33.6% Asset Growth 5.0% 24.1% Activity Ratios Receivable Turnover 187.8 371.1 Inventory Turnover 6.1 6.6 Fixed Asset Turnover 3.7 3.3 Profitability Ratios Profit Margin 6.6% 4.7% Return on Assets 13.2% 9.4% Return on Equity 50.9% 33.9% Dividend Payout Ratio 22.3% 30.7% Price Earnings Ratio 16.3 20.2 Liquidity Ratios Current Ratio 0.99 1.03 Quick Ratio 0.53 0.83 Solvency Ratios Debt to Total Assets 0.76 0.72 Times Interest Earned (Accrual) 22.16 6.68 Times Interest Earned (Cash) 21.83 12.21 © 2008 William R. Pasewark
PRIMARY COMPETITOR ANALYSIS Target Corp Nordstorm $ $ Income Statement Revenue 106,005 14,402 Cost of Goods Sold 74,963 9,344 Interest Expense 421 246 Tax Expense 1,961 68 Income from Cont Op 6,946 178 Net Income 6,946 178 Prior Year Revenue 92,400 10,357 Prior Year Income from Continuing Operations 4,368 690 Balance Sheet Cash 5,911 322 Short Term Investments 4,985 258 Accounts Receivable 631 255 Inventory 13,902 2,289 Current Assets 21,573 3,172 Long Term Investments 13,549 5,058 Net Fixed Assets 28,813 506 Other Assets 1,760 390 Total Assets 53,811 8,869 Current Liabilities 21,747 1,529 Total Liabilities 40,984 8,288 Total Stockholders' Equity 12,827 581 Prior Year Accounts Receivable 498 245 Prior Year Inventory 10,653 1,863 Prior Year Assets 51,248 3,642 Prior Year Liabilities 36,808 9,233 Prior Year Stockholders' Equity 14,440 305 Cash Flow Cash Flow from Operations 8,625 705 Dividends Paid 1,548 0 Interest Paid 414 164
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
RATIO ANALYSIS Income Statement Common-Size Data Gross Profit/Sales 29.3% 35.1% Income from Continuing Operations/Sales 6.6% 1.2% Balance Sheet Common-Size Data Current Assets/Total Assets 40.1% 35.8% Current Liabilities/Total Assets 40.4% 17.2% Liabilities/Total Assets 76.2% 93.4% Equity/Total Assets 23.8% 6.6% Profitabilty Ratios Profit Margin 6.6% 1.2% Return on Assets 13.2% 2.8% Return on Equity 50.9% 40.2% Dividend Payout Ratio 22.3% 0.0% Liquidity Ratios Current Ratio 0.99 2.07 Quick Ratio 0.53 0.55 Solvency Ratios Debt/Total Assets 0.76 0.93 Times Interest Earned (Accrual) 22.16 2.00 Operational Ratios Receivable Turnover 187.8 57.6 Inventory Turnover 6.1 4.5 © 2008 William R. Pasewark
TREND ANALYSIS Prior Year Revenue $76,423 $75,356 $78,112 $92,400 $106,005 Income - Continuing Operations $4,224 $4,110 $3,269 $4,368 $6,946 Cash Flow from Operations $7,117 $10,525 $8,625 Total Assets $41,290 $51,248 $53,811 5 Years Ago 4 Years Ago 3 Years Ago Current Year 5 Years Ago 4 Years Ago 3 Years Ago Prior Year Current Year $0 $50,000 $100,000 $150,000 REVENUE TREND 5 Years Ago 4 Years Ago 3 Years Ago Prior Year Current Year $0 $1,000 $2,000 $3,000 $4,000 $5,000 $6,000 $7,000 NET INCOME TREND 3 Years Ago Prior Year Current Year $0 $2,000 $4,000 $6,000 $8,000 $10,000 $12,000 INCOME TO CASH FLOW COMPARISON Income - Continuing Opera- tions Cash Flow from Op- erations
© 2008 William R. Pasewark 3 Years Ago Prior Year Current Year $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 ASSET CHANGES Total Assets
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
QUARTERLY DATA 1st Q 2nd Q 3rd Q 4th Q Annual Current Year Revenue 26,520 26,040 25,170 31,000 108,730 Last Year Revenue 25,160 25,160 24,210 28,340 102,870 Current Year Income 712 1,830 1,010 1,540 5,092 Last Year Income 1,490 1,540 1,010 1,830 5,870 CURRENT YEAR QUARTERLY STOCK PRICES 1st Q 2nd Q 3rd Q 4th Q High Price $210.86 $263.46 $261.51 $268.98 Low Price $168.12 $202.78 $222.88 $214.60 1st Q 2nd Q 3rd Q 4th Q 0 5,000 10,000 15,000 20,000 25,000 30,000 35,000 26,520 26,040 25,170 31,000 25,160 25,160 24,210 28,340 QUARTERLY REVENUE Current Year Rev- enue Last Year Rev- enue 1st Q 2nd Q 3rd Q 4th Q 0 500 1,000 1,500 2,000 QUARTERLY INCOME Current Year Income Last Year Income 1st Q 2nd Q 3rd Q 4th Q $0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 QUARTERLY STOCK HIGHS AND LOWS High Price Low Price
© 2008 William R. Pasewark
Previous Year 83.65 109.33 114.83 130.24 69.07 70.03 104.01 107.02
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ANALYSIS OF ACCOUNTS RECEIVABLE Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Accounts Receivable 631 498 0 255 245 Allowance for Bad Debt 430 690 1016 59 43 Total Assets 53,811 51,248 41,290 8,869 3,642 Revenue 106,005 92,400 78,112 14,402 10,357 Bad Debt Expense 154 528 1185 52 42 IMPACT OF ACCOUNTS RECEIVABLE Bad Debt Expense Percentage 0.1% 0.6% 1.5% 0.4% 0.4% Allowance Percentage 40.5% 58.1% 100.0% 18.8% 14.9% Accounts Receivable to Total Assets 1.2% 1.0% 0.0% 2.9% 6.7% RECIEVABLE COLLECTION RATES Receivable Turnover 189.3 108.3 282.4 Days of Receivable 1.9 3.4 1.3 © 2008 William R. Pasewark
ANALYSIS OF INVENTORY Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Total Assets 53,811 51,248 41,290 8,869 3,642 Inventory 13,902 10,653 9,497 2,289 1,863 Revenue 106,005 92,400 78,112 14,402 10,357 Cost of Goods Sold 74,963 66,177 54,864 9,344 7,600 Gross Profit 31,042 26,223 23,248 5,058 2,757 IMPACT OF INVENTORY Inventory to Total Assets 25.8% 20.8% 23.0% 25.8% 51.2% Cost of Goods Sold Percentage 70.7% 71.6% 70.2% 64.9% 73.4% INVENTORY TURNOVER RATES Inventory Turnover 6.1 6.6 4.5 Days in Inventory 59.8 55.6 81.1 INVENTORY YIELD Inventory Yield 2.5 2.6 2.4 © 2008 William R. Pasewark
ANALYSIS OF FIXED ASSETS Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Total Assets 53,811 51,248 41,290 8,869 3,642 Gross Fixed Assets 28,181 26,789 26,014 4,863 3,921 Accumulated Depreciation 21,137 20,278 19,664 615 671 Net Fixed Assets 28,813 28,002 6,350 506 3,250 Depreciable Assets 20,899 19,973 19,417 4,205 3,405 Gross Capital Leases 2,972 3,578 3,984 4,409 4,456 Revenue 106,005 92,400 78,112 14,402 10,357 Depreciation Expense 2,642 2,485 2,604 790 839 Operating Lease Expense 387 332 287 191 0 IMPACT OF FIXED ASSETS Tangibility Ratio 53.5% 54.6% 15.4% 5.7% 89.2% Depreciation as a Percent of Revenue 2.5% 2.7% 3.3% 5.5% 8.1% Operating Lease Utilization 0.4% 0.4% 0.4% 1.3% 0.0% Capital Lease Utilization 5.5% 7.0% 9.6% 49.7% 122.4% FIXED ASSET ACTIVITY RATIOS Fixed Asset Turnover 3.7 5.4 7.7 Total Asset Turnover 2.0 2.0 2.3 FIXED ASSET USAGE RATIOS Percent Depreciated 75.0% 75.7% 75.6% 12.6% 17.1% Average Fixed Asset Life 7.9 8.0 7.5 5.3 4.1 © 2008 William R. Pasewark cip 1257 780 533 373 231 land 6025 6036 6064 285 285
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ANALYSIS OF DEBT Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Quick Assets 11,527 16,653 3,366 835 957 Current Assets 21,573 20,756 12,519 3,172 3,374 Current Liabilities 21,747 20,125 15,014 1,529 2,281 Accounts Payable 15,478 12,859 9,780 1,455 1,854 Purchases 78,212 67,333 9,770 Total Assets 53,811 51,248 41,290 8,869 3,642 Total Liabilities 40,984 36,808 29,993 8,288 9,233 Total Stockholders' Equity 12,827 14,440 11,297 581 305 Income from Continuing Operations 6,946 4,368 3,269 178 690 Interest Expense 421 977 477 68 Tax Expense 1,961 1,178 921 68 Cash Flow from Operations 8,625 10,525 7,117 705 Interest Paid 414 939 492 164 LIQUIDITY RATIOS (ANALYSIS OF CURRENT DEBT) Current (Working Capital) Ratio 1.0 1.0 0.8 2.1 1.5 Quick (Acid-Test) Ratio 0.5 0.8 0.2 0.5 0.4 Days Payable Outstanding 66 61 62 SOLVENCY RATIOS (ANALYSIS OF LONG-TERM DEBT) Debt to Total Assets 0.76 0.72 0.73 0.93 2.54 Debt to Equity 3.20 2.55 2.65 14.27 30.27 DEBT SERVICABILITY Times Interest Earned (Accrual Basis) 22.2 6.7 9.8 4.6 Times Interest Earned (Cash Basis) 21.8 12.2 5.3 © 2008 William R. Pasewark
STOCKHOLDER ANALYSIS Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Total Assets 53,811 51,248 41,290 8,869 3,642 Total Stockholders' Equity 12,827 14,440 11,297 581 305 Income from Continuing Operations 6,946 4,368 3,269 178 690 Dividends Paid 1,548 1,343 1,330 0 58 Market Price at Year End 231.44 176.53 124.76 5.27 4.22 Basic Earnings per Share 14.23 8.72 6.39 4.39 3.18 Shares Outstanding 488,000 500,600 510,900 157 156 Dividends per Share 0.00 0.00 0.00 0.00 0.37 DIVIDEND RATIOS Dividend Payout Ratio 22.3% 30.7% 40.7% 0.0% 8.4% Dividend Yield 0.0% 0.0% 0.0% 0.0% 8.8% EARNINGS AND RETURN RATIOS Return on Assets 13.2% 9.4% 2.8% Return on Equity 50.9% 33.9% 40.2% Total Stockholder Return 31.1% 41.5% 24.9% Price Earnings Ratio 16.3 20.2 19.5 1.2 1.3 © 2008 William R. Pasewark
ANALYSIS OF RETIREMENT PLANS Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Total Assets 53,811 51,248 41,290 8,869 3,642 Revenue 106,005 92,400 78,112 14,402 10,357 Defined Contribution Pension Expense 307 281 237 N/a n/a Defined Benefit Pension Expense 467 410 430 n/a n/a Defined Benefit Pension Cash Contribution 236 263 245 n/a n/a Other Post Retirement Expense 1,105 1,065 1,652 n/a n/a Other Post Retirement Cash Contribution 236 236 236 n/a n/a Fair Market Value of Pension Assets 4,433 4,588 4,387 n/a n/a Fair Market Value of Other Post-Retirement Assets 2,186 1,954 1,875 n/a n/a Accumulated Benefit Obligation (ABO) for Pensions 4,520 4,005 4,650 n/a n/a Projected Benefit Obligation (PBO) for Pension 4,305 4,594 4,605 n/a n/a Projected Benefit Obligation for Other Post-Retirement 238 242 248 n/a n/a IMPACT OF RETIREMENT PLANS ON EARNINGS Defined Contribution Pension Expense to Revenue 0.3% 0.3% 0.3% #VALUE! #VALUE! Defined Benefit Pension Expense to Revenue 0.4% 0.4% 0.6% #VALUE! #VALUE! Total Pension Expense to Revenue 0.7% 0.7% 0.9% #VALUE! #VALUE! Other Post Retirement Expense to Revenue 1.0% 1.2% 2.1% #VALUE! #VALUE! Retirement Expense to Revenue 1.8% 1.9% 3.0% #VALUE! #VALUE! IMPACT OF RETIREMENT PLANS ON FINANCIAL CONDITION Pension ABO to Total Assets 8.4% 7.8% 11.3% #VALUE! #VALUE! Pension PBO to Total Assets 8.0% 9.0% 11.2% #VALUE! #VALUE! Retirement PBO to Total Assets 0.4% 0.5% 0.6% #VALUE! #VALUE! RETIREMENT FUNDING RATIOS FMV of Pension Assets to Pension ABO 98.1% 114.6% 94.3% #VALUE! #VALUE! FMV of Pension Assets to Pension PBO 103.0% 99.9% 95.3% #VALUE! #VALUE! FMV of Retirement Benefit Assets to Retirement PBO 918.5% 807.4% 756.0% #VALUE! #VALUE! Pension Contribution Ratio 50.5% 64.1% 57.0% #VALUE! #VALUE! Retirement Contribution Ratio 30.0% 33.8% 23.1% #VALUE! #VALUE! © 2008 William R. Pasewark
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ANALYSIS OF COMPENSATION PLANS Target Corp Nordstorm Current Year Prior Year 3 Years Ago Current Year Prior Year Revenue 106,005 92,400 78,112 14,402 10,357 Shares Outstanding 488,000 500,600 510,900 157 156 Market Price at Year End 231.44 176.53 124.76 5.27 4.22 Stock Option Plan Stock Option Plan Expense 504 517 541 52 53 Shares Obtained by Options Exercised this Year 800 2,300 7,300 0 11 Shares Obtainable from: Options Granted this Year 1,447 3,815 2,455 N/A N/A Exercisable Options 1,100 620 782 N/A N/A Outstanding Options 4,316 3,575 3,124 N/A N/A Average Exercise Price of Exercisable Options 58.17 55.81 48.15 N/A N/A Average Exercise Price of Outstanding Options 186.89 110.80 80.01 N/A N/A Stock Award Plan Stock Award Plan Expense 504 517 541 n/a n/a Shares Obtained by Awards Vested this Year 800 2,300 7,300 n/a n/a Shares Obtainable from: Awards Issued (Granted) this Year 1,447 3,815 2,455 n/a n/a Outstanding (Non-vested) Awards 4,316 3,575 3,124 n/a n/a Stock Purchase Plan Stock Purchase Plan Expense 504 517 541 n/a n/a
POTENTIAL DILUTION RATIOS As a Percentage of Shares Outstanding OPTIONS - Granted this Year 0.3% 0.8% 0.5% #VALUE! #VALUE! OPTIONS - Exercisable 0.2% 0.1% 0.2% #VALUE! #VALUE! OPTIONS - Oustanding 0.9% 0.7% 0.6% #VALUE! #VALUE! AWARDS - Net Issued 0.3% 0.8% 0.5% #VALUE! #VALUE! AWARDS - Outstanding 0.9% 0.7% 0.6% #VALUE! #VALUE! OPTIONS AND AWARDS - Outstanding 1.8% 1.4% 1.2% #VALUE! #VALUE! ACTUAL DILUTION RATIOS As a Percentage of Shares Outstanding OPTIONS - Net Exercised 0.2% 0.5% 1.4% 0.0% 7.1% AWARDS - Net Vested 0.2% 0.5% 1.4% #VALUE! #VALUE! ALL PLANS - Share Increase this Year 0.3% 0.9% 2.9% #VALUE! #VALUE! IMPACT ON EARNINGS RATIOS OPTIONS - Expense to Revenue 0.5% 0.6% 0.7% 0.4% 0.5% AWARDS - Expense to Revenue 0.5% 0.6% 0.7% #VALUE! #VALUE! PURCHASE - Expense to Revenue 0.5% 0.6% 0.7% #VALUE! #VALUE! ALL PLANS - Expense to Revenue 1.4% 1.7% 2.1% #VALUE! #VALUE! BENEFIT TO PLAN PARTICIPANTS RATIOS As a Percent of Year End Stock Price OPTIONS - Price of Exercisable 25.1% 31.6% 38.6% #VALUE! #VALUE! OPTIONS - Price of Outstanding 80.8% 62.8% 64.1% #VALUE! #VALUE! © 2008 William R. Pasewark
ANALYSIS OF OPERATING LEASES Target Corp Average Borrowing Rate: 3.6% Operating Lease PV PV of Year Payment Factor Payment Increase 1 Current Year 185 0.96525 179 2 Next Year 226 0.93171 211 22.2% 3 Current Year + 2 411 0.89933 370 81.9% 4 Current Year + 3 596 0.86808 517 45.0% 5 Current Year + 4 781 0.83792 654 Average 31.0% 7 Current Year + 5 1,023 0.78070 799 increase 45.0% 8 Current Year + 6 1,341 0.75357 1,011 9 Current Year + 7 1,757 0.72738 1,278 10 Current Year + 8 2,303 0.70211 1,617 11 Current Year + 9 376 0.58831 221 Total minimum lease pmts 9,000 6,857 Total Liabilities 40,984 Total Stockholders' Equity 12,827 Income from Continuing Operations 6,946 Total Assets 53,811 Adjusted for Capitalized Operating Leases Total Liabilites 47,841 Total Assets 60,668 RATIOS PRIOR TO CAPITALIZING OPERATING LEASES Debt to Equity 3 Return on Assets 0 RATIOS ADJUSTED FOR CAPITALIZED OPERATING LEASES Debt to Equity 4 Return on Assets 0 © 2008 William R. Pasewark Percentag e
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help