Need math help - for stock company

Section I – Executive Summary

Etsy, Inc. is an American e-commerce firm that specializes in the sale of creative materials and things that are handmade or antique. These products may be classified as belonging to a broad variety of categories, such as jewelry, handbags, apparel, home furnishings and decorations, art, toys, and even craft materials and equipment. There is a minimum age requirement of twenty years for something to be considered vintage. The website maintains the custom of open-air craft fairs by providing vendors with individual storefronts in which they may advertise their wares for a commission of $0.20 per item. Etsy has over 120 million products listed in its marketplace as of the 31st of December, 2021. The online marketplace for handmade and antique goods united 7.5 million merchants with 96.3 million shoppers. Etsy had 2,402 people working for them at the end of the year 2021. Gross Merchandise Sales (GMS) on Etsy amounted to $13.5 billion in 2021, representing the company's overall sales on the platform.

On the heels of 2021 revenue of $2.3 billion, Etsy announced a net profitability of $493.5 million. The three most important revenue streams for the platform are: Each successful sale on Etsy incurs a 6.5% charge, in addition to a listing cost of 20 cents per item. Revenue from Etsy's Seller Services, which includes charges for things like "Promoted Listings," payment processing, and shipping label sales, is expanding at a rapid clip. Etsy also makes money from transaction fees charged by other payment processors. Etsy's Marketplace revenue includes fees received from Etsy is a significant player in the e-commerce marketplaces of the United States, the United Kingdom, Germany, France, Australia, and Canada. It is ranked in the top 10 e-commerce marketplace operators in each of these countries. The company has a strong position in an intriguing market segment by mediating transactions between buyers and sellers of antique and handmade products via its online market. Listing fees, commissions on items that are sold, advertising services, payment processing, and shipping label sales all contribute to the company's revenue, (MOSBY, 2022). As a result, the company has established itself as one of the largest players in a sector that is experiencing rapid expansion. The consolidated gross merchandise volume for the company in 2021 is expected to be $13.5 billion.

By the end of the year 2021, the company has successfully linked more than 96 million customers and more than 7.5 million merchants on its many marketplace sites. Etsy, Inc. runs two-sided online marketplaces that link buyers and sellers mainly in the United States of America, the United Kingdom of Great Britain and Northern Ireland, Germany, Canada, Australia, France, and India. Etsy.com, which links independent craftspeople and business owners with a wide variety of end users, serves as the company's core marketplace. In addition, the firm operates the marketplaces Reverb (for musical instruments), Depop (for secondhand clothing), and Elo7 (for handcrafted and one-of-a-kind things located in Brazil), all of which are available to customers.

Etsy Payments is a service for accepting payments, Etsy Ads is a platform for advertising, and Etsy Shipping Labels is a service for facilitating the purchase of cheap shipping labels for sellers in the United States, Canada, the United Kingdom, Australia, and India. Etsy also provides a number of seller services, such as Etsy Shipping Labels, Etsy Payments, and Etsy Ads. In addition, Etsy provides a number of tools for its sellers, such as the Shop Manager Dashboard, which serves as a central hub from which sellers can monitor customer communications, manage inventory, view metrics and statistics, and track order statuses. The Sell on Etsy app also facilitates enhanced onboarding and video uploading. You'll find both of these resources on the organization's website. The company also offers bookkeeping and accounting services. Targeted offers, which is a sales and promotions tool as well as a social media tool; Etsy seller analytics pages, which provide information regarding the acquisition of traffic for the sellers' shops; Etsy seller analytics pages; and so on. In addition, the firm offers instructional tools such as blog entries, video lessons, the Etsy Seller Handbook, Etsy.com online forums, and insights; Etsy Teams, a platform that allows Etsy sellers to create personal connections with one another; and a Star Seller program. It united a total of 96.3 million active customers with 7.5 million active vendors as of the 31st of December, 2021, and it has 120 million things available for purchase. Etsy, Inc. was once known as Indieco, Inc., but in June 2006, the firm officially changed its name to Etsy, Inc. Etsy, Inc. was established in 2005 and now has its headquarters in the borough of Brooklyn in the state of New York.

Efficiency in the capital market may be defined as the ability of the securities to take in the circumstances of the market, reflect how those conditions are affecting it, and instantly assimilate all of the information that is pertinent to the situation. It implies that the price of shares is automatically adjusted to its optimal level in a capital market that is efficient (Lim et al., 2019). This adjustment is dependent on the type and environment of the market. Although it is not difficult to grasp the idea of efficient capital markets, it is necessary for the markets themselves to exhibit certain behaviors and conduct in order to preserve market efficiency. For instance, a capital market that is efficient must offer all of the information on securities to all of the participants in a manner that is free of any prejudice. Because there are hundreds upon thousands of shares trading at any one time on the market, this is something that is easier said than done. The efficiency of the capital market comes with its own set of benefits. For instance, shareholders are able to make financial investments in an effective stock market without the need of casting doubt on the information that is offered by the market. When the effectiveness of the market is reduced, this allows investors to put more money into the market than they would otherwise be able to.

Efficient market hypothesis

 Current stock prices, according to the efficient market hypothesis (EMH), fully represent all relevant information. The efficient market hypothesis (EMH) states that the value of an item should be reflected in its stock price. According to proponents of the Efficient Market Hypothesis (EMH), passive, low-cost portfolios are where investors are most likely to see returns (Kang et al., 2022). The efficient market hypothesis states that the current stock prices correctly reflect all of the available information and are, therefore, fairly valued. With these caveats in mind, it's hard to see someone consistently beating the market via stock selection or market timing. Exceptions to this rule include getting engaged in a significant financial scandal or being born into a rich family.

Forms of capital market efficiency

Eugene Fama developed a paradigm for measuring market efficiency that distinguished between "weak," "semi-strong," and "strong" forms of efficiency. The cost of each variation is established according to the present state of knowledge. Abnormal returns, defined as returns greater than would be anticipated given the degree of risk, would be earned by investors who trade based on information that is publicly available but is not yet reflected in market pricing.

According to the idea of the weak-form efficient market, all of the past values of securities have already been included into the present market prices of those assets (Hailu & Vural 2020). Therefore, traders who make decisions based on analyses of historical data are known as technicians, and they should not experience excessive gains. Studies show that this is more prevalent in mature markets, but some evidence suggests that it is still possible to benefit from technical analysis in economies that are still developing.

Semi-strong Form

Prices in a market that is semi-strong form efficient represent all of the information that is publicly known and accessible, including all of the information on past prices (Nan & Kaizoji 2019). According to this hypothesis, doing an analysis of any public financial disclosures made by a firm in order to ascertain the intrinsic value of a stock would be a waste of time since the market price of the stock would already take into account all relevant information. In a similar vein, an investor would not be able to make abnormally consistent profits by trading based on unexpected disclosures since the market would respond very fast to the new information.

Strong Form

In a market that exhibits strong-form efficiency, the values of securities completely reflect both public and private information. Since the information in question would already be included in market pricing, it would be impossible for market insiders to create abnormal profits by trading on the knowledge (Bustanji, 2020). Researchers have come to the conclusion that markets are not strong-form efficient in general because anomalous gains may be gained when using the knowledge that is not publicly available.

The EMH argues that investors shouldn't be able to beat the market since all relevant information for making future performance predictions is already included into stock prices. "(Bhattacharya 2022). Stock prices are generally assumed to follow a random walk, with the belief that the direction of stock prices being impacted more by current events than by changes in stock prices in the past. The capital markets link savers with companies in need of funding for their projects. Informational efficiency is crucial if capital market allocations are to be used to support the highest-value initiatives. In order to ensure that their managements carry out only initiatives (decisions) that increase the value of their shares, shareholders want management to maximize stock prices. That's because stockholders want management to do everything possible to boost the stock price. Management's incentives may be better aligned with those of the shareholders by offering incentive compensation tied to the stock's performance.

The capital market will allocate resources to the projects that will provide the highest return on investment only if stock prices are properly valued, which implies that they appropriately represent the underlying worth of all future cash flows. As a result, if the financial markets are functioning normally, there is no reason to believe that management would put short-term goals ahead of long-term ones (Nguyen, 2018). This is the case, for example, when the financial markets function optimally. As a result of the markets determining the prices at which current and prospective security holders are ready to swap claims on a company's future cash flows, effective capital markets make it easier for corporations to obtain money. When this happens, it becomes less difficult for businesses to get funding.

Concern for efficiency is warranted in part because even investors who lack the means to do in-depth research will be more at ease putting their money to work in the market if they are certain that the assets they trade are priced fairly. This is a related reason for caring about efficiency. This, in turn, makes it easier for the capital market to carry out its duty, which is to convert savings into projects that are productive. In conclusion, there are repercussions for public policy that can be drawn from data on market efficiency. If financial markets function well, then the participation of the government in such markets should be kept to an absolute minimum. If, on the other hand, the prices of securities do not adequately represent the fundamentals, then there may be a basis for controlling not only the functioning of the securities markets but also the process of capital allocation itself.

This article takes a notion from transaction cost economics called "imperative credible commitments" and applies it to the situation of Etsy.com, a website that was designed to bring together craftsmen and fans of handmade goods. Learning why and how a social company fails is the article's primary focus. Etsy was always doomed to lose sight of its social mission since it lacked the essential and true promises, which would have protected the company's key stakeholders and ensured the smooth running of the transactions it was founded to facilitate. The notion of credible promises has been proved to be productive in tackling issues of political and economic transformation, but its applicability to the difficulty of figuring out the corporate world has been much underrated. To close this gap, we'll take the example of taking away the discretion of monarchs and CEOs so they can't renege on their promises. Therefore, by expanding on political economy, attention is given to corporate strategies that have been updated or maintained with little consideration from management and economics researchers. This is so because policies based on political economy get more scrutiny.

Researchers in the field of strategy has mostly come to acknowledge the crucial part that narratives play in the creation of organizational identities. Storytelling is a key strategic tool that companies can exploit to motivate their staff, thrill their investors, and captivate the attention of their consumers. The article demonstrates how recent developments in computational linguistics have the potential to open up new avenues for analyzing the stylistic components that contribute to the credibility of a narrative. To be more specific, we utilize a topic model to investigate how the performance of 78,758 craftsmen selling their handcrafted things on the online marketplace Etsy is influenced by the narrative conventionality of the items they are selling. Our results give empirical evidence that good tales present sufficient conventional traits to match with audience expectations, while at the same time preserving enough distinctiveness to peak audience attention.

This article explores concerns leveled against the efficient market hypothesis and the idea that stock prices can be forecast to some extent. The link between predictability and efficiency is analyzed, and the author details the key statistical results and the behavioral foundations for them when appropriate. Contrary to what the author claims, I do not try to provide a comprehensive overview of the so-called regularities and oddities of the stock market. To clarify the main reasons of people who believe that markets are occasionally illogical, this article analyzes the "crash of 1987," the "Internet bubble" at the turn of the century, and numerous other specific irrationalities that are commonly emphasized by opponents of efficiency. The authors conclude that U.S. stock markets are much less predictable and far more efficient than the conclusions of certain recent academic research would have us believe. A large amount of research also suggests that, although stock price abnormalities may happen, they do not provide a trading opportunity for portfolios that would allow investors to make returns that are out of proportion to the degree of risk they are taking.

To begin, I need to define the term "efficiency" in the clearest possible terms. When financial markets are efficient, it is difficult for investors to earn above-average returns without simultaneously taking on substantially greater risks. As a student and a financial professor make their way across campus, they come upon a $100 bill on the ground. This is how the story unfolds: The professor warns the student not to take it, saying that a real $100 bill wouldn't be lying about. During the professor's remark, the student stops to retrieve it. When most financial economists say that markets perform efficiently, they mean something like this. As was most evident during the dot-com boom of the early to mid-2000s, markets may be efficient even if they sometimes make errors in valuation.

One might infer from this that markets can thrive even when a sizable fraction of its participants act irrationally. Markets may be considered efficient even if stock prices exhibit greater volatility than is consistent with fundamental considerations like profitability and dividends. There are many of us in the economics profession who are believers in efficiency because we see markets as fantastically efficient mechanisms for immediately and, for the most part, accurately reflecting new information. This is why we believe that efficiency is paramount. Before everything else, we believe that the financial markets are efficient because they do not allow investors to earn risk-adjusted returns in excess of the average. The efficient market hypothesis has lost much of its logical superiority and widespread support by the turn of the twenty-first century. Numerous statisticians and financial economists have concluded that stock market fluctuations may, at the very least, be predicted with some degree of accuracy.

There is a growing school of economists who believe that investors' emotions and intuition play a significant influence in setting stock prices. As a result of studying stock price trends through time and using certain "fundamental" valuation measurements, these economists have concluded that it is possible to predict future stock prices to some extent. And many of these economists were also arguing for the considerably more debatable idea that investors may get better risk-adjusted returns if they pay attention to these trends since they are observable.

Free cash flow= net operating profit after tax- investment during the year. Free cash flow for 2020 is $671.85M which is the net profit minus the investment in that year. Free cash flow for 2021 is 623.38M which is the net profit minus the investment made in 2021. The difference between the cash flow and the free cash flow is that the cash flow determines the net cash flow both inflow and outflow for the operation, investment and financing of business activities. On the other hand, free cash flow is used to determine the present value of the business. Free cash flow is used by the management when making the decision about the future ventures which will improve the value of shareholders. Free cash flow is important because it show the cash that is available for the company.

Free cash flow to the firm (FCFF) represents the amount of cash flow from operations available for distribution after accounting for depreciation expenses, taxes, working capital, and investments. FCFF is a measurement of a company's profitability after all expenses and reinvestments.

Key Takeaways. Free cash flow (FCF) is the money a company has left over after paying its operating expenses and capital expenditures. The more free cash flow a company has, the more it can allocate to dividends, paying down debt, and growth opportunities.

Cash conversion cycle is the number of days that a firm takes to convert the money invested in inventory to cash i.e. the time taken from manufacture of good to final realization of cash from accounts receivable.

Cash conversion cycle= Days of Sales Outstanding + Days of Inventory Outstanding - Days of Payables Outstanding

Days Sales outstanding is the credit period allowed to customer who buy on credit.

Days Sales Outstanding= ( Average Accounts Receivable/ Net Credit Sales)×365

Days of Inventory outstanding= It is the average period that the company holds stock of inventory before it is sold off.

Days of Inventory Outstanding= (Average Inventory/ Cost of Sales or Sales)×365

Days of Payables outstanding is the credit period allowed by suppliers to the firm to pay off the credit purchases.

Days of Payable Outstanding= (Average Payables/ Net Credit Purchases)×365

A company can reduce its cash conversion cycle by reducing the days of inventory outstanding. It can achieve this by accelerating sales and increasing sales promotion steps.

Cash conversion cycle can also be reduced by bringing down the credit period allowed to debtors by offering rebates and discounts for quick payments.

The other way to reduce the cash conversion cycle is increasing the payment period for payments made to suppliers. This can be done through better negotiation terms with the supplier and have a sound credit repayment history

Financial analysis or an organization documentation it vital to the success of any company to ensure the firm is running at its top financial ability and to be able to understand any problems that may occur regarding the finances.

We used measurement of company "s liquidity ratio of company total cash and equipment to its current labilities we use current liability to pay [salary] how to cash available in company that is to understand. That means the cash ratio helps the company to understand how the company will invest more from the remaining cash by paying off its debts.

Current ratio measures the ability of a company to cover its short term liabilities with its current assets formula as - current ratio/ current liability = 2:1 this is standard ratio it is computed to assess the short term financial position of the enterprise and current ratio is an indicator of the enterprises ability to meet its short term financial obligation .Ideal ratio -2:1 current asset should be twice the current liability current asset means cash and cash equivalents ,pre-paid expenses

Inventory means is the raw materials and production of a company this inventory helps you understand how much raw material you have in your company and how much is ready for sale so you understand the situation of the company and so you can calculate the total turnover

It is a relationship between the cost of goods sold examples are cost of revenue from operation and the average amount of inventory carried during that period

The quick ratio is a measure of how quickly an organization can liquidate to pay off their liabilities. The quick ratio does not include the company’s inventory because the firm could have over bought or over produced a product, the product could not be selling, or the product may be unaccounted for; it should be in the inventory but has disappeared.

The debt-equity ratio is the ratio that calculates a firm’s total liabilities to the shareholders’ equity. The debt-equity ratio is a ratio that measures the degree the assets in the company are financed by debts and shareholders’ equity in an organization. A high debt-equity ratio indicates a company is borrowing a lot of money; while a low debt-equity ratio means the opposite. A high debt-equity ratio could be a sign that a company is having financial difficulties and needs to borrow to stay in business.

The profit margin ratio is a profitability ratio, which calculates the amount of net income earned regarding every dollar of sales. It is fashioned by linking the net income and net sales of an organization. The profit margin ratio shows the percentage of sales that that left after all costs are rewarded by the firm.

Price to Earnings ratio is the ratio of market price of a share to its annual earning (EPS). It reflects the forecasted earnings of a stock. A stock with higher P/E implies that it is likely to produce greater wealth for its stakeholders in future.

The Price to Earnings to Growth ratio helps the investors in evaluating the company's earnings and growth. It is calculated by dividing P/E ratio with anticipated EPS growth. Lower the ratio, the better is the stock in terms of its price and future growth of EPS. The PEG ratio helps the investors in spotting a good investment opportunity.

ROE = Profit Margin*Total Asset Turnover x  Equity Multiplier =  Net Income/Sales* Sales/Total Assets*Total Assets /Total Common Equity

DuPont equation and its calculation of ROE, the three ratios provide insights into the company’s

1. Use of debt versus equity financing

2. Effectiveness in using the company’s assets

3. Control over its expenses

A higher R.O.E. indicates that a company can increase its profit without introducing any fresh capital. The higher the ratio, the more investors it attracts. Suppose a company A is having 35.05% R.O.E. Out of which, 15.05% is due to profit margin and sales and remaining return is earned due to the debt. In such a scenario, if you find another company B which is having the same R.O.E. but the return due to internally generated sales is 25%, then Company B will attract more investors.

The price of a bond moves in opposition to its YTM. A bond's price lowers with an increase in YTM and rises with a reduction in YTM. The price of a bond and its YTM have a convex connection. When the discount rate decreases, the percentage price change is greater than when it increases by the same amount. Investors will expect higher returns as interest rates climb. As a result, bond prices will decline, which will inevitably cause the yield to maturity rate to increase.

When a bond offers a coupon rate below market rates, it will trade at a discount. Investors will pay less to buy a bond with a coupon rate that is lower than the going rate because they want a larger yield; the initial discount offsets the lower coupon rate. if coupon rate is more than YTM bond trade at premium, If the coupon rate is less than YTM bond trade at discount and coupon rate is same as YTM bond trade at par.

The annual income from an investment, which includes dividend and interest payments, is divided by the security's current market value to determine a bond's current yield. The entire return anticipated on a bond if it is held until its maturity date is known as yield to maturity (YTM). The YTM would be higher than the Current Yield if a bond were purchased at a discount from its face value because the discount increases the yield. On the other hand, the YTM will be lower than the current yield if a premium is paid for the bond.

Data taken from the Yahoo Finance

Time and yield are directly proportional. As time to maturity increases, the yield on the respective bonds increases. This is explained by liquidity preference theory which states that lower liquidity associated with longer duration bonds requires higher yields to attract the investors.

References

Agafonow, A., & Perez, M. (2021). How A Social Enterprise Wanes: The Transaction Costs of Credible Commitments at Etsy.com. Journal of Interdisciplinary Economics, 0(0). https://doi.org/10.1177/02601079211038239

Bhattacharya, R. R. (2022). Impact of Capital Market Events on Market Efficiency. Available at SSRN 4030185.

Bustanji, M. (2020). Testing Strong Form Market Efficiency of Jordanian Capital Market: Performance Appraisal of Mutual Funds a comparable study case with Saudi Arabia.  Theory, Methodology, Practice,  16(02), 3-15.