Conestoga Consulting Inc. Conestoga Consulting Inc. is examining their 2023 year-end financial statements and industry data....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Conestoga Consulting Inc. Conestoga Consulting Inc. is examining their 2023 year-end financial statements and industry data. CONESTOGA CONSULTING INC. Balance Sheet December 31, 2023 Assets Liabilities & Shareholders' Equity Cash $ 50,000 Accounts payable $2,200,000 Marketable securities 80,000 Accrued expenses 150,000 Accounts receivable 3,000,000 Notes payable (current) 400,000 Inventory 1,000,000 Bonds (10%) 2,500,000 Property, Plant, & Equipment, net 4,000,000 Common shares (1.7 mill shares) 1,700,000 Retained Earnings 1,180,000 Total assets 8,130,000 Total Liabilities and Equity 8,130,000 CONESTOGA CONSULTING INC. Industry data Income Statement Profit margin 5.75% December 31, 2023 Return on assets 6.90% Sales (all on credit) $ 7,000,000 Return on equity 9.20% Variable costs (0.60) 4,200,000 Receivables turnover 4.35x Contribution margin 2,800,000 Capital asset turnover 1.85x Fixed costs* 2,100,000 Total asset turnover 1.20x Operating profit 700,000 Current ratio 1.45x Less: interest 250,000 Quick ratio 1.10x Earnings before tax 450,000 Debt-to-total assets 25.05% Less: Taxes @ 34% 153,000 Interest coverage 5.35x Earnings after tax 297,000 Deduct: Dividends Increased retained earnings *Fixed costs include: 1. Lease expense of $200,000 2. Amortization of $500,000 118,800 178,200 Requirements 1. Analyze Conestoga Consulting Inc. using ratio analysis and compare it to the industry data provided in the question. Discuss weaknesses, strengths, and what you think can be done to improve performance. 2. Compute the break-even in sales dollars, cash break-even, DOL, DFL, and DCL. 3. Using your response to part 1 and part 2, comment on the risk associated with this company. 4. Conestoga Consulting is currently trying to determine the funds needed for 2024, and it is expected that sales will increase by 20% next year (sales increases can be accommodated with existing capital assets). Compute the Required New Funds (RNF) based on the current balance sheet (Notes payable and bonds are not a part of the liability calculation). 5. Do you think they are credit worthy for a bank loan? Why or why not? 6. How would the RNF change for each of the following two independent situations (no need for any calculations) a. Raised the dividend payout ratio. b. Sales declined. Conestoga Consulting Inc. Conestoga Consulting Inc. is examining their 2023 year-end financial statements and industry data. CONESTOGA CONSULTING INC. Balance Sheet December 31, 2023 Assets Liabilities & Shareholders' Equity Cash $ 50,000 Accounts payable $2,200,000 Marketable securities 80,000 Accrued expenses 150,000 Accounts receivable 3,000,000 Notes payable (current) 400,000 Inventory 1,000,000 Bonds (10%) 2,500,000 Property, Plant, & Equipment, net 4,000,000 Common shares (1.7 mill shares) 1,700,000 Retained Earnings 1,180,000 Total assets 8,130,000 Total Liabilities and Equity 8,130,000 CONESTOGA CONSULTING INC. Industry data Income Statement Profit margin 5.75% December 31, 2023 Return on assets 6.90% Sales (all on credit) $ 7,000,000 Return on equity 9.20% Variable costs (0.60) 4,200,000 Receivables turnover 4.35x Contribution margin 2,800,000 Capital asset turnover 1.85x Fixed costs* 2,100,000 Total asset turnover 1.20x Operating profit 700,000 Current ratio 1.45x Less: interest 250,000 Quick ratio 1.10x Earnings before tax 450,000 Debt-to-total assets 25.05% Less: Taxes @ 34% 153,000 Interest coverage 5.35x Earnings after tax 297,000 Deduct: Dividends Increased retained earnings *Fixed costs include: 1. Lease expense of $200,000 2. Amortization of $500,000 118,800 178,200 Requirements 1. Analyze Conestoga Consulting Inc. using ratio analysis and compare it to the industry data provided in the question. Discuss weaknesses, strengths, and what you think can be done to improve performance. 2. Compute the break-even in sales dollars, cash break-even, DOL, DFL, and DCL. 3. Using your response to part 1 and part 2, comment on the risk associated with this company. 4. Conestoga Consulting is currently trying to determine the funds needed for 2024, and it is expected that sales will increase by 20% next year (sales increases can be accommodated with existing capital assets). Compute the Required New Funds (RNF) based on the current balance sheet (Notes payable and bonds are not a part of the liability calculation). 5. Do you think they are credit worthy for a bank loan? Why or why not? 6. How would the RNF change for each of the following two independent situations (no need for any calculations) a. Raised the dividend payout ratio. b. Sales declined.
Expert Answer:
Related Book For
Accounting
ISBN: 978-0132690089
9th Canadian Edition volume 2
Authors: Charles T. Horngren, Walter T. Harrison Jr., Jo Ann L. Johnston, Carol A. Meissner, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
I need help on this read from bottom to top. Image transcription text 7"} The second ?nancial statement to prepare is the statement of retained earnings. To determine the ending balance of...
-
You are given the following information concerning four stocks: a) Using 20X0 as the base year, construct three aggregate measures of the market that simulate the Dow Jones Industrial Average, the...
-
Sue died on May 3, 2013. On October 1, 2010, Sue gave Tom land valued at $2,013,000. Sue applied a unified credit of $330,800 against the gift tax due on this transfer. On Sue's date of death the...
-
Prairie Riggings three employees are paid weekly. Waverley works in the office and Johnson and Zender are sales representatives. Complete the payroll register above for the week ended March 9, 2015....
-
True or False. The jump phenomenon is exhibited by both linear and nonlinear systems.
-
Jackson Ski Haus had the following statements prepared as of December 31, 2014. Additional information: 1. Dividends in the amount of $20,000 were declared and paid during 2014. 2. Depreciation...
-
Consider the risk-neutral Ho-Lee model for continuously compounded rates with a step size of A = 1 year: T+1 = + + 0 + 0 +1 where, under the risk-neutral measure, the shock +1, which is realized at...
-
I need three case analysis which follows the below-mentioned criteria. 1. Analysis of a Project Failure Objective : To critically analyze a well-known project that failed or faced significant...
-
The first graph shows the years a person was employed before working at the company and the salary at the company. The second graph shows the years employed at the company and the salary. Which graph...
-
Figure 1.13 presents the occupational outlook (median salary and number of job openings) for selected information systems positions. Obtain data from the U.S. Bureau of Labor Statistics and use a...
-
Write down the logic function implemented by the CMOS circuit of Figure 4.28(b). Data in Figure 4.28(b). T PFETS [ (b) X
-
The scatterplot shows the acceptance rate and selectivity index for a sample of medical schools. The acceptance rate is the percentage of applicants who were accepted into the medical school. The...
-
Skechers U.S.A., Inc., is a performance footwear company headquartered in Manhattan Beach, California. The sales revenue for Skechers over a four-year period are as follows: a. Are these...
-
Several themes were introduced in this first chapter, including the importance of entrepreneurship to the success of the overall economy, the need for entrepreneurs to take risks (and the greater the...
-
The relationship described in question 7 does not always appear to hold. What factors, besides the number of firms in the market, might affect margins?
-
Describe how the cash flow statement helps investors and creditors perform each of the following functions: 1. Predict future cash flows. 2. Evaluate management decisions. 3. Predict the ability to...
-
Refer to Exercise 13-13. Compute the book value per share of the preferred shares and the common shares, assuming that four years of preferred dividends (including dividends for the current year) are...
-
On March 1, 2014, Shaw Systems Ltd. issues 8.5-percent, 20-year bonds payable with a maturity value of $5,000,000. The bonds pay interest on February 28 and August 31. Shaw Systems Ltd. amortizes...
-
A system has the differential equations \(\left[\begin{array}{lll}5 & 0 & 0 \\ 0 & 3 & 0 \\ 0 & 0 & 2\end{array} ight]\left[\begin{array}{c}\ddot{x}_{1} \\ \ddot{x}_{2} \\ \ddot{x}_{3}\end{array}...
-
Lagranges equations are used to derive the differential equations for a three degree-of-freedom system resulting in \(\left[\begin{array}{lll}m_{11} & m_{12} & m_{13} \\ m_{21} & m_{22} & m_{23} \\...
-
The following data relate to the manufacturing activities of MilTech company during November: 1. Sales $400,000 2. Purchases $60,700 3. Expenses include: Light and power for manufacturing: $2,700 ...
Study smarter with the SolutionInn App