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...
-
Suppose that you used the sample size calculated in Exercise 12.89 and found p = .92. a. Estimate the population proportion with 90% confidence. b. Is this the result you expected? Explain. c. If you...
-
For a paired-samples t test, how is a Cohens d of 0.5 interpreted, according to Cohens conventions?
-
As of 2023, 20 countries in Europe had adopted the euro as their common currency. These countries are called the euro zone. According to an article on bloomberg.com, in 2023, the euro-area economy...
-
According to figures released by the New York City government, smoking among New York City teenagers is on a decline, continuing a trend that began more than a decade ago ( The New York Times ,...
-
(a) X Ltd. is studying the possible acquisition of Y Ltd. by way of merger. The following data are available in respect of both the companies. Particulars Market Capitalization (Rs.) Gross Profit...
-
Prepare a Consolidated Balance Sheet for Big Lake Bakeries which owns 100% of Marble Falls Orchards. The fair value of Marble Falls net fixed assets are $2,675,000. Big Lake aquired 100% of Marble...
-
Write short note on 3-2-1 principle of location.
-
What is the role of the Bank of Canada in macroprudential policy and how does inflation targeting contribute to financial stability?
-
Biofuels (mainly ethanol) make up 10 percent of auto fuel in the United States and 5 percent in Canada, and the mandated shares have risen. Farmers are smiling because taxpayers subsidize the fuel....
-
Explain the dilemma that low inflation and low unemployment poses for the Bank of Canada. In September 2015, the unemployment rate was 7.0 percent, the inflation rate was 0.1 percent, and the...
-
The UK economy grew by 0.3 percent in the second quarter of 2017 after 0.2 percent growth in the first quarter. These slow growth rates are seen as confirming the predicted effects of the country...
-
Ann receives an unsolicited credit card in the mail and tosses it on her desk. Without Anns permission, her roommate uses the card to spend $1,000 on new clothes. Ann is liable for a. $1,000. b....
-
Richard Earls, in his article titled "Gravity," published in Travel Research Online (April 24, 2016), writes: "...We all have a brand. You don't have to own the travel company you work for to have a...
-
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...
-
Refer to requirement 2 of Exercise4.11. Required Prepare summary journal entries for the use of direct materials and conversion costs. Also prepare a journal entry to transfer out the cost of goods...
-
Europe Electronics SNC manufactures microchips in large quantities. Each microchip undergoes assembly and testing. The total assembly costs during January 2022 were: Required 1 Assume there was no...
-
Describe the distinctive characteristic of weighted-average computations in assigning costs to units completed and closing work in progress.
Study smarter with the SolutionInn App