Question

In: Finance

Please consider the following data from 2017-2019 of a firm in the fashion industry who is...

Please consider the following data from 2017-2019 of a firm in the fashion industry who is expanding its business by increasing the number of products (from T-shirts only the company is expanding its product portfolio into jumpers, trousers, skirts, now launching also swimwear and sportswear) General rules You may have access to your notes, slides, and internet (to access library or other search engines) Please read carefully the following instructions and be sure to address carefully each point 2 | Page 2017 2018 2019

2017 ; 2018; 2019 Sales 7786.0; 9411.5; 10383.0 Equity 2228.5 ; 2284.1 ; 2490.9 lt debt 2.7; 550.9; 550.3 Total assets 4428.9; 5343.9; 5672.6 Operaing income 894.0 ;1053.9; 503.9 Current liabilities 1936.0 ;2156.0; 2190.0 Current assets 1530.0 ;1697.0 ;1748.0

Based on these data, please compute the main financial KPIs (ROI, ROS, ROE, ROA) and construct their trend over these three years.

− How is the company performing?

− What do these KPIs suggest?

− What is your take on this evidence if you also include the analysis of the Capital Turnover and check it compared with the trends of the sales?

Solutions

Expert Solution

Firstly we calculate all the main Key Performance Indicators for the business

The company seems to perform moderately inwell 2018 after slight decrease in KPIs from earlier yr.

But in 2019 the performance has heavily downgraded will fall majority of the KPIs.

The Return of Assets has deteriorated denoting the company is unable to effectively utilize its Assets to generate sufficient profit compared to earlier years.

However the sales of the company has continuously improved over the years which is evident that the company must be expanding its products portfolio with introduction of new line of products.

A company's working capital turnover ratio can be-ve when a company's current liabilities exceed its current assets.

A high turnover ratio shows that management is being very efficient in using a company’s short-term assets and liabilities for supporting sales

So it is evident from the analysis that capital turnover is consistent with growth in sales YoY.


Related Solutions

Please calculate the ratios for 2017 from the following information: 2017 2016 2015 Industry Standard Quick...
Please calculate the ratios for 2017 from the following information: 2017 2016 2015 Industry Standard Quick Ratio 2.2 2.8 1.75 Gross Margin 0.55 0.7 0.7 Net Margin 0.22 0.32 0.24 Return on Equity 0.9 0.78 0.8 Peyton Approved Balance Sheet As of December 31, 2017 Assets Liabilities and Owners' Equity Current Assets: Current Liabilities: Cash 64,713.72 Accounts Payable 27,325.00 Baking Supplies 27,850.00 Wages Payable 1,468.75 Merchandise Inventory (FIFO) 25,750.00 Interest Payable 22,800.00 Prepaid Rent 7,500.00 Total Current Liabilities 51,593.75 Prepaid...
From the following data of a firm:
From the following data of a firm:OutputTotal CostPrice040910708201007301406401805502004i) You are required to calculate at each level of outputThe firm’s total revenue                                           The firm’s marginal revenue and average revenue               The firm’s fixed costs                                                                      The firm’s marginal cost                                                                   The firm’s average cost        The firm’s profit levels         State the type of market the firm is operating in?   At what level of output will the firm aim to produce, state the reasonExplain the relationship between average revenue and price.State the four (4) market structure                                                                                                                                         
Consider the following market game: An incumbent firm, called firm 3, is already in an industry....
Consider the following market game: An incumbent firm, called firm 3, is already in an industry. Two potential entrants, called firms 1 and 2, can each enter the industry by paying the entry cost of 2. First, firm 1 decides whether to enter or not. Then, after observing firm 1's choice, firm 2 decides whether to enter or not. Every firm, including firm 3, observes the choices of firms 1 and 2. After this, all of the firms in the...
Consider the following data from a factorial-design experiment. The DV was “% of participants who offered...
Consider the following data from a factorial-design experiment. The DV was “% of participants who offered help to a stranger in distress.” 1.What is the design of this study (e.g., 2 × 2, 2 × 3, etc.)? 2.List the independent variables of this study, and list the levels of each. 3.Sketch a graph of the results of the study. Fill in the names and levels of the IVs. 4.Main effects -On the average, how does the number of bystanders affect...
Consider the following cost curve for a firm in a competitive industry where the market price...
Consider the following cost curve for a firm in a competitive industry where the market price equals $120 C=1/3q^2+20q+500 What is the​ firm's marginal cost​ (MC)? MC​ = At what level of output does the firm maximize profits​ (minimize losses)? Profit is maximized at: units of output.  ​(Round your answer to two decimal​ places.) What is the​ firm's profit maximizing​ price? What is the​ firm's profit?   In the​ short-run, this firm should produce/shutdown? .
Consider a competitive industry and a price-taking firm that produces in that industry. The market demand...
Consider a competitive industry and a price-taking firm that produces in that industry. The market demand and supply functions are estimated to be: Demand: Qd= 10,000 - 10,000P + 1.0M Supply: Qs= 80,000 + 10,000P - 4,000P1 where Q is quantity, P is the price of the product, M is income, and P1 is the input price. The manager of the perfectly competitive firm uses time-series data to obtain the following forecasted values of M and P1 for 2015: M̂...
Consider the following statement: "A firm competing in an embryonic industry cannot afford to lose its...
Consider the following statement: "A firm competing in an embryonic industry cannot afford to lose its few customers, and so it should do everything it can to satisfy the needs of innovators." Do you agree or disagree, and why?
Consider the following information: On December 1, 2019, a U.S. firm plans to purchase a piece...
Consider the following information: On December 1, 2019, a U.S. firm plans to purchase a piece of equipment (with an asking price of 100,000 francs) in Switzerland during January of 2020. The transaction is probable, and the transaction is to be denominated in euros. On December 1, 2019, the company enters into a forward contract to buy 100,000 Swiss francs for $1.01 on January 31, 2020. Spot rates and the forward rates for January 31, 2020, settlement were as follows...
The following is extracted from the income statement and balance sheet of a firm for 2017....
The following is extracted from the income statement and balance sheet of a firm for 2017. (Amounts in $ thousands) Operating income (after tax) 17,507 Net financial expenses 3,060 Comprehensive income 14,447 The firm paid out all income in dividends at the end of the year and there were no share issues during 2017. The book value of common equity at the end of 2017 was $100,600. The cost of equity capital is 11%. (a) Calculate residual income for 2017....
Consider an industry comprised of a dominant firm with a competitive fringe. Each firm produces a...
Consider an industry comprised of a dominant firm with a competitive fringe. Each firm produces a homogenous good. Market demand is given by Q=a-bp. The dominant firm has a constant marginal cost c. There are three competitive fringe firms; each competitive fringe firm i faces a marginal cost of c+qi, where is qi is the output of firm i. a.) What is the dominant firm’s residual demand curve? b.) What is the output and profit level of each firm? c.)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT