tables are below the question
Change 1993 cost of goods sold from BRABU 70 percent and 1994 cost of goods sold for Boyle 60 percent on page 64 in casebook. 1. 62-78. Please fill in Xs. Divide accounts by total assets in Table 1 to get Xs in Table 3 for 1992. Also, please do long-term debt in Table 3 for 1992 (which is blank-should have an X). Example: In Table 3 for 1992, accounts receivable = 30.19% = 58,714/194,465 TABLE 1 Historical and Pro Forma Balance Sheets for Years Ended December 31 (in Thousands of Dollars) 1990 1991 1992 Proforma 1993 1994 Assets: Cash and marketable securities Accounts receivable Inventory Current assets Land, buildings, plant, and equipment Accumulated depreciation Net fixed assets Total assets $ 9,930 34.196 39.791 $ 83,888 $ 7.363 36,924 69,361 $113.647 $ 6,550 58,714 97/984 $163,249 X X $ 34.634 (5.992) S 28.642 $112,530 $ 39,19 (9308) $.29.887 $143.534 $ 44,604 (13.388) 21.216 $194,465 $ 57,036 (18,234) $38.802 $215,375 $58,746 (21.880 $36.866 X Liabilities and Equity: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term debt Total liabilities Common stock Retained earnings Total equity Total liabilities and equity $ 6,376 13,528 6,886 $ 26,790 $ 13,388 5.738 $ 19.126 $ 45,916 $ 46,538 20,070 $ 66,614 $112.530 $ 10.200 21,012 10,200 $ 41.412 $ 20,082 5,202 $ 25,284 $ 66,696 $ 46,538 30.300 $ 76,828 $143,534 $ 36,466 39.996 14.662 $ 91,124 $20,082 4.680 S 24,762 $115.886 $ 46,538 32.041 $ 78,579 $194,465 31.990 18,602 X $ 20,082 4,208 $24.290 $ 46,538 X $33,590 23,252 X $20,082 3.788 $23,870 X $46.538 X X Notes 4.7.000.000 shares of common stock were outstanding throughout the period 1990 through 1992. h Market price of shares: 1990-$17.78: 1991-89.70, 1992-53.74 c. Pricelearnings (P/E) entios: 1990-6.29, 1991-4.98; 1992-11.28. The 1992 Pre ratio is high because of the depressed earnings that year d. Assume that all changes in interest-bearing loans and gross fixed assets occur at the start of the relevant years, e. The mortgage loan is secured by a first-mortgngo bond on land and buildings TABLE 3 Common-Size Balance Sheets for Years Ended December 31 1990 1991 1992 Assets: Cash and marketable securities Accounts receivable Inventory Current assets Land, buildings, plant, and equipment Accumulated depreciation Net fixed assets Total assets 50.39 8.82% 30.39 35.36 74.55% 30.78% (532) 25.45% 100.00% 5.1396 3.37% 25.72 48.32 79.18% X 27.319 6.48) (6.88 20.82% 16.05% 100.00% 100.00 Liabilities and Equities: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term debt Total liabilities Common stock Retained earnings Total equity Total liabilities and equity 18.75% 20.57 7.54 46.86% 2.41 5.67% 12.02 6.12 23.81% 11.909 5.10 17.00% 40.80% 41.36% 17.84 59.20% 100.00% 7.11% 14.64 7.11 28.85% 13.99% 3.62 17.62% 464793 32.42% 21.11 53.539 100,00 59.5993 23.9396 40.419 100.00% Note: Rounding differences occur in this table. Change 1993 cost of goods sold from BRABU 70 percent and 1994 cost of goods sold for Boyle 60 percent on page 64 in casebook. 1. 62-78. Please fill in Xs. Divide accounts by total assets in Table 1 to get Xs in Table 3 for 1992. Also, please do long-term debt in Table 3 for 1992 (which is blank-should have an X). Example: In Table 3 for 1992, accounts receivable = 30.19% = 58,714/194,465 TABLE 1 Historical and Pro Forma Balance Sheets for Years Ended December 31 (in Thousands of Dollars) 1990 1991 1992 Proforma 1993 1994 Assets: Cash and marketable securities Accounts receivable Inventory Current assets Land, buildings, plant, and equipment Accumulated depreciation Net fixed assets Total assets $ 9,930 34.196 39.791 $ 83,888 $ 7.363 36,924 69,361 $113.647 $ 6,550 58,714 97/984 $163,249 X X $ 34.634 (5.992) S 28.642 $112,530 $ 39,19 (9308) $.29.887 $143.534 $ 44,604 (13.388) 21.216 $194,465 $ 57,036 (18,234) $38.802 $215,375 $58,746 (21.880 $36.866 X Liabilities and Equity: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term debt Total liabilities Common stock Retained earnings Total equity Total liabilities and equity $ 6,376 13,528 6,886 $ 26,790 $ 13,388 5.738 $ 19.126 $ 45,916 $ 46,538 20,070 $ 66,614 $112.530 $ 10.200 21,012 10,200 $ 41.412 $ 20,082 5,202 $ 25,284 $ 66,696 $ 46,538 30.300 $ 76,828 $143,534 $ 36,466 39.996 14.662 $ 91,124 $20,082 4.680 S 24,762 $115.886 $ 46,538 32.041 $ 78,579 $194,465 31.990 18,602 X $ 20,082 4,208 $24.290 $ 46,538 X $33,590 23,252 X $20,082 3.788 $23,870 X $46.538 X X Notes 4.7.000.000 shares of common stock were outstanding throughout the period 1990 through 1992. h Market price of shares: 1990-$17.78: 1991-89.70, 1992-53.74 c. Pricelearnings (P/E) entios: 1990-6.29, 1991-4.98; 1992-11.28. The 1992 Pre ratio is high because of the depressed earnings that year d. Assume that all changes in interest-bearing loans and gross fixed assets occur at the start of the relevant years, e. The mortgage loan is secured by a first-mortgngo bond on land and buildings TABLE 3 Common-Size Balance Sheets for Years Ended December 31 1990 1991 1992 Assets: Cash and marketable securities Accounts receivable Inventory Current assets Land, buildings, plant, and equipment Accumulated depreciation Net fixed assets Total assets 50.39 8.82% 30.39 35.36 74.55% 30.78% (532) 25.45% 100.00% 5.1396 3.37% 25.72 48.32 79.18% X 27.319 6.48) (6.88 20.82% 16.05% 100.00% 100.00 Liabilities and Equities: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term debt Total liabilities Common stock Retained earnings Total equity Total liabilities and equity 18.75% 20.57 7.54 46.86% 2.41 5.67% 12.02 6.12 23.81% 11.909 5.10 17.00% 40.80% 41.36% 17.84 59.20% 100.00% 7.11% 14.64 7.11 28.85% 13.99% 3.62 17.62% 464793 32.42% 21.11 53.539 100,00 59.5993 23.9396 40.419 100.00% Note: Rounding differences occur in this table
