Burrows C Analysis

xls

School

University of California, Los Angeles *

*We aren’t endorsed by this school

Course

231E

Subject

Finance

Date

Nov 24, 2024

Type

xls

Pages

6

Uploaded by leedevin

Report
1980-1981 Source/ (Use) BALANCE SHEET Cash 154.0 Accounts Receivable 311.0 Note Payable, Curr. Port. Lease 22.0 Accounts Payable 424.0 LT Debt 150.0 Deferred Taxes 78.0 Common Stock 1.0 Income 16.0 1,156.0 Inventory (256.0) Prepaid Expenses and other (219.0) Fixed Assets, net (334.0) Other Assets (13.0) Accrued Liabilities (51.0) Taxes Payable (241.0) LT Capital Lease (1.0) Preferred Stock (9.0) Additional Paid-in Capital, net of T-stock (32.0) (1,156.0)
BURROWS B Page 2 Burrows A REAL EXPECTED INCOME STATEMENT 1/31/1970 1/31/1971 ### ### ### ### ### ### ### 1970 1971 1972 1973 1974 1975 1976 1977 1978 Total Sales 4,235 4,231 4,422 5,207 5,967 6,990 7,945 9,115 10,165 Cost of Goods Sold 3,222 3,266 3,426 2,977 3,341 3,914 4,449 5,104 5,692 Gross Margin 1,013 965 996 2,230 2,626 3,076 3,496 4,011 4,473 Expenses 913 869 908 1,950 2,296 2,666 2,946 3,231 3,543 Income Before Income Taxes 100 96 88 280 330 410 550 780 930 Income Taxes (50%) - - - 140 165 205 275 390 465 Net Income 100 96 88 140 165 205 275 390 465 BALANCE SHEET ### 2/3/1973 ### ### ### ### ### Cash 14 14 678 819 1,162 1,578 2,036 Accounts Receivable 100 3 - - - 100 200 Inventory 1,412 1,363 1,310 1,540 1,683 1,800 2,000 Prepaid Expenses 23 - - - - - - Current Assets 1,549 1,380 1,988 2,359 2,845 3,478 4,236 Fixtures and Equipment 627 665 870 1,044 1,154 1,264 1,374 Less Res. for Depreciation - (470) (542) (629) (733) (859) (996) Leasehold Improvements 293 320 320 320 320 320 320 Less Res. for Depreciation - (250) (250) (250) (250) (250) (250) Lease Valuation - 50 50 50 50 50 50 Less Res. for Depreciation (712) - (8) (16) (24) (32) (40) Fixed Assets, net 208 315 440 519 517 493 458 Other Assets 22 30 40 50 60 70 80 Total Assets 1,779 1,725 2,468 2,928 3,422 4,041 4,774 Accounts Payable 233 36 350 650 750 850 1,000 Accrued Liabilities 112 131 230 300 400 500 600 Taxes Payable 2 - 165 50 69 98 116 Current Debt 347 167 745 1,000 1,219 1,448 1,716 Senior Subordinated Note 1,432 1,000 1,000 1,000 1,000 1,000 1,000 Total Debt 1,779 1,167 1,745 2,000 2,219 2,448 2,716 Preferred Stock - 248 248 248 248 248 248 Common Stock - 13 13 13 13 13 13 Paid-in Surplus - 297 297 297 297 297 297 Retained Earnings - - 165 370 645 1,035 1,500 Total Equity - 558 723 928 1,203 1,593 2,058 Total Debt and Equity 1,779 1,725 2,468 2,928 3,422 4,041 4,774 - - - - - - -
BURROWS B Page 3 Burrows B HIGBEE BURROWS INCOME STATEMENT ### ### ### ### ### ### ### ### 2/2/1980 ### 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Total Sales 4,422 5,169 5,671 6,365 6,960 7,982 9,617 11,735 13,730 13,777 Cost of Goods Sold 3,455 4,007 3,285 3,699 3,864 4,338 5,300 6,308 7,634 7,673 Gross Margin 967 1,162 2,386 2,666 3,096 3,644 4,317 5,427 6,096 6,104 Operating & SG&A 908 1,050 2,119 2,361 2,695 3,140 3,688 4,620 5,626 6,171 Interest expense 73 108 73 75 86 113 224 282 Income Before Income Taxes 59 112 194 197 328 429 543 694 246 (349) Income Taxes (50%) - - 93 88 147 192 222 275 68 (186) Net Income 59 112 101 109 181 237 321 419 178 (163) BALANCE SHEET ### 2/3/1973 2/1/1974 2/1/1975 ### ### ### 2/3/1979 2/2/1980 ### Cash 14 15 517 140 185 153 169 215 86 61 Accounts Receivable 4 91 206 277 283 271 354 523 225 212 Inventory 1,412 1,514 1,610 1,588 1,765 2,205 2,060 2,901 2,959 3,157 Prepaid Expenses and other 71 61 53 80 95 101 112 163 184 382 Current Assets 1,501 1,681 2,386 2,085 2,328 2,730 2,695 3,802 3,454 3,812 Fixtures and Equipment 627 680 285 408 524 691 883 1,115 1,250 1,334 Leasehold Improvements 293 321 186 206 225 310 402 482 771 863 Vehicles - - - - 11 16 30 53 66 66 Less Res. for Depreciation (711) (720) (47) (106) (178) (266) (381) (527) (610) (806) Fixed Assets, net 209 281 424 508 582 751 934 1,123 1,477 1,457 Other Assets 22 14 36 39 41 43 49 177 267 190 Total Assets 1,732 1,976 2,846 2,632 2,951 3,524 3,678 5,102 5,198 5,459 Note Payable, Curr. Port. Lease - - 290 - - - - 15 36 37 Accounts Payable 182 344 780 828 722 928 780 1,367 1,247 1,791 Accrued Liabilities 110 88 280 201 258 313 374 408 308 357 Taxes Payable 51 47 77 61 175 228 221 282 85 41 Current Debt 343 479 1,427 1,090 1,155 1,469 1,375 2,072 1,676 2,226 LT Debt 1,389 1,497 750 750 800 800 700 900 1,100 1,050 LT Capital Lease - - - - - - - 56 96 55 Deferred Taxes - - 10 23 46 68 95 139 202 217 Total Debt 1,732 1,976 2,187 1,863 2,001 2,337 2,170 3,167 3,074 3,548 Preferred Stock - - 248 248 248 248 248 248 248 239 Common Stock - - 13 13 13 13 13 14 14 15 Additional Paid-in Capital, net of T-stock - - 297 297 297 297 297 304 315 272 Retained Earnings - - 101 211 392 629 950 1,369 1,547 1,385 Total Equity - - 659 769 950 1,187 1,508 1,935 2,124 1,911 Total Debt and Equity 1,732 1,976 2,846 2,632 2,951 3,524 3,678 5,102 5,198 5,459 - - - - - - - - - -
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
BURROWS B Page 4 RATIO ANALYSIS Operational (1970) 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Sales Growth Burrows A -0.1% 4.5% 17.8% 14.6% 17.1% 13.7% 14.7% 11.5% Burrows B 16.9% 9.7% 12.2% 9.3% 14.7% 20.5% 22.0% 17.0% 0.3% COGS/Sales Burrows A 77.2% 77.5% 57.2% 56.0% 56.0% 56.0% 56.0% 56.0% Burrows B 78.1% 77.5% 57.9% 58.1% 55.5% 54.3% 55.1% 53.8% 55.6% 55.7% Gross Margin Burrows A 22.8% 22.5% 42.8% 44.0% 44.0% 44.0% 44.0% 44.0% Burrows B 21.9% 22.5% 42.1% 41.9% 44.5% 45.7% 44.9% 46.2% 44.4% 44.3% Expenses/Sales Burrows A 20.5% 20.5% 37.4% 38.5% 38.1% 37.1% 35.4% 34.9% Burrows B 20.5% 20.3% 37.4% 37.1% 38.7% 39.3% 38.3% 39.4% 41.0% 44.8% EBIT Margin Burrows A 2.3% 2.0% 5.4% 5.5% 5.9% 6.9% 8.6% 9.1% Burrows B 1.3% 2.2% 3.4% 3.1% 4.7% 5.4% 5.6% 5.9% 1.8% -2.5% Net Profit Margin Burrows A 2.7% 2.8% 2.9% 3.5% 4.3% 4.6% Burrows B 1.8% 1.7% 2.6% 3.0% 3.3% 3.6% 1.3% -1.2% Activity (1970) 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Collection Days Burrows A 8 0 - - - 4 7 Burrows B 0 6 13 16 15 12 13 16 6 6 Inventory Turnover Burrows A 2.4 2.2 2.6 2.5 2.6 2.8 2.8 Burrows B 2.4 2.6 2.0 2.3 2.2 2.0 2.6 2.2 2.6 2.4 Inventory Days Burrows A 150 167 143 144 138 129 128 Burrows B 149 138 179 157 167 186 142 168 141 150 Asset Turnover Burrows A 2.5 3.0 2.4 2.4 2.3 2.3 2.1 Burrows B 2.6 2.6 2.0 2.4 2.4 2.3 2.6 2.3 2.6 2.5 Payable Days Burrows A 37 20 63 89 94 97 103 (Acc. Pay + Accr. Liab.) Burrows B 31 39 118 102 93 104 79 103 74 102 Leverage 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Current Ratio Burrows A 4.5 8.3 2.7 2.4 2.3 2.4 2.5 Burrows B 4.4 3.5 1.7 1.9 2.0 1.9 2.0 1.8 2.1 1.7 Acid Test Burrows A 0.3 0.1 0.9 0.8 1.0 1.2 1.3 Burrows B 0.1 0.2 0.5 0.4 0.4 0.3 0.4 0.4 0.2 0.1
BURROWS B Page 5 Current Debt/Total Debt Burrows A 20% 14% 43% 50% 55% 59% 63% Burrows B 20% 24% 65% 59% 58% 63% 63% 65% 55% 63% Debt/Equity Burrows A 2.1 2.4 2.2 1.8 1.5 1.3 Burrows B 3.3 2.4 2.1 2.0 1.4 1.6 1.4 1.9 Debt/Assets Burrows A 100% 68% 71% 68% 65% 61% 57% Burrows B 100% 100% 77% 71% 68% 66% 59% 62% 59% 65% Profitability 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Return on Assets Burrows A 8.1% 6.7% 7.0% 8.0% 9.7% 9.7% Burrows B 3.5% 4.1% 6.1% 6.7% 8.7% 8.2% 3.4% -3.0% Return on Equity Burrows A 25.1% 22.8% 22.1% 22.9% 24.5% 22.6% Burrows B 15.3% 14.2% 19.1% 20.0% 21.3% 21.7% 8.4% -8.5%
BURROWS B Page 6 CASH FLOW ANALYSIS Burrows A 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Net Income 165 205 275 390 465 Depreciation 80 95 112 134 145 Changes in Current Assets Changes in Current Liabilities Changes in Fixed and Other Assets Net Operational Cash Flows 245 300 387 524 610 Burrows B 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 Net Income 101 109 181 237 321 419 178 (163) Interest 73 108 73 75 85 86 224 282 Capex 530 (143) (146) (257) (298) (335) (437) (176) Depreciation (673) 59 72 88 115 146 83 196 Changes in working capital 270 (292) (141) (52) (486) 128 235 Net Operational Cash Flows 31 403 (112) 2 171 (170) 176 374
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