Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions