Question

In: Accounting

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


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...
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the...
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the financial ratios requested below. All answers must be rounded to TWO decimal places including percentages Sales 421756 Operating Costs 313053 Depreciation Expense 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 52175 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 62175 Based on these values calculate: Current ratio Quick ratio NWC-to-total-Assets (Working capital to assets)...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT