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...
-
1. Calculate the net profit margin for each year. 2. Calculate the average annual growth rates for revenue and net income using the GEOMEAN function. 3. Calculate the average annual growth rate of...
-
The following notes were received by Davis Company during 2016: Compute the maturity value of each note. Analyze: What is the total interest expense on these notes for the year? Period 3 months 90...
-
Traditionally, accountants have been most involved with which portion of the HRM/payroll cycle? a. hiring b. payroll c. training d. performance evaluation
-
1. Determine the benefit-cost ratio (defined as the ratio of discounted benefits to costs) for the proposed fairgrounds development. 2. Based on this analysis, should the redevelopment program be...
-
Scenario: You are the Purchasing Manager at an insulated beverage flask producing company. Your Company just completed your 25-years anniversary and are in the top 3 recognized Insulated flask...
-
1. Why might a structured organizational assessment framework be a useful tool in identifying the issues in a situation like the one presented in the Whispering Pines case? (LO 1 and LO 5) 2. What...
-
Jones plc, a UK-based smart phone manufacturer, is considering adding a new model of smart phones to its current production line. The success of the new model depends on general market conditions....
-
Calculate the put premium according to put - call parity which gives no arbitrage opportunity. Explain what transaction would you do if the put premium is below / above the put premium you...
-
The Roman emperor Claudius probably died from a buildup of toxins in his body as a result of liver failure. Historians believe his liver failed because he ate poisonous mushrooms that his wife gave...
-
Multiply. 3ay 8y 15a 2ys
-
Company MAUMBA, an international exporter, faces currency exchange rate risk due to fluctuations in the foreign exchange market. They have a significant portion of their revenue denominated in a...
-
Planning strategically is an essential process for any organization because it supplies a framework for goal setting, creating an action plan to achieve those goals, and measuring success in...
-
8. Using the standard normal distribution, find each probability. a. P( Z less than 1.16) b. P( Z greater than -1.71) c. PZ less than or equal to 0)
-
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...
-
Which of the following techniques involves the creation and use of a pair of public and private keys? a. hashing c. symmetric encryption b. asymmetric encryption d. key escrow
-
Which of the following is a preventive control? a. penetration testing c. training b. patch management d. log analysis
-
The approach to perimeter defense that involves examining only information in the packet header of each individual IP packet is referred to as a. deep packet inspection c. stateful packet filtering...
Study smarter with the SolutionInn App