Data for Campsey Computer Company and its industry averages follow. a. Calculate the indicated ratios for Campsey.
Question:
Data for Campsey Computer Company and its industry averages follow.
a. Calculate the indicated ratios for Campsey.
b. Construct the DuPont equation for both Campsey and the industry.
c. Outline Campsey’s strengths and weaknesses as revealed by your analysis.
d. Suppose Campsey had doubled its sales as well as its inventories, accounts receivable, and common equity during 2015. How would that information affect the validity of your ratio analysis?
Campsey Computer Company: Balance Sheet as of December 31, 2015 Cash Receivables Inventories Total current assets Net fixed assets $77,500 Accounts payable 336,000 241,500 Other current liabilities 655,000 Total current liabilities 292,500 Long-term debt $129,000 84,000 117,000 S330,000 256,500 361,000 947,500 Tta iabilities and eqty $947,500 Notes payable Common equity Total assets Campsey Computer Company. Income Statement for Year Ended December 31, 2015 Sales Cost of goods sold 1,607,500 1,353,000) Gross profit $254,500 143,000) $111,500 Fixed operating expenses except depreciation Earnings before interest, taxes, depreciation and amortization (EBITDA) Earnings before interest and taxes (EBIT) Earnings before taxes (EBT) 41,500) $ 70,000 24,500) S 45,500 18,200 S 27,300 Depreciation Interest Taxes (40%) Net income Industry Average 2.0x Ratio Campsey Current ratio Days sales outstanding Inventory turnover Total assets turnover Net profit margin Return on assets (ROA) Return on equity (ROE) Debt ratio 35.0 days 5.6x 3.0x 1.2% 9.0% 60.6%
Step by Step Answer:
a b For Campsey ROA PM x TA turnover 17 x 17 29 For the industry ROA 12 x 30 36 c Campseys days sale...View the full answer
Related Video
The Dupont analysis is an expanded return on equity formula, calculated by multiplying the net profit margin by the asset turnover by the equity multiplier. The DuPont analysis is also known as the DuPont identity or DuPont model.This Video will guide on how to calculate return on Equity and estimate profitability of shareholders using DuPont Analysis.
Students also viewed these Corporate Finance questions
-
Data for Barry Computer Company and its industry averages follow. a. Calculate the indicated ratios for Barry. b. Construct the extended Du Pont equation for both Barry and the industry. c. Outline...
-
Data for Lozano Chip Company and its industry averages follow. a. Calculate the indicated ratios for Lozano. b. Construct the extended DuPont equation for both Lozano and the industry. c. Outline...
-
Data for Barry Computer Co. and its industry averages follow. Select the correct option based on Barry's strengths and weaknesses as revealed by your analysis. A. The firm's days sales outstanding is...
-
Steve is a member of a local church. May he deduct as a charitable contribution the commuting expenses for the Sundays that he is assigned to usher?
-
What is the purpose of developing a site log sheet for each session?
-
The clamp is used in a jig. If the vertical force acting in the bolt is F = {-500k} N, determine the magnitudes of the components F1 and F2 which acts along the OA axis and perpendicular toit. 40 mm...
-
If \(\mathbf{Z}\) is the \(n \times k\) matrix of standardized regressors and \(\mathbf{T}\) is the \(k \times k\) upper triangular matrix in Eq. (11.3), show that the transformed regressors...
-
Yeaman expects total sales of $333,000 in January and $407,000 in February. Assume that Yeamans sales are collected as follows: 60% in the month of the sale 30% in the month after the sale 8% two...
-
A manufacturing company reports the following for the period: Inventories Beginning Ending Raw materials $ 1 8 , 1 2 0 $ 1 2 , 1 0 0 Work in process 9 , 5 0 0 1 1 , 3 0 0 Finished goods 1 2 , 5 6 0...
-
A retail catalogue operation employs a bank of six telephone operators who process orders using computer terminals. When a terminal breaks down, it must be disconnected and taken to a nearby...
-
Data for Argile Textiles 2014 financial statements are given in Tables. a. Compute the 2014 values of the following ratios: b. Briefly comment on Argiles 2014 financial position. Can you see any...
-
Complete the balance sheet and sales information in the table that follows for Isberg Industries using the following financial data: Debt ratio: 50% Quick ratio: 0.80 Total assets turnover: 1.5 Days...
-
In 2020, Fred invested $50,000 in a general partnership. Freds interest is not considered to be a passive activity. If his share of the partnership losses is $35,000 in 2020 and $25,000 in 2021, how...
-
How do transformational leaders strategize to cultivate a culture of innovation and adaptability within their organizations?
-
what are negatives of organizations that do not pay attention to the uncontrollable environments that affect the global supply chains?
-
A useful device in thinking about any implementation programme is the change curve which represents a journey on which employees need to be taken if a change is to lead to actions and be successful....
-
Review the Case of Maria . come up with at least 2 SMART goals for Maria's treatment plan. Use Ch. 8 of the text to create goals that are specific, measurable, achievable, realistic, and time-phased....
-
I believe that ethics has to be a top-down approach: meaning the CEO, leaders and managers of the company must promote and establish an ethical work culture that trickles down to every employee. Do...
-
Isaac Murillo, the accounting manager at Precision Excavation was a hunter and gun collector. He and Kevin Carstens, an accountant who had worked for Precision for 5 months liked to talk about guns...
-
What mass of KBr (in grams) should you use to make 350.0 mL of a 1.30 M KBr solution?
-
With interest at 9 percent compounded annually, what is the fewest number of years (integer-valued) required for money to double in magnitude?
-
Fantastic Foods has total assets of $150,000, current assets of $80,000 (current assets includes $30,000 of cash, $10,000 of short term investments, $20,000 of accounts receivable, and $20,000 of...
-
Outside of the four key areas of limitations, Jim also explores a number of key elements that ratios arent able to convey. What characteristics of a firm would you most want to know about if you were...
-
What is a common economic influence that has the potential to skew financial analysis figures? a. Past performance b. Inflation c. Generally Accepted Accounting Principles d. Benchmark data
-
How do the local electronic and printing advertisements apply in the real ground? What are the most accepted brand names? What are the good qualities and demerits of the brand?
-
Gary and Linda assume they will need $70,000 at the beginning of each year in today's dollars when they retire in 6 years. The couple is assuming an annual inflation rate of 4% and a 7.5% after-tax...
-
What motivates you to succeed in your work or personal endeavors?Can you provide an example from your past experiences where you successfully turned a setback into a motivation to achieve a goal?
Study smarter with the SolutionInn App