A quarterly forecasted balance sheet is below. Calculate OWC in each quarter. What is the maximum...

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

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

RTY Company’s year-end balance sheet for 2018 and forecasted quarterly cash flows for 2019 are given...

RTY Company’s year-end balance sheet for 2018 and forecasted quarterly cash flows for 2019 are given below. Company always pays for its purchases one quarter after the purchase. 50% of all sales are collected in the current quarter and 50% in the next quarter. Other expenses are paid in the current quarter. a. Prepare the quarterly cash budget for the company for 2019. b. Assuming all forecasts will be accurate, how much external long-term financing will the company need if...

For the given quarterly sales data, a) calculate seasonal indices for each quarter, b) the year...

For the given quarterly sales data, a) calculate seasonal indices for each quarter, b) the year 4 annual forecast based on a linear regression trend forecasting method, c) the seasonally adjusted trend based quarterly forecasts for that 4th year, d) the year 4 annual forecast based on the Naive forecasting method, and e) the seasonally adjusted Naive based quarterly forecast for that 4th year. Quarter: Year 1 Year 2 Year 3 1 2 3 7 2 6 10 18 3...

Below is balance sheet information for five independent situations. Calculate the answer to each. 1. A...

Below is balance sheet information for five independent situations. Calculate the answer to each. 1. A company reports total assets of $3,560 and total liabilities of $740. What is the amount of stockholders' equity? 2. A company reports total liabilities of $1,800 and stockholders' equity of $1,200. What is the amount of total assets? 3. A company reports total assets of $3,000 and total stockholders' equity of $450. What is the amount of total liabilities? 4. A company reports an...

Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each...

Below is the balance sheet information on two companies. Prepare a common-size balance sheet for each company. Review each company's percentage of total assets. Are these companies operating with similar philosophies or in similar industries? What appears to be the major difference in financing for these two companies? Account Balance Sheet Company 1 Balance. Sheet Company 2 Current Assets Cash $5,377 $299 Investments $4,146 $354 Accts. Rec. $8,100 $221 Inventory $5,372 $494 Total Current $22,995 $1,368 Long Inv. $84 $307...

For each of the following, calculate the cost of inventory reported on the balance sheet. (a)...

For each of the following, calculate the cost of inventory reported on the balance sheet. (a) The total inventory on hand at the end of the year as determined by taking a physical inventory is $62,000. Of the $62,000, $8,000 has been sold FOB destination and is awaiting pickup by the carrier. (b) The total inventory counted at the end of the year was $63,000. Excluded from the count were purchases of $6,000 in transit under FOB shipping point terms. (c)...

( B ) : In each quarter of every year, the maximum capacity of the "MBA...

( B ) : In each quarter of every year, the maximum capacity of the "MBA Co." is 4000 hours available for sorting and re-packing two sorts of imported apples in special boxes where each box contains only one ton of either the red or the yellow apples. The monthly common committed fixed costs of the company is L.E. 100000, and the following estimates are presented in relation to the coming quarter which will start July 1, 2015 :- red...

Quarterly deposits are made into a fund at the beginning of each quarter starting today for...

Quarterly deposits are made into a fund at the beginning of each quarter starting today for 5 years. The first 8 deposits are $1000 each and deposits increase by 1% per quarter thereafter. If the fund earns 8% effective annually, find the accumulated value at the end of 5 years. Please explain which equations you used and do not use excel.

what quarterly deposits at the end of each quarter should be made into a savings account paying the nominal interest of

1. what quarterly deposits at the end of each quarter should be made into a savings account paying the nominal interest of 4% compounded quarterly to accumulate $10,000 at the end of 10 years?2. Faith buys a used car by paying a $500 down payment plus $180 a month for 3 years. what was the price of the car if the interest rate on the loan is the nominal interest rate of 9% compounded monthly?

A Using the balance sheet and income statement below, calculate the quick ratio. B Using the...

A Using the balance sheet and income statement below, calculate the quick ratio. B Using the balance sheet and income statement below, calculate the current ratio. C Using the balance sheet and income statement below, calculate return on equity. D Using the balance sheet and income statement below, calculate days sales outstanding (also called average collection period). E Using the balance sheet and income statement below, calculate inventory turnover. F sing the balance sheet and income statement below, calculate the...

Indicate the way each of the items listed below should be reported in a balance sheet...

Indicate the way each of the items listed below should be reported in a balance sheet at December 31, 2021. asset current liability disclosure note only long term liability not reported Reporting method commercial paper noncommitted line of credit customer advances estimated quality assurance warranty cost accounts payable Long Term bonds that will be callable by the creditor in the upcoming year unless an existing violation is not corrected Note due March 3 2022 Interest accrued on note December 31,...

Subjects