Churchill Company has been in business for 3 years now, and things are going well. Greg...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Churchill Company has been in business for 3 years now, and things are going well. Greg Johnson has been able to expand the company onto two other campuses, and the company's sales and earnings have increased quickly. Since Greg's background is not in finance, after interviewing many candidates he recently decided to hire Nora Stanton as Churchill Company's first chief financial officer. Nora has a background in accounting and has quite a bit of experience in budgetary procedures. Nora's first task is to undertake a complete analysis of the firm's financial condition, including strengths and weaknesses, in order to develop sound financial plans for additional future expansion. 1. Using the financial statements and industry standard ratios below, develop a complete time series (where we compare the companies 2020 & 2022 results to each other and see if things were better or worse, labeled - Good, OK, or Poor)land cross-sectional analysis (where we compare our company to standard industry ratios) of Churchill Company's financial condition including strengths and weaknesses of Churchill Company. Again, time series is where a company compares the company to its self over time. Cross-sectional is where we compare the company to the industry (standard industry ratios). 2. Prepare common size income statements for 2020 and 2021 and address changes and concerns. A common size income statement is where we take each line item and divide it by the sales. When we do this, we state each line item in a percentage, which represents percentage of sales. Sales then will always be 100%. Once we have done this we can compare apples to apples so to speak. 3. Nora also believes the DuPont method of analysis (to calculate ROE or return on equity) is also a good way to see how the company is generating returns to its owner. Prepare a DuPont analysis for both Churchill Company and the industry and discuss Churchill Company s performance as compared to its industry. The formula to calculate return on equity using the DuPont method is: NPM x TATX FLM - ROE 4. After analyzing the data, what conclusions and recommendations would Nora be justified in making her report to Greg? What areas of Churchill Company's operations are in greatest need of immediate attention? Prepare a planned course of action for the solution of the firm's most pressing problems. Standard Industry Ratios 3.50 Current ratio Quick ratio 1.50 Average Collection period 30 days Inventory turnover 5.00 Total asset turnover 1.00 Debt ratio 45.0% Times interest earned 4.10 Gross profit margin 25.0% Net profit margin 8.0% Return on total assets 8.0% Return on equity 14.50% Financial Leverage Multiplier 1.81 Churchill Company, Inc. Comparative Balance Sheets December 31, 2020 December 31, 2021 Assets $ 10,000 $ 50,000 100,000 120,000 150,000 150,000 $ 300,000 $ 280,000 1,200,000 1,480,000 (560.000) S 920,000 $1,200,000 $ 42,000 24,000 224.000 $ 290,000 200,000 200,000 $10,000 $1,200,000 December 31, 2017 $1,200,000 900,000 300,000 114,000 60,000 174,000 126,000 39,000 87,000 34,800 52,200 Cash Accounts Receivable Inventory Fixed Assets Total Assets Accounts Payable Accruals Notes Payable Total Current Liabilities Long-term debt Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Sales Cost of Goods Sold Gross Profit Operating Expenses: S, G, & A Depreciation Interest Expense Taxes Total Current Assets Less: Accumulated Depreciation Total Fixed Assets Total Operating Expenses Operating Profit Net income before taxes Net income after taxes (500,000) $ 700,000 $1,000,000 Liabilities and Stockholders' Equity $ 40,000 20,000 50,000 $ 110,000 200,000 200,000 490,000 $1,000,000 Churchill Company, Inc. Income Sheets December 31, 2016 $1,000,000 675,000 325,000 100,000 50,000 150,000 175,000 25,000 150,000 60,000 90,000 Churchill Company has been in business for 3 years now, and things are going well. Greg Johnson has been able to expand the company onto two other campuses, and the company's sales and earnings have increased quickly. Since Greg's background is not in finance, after interviewing many candidates he recently decided to hire Nora Stanton as Churchill Company's first chief financial officer. Nora has a background in accounting and has quite a bit of experience in budgetary procedures. Nora's first task is to undertake a complete analysis of the firm's financial condition, including strengths and weaknesses, in order to develop sound financial plans for additional future expansion. 1. Using the financial statements and industry standard ratios below, develop a complete time series (where we compare the companies 2020 & 2022 results to each other and see if things were better or worse, labeled - Good, OK, or Poor)land cross-sectional analysis (where we compare our company to standard industry ratios) of Churchill Company's financial condition including strengths and weaknesses of Churchill Company. Again, time series is where a company compares the company to its self over time. Cross-sectional is where we compare the company to the industry (standard industry ratios). 2. Prepare common size income statements for 2020 and 2021 and address changes and concerns. A common size income statement is where we take each line item and divide it by the sales. When we do this, we state each line item in a percentage, which represents percentage of sales. Sales then will always be 100%. Once we have done this we can compare apples to apples so to speak. 3. Nora also believes the DuPont method of analysis (to calculate ROE or return on equity) is also a good way to see how the company is generating returns to its owner. Prepare a DuPont analysis for both Churchill Company and the industry and discuss Churchill Company s performance as compared to its industry. The formula to calculate return on equity using the DuPont method is: NPM x TATX FLM - ROE 4. After analyzing the data, what conclusions and recommendations would Nora be justified in making her report to Greg? What areas of Churchill Company's operations are in greatest need of immediate attention? Prepare a planned course of action for the solution of the firm's most pressing problems. Standard Industry Ratios 3.50 Current ratio Quick ratio 1.50 Average Collection period 30 days Inventory turnover 5.00 Total asset turnover 1.00 Debt ratio 45.0% Times interest earned 4.10 Gross profit margin 25.0% Net profit margin 8.0% Return on total assets 8.0% Return on equity 14.50% Financial Leverage Multiplier 1.81 Churchill Company, Inc. Comparative Balance Sheets December 31, 2020 December 31, 2021 Assets $ 10,000 $ 50,000 100,000 120,000 150,000 150,000 $ 300,000 $ 280,000 1,200,000 1,480,000 (560.000) S 920,000 $1,200,000 $ 42,000 24,000 224.000 $ 290,000 200,000 200,000 $10,000 $1,200,000 December 31, 2017 $1,200,000 900,000 300,000 114,000 60,000 174,000 126,000 39,000 87,000 34,800 52,200 Cash Accounts Receivable Inventory Fixed Assets Total Assets Accounts Payable Accruals Notes Payable Total Current Liabilities Long-term debt Common Stock Retained Earnings Total Liabilities and Stockholders' Equity Sales Cost of Goods Sold Gross Profit Operating Expenses: S, G, & A Depreciation Interest Expense Taxes Total Current Assets Less: Accumulated Depreciation Total Fixed Assets Total Operating Expenses Operating Profit Net income before taxes Net income after taxes (500,000) $ 700,000 $1,000,000 Liabilities and Stockholders' Equity $ 40,000 20,000 50,000 $ 110,000 200,000 200,000 490,000 $1,000,000 Churchill Company, Inc. Income Sheets December 31, 2016 $1,000,000 675,000 325,000 100,000 50,000 150,000 175,000 25,000 150,000 60,000 90,000
Expert Answer:
Answer rating: 100% (QA)
1 Dec 312016 Dec 312017 Indy Ratios Current Ratio Current assetsCurrent Liabilities 300000110000 273 280000290000 097 35 Liquidityie Capacity to meet lesthana year obligations very low compared to ind... View the full answer
Related Book For
Posted Date:
Students also viewed these corporate finance questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
You, CA, have been working for Plener and Partners, Chartered Accountants (P&P), a mid-size CA firm, for three years. You have been assigned a new project for a long-term client of your firm, Oxford...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Raider Company manufactures and sells multiple products. The traditional costing system allocates overhead costs based on direct labor hours, while the company is considering transitioning to an...
-
Why are IT resources described as a commodity? How do IT resources matter in terms of the different roles they play in an organization? Which component of an information system is most critical to...
-
The uniform 24-kg plate is released from rest at the position shown. Determine its initial angular acceleration and the horizontal and vertical reactions at the pin A. A -0.5 m- 0.5 m
-
Use the NBA PER data introduced in Problem 8.21 and consider the model found in part $\mathrm{c}$ of that problem. There are some potential outliers in the data (the first observation is an obvious...
-
Popeye Canning is contracted to receive daily 60,000 lb of ripe tomatoes at 7 cents per pound from which it produces canned tomato juice, tomato sauce, and tomato paste. The canned products are...
-
Provide an introduction to your planned new product/service ( apple watch for elders) and where it will sit within your chosen organization i.e apple inc. Incorporate the possible value proposition....
-
Harriet's Hats is a retailer who buys hats from a manufacturer and then sells them in its stores. The following information includes the company's December 31, 20Y8 Balance Sheet and the details of...
-
An object of mass m travels along the parabola y = x^2 with a constant speed of 10 units/sec. What is the force on the object due to its acceleration at (0,0)? at (2 1/2,2)? Write answer in terms of...
-
What annual growth rate is needed for a country to double its output in 7 years? In 35 years? In 70 years? In 140 years?
-
For a balanced- \(\Delta\) load supplied by a balanced positive-sequence source, the line currents into the load are \(\sqrt{3}\) times the \(\Delta\)-load currents and lag by \(30^{\circ}\). (a)...
-
What is a partition? How does a partition relate to a collaboration?
-
How long would it take for the price level to double if inflation persisted at (a) 2 percent per year, (b) 5 percent per year, and (c) 10 percent per year?
-
In a balanced three-phase Y-connected system with a positive-sequence source, the line-to-line voltages are \(\sqrt{3}\) times the line-to-neutral voltages and lend by \(30^{\circ}\). (a) True (b)...
-
4. Draw the box diagram and PAD diagram of the following pseudocode program. g n While p do if q then al a2 else End do while r do end if bl b2 end do
-
The power company must generate 100 kW in order to supply an industrial load with 94 kW through a transmission line with 0.09 resistance. If the load power factor is 0.83 lagging, find the...
-
What are the needs of the users of a not-for-profit organization's financial statement versus those of a profit oriented company?
-
What is the effect of an investment increasing from 20% to 40% where there was significant influence upon the purchase of 20%?
-
Investco Ltd. is a Canadian real estate and property developer that decided to hold a parcel of land in downtown Munich, Germany, for speculative purposes. The land, costing 12 million, was financed...
-
A blender does 5000 J of work on the food in its bowl. During the time the blender runs, 2000 J of heat is transferred from the warm food to the cooler environment. What is the change in the thermal...
-
Which system contains more atoms: 5 mol of helium (A = 4) or 1 mol of neon (A = 20)? A. Helium B. Neon C. They have the same number of atoms.
-
A sample of ideal gas is in a sealed container. The temperature of the gas and the volume of the container are both increased. What other properties of the gas necessarily change? (More than one...
Study smarter with the SolutionInn App