The balance sheet and the income statement of Omega Company containing data in is as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The balance sheet and the income statement of "Omega" Company containing data in € is as follows: Assets Fixed assets: Property, plant and equipment Less accumulated depreciation Net property, plant and equipment Total fixed assets Current assets: Cash and cash equivalents Marketable securities Accounts receivables Inventory Prepaid expenses Total current assets Total assets Balance Sheet 20X1 Liabilities & Stockholders' Equity. Stockholders' equity: 11,000,000 Common stock (3,925,000) Retained earnings 7,075,000 7,075,000 Total stockholders' equity Long-term liabilities: Long-term debt 700,000 Total long-term liabilities 800,000 Current liabilities: 1,650,000 Accounts payable 2,100,000 Short-term debt 750,000 6,000,000 13,075,000 Interest expense Income before taxes Income taxes (25%) Net income Total current liabilities Total liabilities Total liabilities & stockholders' equity Income Statement 20X1 Sales Cost of goods Gross margin Selling and administrative expenses Net operating income 17,499,600 (13,000,000) 4,499,600 (3,599,600) 900,000 (400,000) 500,000 (125,000) 375,000 20X1 5,500,000 1,075,000 6,575,000 3,500,000 3,500,000 700,000 2,300,000 3,000,000 6,500,000 13,075,000 Due to significant changes to the financial environment in one of the main Omega's markets it is expected that the average collection period will increase to 50 days. Omega is in the process of negotiating a long-term loan and the CFO is concerned on the credit outlook of the company. The CFO has decided to reduce cash and cash equivalents to €400,000. However, further actions are needed. You are asked to examine two extreme what-if scenarios to help the CFO decide the future financial policy of Omega. The first is to decrease inventories, and the other is to hold back Omega's payments by increasing the accounts payable. Assume all other amounts as the same. Required: 1. Calculate the impact on accounts receivables of the increase of the average collection period (5%). 2. Prepare the balanced sheet of each scenario, also taking into account the reduction in cash and cash equivalents. Please prefer to report them in comparative form (10%) 3. Calculate for each scenario the a) working capital, b) current ratio, c) acid-test ratio, d) cash to current liabilities ratio, e) days' sales in receivables (based on ending accounts receivables), f) days' sales in inventory (based on ending inventory), g) operating cycle, h) total debt to equity ratio and i) times interest earned. For your calculations, assume that a year amounts for 360 days (5%). The balance sheet and the income statement of "Omega" Company containing data in € is as follows: Assets Fixed assets: Property, plant and equipment Less accumulated depreciation Net property, plant and equipment Total fixed assets Current assets: Cash and cash equivalents Marketable securities Accounts receivables Inventory Prepaid expenses Total current assets Total assets Balance Sheet 20X1 Liabilities & Stockholders' Equity. Stockholders' equity: 11,000,000 Common stock (3,925,000) Retained earnings 7,075,000 7,075,000 Total stockholders' equity Long-term liabilities: Long-term debt 700,000 Total long-term liabilities 800,000 Current liabilities: 1,650,000 Accounts payable 2,100,000 Short-term debt 750,000 6,000,000 13,075,000 Interest expense Income before taxes Income taxes (25%) Net income Total current liabilities Total liabilities Total liabilities & stockholders' equity Income Statement 20X1 Sales Cost of goods Gross margin Selling and administrative expenses Net operating income 17,499,600 (13,000,000) 4,499,600 (3,599,600) 900,000 (400,000) 500,000 (125,000) 375,000 20X1 5,500,000 1,075,000 6,575,000 3,500,000 3,500,000 700,000 2,300,000 3,000,000 6,500,000 13,075,000 Due to significant changes to the financial environment in one of the main Omega's markets it is expected that the average collection period will increase to 50 days. Omega is in the process of negotiating a long-term loan and the CFO is concerned on the credit outlook of the company. The CFO has decided to reduce cash and cash equivalents to €400,000. However, further actions are needed. You are asked to examine two extreme what-if scenarios to help the CFO decide the future financial policy of Omega. The first is to decrease inventories, and the other is to hold back Omega's payments by increasing the accounts payable. Assume all other amounts as the same. Required: 1. Calculate the impact on accounts receivables of the increase of the average collection period (5%). 2. Prepare the balanced sheet of each scenario, also taking into account the reduction in cash and cash equivalents. Please prefer to report them in comparative form (10%) 3. Calculate for each scenario the a) working capital, b) current ratio, c) acid-test ratio, d) cash to current liabilities ratio, e) days' sales in receivables (based on ending accounts receivables), f) days' sales in inventory (based on ending inventory), g) operating cycle, h) total debt to equity ratio and i) times interest earned. For your calculations, assume that a year amounts for 360 days (5%).
Expert Answer:
Answer rating: 100% (QA)
a Working Capital Rationet sales Current AssetsCurrent Liabilities 17499600500000 349992 b Current R... View the full answer
Related Book For
Intellectual Property- The Law of Trademarks, Copyrights, Patents, and Trade Secrets
ISBN: 978-1428318366
3rd Edition
Authors: Deborah E. Bouchoux
Posted Date:
Students also viewed these accounting questions
-
Vision has asked two of its in-house marketing employees to create a jingle for a new ad campaign. There is no agreement as to who will own the copyright in the finished jingle. In 2000, Vision...
-
V-24 V www ww R R R P Load C If we would like to design a power supply to supply different equipment: 1-84 v for Load A with 39 mA current Load F 2-58 V for Load F with 25 mA current. 3-12 V for Load...
-
Insurance companies bond employees of other companies who handle cash Bonding employees is much like having an insurance policy that will reimburse the company if an employee steals money Good idea...
-
Knowing that two equal caps have been removed from a 10-in.-diameter wooden sphere, determine the total surface area of the remaining portion. 4 in 10 in.
-
A demand loan of $3000 is repaid by payments of $1500 after two years, $1500 after four years, and a final payment after seven years. Interest is 9% compounded quarterly for the first year, 10%...
-
Virginias Ron McPherson Electronics Corporation retains a service crew to repair machine breakdowns that occur on average = 3 per 8- hour workday (approximately Poisson in nature). The crew can...
-
Based on the design, briefly discuss the data collection procedures to be used. Be sure to include the area rea of focus and targeted sample as part of these procedures. Develop a hypothetical...
-
Green Thumb operates a commercial plant nursery where it propagates plants for garden centers throughout the region. Green Thumb has $4,800,000 in assets. Its yearly fixed costs are $600,000, and the...
-
Consider the function f(x) = -x + 5. . - Given the graph of f(x) = x + 5, accurately sketch the graph of y(x) on the same set of axes. (1 mark) Algebraically determine the invariant points as exact...
-
A highway has an optional toll lane that drivers may take to reduce the time they spend driving. Drivers pay a small fee to enter the toll lane ($0.25). Then, once they leave the toll lane, they pay...
-
For this assessment submit only one file, in Word. This means you must import your financial assessment as TABLES, not pictures, into Word. Pdf files will receive a grade but no feedback will be...
-
If you are exposed to a 'BBB' rated corporate bond and wanted to hedge against default, what would be the expected fair-value CDS premium on a 4 year CDS contract? CDS Contract Details 'BBB' Default...
-
Michael has an employment income on line 10100 for $52,000 and he paid union dues for $500 in 2020 What is her earned income for RRSP purposes?
-
Explain the intern why these two steps are different. Explain the different assertions being tested and what types of errors each of these tests would identify. Possible for other businesses such as...
-
create an outline in defense of a position of international medical tourism. The outline should be comprised of talking points related to the following: - describe whether you agree or disagree with...
-
1. what are capital budgeting decisions and their function? 2. What is a cash budget and its function?
-
(Non-Arm's Length Disposition of Depreciable Property) The following two independent Cases involve a non-arm's length disposition of a depreciable property. Case One Jason Lasarge owns a depreciable...
-
KD Insurance Company specializes in term life insurance contracts. Cash collection experience shows that 20 percent of billed premiums are collected in the month before they are due, 60 percent are...
-
Identify each of the following as a compilation, collection, or derivative work. The Broadway play Spamalot based on the earlier Monty Python sketches A chart entitled Fast Facts about U.S....
-
ABC Co. has an aggressive trade secret protection program, including encrypting its documents when they are transmitted electronically. Through an unanticipated development, a company has been able...
-
If a search of the USPTO records for SPA LOTION discloses a reference for SPA TREATMENT LOTION for moisturizers, what should the client do?
-
Why do you think we would want to look at the accounts receivable in the accounting books as often as once a month?
-
Why did the relaxation of mortgage lending standards lead to an increase in house prices in the U.S. during the 20002006 period?
-
What happened to the large investment banks following the 20078 crisis?
Study smarter with the SolutionInn App