Question You have been provided with the 2020 financial statements of XYZ Inc. (XYZ) (reproduced Obelow)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question You have been provided with the 2020 financial statements of XYZ Inc. ("XYZ") (reproduced Obelow) and the following additional information (all amounts are h '000s): • The demand for XYZ's products is highly seasonal, but the firm employs level production throughout the year because of its limited plant capacity Cost of goods sold is 70% of sales. Estimated costs of goods manufactured (COGM) for 2021 is 3,010. Due to level production, the value of goods produced each month is the same ICOGM =_436 -re Accounts payable, for the purchases of raw materials ("RM"), are paid in the month following purchase and owing to level production, are constant at $125 at the end of gach month 3,010 and Monthly production 3,010 -12 = $250.833] Thus, purchases each month= A25 JOURNAL ENTRIES: Ra Materrine Suventeng AP AP 12 Casle 125 Operating expenses are $46 per month. • Depreciation expense (on non-manufacturing assets) is calculated on a straight-line basis and equals $525 per year. • All sales are on credit and accounts receivable are collected 2 months after the sale Bad debts are negligible • XYZ wants to maintain a MINIMUM cash balance of $150. The company has a $1.000 line of credit available at the bank that is used for any cash deficiencies (as needed). Any excess cásh over the minimum required will be used to reduce the line of credit where applicable. Income taxes are levied at a rate of 50 percent and are paid three months after the year-end (for the full year). Long-term debt repayments of $100 and interest payments of $50 are made at the end of June and December. For simplicity, ignore interest on the line of credit Annual dividends of $15 are declared and paid at the end of December. XYZ Inc. Income Statement for the Yoar Ended December 31, 2020 (in '000s) $4,149, 2.904 $1,245 Sales Cost of goods sold Gross margin Operating expenses Depreciation expense Income before interest and taxes Interest expense Income before taxes Income tax expense Net income 552 525 $168 100 $68 34 $34 4-31 XYZ Inc. Balance Sheet as at December 31, 2020 (in '000s) $150 ASSETS Cash 1,750 310 Accounts receivable LJu + Inventory Total current assets Property, plant and equipment ("PP&E") Less: Accumulated depreciation PP&E, net Total assets $2,210 $10,500 3,900 6.600 $8.810 LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable Bank loan (line of credit) Interest payable Income tax payable [paidA/312224 Current portion of long-term debt $125 215 34 200 $574 Total current liabilities Long-term debt (net of current portion) Total liabilities Common shares (Capital stock) Retained earnings Total liabilities and shareholders' equity 3.400 3,974 1,800 3.036 $8.810 ACTUAL sales for 2020 (in '000s): November $820 December $930 PROJECTED (estimated) sales for 2021 (in 000s): January February March $55 July August September $80 $550 $55 $55 $5 $690 April May October $830 $60 November $850 $960 June $60 20 December REQUIRED: Prepare Pro-Forma financial statements for the first quarter of 2021 and Mar 31 "HIGHLY SEASONAL": January to July Sales 430 = 9.77% of yearly sales August to December Sales - = 90.23% of yearly sales Total Sales $4.300 4-32 We prepared the statements for Quarter 1 (Q1) in class. Prepare the statements for Q2 (April 1- June30) based on the following assumptions: April's sales. $100.000: May's sales. $150.000: and. June's sales. $200.000. Indicate your answers on page 2 and show your work on page 3. EVERYTHING ELSE STAYS THE SAME AS IN THE QUESTION IN THE NOTES. PROJECTED (estimated) sales for 2021 (in "000s): January $55 July February $55 $100 $150 $80 $550 $690 $830 S850 $55 August March September October April May June November $200 December $960 Since we completed Quarter 1 in class, start with those balances and Prepare Pro-Forma financial statements for the second quarter of 2021. ASSIGNMENT #2 - Chapter 4 (Part 2) NAME (Last, First): (12 marks) XYZ Company PRO FORMA Quarterly Student No.: Income Statements Q2 Q1 $165,000 115.500 49,500 138,000 131.250 Sales Cost of goods sold Gross profit Operating expenses Depreciation expense Income before interest & taxes (219,750) Interest expense Income before taxes Income (expense)/recovery Net Income 25.000 (244.750) tax 122.375 S(122.375) PRO FORMA Quarterly Balance Sheets 02 $815,500 110,000 947,000 10.500,000 4,031.250) $8.341.250 3125.000 01 Cash Accounts receivable Inventory Plant & equipment Accumulated depreciation Total Assets Accounts payable Line of credit 25.000 122,375) Interest payable Taxes payable Current portion of LT debt 200,000 Long-term debt Common shares Retained earnings Total Liabilities & Sh. Equity$8.341.250 SHOW YOUR WORK: 3,400,000 1,800,000 2.913.625 Question You have been provided with the 2020 financial statements of XYZ Inc. ("XYZ") (reproduced Obelow) and the following additional information (all amounts are h '000s): • The demand for XYZ's products is highly seasonal, but the firm employs level production throughout the year because of its limited plant capacity Cost of goods sold is 70% of sales. Estimated costs of goods manufactured (COGM) for 2021 is 3,010. Due to level production, the value of goods produced each month is the same ICOGM =_436 -re Accounts payable, for the purchases of raw materials ("RM"), are paid in the month following purchase and owing to level production, are constant at $125 at the end of gach month 3,010 and Monthly production 3,010 -12 = $250.833] Thus, purchases each month= A25 JOURNAL ENTRIES: Ra Materrine Suventeng AP AP 12 Casle 125 Operating expenses are $46 per month. • Depreciation expense (on non-manufacturing assets) is calculated on a straight-line basis and equals $525 per year. • All sales are on credit and accounts receivable are collected 2 months after the sale Bad debts are negligible • XYZ wants to maintain a MINIMUM cash balance of $150. The company has a $1.000 line of credit available at the bank that is used for any cash deficiencies (as needed). Any excess cásh over the minimum required will be used to reduce the line of credit where applicable. Income taxes are levied at a rate of 50 percent and are paid three months after the year-end (for the full year). Long-term debt repayments of $100 and interest payments of $50 are made at the end of June and December. For simplicity, ignore interest on the line of credit Annual dividends of $15 are declared and paid at the end of December. XYZ Inc. Income Statement for the Yoar Ended December 31, 2020 (in '000s) $4,149, 2.904 $1,245 Sales Cost of goods sold Gross margin Operating expenses Depreciation expense Income before interest and taxes Interest expense Income before taxes Income tax expense Net income 552 525 $168 100 $68 34 $34 4-31 XYZ Inc. Balance Sheet as at December 31, 2020 (in '000s) $150 ASSETS Cash 1,750 310 Accounts receivable LJu + Inventory Total current assets Property, plant and equipment ("PP&E") Less: Accumulated depreciation PP&E, net Total assets $2,210 $10,500 3,900 6.600 $8.810 LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable Bank loan (line of credit) Interest payable Income tax payable [paidA/312224 Current portion of long-term debt $125 215 34 200 $574 Total current liabilities Long-term debt (net of current portion) Total liabilities Common shares (Capital stock) Retained earnings Total liabilities and shareholders' equity 3.400 3,974 1,800 3.036 $8.810 ACTUAL sales for 2020 (in '000s): November $820 December $930 PROJECTED (estimated) sales for 2021 (in 000s): January February March $55 July August September $80 $550 $55 $55 $5 $690 April May October $830 $60 November $850 $960 June $60 20 December REQUIRED: Prepare Pro-Forma financial statements for the first quarter of 2021 and Mar 31 "HIGHLY SEASONAL": January to July Sales 430 = 9.77% of yearly sales August to December Sales - = 90.23% of yearly sales Total Sales $4.300 4-32 We prepared the statements for Quarter 1 (Q1) in class. Prepare the statements for Q2 (April 1- June30) based on the following assumptions: April's sales. $100.000: May's sales. $150.000: and. June's sales. $200.000. Indicate your answers on page 2 and show your work on page 3. EVERYTHING ELSE STAYS THE SAME AS IN THE QUESTION IN THE NOTES. PROJECTED (estimated) sales for 2021 (in "000s): January $55 July February $55 $100 $150 $80 $550 $690 $830 S850 $55 August March September October April May June November $200 December $960 Since we completed Quarter 1 in class, start with those balances and Prepare Pro-Forma financial statements for the second quarter of 2021. ASSIGNMENT #2 - Chapter 4 (Part 2) NAME (Last, First): (12 marks) XYZ Company PRO FORMA Quarterly Student No.: Income Statements Q2 Q1 $165,000 115.500 49,500 138,000 131.250 Sales Cost of goods sold Gross profit Operating expenses Depreciation expense Income before interest & taxes (219,750) Interest expense Income before taxes Income (expense)/recovery Net Income 25.000 (244.750) tax 122.375 S(122.375) PRO FORMA Quarterly Balance Sheets 02 $815,500 110,000 947,000 10.500,000 4,031.250) $8.341.250 3125.000 01 Cash Accounts receivable Inventory Plant & equipment Accumulated depreciation Total Assets Accounts payable Line of credit 25.000 122,375) Interest payable Taxes payable Current portion of LT debt 200,000 Long-term debt Common shares Retained earnings Total Liabilities & Sh. Equity$8.341.250 SHOW YOUR WORK: 3,400,000 1,800,000 2.913.625
Expert Answer:
Answer rating: 100% (QA)
We prepared the statements for Quarter 1 Q1 in class Prepare the statements f... View the full answer
Related Book For
Accounting
ISBN: 978-0324662962
23rd Edition
Authors: Jonathan E. Duchac, James M. Reeve, Carl S. Warren
Posted Date:
Students also viewed these accounting questions
-
In Figure two particles of charges q1 and q2 are fixed to an x axis. If a third particle, of charge + 6.0C, is brought from an infinite distance to point P, the three-particle system has the same...
-
In Figure the particles have charges q1 = ?? q2 = 100nC and q3 = ?? q4 = 200nC, and distance a = 5.0cm. What are the(a) x and(b) y components of the net electrostatic force onparticle? t (2 $ 2) 1
-
In divisional income statements prepared for Mills Construction Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll checks, and the...
-
5. Did Danone follow the advice regarding JVs in China mentioned in the list just above? Which aspects did it follow and which did it not? Danone's Wrangle with Wahaha In 1996, In 1996, Danone Group...
-
At the beginning of the year, Tennyson Auto Parts had an accounts receivable balance of $31,800 and a balance in the allowance for doubtful accounts of $2,980 (credit). During the year Tennyson had...
-
Why is it considered necessary for a successor auditor to communicate with a previous auditor? Identify three matters about which the proposed auditor should direct inquiries to the previous auditor.
-
On January 7, Red Tucker, Inc., paid $254,700 for equipment used in manufacturing automotive supplies. In addition to the basic purchase price, the company paid $500 transportation charges, $300...
-
On February 25, Madison County Rocks Inc., a marble contractor, issued for cash 120,000 shares of $36 par common stock at $40, and on June 3, it issued for cash 50,000 shares of preferred stock, $8...
-
Aristocrat Leisure (ALL) acquired Video Gaming Technologies (VGT) in 2014. How would you describe the financing of the acquisition? Evaluate the financing choice on Aristocrat's distress/credit risk,...
-
A parallel chord Howe truss is loaded as shown. Determine the force in members GI, GJ, and HJ.
-
ABC Hospital is one of two hospitals in the community. The Hospital offers all major specialty services (e.g. cardiology, neurology, pulmonology, etc.) The Hospital is approached by a cardiologist...
-
Let V,C be the Roman-alphabet vowels and consonants, respectively, and let A be both together, the whole alphabet thus. (Consider "y" to be a consonant.) Remember that V (etc.) is sometimes used as...
-
Maxwell Inc. sells computer systems. Maxwell leases computers to Poodle Company on January 1, 2024. The manufacturing cost of the computers was $12 million. This noncancelable lease had the following...
-
A marketing manager is considering the following advertising media to promote a new product. Type Audience Reached/Ad Cost/Ad Maximum No. of Ads TV 50,000 $3000 10 Radio 25,000 $1000 15 Newspaper...
-
A simple pendulum is found to vibrate at frequency of 0.6 Hz in a vacuum and 0.45 Hz in a viscous fluid. Answer questions 5-6. 5. What is the cord length? A. 0.994 m. C. 0.388 m E. 0.212 m 6. What is...
-
As part of a school science fair, students from various school districts must be transported to the various locations. School districts are as follows (with the number of attendees listed by...
-
Calculate the fair present values of the following bonds, all of which pay interest semiannually, have a face value of $1,000, have 10 years remaining to maturity, and have a required rate of return...
-
Write the given system without the use of matrices. D) - ()- d (x sin t + 8 (2+ 1)
-
Bio-Care, Inc., a manufacturer of disposable medical supplies, prepared the following factory overhead cost budget for the Assembly Department for March 2010. The company expected to operate the...
-
The Rolling Department of Atlas Steel Company had 4,150 tons in beginning work in process inventory (40% complete). During the period, 83,580 tons were completed. The ending work in process inventory...
-
Can a company change its method of costing inventory? Explain.
-
Find the eigenvalues and eigenvectors of the following matrix: \[[A]=\left[\begin{array}{cc}8 & -1 \\-4 & 4\end{array} ight]\] \[[[A]-\lambda[I]] \vec{X}=\overrightarrow{0}\] where \(\lambda\) is the...
-
Find the natural frequencies of the system shown in Fig. 6.19 with \(m=1 \mathrm{~kg}, l=1 \mathrm{~m}\), \(k=1000 \mathrm{~N} / \mathrm{m}\), and \(c=100 \mathrm{~N}-\mathrm{s} / \mathrm{m}\)....
-
Consider the eigenvalue problem \[\left[[k]-\omega^{2}[m] ight] \vec{X}=\overrightarrow{0}\] where Find the natural frequencies by finding the roots of the characteristic equation...
Study smarter with the SolutionInn App