How to compute the IRR in Excel

How to compute the IRR in Excel

Photo Jérémy PAULEN Jeremy PAULEN

In this article, Jérémy PAULEN (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023) explains everything about the IRR function in Excel, which is used to compute the internal rate of return of a series of cash flow to evaluate the financial performance of an investment in relative terms.

What is the IRR?

The IRR represents the internal rate of return of an investment. It is closely related to the net present value (NPV) of the investment as the IRR is the discount rate that makes the NPV equal to zero.

Consider an investment represented by a series of cash flows CF0, CF1, CF2, …, CFT, which take into account the revenues and expenses of the project computed or forecasted at time 0 leading to capital inflows and outflows for the firm. The NPV of this investment is given by:

NPV formula

where r is the discount rate that takes into account the risk of the project.

The IRR corresponds to the value of the discount rate for which the NPV is equal to 0:

IRR

The IRR is the solution of a non-linear equation:

IRR

Note that this equation may have one solution, several solutions or no solution according to the sequence of cash flows.

The internal rate of return (IRR) is an important indicator in the decision-making process as it measures the financial performance of a project. The IRR is a relative measure as its unit is a percentage. The NPV is an absolute measure as its unit is the euro, the dollar, etc.

It makes it possible to measure the future financial performance of a project or a company. The higher the IRR is, the more interesting it is to launch the project.

The IRR can therefore be used in the case of a choice to be made between different investment perspectives, but also to evaluate the company’s share buyback programs.

A limit of using the IRR method is that it does not consider the size of a project. Cash flows are simply compared to the amount of capital outlay generating those cash flows. In other words, considering two projects A and B, the IRR of A may be lower than the IRR of B, while the NPV of A may be higher than the NPV of B.

The IRR function in Excel

How to use the IRR function in Excel?

In Excel, you can get the IRR function in the “Formulas” tab.
You can also type “= IRR (value, [guess])” in the cell where you want to compute the IRR.

The IRR function uses the following arguments:

  • Values: The cash flow series. Cash flows include investment values and net income.
  • Guess: a number guessed by the user that is close to the expected internal rate of return

Example

Example: consider a new factory modeled by the following series of cash flows:

  • CF0 = -$50,000 (initial cost)
  • CF1 = +$5,000 (net cash flow in year 1)
  • CF2 = +$8,000 (net cash flow in year 2)
  • CF3 = +$13,500 (net cash flow in year 3)
  • CF4 = +$18,800 (net cash flow in year 4)
  • CF5 = +$20,500 (net cash flow in year 5)

Excel file to compute the IRR of a series of cash flows

You can download below a short video which illustrates how to compute the IRR of a series of cash flows with Excel.

Download a video to illustrate IRR with Excel

Related posts on the SimTrade blog

   ▶ Raphaël ROERO DE CORTANZE The Internal Rate of Return

   ▶ William LONGIN How to compute the present value of an asset?

   ▶ Rodolphe CHOLLAT-NAMY Bond valuation

   ▶ Léopoldine FOUQUES The IRR, XIRR and MIRR functions in Excel

   ▶ Sébastien PIAT Simple interest rate and compound interest rate

Useful resources

Microsoft IRR function

About the author

The article was written in November 2021 by Jérémy PAULEN (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023)

My Marketing Developer Experience

My Marketing Developer Experience

Photo Jérémy PAULEN

In this article, Jérémy PAULEN (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023) shares his experience as a marketing developer at the Tennis Club of Rosheim.

Tennis Club of Rosheim

Tennis Club of Rosheim was founded in 1970 and is owned by David Livernais. The premises are located in the sports center of Rosheim, in Alsace. The Tennis Club had 191 members in 2021 and several partners. The Club therefore organizes many events every year.

The club wishes to create a relationship of trust with its members as well as a friendly atmosphere.

My internship at the Tennis Club of Rosheim

During my studies at ESSEC Business School, I had the opportunity to undertake an internship as a marketing developer at the Tennis Club of Rosheim.

Tennis Club Rosheim

Source: Tennis Club Rosheim

I was involved with the marketing department, which is in charge of promoting the club to potential new members. The promotion of a business takes place in several stages. First of all, through the development of a visual identity. The visual identity or graphic identity is a set of coherent visual elements which make it possible to identify the same entity through the different communication media that it uses. Example: Coca-Cola and the color red are almost synonymous with each other. The company uses its signature color on all of its products and all of its marketing materials.

Given my experience in the visual field and my different skills, I was given the responsibility of developing a new visual identity. The only restriction I had was to use the orange color.

I first had to create a logo. The logo is the pillar of a company’s image. A professional logo allows a company to stand out from its competitors, to convey its values and to tell a story. It therefore needs to be studied. The logo I created is made up of three elements:

  • A tennis ball in the center of the image to evoke the main activity of the club
  • The date the club was founded: 1970. Integrating a date reassures potential customers Because it implies professional knowledge and experience acquired over the years.
  • And last but not the least: the name of the club.

Tennis Club Rosheim logo

Source: Tennis Club Rosheim

I wanted a simple and uncluttered logo to reach as many people as possible.

I also had to create multiple posters to announce the different events. Each of my creations had a similar color code: orange, green and yellow. Orange is the color of cheerfulness, generosity, ambition, and abundance, but more importantly the color of the company. Green symbolizes hope and nature. Yellow is associated with joy, good humor, and radiance.

Promotion also passes through word, including emails or flyers. On several occasions I had to communicate by email with members and partners. Communicating through this media involves many codes. We must respect the codes of politeness and avoid any awkwardness. The emails are written and thus visible at all times.

Every day, the club president organized a general meeting where he talked about global debriefing. The various meetings make it possible to clarify the week’s objectives and to distribute the tasks to the workforce. They also present an opportunity to give feedback and to integrate each employee in the decision-making process. For my part, I took this opportunity to propose a new method of communication: Tiktok.

During my time at the TC Rosheim, I also had the opportunity to organize a large-scale event. Many competitors meet each year for a big competition. It was therefore necessary to find sponsors to finance this event, in our case the main partner was KARANTA. I also had to find volunteers to supervise the event and ensure it was smoothly run.

My key learning outcomes

During my internship at the Tennis Club of Rosheim, I had the opportunity to develop the following (soft) skills:

  • To manage a team
  • To meet deadlines
  • To improve communication skills
  • To understand the needs and to listen to the expectations of (internal) clients
  • The ability to learn and to improve my different skills

Three key terms

I develop below three key terms to understand my work.

Visual identity

The visual identity or graphic identity is a set of coherent visual elements which make it possible to identify the same entity through the different communication media that it uses.

A participatory leader

The participatory leader likes to study all the proposals before making a decision. He or she encourages his or her employees and values their work and achievements. A key element is feedback.

Feedback

Feedback is a step back, a testimony on an event that occurred. It allows time to check if the meaning of a message is understood, determine if help is required and verify if everybody is involved.

Useful resources

Tennis Club Rosheim

Related posts on the SimTrade blog

   ▶ All Professional experiences

About the author

The article was written in November 2021 by Jérémy PAULEN (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023).

My experience as a junior audit consultant at KPMG

My experience as a junior audit consultant at KPMG

Photo Pierre-Alain THIAM

In this article, Pierre-Alain THIAM (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023) shares his experience as a junior audit consultant in the Audit & Consulting department at KPMG.

About KPMG

When we mention professional services networks, everyone is instantly thinking about the “Big Four”. During the last summer from May to July 2021, I had the opportunity to work in one of these companies, KPMG, as a Junior intern in Audit & Consulting.

KPMG’s letters are the sheer remnants of the company’s history. In March 1917, Piet Klijnveld and Jaap Kraayenhof created an accounting firm in Amsterdam called Klynveld Kraayenhof & Co. Then multiples mergers occurred and in 1979, Klynveld Kraayenhof & Co., McLintock Main LaFrentz from the United States and Deutsche Treuhandgesellschaft from Germany, formed Klynveld Main Goerdeler known as KMG. In 1987, KMG and Peat Marwick merged and had one of the biggest mergers at the time. Two of the biggest accounting firms of the 20th century chose to unify and ultimately formed KPMG as we know it today.

Nowadays, KPMG provides multiple finance services including mainly Audit, Management Consulting and Tax Consulting.

KPMG office

Source: KPMG

What I did during my internship

During my internship, I evolved in a global system. I tried to understand the rules and even complex expectations of a work organization. My goals were to adopt an action or work plan coherent with the challenges and success of the requested mission and work effectively in a multicultural and interdisciplinary team while communicating in a dynamic national and international environment. I had to focus on producing clear and well-organized working documents on various subjects (test on revenues, process of a system, bank reconciliation of two pension fund regimes for examples), that the highest graded employees like managers or even partners would review for the mission.

I was mainly involved in audit assignments. The activity entrusted to it was essentially the understanding of target companies: organization, processes, and risks. Then, the understanding of audit objectives and performing substantive controls to identify accounting anomalies, including fraud of all types. And last but not least, I had to understand and perform internal control assessment work. I did a total of four missions over three months, with a range from a national agricultural organization to an insurance and a pension fund.

What I learned during my internship

Throughout my time at KPMG, I learned that technical skills are not the most important skills needed to work in the audit sector. Of course, you need to master hard skills like knowing the basics of financial accounting, being able to find the equilibrium of a balance sheet or having solid foundations on Excel. Nonetheless, there is a big “relational” aspect of the job. Since you are almost always with new people and colleagues, soft skills are definitely required. If you find a way to show your ability to communicate with other people, it always results with a better quality of work for you and the people involved in your mission.

When working in the audit sector, I think there are three principal aspects you need to focus on: logic, flexibility, and tenacity.

Logic

That may sound surprising, but logic is the most important quality you will need. When we talk about audit, people instantly think about big formulas, accounting and working on numbers all the time. This vision is quite wrong, I know for a fact that audit is mostly a process. A process is the description and assessment of the procedures for granting aid to customers: monitoring of their activities, the respect of accounting procedures and the identification of the various risks and controls implemented. You need to ask yourself a lot of questions related to the activities of the company you are working with. The aim is to identify the risks, assess them, define control measures, and simulate different scenarios of incidents to be analyzed: basically, it is called risk management. For example, if you work with Orange on their mobile services, you will first ask them how they make money from this activity. If they tell you each call is counted as a transaction, we will try to know how they make sure a call is counted. Then if Orange answers us that they have antenna A that conveys information to antenna B, KPMG will then investigate the risks of this method and how it can be the cause of a loss of money for the client company. This example is very specific to a certain type of firm, and it directly leads us to the second quality you need to succeed: flexibility.

Flexibility

At KPMG you can work in every field you can imagine and in any country in the world. My first mission was in a pension fund for employees of a bank group, my fourth week I worked in an insurance company and the week just after I worked in a logistics company. Lastly, my final mission was in a company for the support of the rural development of a country.

As you can see, we jump from one subject to another pretty quickly. Versatility is key because you never know what you are going to work on and where you are going to work at. If you don’t like to disrupt your habits, the rhythm of a consulting firm will promptly become fiendish for you. The bright side of this atmosphere is that it constantly stimulates you intellectually and you are always learning. Working in this type of company is extremely formative, but it comes with its advantages and disadvantages, metaphorically it is a double-edged sword, and you will either love it or hurt yourself if you find the correct way to handle it or not. And this is precisely why tenacity is essential to stay on the course.

Tenacity

Sometimes the work can be hard, and you have to try a lot of ideas until you find a solution. This can be even more difficult when there is tension with the management of your client company. Some people are really tough to work with and they just don’t want you to succeed because it will be at their detriment. Therefore, you need to have good communication skills while standing strong in your positions and not letting people walk over you.

The threat cannot only come from the clients but from your own colleagues. Most of the people are benevolent, but it is a dog-eat-dog world and not everyone can get to the top.

Related posts on the SimTrade blog

   ▶ All posts about Professional experiences

   ▶ Anant JAIN My internship experience at Deloitte

Useful resources

KPMG

About the author

The article was written in November 2021 by Pierre-Alain THIAM (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023).

What I learned from my time on the stock market

What I learned from my time on the stock market

Photo Joshua WAN

In this article, Joshua WAN (ESSEC Business School, Global Bachelor of Business Administration, Exchange Student from Stockholm University, Fall 2021) shares what he has learnt in the stock market.

I’m sure many who have chosen the Sim Trade course are active on the stock market and probably have been for some time. But maybe some of you have not yet ventured out on the world’s equity markets and maybe some of you are taking the SimTrade course in order to prepare yourself for trading with your own hard-earned money.

My story

I was 16 years old when I first decided that I wanted to start investing my spare money and saving it for the future. I had started my first year of Business Administration in upper secondary school and a friend told me that you could open an account on Avanza (Sweden’s largest brokerage firm) with your parents’ permission. After handing in all the required paperwork I transferred about €500 that I had left over from my summer job and was ready to do my first trade.

Back then €500 was a lot of money for me but in the context of the stock market it is just peanuts. What I realize now in hindsight is that this relatively small amount of money allowed me to learn valuable lessons about investing and financial markets without having any larger future consequences. I lost a large percentage of this money, but I did learn a lot from my mistakes. I wanted to share what I learned and maybe someone that wants to start investing can use these lessons to avoid making the rookie mistakes that I made.

Do your own research

One of the first things I learned was that you should always try to understand why you are investing in a specific stock and not just go off other people’s advice. I remember one of my friends telling me to invest in a certain company and he showed me the return that he made on the stock. I didn’t know much about the company, its market, and the future challenges. I did not know why I was investing in this company, so it is no surprise that this investment did not turn out very well. Now I’m not saying that you need to do a full fundamental or technical analysis, but you should understand the company you are investing in and why you are investing in it. You can read different recommendations and try to form your own opinion but don’t invest in something just because someone else tells you to.

Don’t be too impulsive and emotional

The aforementioned investment did not go very well, and I quickly found myself in the red. After about 5 months my position had gone down by circa 40%. At this point I decided to sell the stock in what was more of an impulsive emotional decision than a rational one. I did not sell because the company had no upside, I sold because I did not want to see -40% every time I opened the app.

Warren Buffet once said, “The most important quality for an investor is temperament, not intellect” (Sarwa, 2021). He meant that you need to have discipline, patience and that you need to understand that the market will fluctuate. He also goes on to say that humans are irrational and are tempted to make trades when they feel like the market is working against them. Of course, you should not stay onboard a sinking ship but if you have invested in a good company then patience will often pay off.

If I would have kept my position in this firm until today, I would have had a return of over 500% and if I would have sold it at the all-time high, I could have had a return of 1,500%. This does however bring me to my next point.

The figure below shows the price evolution of PowerCell Sweden stocks over the period 2015-2021 (the stock investment that I am talking above).

Figure. Stock chart of PowerCell Sweden

Stock chart of PowerCell Sweden

Source: First North Stockholm

Learn from your mistakes but don’t beat yourself up

Even if you do your research and have patience, you will still have some investments that don’t turn out well and some big opportunities that you will miss. It’s very easy to get hung up on these mistakes but instead of just seeing the negatives you can use this opportunity to try and understand why you made the mistake. By understanding your mistakes, you can lay a foundation for better future decisions. From the investment I previously mentioned I learned the importance of patience and knowledge. I realize now that it would have been a perfect opportunity to buy more shares instead of selling. But even if it doesn’t feel very nice that I missed out on a huge return you can’t beat yourself up over it because there will always be something you could have done better.

Have a strategy

Before you start trading/investing you need to have a strategy. You should know if you are investing long term or short term, low-risk low-return or high-risk high-return or if you are targeting value or growth firms. Of course, you can mix all these strategies and use different ones for different investments, but you need to be aware of what you are doing and why you are doing it. It can also be useful to know how much money you are willing to lose and how much profit you are willing to walk away with so you can manage your position using stop-loss orders and take-profit orders.

Diversification

For many of you this is nothing new, but diversification is one of the most important things to think about when building an investment portfolio. By investing in different industries and different geographical markets, you can minimize the risk that is specific to each firm. Of course, you cannot diversify all risk, after a certain point the diversification effect is marginally decreasing and there is a systematic risk that you cannot diversify away. When I first started, I only owned 2 stocks and I was very heavily weighted in one of them so when this stock went down my whole portfolio also went down. Of course, it was hard to achieve significant diversification with such a small amount of capital, but I have since then learned the importance of diversification. Even on the worst days there is usually one or two stocks in my portfolio that are not in the red.

Some final thoughts

I’m sure most of this is old news to you but I wanted to share what I’ve learned from my early mistakes in case anyone here wants to but has not yet taken the step on to the financial markets. Even if you don’t want to be an active trader and just want to invest in mutual funds and ETFs, these lessons and principles can still be useful.

Related posts on the SimTrade blog

   ▶ Youssef LOURAOUI Modern portfolio theory

   ▶ Akshit GUPTA Growth investment strategy

Useful resources

Sarwa (7th October 2021) Top 20 Warren Buffett Quotes To Inspire Your Investment Goals.

About the author

The article was written in November 2021 by Joshua WAN (ESSEC Business School, Global Bachelor of Business Administration, Exchange student from Stockholm University, Fall 2021).

Marketable Securitites

Marketable Securities

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of marketable securities.

This read will help you get started with understanding marketable securities on the balance sheet of a business.

Introduction

Marketable securities are financial instruments that can be converted into cash easily by the firm. Marketable securities are recorded in the balance sheet along with other current assets because of their nature. You can find marketable securities on a firm’s balance sheet under the Cash and cash equivalents section.

Types of marketable securities:

There are various types of marketable securities available to the firm and that can appear in its balance sheet. The most common ones are:

Bankers acceptances

Bankers acceptance bills can be imagined as an instrument that functions like a post-dated cheque. The business which purchases a banker’s acceptance note can use this instrument to convert it into cash, with the bank guaranteeing the payment. The bank issues these cheques in exchange of a fee, i.e. issues it at a discount to a face value to the company.

Commercial paper

Commercial Paper (CP) bought by a company refers to a short-term and unsecured debt instrument issued by other companies. The maturity of commercial papers can be as short as a few days to 270 days typically. Again, just like banker’s acceptance, commercial papers are issued at a discount on the face value.

Certificate of Deposits

Certificate of Deposits (CD) are issued by banks that provide interest on their value. Most financial institutions offer these certificates with a blocked period in which the certificate holder keeps the certificate untouched. The institution also levies a penalty in case of early withdrawal.

Treasury Bills

Treasury Bills (T bills) are similar to certificates of deposits, but are issued by governments with maturity of one year or less. They are usually issued in fixed denomination at a discount on the face value. They are considered as one of the safest forms of investment and the discount rate is referred to risk free rate of the country.

 

Final Words:

Marketable securities are important as they can be sold on short notice to meet the financial obligation of the firm (to pay salaries to employees, to pay bills to providers, etc.).

 

Relevance to the SimTrade certificate

This post deals with Marketable Securities on the balance sheet, an important tool for investors to take investment decisions.

About theory

  • By taking the SimTrade course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Liabilities

Liabilities

Shruti Chand

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on the concept of liabilities.

This read will help you get started with understanding the liability side of the balance sheet.

Introduction

A liability is an obligation that a company has in return of economic benefits that the company has received in the past. Any kind of obligation or risk that are due to a third party can be termed as liability.

Liabilities are recorded on the balance sheet can be short-term or long-term in nature.

Liability vs Expense

It is important to know that liability is not an expense for the business. An expense is the cost of operation for the business and is recorded on the income statement of a business. Liabilities on the other hand is what the business owes to another party already as the economic benefit has been transferred in the past. It is recorded in the balance sheet of the company.

Liabilities are very important for a business as they finance the daily operations of the business. For expansion activities, for instance if a business wants to expand overseas, liability in form of bank loans will help the business acquire assets to make the move to another location. This loan facilitated by a bank for example will be recorded in the liabilities section in the balance sheet.

Structure of the Liabilities part of the balance sheet

The Liabilities part of the balance sheet can be structured as follows.

Screenshot 2021-10-25 at 1.24.06 AM

Current Liabilities

These are the company’s short-term obligation (Usually financial in nature) that are to be paid within a period of one year. Most noteworthy examples of current liabilities include:

  1. Wages Payable: The total amount of salaries that the company owes to its employees.
  1. Interest Payable: The credit that the business takes to finance short term needs of business operations accrues an interest. This interest in payable by the business in the short term and is recorded in the interest payable section of the balance sheet.
  1. Dividends Payable: The total amount of dividends that the company owes to the investors against the stocks issued to them.

These items help the readers understand the level of obligations on the businesses due in a short period of time.

Non-current liabilities

These are obligations that are owed in a period longer than a year. Long term bonds, loans, etc. are a part of long-term/non-current liabilities. Companies usually issue bonds fulfil their long-term capital needs which are very common type of non-current liability. Other common examples of long-term liabilities include:

  1. Debentures: Type of bond or debt instrument issued by the company unsecured against a collateral.
  1. Bonds Payable: Long term debt instrument issued by companies and government which is a promise to pay at a future date and is issued at a discount in the current period.
  1. Deferred tax liabilities: All that the company owed the government in the form of tax obligation that hasn’t been met yet by the company.

Final Word

Liability section of the balance sheet helps investors to assess the risk profile of a business. It is an important tool to measure the leverage taken by a firm to assess the risk level of the company within the industry and compare it with competitors in the same industry.

Relevance to the SimTrade certificate

This post deals with Liability side of the balance sheet, an important tool for investors to take investment decisions.

About theory

  • By taking the SimTrade course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance Sheet

   ▶ Shruti CHAND Long-Term Liabilities

   ▶ Shruti CHAND Accounts Payable

   ▶ Shruti CHAND Financial leverage

About the author

Article written by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Assets

Assets

Shruti Chand

In this article, Shruti CHAND (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of assets.

This read will help you get started with understanding Assets side on the balance sheet of a company.

Introduction

An asset can be defined as anything that has an economic value or future benefit. Assets are an important part of the balance sheet of a firm as it reports all that a business owns at a given point of time. Assets are economic resources that will generate cash flows in the future. Examples of assets include machinery, building, accounts receivable, etc.

All the value of assets that one sees on the balance sheet are typically recorded on historical cost, adjusted from time to time based on depreciation. The Assets side of the balance sheet states all the assets in the order of their liquidity, i.e., ease with which they can be converted into cash. Hence, current assets such as cash or cash equivalents, short-term investments, etc. are listed first followed by fixed non-liquid assets at the end (with the US and international framework).

Structure of the Assets part of the Balance Sheet

Screenshot 2021-10-25 at 1.24.06 AM

 

Types of Assets on the Balance Sheet:

Current Assets:

Any asset that can be converted into cash with ease (Typically within a timeframe of 1 year) is known as Current Asset.

Most common current assets on a balance sheet include cash and cash equivalents, inventory, accounts receivable, and other prepaid expenses.

Fixed Assets:

Fixed assets are resources that the business owns which cannot be converted into cash immediately. Most noteworthy fixed assets on a balance sheet include plants, buildings, machinery and equipment. There is a constant adjustment that is made to the value of these assets from time to time to reflect their current value.

Financial Assets:

This asset class represents the securities, corporate bonds, preferred equity and all other hybrid equity that is financial in nature that the business owns.

Intangible Assets:

These assets have no physical existence whatsoever, but since they still have value attached to it and generate benefit for the business, they are categorized as Intangible Assets. Examples of intangible assets include patents, copyrights, trademarks, goodwill and other intellectual property owned by the business.

Note that with the French presentation of the balance sheet, the least liquid assets appear in the top while the more liquid assets appear in the bottom of the balance sheet), and similarly the shareholders’ equity and the long-term liabilities appear in the top while the short-term liabilities appear in the bottom of the balance sheet.

Final Word:

Investors use the Assets side of the balance sheet to check the financial health of the business (profitability of the investments). One common way to assess the performance is to find out Asset turnover ratio which measures the revenues generated form the use of assets against sales.

The amount of which type of asset a business owns is dependent upon its area of operations. Some businesses are more capital intensive than others which might require them to have more fixed assets than others. Equipment manufacturers are going to have large number of fixed assets such as machinery while a tech business have almost no fixed assets (except intellectual property assessed over time accounted in intangibles).

Relevance to the SimTrade certificate

This post deals with Asset side of the balance sheet, an important tool for investors to take investment decisions.

About theory

  • By taking the SimTrade course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Cash and Cash Equivalents

Cash and Cash Equivalents

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of cash equivalents

This read will help you get started with understanding the concept and its significance in determining financial health of a business.

Introduction

Cash and Cash Equivalents on the assets side of the balance sheet is the total amount of cash or assets that can be converted into cash on an immediate basis. Any bank accounts or marketable securities that a business owns can be categorized as cash equivalents.

What is included in Cash and Cash Equivalents?

Cash equivalents are the assets with short maturities typically 90 days or less. Examples of cash equivalents on a firm’s balance sheet include:

  • Treasury Bills
  • Money market mutual funds
  • Commercial Paper (bought from other firms)
  • Bank Certificates of deposit
  • Repurchase agreements
  • Other money market instruments

Cash on the other hand is not limited to the amount of money in checking and savings accounts (and coins and banknotes). It also includes assets such as cheques received but not deposited.

Cash and Cash Equivalents is recorded in the balance sheet in the “Current assets” section. Cash and Cash equivalents are related to other current assets that will transformed into cash later.

Measure of liquidity

Cash and Cash equivalents are used to measure the liquidity of the firm. For example, in financial analysis, it enters the computation of liquidity ratios.

Final Words

Cash and Cash equivalents may be a small part on the balance sheet of a firm but have a lot of impact as it is used to pay day-to-day operations of the firm on a very frequent basis.

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance sheet

   ▶ Shruti CHAND Current Assets

About the author

Article written in October 2021 by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Long-term securities

Long term securities

Shruti CHAND

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on the concept of long-term securities.

This read will help you get started with understanding long-term securities.

Introduction

Long-term assets on a balance sheet represent all the assets of a business that are not expected to turn into cash within one year. They are represented as the non-current part of the balance sheet. These are a set of assets that the company keeps for a long-term and is not likely to be sold in the coming years, in some cases, may never be sold.

Long-term assets can be expensive and require huge capital which might result in draining cash reserves or increasing debt for the firm.

The following category of long-term assets can be found in the balance sheet:

Investments

These are all the long-term investments by a company in securities, real estate and other asset classes. Even the bonds and other assets restricted for long-term value are treated as investments by the company.

Property, plant and equipment

Property that the company owns associated with the manufacturing process or other business operations. An important aspect about this asset class is the depreciation associated with the value of the asset over time.

Typically, you can find the following items disclosed as property, plant and equipment on the balance sheet:

  • Land
  • Land improvements
  • Buildings
  • Furniture
  • Machinery

(Less: Depreciation)

Intangible assets

Intangible assets are the assets without a physical existence. These items represent the intellectual property of a business acquired through their operations, marketing and other efforts to create value. The most notable intangible asset on a balance sheet is Goodwill.

Other intangible assets found in the financial statements are:

  • Copyrights
  • Trademarks
  • Patents

Other assets: All the assets of non-current nature that can not be liquidated easily.

Final words

Since a company holds the long-term assets for a long period of time, the changes in the long-term assets can be a sign of liquidation in some cases. When investors study the balance sheet of a company, they can see if the company often sells its long-term assets then it can be a sign of financial difficulty.

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance Sheet

   ▶ Shruti CHAND Assets

   ▶ Shruti CHAND Fixed Assets

About the author

Article written in October 2021 by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Intangible Assets

Intangible Assets

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of Intangible Assets

This read will help you get started with understanding intangible assets on the balance sheet of a company.

Meaning:

An intangible asset is an asset that has no physical existence. Such assets are identifiable when it is separable, or when it arises from contractual or other legal rights. These intangible assets can be sold, transferred or even licensed.

Most notable examples of intangible assets include:

  • Goodwill: Goodwill is an intangible asset that is the premium in excess to the purchase price of the company. Goodwill of a company can include intellectual property and brand value, which is not easily quantifiable.

 

  • intellectual property: The intellectual property owned by a company as a result of creativity, such as patents, copyrights, etc.

 

  • Patents: A license issued to a company conferring a right or title for a set period to exclude others from using, selling or making an invention.

 

  • Trademarks: Words, symbols legally registered by a company representing a product owner by them.

 

  • Copyrights: Rights that the creators of a product have created so that other makers don’t mimic/copy their work

Software and other computer-related assets outside of hardware also classify as intangible assets.

 Real life example: For instance, Company A purchases a patent from Company B for an agreed amount of 1 million, then Company A would record in its intangible assets 1 million under long term assets.

 

How can you value Intangible Assets?

 Businesses can create intangible assets in cases where it pays more than the book value of an asset and records it at a higher value on the Balance Sheet. This premium paid is an intangible asset on the books of the company.

 

Some important things to remember:

Financial assets are not intangible because they derive value from the contractual claims backing them.

Intangible assets contribute to the value of the company only through its presence on the balance sheet. Its measurement is essential to the company while assessing the state of the company’s resources.

Relevance to the SimTrade certificate

Intangible assets are an important factor to assess the value of companies investors want to invest in.

About theory

  • By taking the SimTrade course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Fixed Assets

Fixed Assets

Shruti Chand

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on the concept of fixed assets.

Fixed Assets:

A fixed asset on a balance sheet is any asset that has a useful life greater than one year. Typically, a fixed asset is not intended to be resold within a short period of time. Fixed assets can also be understood as any non-current asset are recorded on the Balance Sheet with other assets.

Examples of Fixed assets on a company’s balance sheet:

  1. Property
  2. Building
  3. Machinery
  4. Land

The fixed assets are usually recorded at the net book value, which is nothing but the price at which it was acquired. Over time, all the lost value in the fixed assets arising out of holding these assets is recorded as impairment charges and depreciation in the balance sheet.

Out of intuition, it is fair to assume that Fixed costs are large assets which are immovable, but that is not true. An office equipment such as Office Computer can also be a fixed asset if it exceeds the capitalization limits of the concerned business.

Depreciation of fixed assets

Fixed assets can not be converted into cash easily. It is usually acquired by the company to produce more goods and services, hence the use that the fixed assets are put into can lead to its depreciation in value.

This decrease in value is recorded as depreciation in the books of accounts (Balance Sheet). Depending on the company, the depreciation methods vary. For instance, if the company uses a straight line method, the same amount of depreciation is recorded every year for a fixed period of time until the value of the asset is zero.

Example of depreciation

Let’s say a company purchases machinery and plants for $100000 and the useful life of the asset is fixed at 10 years, then every year $10000 will be recorded as depreciation in the books of accounts for the next 10 years and at the 10th year, the value of the asset in the book finally will be 0.

Relevance to the SimTrade certificate

This post deals with Fixed Assets on the Balance Sheet of the companies investors might be assessing to understand the financial health of the company.

About theory

  • By taking the SimTrade course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance Sheet

   ▶ Shruti CHAND Assets

   ▶ Shruti CHAND Long-term securities

About the author

Article written by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Balance Sheet

Balance Sheet

Shruti CHAND

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on the concept of balance sheet

This read will help you get started with understanding balance sheet and what it indicates when studying a company.

What is a balance sheet?

Balance Sheet is one of the most important financial statement that states business’ assets, liabilities and shareholders’ equity at a specific point of time. It is a consolidated statement to explain what an entity owns and owes to the investors (both creditors and shareholders).

Balance sheet helps to understand the financial standing of the business and helps to calculate ratios which better explain the liquidity, profitability, financial structure and over all state of the business to better understand it.

Structure of the balance sheet

Screenshot 2021-10-25 at 1.24.06 AM

Use of the balance sheet in financial analysis

In financial analysis, the information from the balance sheet is used to compute ratios: liquidity ratios, profitability ratios (especially the return on investment (ROI) and the return on equity (ROE)) and ratios to measure the financial structure (the debt-to-equity ratio).

Final Word

Balance Sheet is one of the most important financial statement for fundamental analysis. Investors use Balance Sheet to get a sense of the health of the company. Various ratios such as debt-to-equity ratio, current ratio, etc can be derived out of the balance sheet. Fundamental Analyst also use the balance sheet as a comparison tool between companies in the same industry.

Relevance to the SimTrade certificate

This post deals with Balance Sheet and its importance in the books of accounts of a company that investors might want to assess.

About theory

  • By taking the SimTrade course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

Related posts on the SimTrade blog

   ▶ Shruti CHAND Assets

   ▶ Shruti CHAND Liabilities

   ▶ Shruti CHAND Assets

   ▶ Shruti CHAND Long-term securities

About the author

Article written by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Shareholder's Equity

Shareholder’s Equity

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of Shareholder’s equity.

This read will help you get started with understanding shareholder’s equity and its meaning on the books of accounts of companies.

Shareholders Equity:

Shareholders equity on the Balance Sheet is the amount that the owners of the company have invested into the business.

Shareholders equity = Money invested by owners + Retained earnings deferred over time.

The three categories of shareholders equity are:

  • Money invested by the shareholders:
  1. Common Shares: These shareholders are last in line when it comes to claims in case of dissolution of the company. They fall behind all the other dues of the company such as creditors, bond holders and preferred shareholders.
  2. Preferred Shares: These shareholders have a priority over the earnings of the company. What this means for the shareholders is that they are paid dividends before the common shareholders.
  3. Retained Earnings: is the percentage of net earnings that was not paid to the shareholders as dividends.

Owner’s claim:

One can further understand the shareholders equity by thinking of it as the difference between what the business owns and owes, i.e.: Total Assets – Total Liabilities. If one sums the total assets on a balance sheet and subtracts all types of liabilities, what remains is the sum of money that the business owes to its shareholders.

Understanding Shareholders equity:

If the value of Shareholders equity is positive, it means that business is in a healthy state and has enough assets to cover its liabilities. On the other hand, if the Shareholders equity is negative, then the business owes more in liabilities than the assets it holds to back the claims.

Relevance to the SimTrade certificate

Understanding shareholder’s equity structure of a company is an important indicator of the health of a company and can help investors make better investment decisions.

  • By taking the market orders course , you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Technical Analysis

Technical Analysis

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of technical analysis.

This read will help you get started with understanding technical analysis and how it is practiced in today’s world.

What is technical analysis?

Technical analysis is a tool used to predict future price movements and trends of security. This type of analysis is based on historical market data (both transaction prices and volumes) using various methods to help traders and investors in their decisions to buy and sell securities.

Investors perform technical analysis because sometimes, fundamental analysis may not always reflect the market price. In other words, the market may not be efficient from an informational point of view. Since technical analysis uses statistical and behavioral economics, it guides traders to what is most likely to happen. Hence, in real-life scenarios, investors usually use both technical and fundamental analysis to make decisions.

While fundamental analysis involves evaluating the intrinsic value of a company based on external events, market study, financial statement analysis, industry trends to name a few. Technical Analysis, on the other hand, relies on market movement more than the intrinsic value of the investment.

How is Technical Analysis different from Fundamental Analysis?

Unlike fundamental analyst, the overvaluation and undervaluation of a stock does not influence the behaviour of a technical analyst. Since Technical Analysis is concerned with price action, all decisions are based on the market movements rather than considering industry trends and company performance as technical analysts are really looking to
make money based on the stock market performance of a stock based on price trends.

Since technical analysis is statistical in nature, it is based on various
assumptions. It is very important to keep these assumptions in mind to
be able to perform technical analysis for investing:

  1. Market discounts itself: All the prices in the markets are a reflection of known and
    unknown information present with the investors in the stock
    market. The market takes into account all these factors and hence, price
    is always a reflection of this information.
  2. History repeats itself: Technical Analysis is a historic representation
    of price movements. It assumes that the history of the previous record
    of prices will be repeated in the future. It is based on the actions
    that investors take in an upward trending market, people tend to go
    long and vice versa.
  3. Trend influences price: Technical analysis studies and identifies
    trends in the market on the basis of which decisions are made.
    Since it is assumed that these trends will be reflected in the price,
    only then does technical analysis and its actions make sense.

How can you start Technical Analysis?

A lot of you all might wonder how can you start and eventually make money while practicing technical analysis. These simple steps can help any beginner:

There are various technical indicators that help technical analysts to identify market trends:

Charts:

While it is important to keep in mind that no technical analysis is perfect, there are some tried and tested common charts that Investors use various charts to help them predict future market movements, some of the most common ones are:

1.  Line Chart
2. Bar Chart
3. Candlestick Chart
4. Renko Chart etc
And many more…

Moving Averages:

Moving average is a technical analysis tool that helps investors smoothen the price movements data by a frequently updated average price. Since minor and major movements in stocks over a really brief period of time can influence technical analysis results, a moving average is calculated to better predict actions.

MA are customizable and the time frame is based on the discretion of the analyst. The most common time frames that investors use are 15, 20, 30, 50, 100, 200 days.

Relevance to the SimTrade certificate

With basic technical analysis, you can start trading in the markets through Online Brokers or through the Simtrade Platform to enhance your learnings.

About theory

  • By taking the market orders course , you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Long-Term Loans

Long-Term Loans

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on long-term loans.

This read will help you get started with understanding long-term loans and how it is used in today’s world.

Introduction

A term loan or long-term loan refers to a loan from a bank for a specific amount of
funds with a fixed interest rate or a floating interest rate payable over a specified
schedule. A company uses term loans to fund the purchase of fixed assets, for
instance, manufacturing equipment, property, etc.

The term loans are issued by banks for short-term as well as long-term periods of
time. Depending on the needs of the business, the banks usually have different
types of term loan offerings. These loans differ from each other in their repayment
schedule as well as the type of interest rates.

Main aspects behind facilitating a term loan

1. Collateral:
Nature of term loans are usually very risky for the lender, hence the banks
usually require collateral and a rigorous approval process to grant term loans
to businesses.

2. Repayment schedule:
The repayment schedule is fixed by the bank at the beginning of the term loan
grant process. This is based on various factors that the bank considers about
the risk profile behind the loan. Generally, term loans do not carry any
penalties if they are paid off ahead of schedule. If the company does not pay
the obligations in time based on a pre-decided repayment schedule, the
banks charge a penalty which can be hefty. These repayment schedules can
be monthly, quarterly, or yearly.

3. Interest rates: The term loan bears an interest rate charged by the bank which is pre-decided. This interest rate can be either fixed throughout the tenure of the
term loan period or be a floating rate that fluctuates throughout the period of
the term loan. Let’s understand the types of interest rates to get better
understanding:

● Fixed interest rate:
This is straightforward as it is fixed based on the nature of the loan and
the time period. If the loan is relatively risky, the interest rate fixed will be
higher than that for a loan with low levels of risk.

● Variable interest rates:
The interest rates that differ along the period of the term loan are
referred to as variable interest rate. They are usually attached to the
value of a benchmark rate such as LIBOR (London Interbank Offered
Rate).

This interest can be represented in the following way: LIBOR + 0.5%
Hence, as the value of LIBOR changes, the interest rate also increases
or decreases along with it.

 

Various types of term loans:

1. Short-term loans: These loans are usually taken by companies for a period of
less than 1 year.

2. Intermediate-term loans: These loans are usually for a period of more than 1
year but less than 3 years. The company usually pays for these loans monthly
through the cash flow it generates through its operations.

3. Long-term loans: Any term loan for a period of more than 3 years can be
defined as a long-term loan. These loans require collateral to be granted by
the bank. The repayment schedule can be monthly, quarterly based on the
agreed terms in the beginning.

Long-term loans are present on the non-current liabilities of the balance of every
firm. Long-term loans cannot be avoided by a company especially when it is starting
out as it is a primary source of funding

You can read more about other forms of liabilities on a firm’s balance sheet.

Relevance to the SimTrade certificate

This post deals with Long-Term loans, which are taken up by companies and indicate their financial health.

About theory

  • By taking the market orders course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Long-Term Liabilities

Long-Term Liabilities

Shruti Chand

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on long-term liabilities.

This read will help you get started with understanding long-term liabilities and how it is used in making investment decisions.

Introduction

Long-term liabilities are financial liabilities of the firm that are due in a period more than one year. These long-term obligations are also referred to as non-current liabilities.

You can find the long-term liabilities in the balance sheet including various items such as all long-term loans, bonds, and deferred tax liabilities.

While the current liabilities of a business represent the funds used by a company to cover its liquid assets, the non-current part of the liabilities are used to cover primary business operations and purchase of heavy long-term assets.

The current and non-current liabilities are separated from each other to help readers understand the financial prosperity of the businesses in different time scenarios.

The most common examples of long-term liabilities are as follows:

● Bonds payable
● Long term loans
● Pension liabilities
● Deferred income taxes
● Deferred revenues

Final Words

Understanding the level of long-term liabilities of the business helps the reader to assess the risk behind meeting the financial obligations of a business. To be able to measure this risk level, it is very important for the investor to understand the concept of leverage. It helps the reader understand how much capital comes from debt. This
helps one understand the position of a company towards its ability to meet its financial obligations. High levels of leverage can be risky for the business. You can measure this using various financial ratios. Common leverage ratios include debt-equity ratio and equity multiplier.

Relevance to the SimTrade certificate

Understanding long term liabilities and its significance in the books of accounts of a company will help you better understand the financial health of companies you would like to invest in.

About theory

  • By taking the market orders course, you will know more about how investors can use various strategies to invest in order to trade in the market.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance sheet

   ▶ Shruti CHAND Liabilities

About the author

Article written in October 2021 by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Accounts Payable

Accounts Payable

Shruti Chand

In this article, Shruti Chand (ESSEC Business School, Master in Management, 2020-2022) elaborates on the concept of accounts payable.

This read will help you get started with understanding accounts payable and its significance.

What are accounts payable?

Accounts Payable appears in the balance sheet of a company when the company purchases goods or services on credit that needs to be paid after a certain period.

Accounts payable arises when the payment for a purchase of goods or services has not been made upfront but will happen in the future at a given date determined at the time of the purchase by the client (sale by the firm). In this case, goods or services are purchased on credit. They are to to be paid back in the short term.

Example

The services that we consume monthly such as electricity or telephone usually must be paid at the end of the month even though the consumption of the month is done before the said payment. This in turn becomes accounts payable. And our failure to meet the payment at the end of the month could lead to default and hence an extra charge.

For businesses the account payable could be when for example they buy a product, but the payment is not done instantly. For instance, Company X buys an AC from company Y but agrees to make the payment after a month. This transaction for Company X will be recorded as accounts payable whereas for Company Y it will be recorded as accounts receivable.

Accounting Treatment

‘Accounts payable’ falls under Liability in the balance sheet under ‘Current Liability’. It is in current liability since it is a form of short-term debt. Failure to meet this payment by the company will lead to a default. For double entry of accounting, the debit of the same is recorded in the expense account as a purchase. For goods like raw materials, there is a variation in inventory in the revenues and an increase in the Asset side under ‘Inventory’.

The increase or decrease in the Accounts Payable of the prior period is recorded in the Cash Flow statement of the entity.

 

Final Words

Accounts payable are crucial to every economy and it differs based on various factors and is taken in control by policy makers whenever needed. As a student curious about Finance, learning about Repo Rate will go a long way in the future to understand better how liquidity and prices in the economy is maintained.

Relevance to the SimTrade certificate

This post deals with Accounts Payable and how it’s significance in the books of accounts of the companies you would like to invest in as an investor,

About theory

  • By taking the SimTrade course , you will learn more about the markets.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

About the author

Article written by Shruti Chand (ESSEC Business School, Master in Management, 2020-2022).

Inventory

Inventory

Shruti Chand

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on the concept of accounts receivable.

This read will help you get started with understanding inventory and its significance.

Definition

All the raw material that a business uses to produce goods and the ready for sale products that a business possesses is referred to as Inventory. It is a form of asset for a business.

All inventory is categorised and recorded as current asset on the balance sheet. The inventory mainly comprises of three types of goods:

1. Raw materials: The assets that a business uses in the production process to produce the final product.

2. Work-in progress: The unfinished product held by a business not ready to be sold yet.

3. Finished goods: Ready to sell products possessed by a business not sold yet. These products are usually held by a business in warehouses.

The value of inventory is important to be evaluated by a business as it is an asset stored by the business which incurs costs of storage. The value of the inventory can be evaluated in various ways though, depending on the accounting method followed by the business.

The three ways in which inventory can be valued are as follows

1. FIFO: First in first out method which calculates the cost of goods sold on the basis of the cost of earliest purchased materials.

2. LIFO: Last in first out method states that the cost of the goods sold are calculated based on the value of the raw materials purchased last.

3. Weighted average method: States that the value of inventory is calculated based on the average cost of the total raw material purchased by the business.

Final Words

Understanding inventory and calculating it well helps the business to plan the purchase of raw materials and production decisions better. Business can determine the level of purchases to be made and exercise stock control for better business performance.

Relevance to the SimTrade certificate

This post deals with inventory part of the books of accounts, which is an important indicator for investors to study the financial health of a company.

About theory

  • By taking the SimTrade course , you will learn more about the markets.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance sheet

   ▶ Shruti CHAND Accounts Receivable

   ▶ Shruti CHAND Current Assets

About the author

Article written in October 2021 by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Accounts Receivable

Accounts Receivable

Shruti Chand

In this article, Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022) elaborates on the concept of accounts receivable.

This read will help you get started with understanding accounts receivable and its significance.

Introduction

Accounts Receivable appears in the balance sheet of a company when an entity (an individual or a company) purchases goods or services on credit from the company and the payment will be received later.

It is the amount of money owed by the customer for any purchase that is made on credit. Quite often, business sells products/services to its customers but the payment is made in the future and issues an invoice for this same in the meantime. This invoice signifies that the product has been sent but the payment is to be done within a specified future date. These are a form of short-term debt since they are to be paid back in a short span. The time for the payment is usually from about 30 days to a few months.

Example

Company A that sells broadband service usually provides the service for the month, but the payment is typically received at the end of the month. This means that even though the service has been provided, the payment is pending hence making it an accounts receivable.

Mostly, businesses provide credit purchases to customers with whom they have frequent transactions. This enables them to avoid the hassle of payments every time a transaction occurs. It also helps build a good relationship with its clients by providing them an ease of payment.

Accounting Treatment

As discussed, since Accounts Receivables is like a short-term credit line to clients hence it is treated as a short-term asset in the balance sheet. It falls under ‘Current Assets’ since the payment is received in the short term. For double entry, the credit side of the same is recorded in the income account as a sale. Once, the payment is made the cash in the balance sheet will increase and the accounts receivable will decrease. For goods like raw materials, there is a variation in inventory in the revenues and a decrease in the Asset side under ‘Inventory’.

The increase or decrease in accounts receivable from the prior period is also recorded in the Cash Flow Statement.

Final Words

Accounts receivable are crucial to every economy and it differs based on various factors and is taken in control by policy makers whenever needed. As a student curious about Finance, learning about accounts receivable will go a long way in the future to understand better how liquidity and prices in the economy is maintained.

Relevance to the SimTrade certificate

This post deals with Accounts Receivable and its significance on the book of accounts of a company.

About theory

  • By taking the SimTrade course , you will learn more about the markets. It’s important to remember that accounts receivables are an important to assess it to understand the financial health of a company you would like to invest in.

Take SimTrade courses

About practice

  • By launching the series of Market maker simulations, you can extend your learning about financial markets and trading approaches.

Take SimTrade courses

Related posts on the SimTrade blog

   ▶ Shruti CHAND Balance sheet

   ▶ Shruti CHAND Accounts Payable

   ▶ Shruti CHAND Current Assets

About the author

Article written in October 2021 by Shruti CHAND (ESSEC Business School, Grande Ecole Program – Master in Management, 2020-2022).

Rise of SPAC investments as a medium of raising capital

Rise of SPAC investments as a medium of raising capital

Daksh GARG

In this article, Daksh GARG (ESSEC Business School, Master in Strategy & Management of International Business (SMIB), 2020-2021) talks about the rise of SPAC investments as a medium of raising capital. Imagine someone famous asking you to invest in a company. Chances are, you will want to know more. As it turns out, there is no company, at least not yet. Will you invest in it with your money?

What are SPACs?

‘SPAC’ stands for Special Purpose Acquisition Companies. SPACs are a type of blank-check company that pools funds to finance mergers and acquisitions (M&A) transactions.

Once shunned by investors, SPACs have become an increasingly popular method in recent years to list companies on a stock exchange.

SPACs are shell companies with no actual commercial operations but are created solely for raising capital through an initial public offering – or IPO – to acquire later a private company. This is done by selling common stocks – with shares commonly sold at $10 a piece – and a warrant, which gives investors the preference to buy more stocks later at a fixed price.

Once the funds are raised, they will be kept in a trust until one of two things happen:

    The management team of the SPAC — also known as sponsors — identifies a company of interest, which will then be taken public through an acquisition, using the capital raised in the SPAC IPO.

    If the SPAC fails to merge or acquire a company within a deadline typically two years — the SPAC will be liquidated, and investors will get their money back.

SPACs have existed in one form or another as early as the 1990s, typically as a last resort for smaller companies to go public. The number of SPAC IPOs has waxed and waned over the years in tandem with the economic cycles. SPACs have been making a resurgence of late.

The timeline for SPAC

Figure 1 gives the typical timeline for a SPAC investment. Following the IPO, the proceeds for a SPAC are placed in a fund. In the meantime, the SPAC has to merge with a target company. If it is not able to do that in the time frame, the SPAC has to liquidate and the IPO proceeds are returned to the shareholders.

Figure 1. Typical SPAC timeline.

Typical SPAC timeline

Source: PWC accounting advisory

Difference between a traditional IPO and a SPAC

There are several ways a private company can go public (being quoted on the stock market). The most common route is through a traditional IPO, where the company is subject to regulatory and investor scrutiny of its audited financial statements.

An investment bank is usually hired by the company to underwrite the IPO, which usually takes 4-6 months to complete. This involves roadshows and pitch meetings between company executives and potential investors to drum up interest and demand in its shares. And not all IPOs succeed. A very famous example is that of a co-working-space company called WeWork withdrew its high-profile IPO in 2019 amid weak demand for its shares after massive losses and leadership controversies were revealed. Other companies such as Spotify and Slack went public through direct listings, saving on fees paid to middlemen such as investment banks, although there are more risks involved. And while private companies listed through SPACs are similar to reverse takeovers, such as the case for insolvent fintech company Wirecard, they are different in that SPACs start off on a clean slate and have lower risks. Because SPACs are nothing more but shell companies, their track records depend on the reputation of their management teams. By skipping the roadshow process, SPAC IPOs also typically are listed in a much shorter time. This leads to some investors to become wary of buying shares in companies listed through SPACs due to the lack of scrutiny compared to traditional IPOs.

SPAC sponsors also typically receive 20% of founder shares in the company at a heavily discounted price, also known as the “promote.” This essentially dilutes the ownership of public shareholders.

Performance of traditional IPOs compared to SPAC IPOs

According to Bloomberg, a study of 56 SPACs that completed acquisitions or mergers since the start of 2018 found that they tend to underperform the S&P 500 during a three, six and 12-month period after the transaction. A separate study of blank-check companies in the U.S. organized between 2015 and 2019 found that the majority are trading below the standard price of $10 per share. Between 2017 and the middle of 2019, there were slightly over 100 SPACs in the U.S., with an average return of a mere 2%.

Even before the pandemic, SPACs were already on the rise, buoyed by the equity boom and hot IPO market in 2019. While the pandemic has slowed the pipeline of traditional IPOs, SPACs have increased.

In fact, funds raised through SPACs outpaced traditional IPOs in August 2020 — a rarity on Wall Street. In the first ten months of 2020, there were 165 SPAC IPOs globally, of which 96% of them were listed in the U.S. While largely an American phenomenon, SPACs have caught the attention of investors in other jurisdictions.
In 2018, Antony Leung, the former finance secretary of Hong Kong, raised $1.5 billion on the New York Stock Exchange through his SPAC, which bought a mainland hospital chain a year later.

Other players include Masayoshi Son’s SoftBank, and the investment arm of Chinese state-owned conglomerate CITIC Group. Despite having sponsors from Asia looking to acquire international companies, these SPACs are ultimately listed in the U.S.

One main reason is the different rules for SPACs across jurisdictions. In the U.S., investors can vote to approve the acquisition the SPAC proposes or redeem their funds if they do not support the proposed deal.

This, however, isn’t a requirement in some European jurisdictions, including the U.K. There is also a lock-in period for British investors once an acquisition is announced until the approval of the prospectus, which ties them into deals that they may not support in that indefinite period.

Future of SPACs

As SPAC activity reaches fever pitch in the U.S., regulators are putting these blank-check companies under the microscope. Competition to the IPO process is probably a good thing, but for good competition and good decision-making, you need good information. And one of the areas in the SPAC space that I’m particularly focused on is incentives and compensation to the SPAC sponsors. As more ordinary investors jump on the SPAC bandwagon, experts are concerned that this will overheat markets and affect any fragile economic recovery. While SPACs provide a straightforward route to invest through a trusted intermediary, its performance so far means that it is a dicey bet for ordinary investors.

Why should I be interested in this post?

If you are interested in how big companies are going public, SPAC is one of the most interesting phenomena which is going to transform the financial industry. So, if you are planning to work for top underwriting firms or big banks or on Wall Street, you should have in-depth knowledge on how SPACs work and what are some of their advantages and disadvantages.

Useful resources

PWC How special purpose acquisition companies (SPACs) work Accessed November 2, 2021.

PWC Analysis: De-SPACing Successes Refuel Hot SPAC IPO Market Accessed November 2, 2021.

Related posts on the SimTrade blog

   ▶ Suyue MA Expeditionary experience in a Chinese investment banking boutique

   ▶ Raphaël ROERO DE CORTANZE In the shoes of a Corporate M&A Analyst

About the author

The article was written in November 2021 by Daksh GARG (ESSEC Business School, Master in Strategy & Management of International Business (SMIB), 2020-2021).