In: Accounting
A quarterly forecasted balance sheet is below. Calculate OWC in each quarter. What is the maximum OWC level?
Q1 | Q2 | Q3 | Q4 | |
Cash and equivalents | 273,963.7 | 210,182.0 | 251,475.6 | 357,125.6 |
Accounts receivable, net | 279,881.2 | 335,352.0 | 580,500.0 | 458,039.6 |
Inventories | 256,128.0 | 341,518.0 | 348,314.0 | 235,008.4 |
Prepaid assets and other current assets | 228,915.6 | 228,936.4 | 228,594.8 | 228,571.6 |
Total current assets | 1,038,888.5 | 1,115,988.4 | 1,408,884.4 | 1,278,745.2 |
Property, plant, and equipment | 286,243.2 | 293,200.8 | 288,519.6 | 296,458.8 |
Goodwill | 554,358.0 | 557,258.8 | 555,183.6 | 553,808.0 |
Other fixed assets | 564,118.4 | 576,780.4 | 542,821.2 | 492,063.6 |
Total Assets | 2,443,608.1 | 2,543,228.4 | 2,795,408.8 | 2,621,075.6 |
Short term borrowings | 800.5 | 14,107.6 | 0.0 | 6,765.6 |
Current portion of long term debt | 0.0 | 0.0 | 0.0 | 120,000.0 |
Accounts payable | 115,039.6 | 198,704.0 | 324,267.2 | 260,672.4 |
Accrued expenses | 198,720.8 | 244,050.8 | 375,201.6 | 263,290.0 |
Income taxes payable | 4,214.8 | 3,114.8 | 12,767.2 | 7,500.8 |
Total current liabilities | 318,775.7 | 459,977.2 | 712,236.0 | 658,228.8 |
Long-term debt | 840,000.0 | 840,000.0 | 840,000.0 | 720,000.0 |
Other noncurrent liabilities | 218,175.2 | 217,462.0 | 214,107.6 | 189,545.2 |
Total noncurrent liabilities | 1,058,175.2 | 1,057,462.0 | 1,054,107.6 | 909,545.2 |
Common stock | 176,547.6 | 176,547.6 | 176,547.6 | 176,547.6 |
Retained earnings | 890,109.6 | 849,241.6 | 852,517.6 | 876,754.0 |
Total stockholders’ equity | 1,066,657.2 | 1,025,789.2 | 1,029,065.2 | 1,053,301.6 |
Total Liabilities and Stockholders’ Equity | 2,443,608.1 | 2,543,228.4 | 2,795,408.8 | 2,621,075.6 |
Check | 0.0 | 0.0 | 0.0 | 0.0 |
OK | OK | OK | OK |
Select one:
720,112.8
446,149.1
459,936.8
604,546.8