Category: Uncategorized

  • Working Capital Turnover Ratio

    Working Capital Turnover Ratio

    Walter Harvey Pvt Ltd had spent ₹12,00,000 to run its day-to-day operations, such as inventory management, transportation of raw material, and so on. This means they had a working capital of ₹12,00,000. It had ₹60,00,000 in net sales over the last 12 months. 

    But how do they determine if they’ve used their resources effectively?

    This is when the working capital turnover ratio helps! Thus, their working capital turnover ratio is ₹60,00,000/₹12,00,000 = 5.0. This means that every ₹1 of working capital produced ₹5 in revenue.

    This article talks about the working capital turnover ratio and what it conveys.

    What does it actually mean?

    To understand the working capital turnover ratio, you must know about working capital.

    Working capital is the difference between the current assets and the current liabilities of a company. This difference, when computed, measures the company’s liquidity, operational efficiency, and financial health in the near future (short-term). 

    If the company has considerable positive working capital, it most likely has sufficient funds to invest and grow. But if its working capital is negative (or low), then it may face troubles in its growth and settling its debts. Eventually, it might go bankrupt. Although positive working capital is good, it sometimes suggests that the company has excess inventory or has not invested excess cash.

    Now, coming to the working capital turnover ratio

    The working capital turnover ratio estimates how efficiently a company utilizes its working capital to grow its sales. Since it is the ratio between the net sales and the average working capital, it is also called net sales-to-working capital.

    In other words, the working capital turnover ratio assesses the relationship between the funds used to run the operations of a company and the revenues it is earning to keep running its further day-to-day operations and remain profitable.

    Working capital turnover ratio formula

    The working capital turnover ratio can be calculated by dividing the average working capital by the net annual sales. So, the working capital turnover formula is​

    Working Capital Turnover Ratio = Net Annual Sales/Average Working Capital.

    In the formula, the net annual sales are the sum of a company’s gross sales in a particular period, deducted by its returns, allowances, and discounts. In contrast, average working capital is the difference between average current assets and average current liabilities.

    Example of working capital turnover ratio

    Assume that you own an art supplies store. You sell products for art students, professional artists, art hobbyists, and art colleges. 

    In the course of the year, you made sales of ₹36,00,000. Moreover, your working capital was ₹7,00,000.

    You wonder if you’ve used your resources to their best or not. Therefore, you computed your store’s working capital turnover ratio to determine this. 

    To calculate it, you divided your net sales (₹36,00,000) by your average working capital (₹7,00,000). Thus, your working capital turnover ratio comes to be around 5 (approximately 5.143). 

    This means that for every ₹1 of your working capital, you made sales of nearly ₹5. In other words, every ₹1 that you invested into or allotted for your store’s operations made ₹5 of sales for you.

    What does it tell you?

    As mentioned above, the working capital turnover ratio denotes how efficiently a company is employing its working capital to carry on with its sales and growth. Moreover, to evaluate how effectively a company has been utilizing its working capital, analysts also compare its working capital ratio with those of other similar companies in the same industry. Then, they examine how the ratios have been fluctuating with time. Accordingly, they interpret the efficiency of the company.

    Nonetheless, these comparisons are not quite useful if working capital becomes negative. When the working capital turns negative, the turnover ratio also turns negative. You can also refer to the formula to understand this.

    A high (or positive) working capital turnover ratio suggests that the company is extremely effective in utilizing its short-term assets and liabilities to make sales. Put differently, it generates a higher rupee amount of sales for every one rupee of working capital it has used.

    The example above represents a high working capital turnover ratio.

    Therefore, a high working capital turnover ratio represents that a company is functioning smoothly and has no or limited requirements for additional funding. The cash inflow and outflow are regular, making the company flexible enough to spend its working capital for further expansion or inventory (production). Moreover, a company can also get a competitive advantage over other similar companies as it is an indicator of profitability.

    However, an extremely high working capital turnover ratio can sometimes also reflect a lack of capital to continue with sales and growth. Gradually, such a company can turn insolvent in the near future if it does not get additional funds.

    Apart from this, the working capital turnover ratio can be deceiving if the accounts payable of a company are very high. This would suggest that the company is facing trouble paying its bills as they remain unpaid. Such a company can even stop its operations due to a lack of funds.

    Contrarily, a low working capital turnover ratio indicates that a company has invested in a very high number of accounts receivable and inventory to continue with its sales. This can result in excessive bad debts or dead inventory in the near future.

    This can be understood with another example.

    Assume that your art supplies store made sales of ₹35,00,000. Moreover, you’ve acquired a new client, a prestigious art college. However, as your new client made several orders on credit, you accumulated a huge number of unpaid invoices. Therefore, your working capital came out to be ₹45,00,000.

    In this scenario, you computed your store’s working capital turnover ratio to determine your efficiency to use your working capital. 

    To calculate it, you divided your net sales (₹35,00,000) by your average working capital (₹45,00,000). Thus, your working capital turnover ratio comes to be 0.78, which is less than 1. 

    This means that for every ₹1 of your working capital, you made sales of nearly ₹0.78. In other words, every ₹1 that you invested into or allotted for your store’s operations and expansion could only make ₹0.78 of sales for you. This interprets that you could not efficiently utilize your assets for your store’s profits and growth.

    Bottom line

    While working capital shows the difference between a company’s current assets and current liabilities, the working capital turnover ratio evaluates the efficiency of a company in making sales for every rupee of its working capital that is put to use. However, a higher working capital turnover ratio is good. It shows the company’s ability to generate a larger amount of sales. 

    An exceedingly high working capital turnover ratio implies that the company has additional capital requirements for its future growth. Likewise, a negative working capital turnover ratio shows its inefficiency in utilizing its working capital. In this way, the calculation of this ratio ensures liquidity, prevents operational interruptions, and enhances the company’s overall financial health and value.

  • How to use the VLOOKUP function in Excel

    How to use the VLOOKUP function in Excel

    Microsoft Excel is an incredibly effective tool for managing data. It makes it simple for users to evaluate and interpret data. Microsoft Excel is unquestionably a strong and very popular programme utilized by practically every organization. Excel offers a wide variety of features that make working with data easier. One such Excel function is VLOOKUP.

    VLOOKUP serves as a search tool by scanning vertically over a table or spreadsheet for particular data. Let’s examine VLOOKUP in more detail.

    What is VLOOKUP in Excel?

    VLOOKUP in Excel stands for Vertical Lookup. VLOOKUP is a built-in Excel function that, as its name implies, enables you to find specific data by looking for it vertically across the page. It may appear difficult at first, but if you give it a try, you’ll see that it’s a simple to use and very helpful tool. It is arguably one of the most well-known features, for good and bad reasons. Let us now talk about some pros and cons of using VLOOKUP.

    PROS AND CONS OF VLOOKUP:

    On the plus side, VLOOKUP is simple to use and performs a highly valuable task. VLOOKUP can scan a table, locate a match, and deliver the right result, especially for beginners. Success with VLOOKUP is a must for moving from a novice Excel user to a proficient one.

     The drawback of VLOOKUP is that it requires a complete table with lookup values in the first column, unlike INDEX, MATCH, or XLOOKUP. Because of this, using VLOOKUP with multiple criteria is challenging. Additionally, it’s simple to obtain false results because of the default matching behaviour. Understanding the fundamentals is the key to using VLOOKUP effectively.

    VLOOKUP Formula

    VLOOKUP formula or the syntax is as follows:

    =VLOOKUP (lookup_value, table_array, column_index_num, [range_lookup])

    where,

    lookup_value – The value to search for in a table’s first column.

    table_array – The table from which a value should be retrieved.

    column_index_num – The table column from which a value should be retrieved.

    range_lookup – [optional] TRUE = approximate match (default). FALSE = exact match.

    Clearly, there are two possibilities if you want to be more specific:

    1. TRUE to find an approximate match.  
    2. FALSE to search for an exact match 

    In the absence of a particular command, TRUE is the default value.

    How To Find an Exact Match Using VLOOKUP?

    When utilizing VLOOKUP, an exact match is typically used, especially when the lookup value is a singular value. In this VLOOKUP example, an exact match is used because the lookup value is present in the table’s leftmost column.

    This time, the table array A:F contains the value 178462 or H2 in the leftmost column. Since the fourth column of the table contains the relevant value for the lookup, we enter 4 to instruct Excel to return the value from the fourth column of the table array in the same row. To tell Excel to return an exact match, we put FALSE as the fourth option.

    Excel returns Ahmedabad, which matches Client ID 178462 accurately.

    Excel will return #N/A to indicate that the lookup value could not be located if it is not included in the table’s leftmost column.

    How To Find an Approximate Match Using VLOOKUP?

    In order to discover the closest value that is less than the lookup value that we specify, Approximate Match searches for the next greatest value. Excel presumes that a lookup refers to an approximate match when no instruction is provided. Although it is generally less frequently used than exact match, it is nonetheless helpful when the lookup value is not present in the table array.

    For example, the table’s leftmost column does not include information about the 10,00,100

    salary. When asking Excel to provide an approximate match in this scenario, TRUE is helpful. Because 10,00,100 is not available, it will return a figure lower than 10,00,100 (10,00,000in this case), which is 145301.

    Excel will return #N/A if we use FALSE (exact match in this case), as there is no value of 10,00,100 present in the leftmost column.

    How to Use VLOOKUP for Multiple Criteria?

    The fundamental principle of utilizing VLOOKUP in a situation with multiple criteria is to concatenate the various criteria so that you can utilize them as a single lookup value. In this case, the ampersand (&) will be used for concatenation. Therefore, before continuing with the lookup, we must create a helper column that joins the “Table_arrays.”

     

    First, create a helper column. For this, let’s take an example. We will create a new column to combine the information from the “Name” and “City” columns. Insert a column after B which is the Helper Column (name it as per choice). Copy the formula (=A2&B2) to the remaining rows of the data after entering it in cell C2 of the worksheet.

    Now let’s follow these steps to understand the multiple criteria function better.

    1. To extract the data, insert the VLOOKUP function in the empty cell.

    2. Enter the first argument which is “lookup_value”. This is the thing that you already know. Here “Name” and “City” is known while “Client ID” is not known.

    To alter the lookup value in the function, create an Excel VLOOKUP multiple criteria.

    The two criteria to include in the VLOOKUP should be concatenated to form the lookup value. In G2, H2, and I2, respectively, place the VLOOKUP formula, the first criterion, and the second criterion. H2&I2 should be the lookup value for the VLOOKUP.

    3. Enter the second argument which is “table_array”. The place where you are seeking the data is the “table array.” It would be columns A through E if you were using a “regular” VLOOKUP. Columns C through E must be used in this scenario due to the assistance column.

    4. Enter the third argument which is “col_index_number”. The column from which you want to return the result is indicated by the ‘col index number’. Our “table array” consists of three columns, and we want to return the Client ID, which is in column E (the third column). In our example, this number should be 3.

    5. Enter the fourth argument which is “[range_lookup]”. Simply a “TRUE” or “FALSE” tells Excel whether we want to employ an approximate or exact match for our query with the [range lookup] field. For this syntax argument, we just type “FALSE” in this example.

    Press enter and you’ll get the desired result i.e. the Client ID.

    Conclusion

    One of the most frequently used Excel functions is VLOOKUP. Based on a lookup value in the leftmost column, it looks through a specified data collection and returns a corresponding value in the same row.

    When a unique known identifier is the lookup value, an exact match is typically utilized to return the exact corresponding data in the same row. An approximate match is sometimes used to discover the closest match given the criteria when the lookup value is known.

     

    VLOOKUP is a highly helpful tool when it comes to looking for information while working with numerous data sets, despite the fact that it initially appears to be tough to set up. It’s critical to understand that VLOOKUP only finds matches by scanning to the right of the data and only returns the first match.

  • Accrued Income: Definition, Formula, Calculation

    Accrued Income: Definition, Formula, Calculation

    Introduction:

    Suppose you are a Gym owner and have spent a great deal of money on Gym equipment. So you can only do this in case you are completely sure that the members of your Gym will eventually pay for the convenience of using the equipment purchased. 

    So as your business grows, you will recover your money with profit. The proper term here used is Accrued Income. Some other areas where you will come across this term are paying rent of your apartment, investing in mutual funds, etc.

    In this article, let us understand the accrued income, examples, and usages.

    What is Accrued Income?

    Accrued income refers to the money you have earned but has to be received in the future within the specified accounting period. Many individuals or firms are investing in mutual funds, or multiple companies decide to come together and pool their assets to invest in mutual funds in the hope of earning income in the possible future. 

    Some multiple firms and companies also bring about the income without actually having it, as it comes under the accrual accounting system.

    Now after understanding the accrued income meaning, let’s check out how to calculate it with the help of a formula.

    Formula:

    Accrued income is based upon the accounting equation, which says that the total sum of liabilities and the holder’s capital equals the total assets of the business firm. It will help if you read more about Profit & Loss A/c. For this, an accountant must pass the debits journal entry and read more accrued Income A/c and credit Income A/c.

    Calculation:

    There are three ways through which accrued income can take place in any business:

    #1 Rent Income

    Rent income also comes under the Accrued Income, although policies may vary.

    For example, Arya Real estate built a multi-story apartment and decided to give it on rent every quarter instead of taking the rent monthly. In this scenario, the rental income treatment is considered the Accrued Income. This is because it will generate revenue for two straight months simultaneously, but Arya Real Estate will receive its income in the Third month of the same quarter.

    #2 investment

    The retail investors and company also generate income on investment, which is yet to be received in the future.

    For example, Tesla invested $500,000 in Morgan Stanley bonds at a 4 percent interest rate on 1st January. Morgan Stanley will now pay interest of $10,000 to Tesla on 30th June and 31st January. 

    Tesla, which invests a sum of $500,000 at the end of the first month on 31st January, will not receive a sum of $1,667 in the same year. So till 30th June, the amount received by Tesla on 31st January will be an accrued income for the company as Tesla knows that they received a sum of $1,667 on their investment on Morgan Stanley bonds. Still, they will receive their accrued income in the future.

    #3 Income from Services

    It happens when the service provider agency provides its services to their respective clients, and the clients here promise the company to pay in the future for their services; in general terms, it is regarded as the accrued income. Now let’s further understand the concept with the help of an example of accrued income.

    Accrued Income Example.

    The Rana insurance company has rented Wilmer limited a $6,000 per month. On 31st December 2021, Rana Insurance showed the total outstanding rent of $12,000, which was received on 15th January 2022.

    Its Journal entry will be:

    #When income will be accounted for.

    31st December 2021.
    Accrued Income A/C
    Debit
    $12,000
    Income Account A/C
    Credit
    $12,000
    Accrued Income accounted for

    #When Payment is received.

    Cash A/C
    Debit
    15th January 2022
    $12,000
    Accrued Income A/C
    Credit
    $12,000

    Limitations:

    • Accrual accounting will be a demanding and hectic job for small businesses as hiring an expert to manage such core technical accounts is required.
    • The lengthy reporting is the essential requirement for the Accrued Income, which is a complex and time-consuming process as it is opposed to accounting done on a cash basis. It generally happens when it comes to the splitting of the interest income and accrued income over a longer time.
    • Accrual accounting does not let businesses escape from taxes by any means. So the thing here to keep in mind is that you should recognize the income before it is earned. You also must pay taxes on that certain income before it comes into your pocket.
    • The Accrued Income will be very complicated and hazy if the accrual accounting paints an untrue picture of that particular firm in case the business has seasonal or cyclical earnings.
    • If the accrual accounting is misused, the accrual accounting can create chances for executives and the management of the particular firm to report sales and revenue to gain advantages from the incentives and commission.

    Conclusion.

    • Accrued income is essential for any Individual’s overall financial year, company, or financial balance sheet. So it is imperative to understand Accrued Income when it comes to the hard-earned money of your own business. 

      This article will help you with your long-term business and retail investment in the areas such as real estate, mutual funds, and other critical areas of investment you are looking for.

    Hyperlink

  • How to use a Pivot Table in Excel

    How to use a Pivot Table in Excel

    Pivot tables are one of the most powerful features in Microsoft Excel, and they’re great for analyzing data. You can use them to summarize large amounts of information into meaningful, concise reports. The best part is that pivot tables are easy to create. This article will help you learn more about pivot tables and how to create one in excel.

    What is a pivot table in Excel?

    A pivot table is a powerful Excel tool that helps organize, summarise, and analyze data. It is a dynamic table that can be updated automatically. They are not limited to any range of cells as they work with data sources like text, numbers, or formulas.

    Pivot tables do not change when you change the source data, so they are used in business, finance, and marketing, where changing the source data may happen frequently or even daily. Hence, it could be challenging to keep track of all these changes manually, which will take lots of time if you don’t have an automated solution like pivot tables that can do this job without wasting much time or effort. 

    What are the Uses of Pivot Tables?

    Pivot tables can be used to quickly summarise large amounts of information, and they’re a great way to compare different data sets. Here are some common uses of pivot tables:

    • Data Analysis

    The pivot table is a powerful feature of Excel, which allows you to analyze your data and make sense of it. For example, if you have sales data and want to know how many sales were made by each employee concerning the product they sold, you can use the pivot table in excel.

    • Data Exploration

    You can also look at different scenarios using Pivot Tables. For example, if one month has high sales while another has low sales, you can compare which items sell better than others by creating multiple reports based on this information.

    • Data Summarisation

    You may need to summarise large amounts of data into a single table. A pivot table can make it easy for management or other people involved in decision-making processes, such as marketing agencies. For example, they may be interested in seeing how certain factors affect their business performance over time using visual representations like bar charts, pie charts, etc. This lets them view their information together rather than doing calculations.

    How to Use a Pivot Table in Excel?

    • Organize your Data

    It can be overwhelming to understand where to start if you’re dealing with a large amount of data. It is important to organize your data beforehand to make the most of your pivot table. It can also be helpful to think through what you’re trying to learn from your data. 

    • Is there a question that you want to be answered? 
    • What do you hope to find out by looking at the data? 

    By answering these questions, you can determine the most important fields and where they should go in your pivot table.

    • Insert the Pivot Table

    Choose the data you want to analyze. Next, click the pivot table icon in the ribbon and then select OK when prompted to select a cell location for your new pivot table

    Select a cell outside of any existing pivot tables on your worksheet, and then choose Insert > PivotTable > Choose Location on Current Sheet (or press Ctrl+Alt+M). Choose one cell in each range that you want to include in your pivot table:

    • Setup the Pivot Table Field

    Once you have your data sorted, the next step is to set up your pivot table. To do so:

    • Select the field you want as rows from the “Data” tab.
    • Click on the “Insert” menu and then select PivotTable in it.
    • In the Create PivotTable dialog box, click on the “Fields…” button under Choose fields for your report section in the first row of this dialog box to open the Field List window. Select any two columns from the list available there and drag them into Row Labels and Values lists, respectively, in the left side pane of the Field List window.
    • Sort the Table

    To sort the table:

    • Click the pivot table field you want to sort.
    • Click the dropdown arrow at the right of your chosen field name and select Sort.
    • Select either Ascending or Descending from the first dropdown menu that appears in order to determine whether you want your results arranged from A to Z (or lowest value to highest) or vice versa.
    • Choose whether to sort by one column or multiple columns by selecting either “Single Column” or “Multiple Columns” in a subsequent dropdown menu.
    • Finally, choose which column(s) you’d like to be sorted by clicking OK
    • Filter the Data

    You can use filters to show or hide certain data. Let’s say you want to see all the sales that came in on Tuesday. When you start a pivot table, it will have all the days of the week represented as columns and categories. To filter for one day, click on the dropdown arrow next to “Tuesday” in your Pivot Table Field List and select “Show Values As” from the dropdown menu that appears.

    This will remove any rows from the report that don’t contain sales from Tuesday (or whatever day you’ve chosen).

    • Edit the Data Values

    You can edit the data values with a pivot table by clicking on the dropdown menu on your pivot table and choosing the pivot table field. For this, select data values from this menu, and you’ll see a list of fields you have selected for your report.

    Click on one of these items, and Excel will expand your pivot table to show all of those fields instead of just one at a time.

    Conclusion

    Now that you understand how to use pivot tables in Excel, it’s time to put these skills into practice. The best way to learn how to create pivot tables is by trying it out yourself. The more you practice, the better you will become at using this powerful tool.



  • Why You Shouldn’t Miss Out on the Return On Capital Employed (ROCE) Indicator

    Why You Shouldn’t Miss Out on the Return On Capital Employed (ROCE) Indicator

    An investor’s biggest concern is whether a company will yield profits or not. To find out if a company is worth taking a risk for, we take the help of various profit-measuring metrics. 

    These financial ratios calculate the overall financial health of a company. So, you can make informed investing decisions. In the following article, we will discuss Return on Capital Employed (ROCE) indicator and why you shouldn’t ignore it while investing.

    What is Return On Capital Employed?

    Before giving you the generic definition of ROCE & its importance, try to answer a fundamental investing question- e

    How do you measure the profit-making capacity of a company?

    Checking how much revenue a company makes is a good start? Definitely! But that doesn’t tell us whether a company is profitable since there are always deductions. A company might be sustaining because of huge debts, for instance. 

    Moreover, it removes investors totally out of the picture! So what exactly does this tell you?

    As an investor, you would like to know how much profits it can make based on its capital. If it can make more money per rupee (of its capital), the more profits its investors will get.  

    ROCE is a financial ratio that tells how efficiently a company utilizes its capital to yield profits. 

    To find out the ROCE of a company, divide a company’s operating profits, which are also known as EBIT, by its capital employed.

    Formula of ROCE: (EBIT/ Total Capital) *100

    Here, EBIT = total earnings before tax and interests.

    Total capital = Equity capital + debt capital 

    You can also obtain total capital by subtracting total liabilities from total assets. 

    There are many benefits of ROCE. Two major benefits of ROCE are:

    – It helps assess a company’s profitability and growth over time

    – ROCE helps in comparing two companies and which is better for investing

    Now, let’s discuss two of these in detail.

    Assessing the Company’s Profitability and Growth

    One of the primary benefits of using ROCE is that it helps assess a company’s profitability and growth. While investing, investors, fund managers, and stakeholders use this indicator. 

    A high ROCE ratio is preferable, which indicates that a company is efficiently using its capital to generate profit. Conversely, a low ROCE signifies a company is over-leveraged or that its operations are not as efficient as they could be. 

    Let’s take a simple example to understand this concept-

    Assume that Company ABC has the following financial information for the year ended 31 December 2021:

    Total assets = Rs 5,000,000

    Non-operating assets = Rs. 100,000

    Current liabilities = Rs. 200,000

    EBIT = Rs. 300,000

    Tax rate = 20%

    ROCE is calculated as follows: Net Operating Profit After Tax (NOPAT) / Capital Employed

    Where,

    NOPAT = EBIT * (1 – Tax Rate)

    Employed Capital = Total Assets – Non-Operating Assets – Current Liabilities 

    Using the above information, we can calculate Company ABC’s ROCE as follows:

    NOPAT = EBIT * (1 – Tax Rate)

    = Rs 300,000 * (1 – 0.2)

    = Rs 2,40,0000

    Capital Employed = Total Assets – Non-Operating Assets – Current Liabilities

    = Rs. 5,000,000 – Rs. 100,000 – Rs. 200,000

    = Rs. 4,700,000

    Return on Capital Employed = (Rs 2,40,000 / Rs 4700000)* 100 = 5.1%

    Therefore, Company ABC has a ROCE of 5.1%. The low percentage suggests that the company is over-leveraged and is not running its operation as it should, implying it could be a poor choice for investment.

    Comparative analysis of companies with different capital structures

    Another reason why ROCE is significant is that it lets you evaluate the profitability of two businesses. If both have the same ROCE, they make the same profit for each rupee of capital employed. 

    However, if one has a higher ROCE than the other, it is more profitable and generates greater profits for each rupee of capital employed. You can compare the ROCE of the companies to check which would be a better investment. Let’s see an example to understand this concept. 

    Suppose there are two companies: X and Z. Recently, both the firms made equal profits. Which company would you choose, X or Z? 

    Since we are short of information here, it is hard to tell. 

    Now, let’s say company X makes a profit of Rs. 200 on sales of Rs. 1,000, while Company Z makes Rs. 250 on Rs. 1,000 of sales. If we compare the two in terms of profitability, X has a 20% profit margin, while company Z has a 25% margin. 

    However, if we say X utilizes Rs. 500 of capital and B Rs. 1,000. And we found out X has a ROCE of 40% (200/500), whereas Z has a ROCE of 25% (250/1,000). 

    Based on ROE, which would you choose?

    X is a better investment because it will shell out more money. And which, if invested back into the company, will benefit the shareholders more.

    Limitations of Capital Employment Indicator

    There is no doubt that ROCE is one of the financial ratios to consider when investing. But it is not a perfect metric. No single metric guarantees that/this company is worth taking the risk. Though, ROCE can give you an idea, which you can verify with other metrics such as Return on Equity (ROE). 

    Some of the limitations of ROCE are-

    • It varies as per the accounting policies.
    • ROCE does provide correct information on the performance of companies with large cash reserves.

    The Key Takeaways

    ROCE is all about the profit-making capacity of a company on its capital. In simple terms, it tells investors how much profit a business makes for every rupee invested. Calculating ROCE is easy. You divide its total earnings before tax and interests by the sum of total equity and total debt. 

    The financial ratio has many benefits. From assessing the growth and profitability of a business to comparing two companies with different capital, ROCE is one of the most reliable performance indicators for investors. It also tells how much a company is gaining from its investors. 

    Regardless of its benefits, ROCE is not a standalone metric for investment. It has some limitations. For instance, it may not provide correct information on the performance of companies with large cash reserves. Thus, you should refer to other metrics as well. 

  • A Guide to Calculate Variance in Excel

    A Guide to Calculate Variance in Excel

    A Guide to Calculate Variance in Excel

    Variance is an essential financial measurement that is used for all types of businesses. Variance can play an important part whether you are trading futures or want to understand the performance of different assets in your portfolio. 

    What is variance?

    Variance can be described as a measure to analyse how far numbers of a set are from the mean value. From a practical point of view, it shows how much something tends to alter. Hence, variance measures the variability in the data set. Mathematically, it is the average of differences(squared) from the mean value. 

    Let’s look at an example below to understand how you can use variance in your life.

    Suppose that there are 5 children in your locality. The ages of these children are 14, 10, 8, 6 and 2.

    The mean would be:

    14 + 10 + 8 + 6 + 2

    ————————— =  8

                    5

    Now that we’ve calculate mean, variance can be calculated using simple steps.

    1. Calculate the mean value of all the values i.e 8.
    2. Subtract the mean from each number to compute the differences between the mean value and the actual value. The differences for each of the items (14, 10, 8, 6 and 2) would be 6, 2, 0, (-2), and (-6).
    3. It’s time to find the square of each of the different values. These would be 36, 4, 0, 4, and 36.
    4. Now, calculate the average of all the squared differences. It would be:

    36 + 4 + 0 + 4 + 36

    ————————— = 16

                  5

    1. The variance comes out to be 16 in this case.

    But what is the purpose of calculating variance? What does this 16 signify?

    Variance is used to compute differences in the data set. The smaller the number, the lesser the data set would spread. The larger the number, the more dispersions will be. The number 0 means there isn’t any variability in the data set.

    What are the advantages and disadvantages of calculating variance?

    Advantages:

    • Variance gives a better insight into the groups covered in the data set, as seen in the above example.
    • Variance treats all the differences/deviations from the mean as they are, even without paying attention to their directions.
    • Variance is widely used in many fields, including finance, where investors can calculate risk.

    Disadvantages

    • Data gets skewed when there are numbers far from the mean. Hence, sometimes, additional weight might be given to such numbers.
    • Interpretation of variance is not always easy for everyone. 
    • Standard deviation might be a better option than variance and is often used more than a variance.

    How to calculate variance in excel?

    To calculate variance in excel, you need to know the variance formula. Since there are inbuilt features, calculating variance in excel is an easy task. 

    Generally, variance is calculated for a sample and population. Let’s look at how to calculate the variance of a sample in excel.

    Calculating the variance of a sample

    Suppose you are interested in a rare animal found in America. You have collected 15 samples and computed their length in meters.

    Now, to calculate the variance of a sample, you’ll use the VAR.S function in excel.

    = VAR.S (value 1, value 2, value3, value4, ……..value 15)

    Let’s find out the variance.

    Step1. Enter your entire data in a single range of cells(all the values of 15 samples) in excel.

    Step2. For calculating variance, enter the formula: 

    Variance =VAR.S(A2:A15)

    Step3. The variance for your sample will be displayed in the next cell.

    Note: Three functions can be used for calculating the variance of a sample ( VAR, VAR.S, VARA). For VAR and VARA, excel version 2000-2019 is required. For VAR.S excel version 2010-19 is needed.

    Calculating the variance of a population

    Now let’s say instead of a sample, you’re interested in the entire population of the animal in the whole world. There are 100 species in total.

    You must keep in mind that calculating variance for a population requires a different formula from the sample one, i.e. VAR.P function.

    Now, to calculate the variance of a population, you’ll use the VAR.P function in excel.

    = VAR.P (value 1, value 2, value3, value4, ……..value 100)

    Let’s find out the variance.

    Step 1: Enter your entire data in a single range of cells(all the values of 100 samples) in excel.

    Step 2: For calculating variance, enter the formula: 

    Variance =VAR.P(A2:A16)

    Step 3: The variance for your population will be displayed in the cell.

    Note: Three functions can be used to calculate a sample’s variance ( VAR, VAR.S, VARA). For VAR and VARA, excel version 2000-2019 is required. For VAR.S, excel version 2010-19 is needed.

    Similarly, three functions can be used to calculate a population’s variance ( VARP, VAR.P, VARPA). Excel versions required are 2000-19 for VARP and VARPA and 2010-2019 for VAR.P.

    Importance of variance in finance

    Variance holds a special space in finance like any other field. It is used to compare the performance of all the assets in a portfolio to attain the best asset allocation where risk is minimised, and returns are maximised. 

    Let’s have a look at an example where our interest lies in the prices of the stocks and their returns. 

    We observed the stock’s prices and returns for 10 days. The stock prices were Rs 100, 120, 105, 110, 125, 130, 140, 135, 125 and 130 respectively. The returns as observed were 20.0%, -12.5%, 4.8%, 13.6%, 4.0%, 7.7%, -3.6%, -7.4% and 4.0%. 

    The variance would be 0.082, and the standard deviation (square of variance) would be 9.05% when we use the variance formula that we mentioned earlier.

    Variance for investors

    Variance assists investors in making investment decisions. Let’s say you are an investor with a high-risk tolerance. Then you’ll look for investments with high risk. High-risk investments usually have a high variance. Investments with low risk(low variance) are considered ideal for conservative investors.

    Variance explains or computes the risk associated with investments that whether a particular investment is expected to perform better than/worse than the expectations. 

    But can you reduce variance without affecting expected returns? Absolutely. It can be done by diversification. Diversification across various types of investments(stocks, bonds, REITs etc.), economies and sectors can help you achieve your financial goals.

    Conclusion

    Variance is used in many fields for different purposes and holds a significant position in finance too. It shows how data points in the data set vary from each other. Investors can use variance to predict risk and returns for their investments. Usually, investments with high variance come with high risk and, thus, a high possibility of extreme returns. 

  • Difference between Simple Interest and Compound Interest

    Difference between Simple Interest and Compound Interest

    Introduction

    Interest, which is one of the most commonly used financial terms is nothing but the cost of borrowing money. When one borrows money from a financial institution, they pay an annual interest in lieu of the money that is borrowed. Interest is generally expressed in percentages and it can either be simple or compounded. One of the major differences between simple and compound interest is the way in which interest builds up.

    Before diving into the details, let us first understand the meaning of simple and compound interests.

    What is a Simple Interest?

    Simple interest is the percentage that is charged on the principal sum of money that is lent or borrowed. Similar to this, when you deposit a particular amount in a bank, you can also earn interest. The concept of simple interest is widely used in many industries, including banking, mortgages, autos, and other financial institutions. 

    The formula used for calculating simple interest is as follows:

    SI = (P * R * T) / 100

    Where, 

    SI = Simple Interest 

    P = Principal

    R = Rate of interest (expressed in percentage)

    T = Time duration (in months or years)

    If time, rate of interest and the principal amount is known, the simple interest can be calculated using this formula.

    To calculate the total amount (A):

    Total Amount (A) = Principal (P) + Interest (I)

    Where,

    Principal (P) – The amount that was first put in a bank or borrowed is known as the principle. 

    Rate of interest (R) – The interest that is charged on the principal amount.

    Time (T) – This is the time frame during which money is deposited or borrowed. Typically, time is described in terms of months or years. 

    Amount (A) – The total interest and principal for a specific time period are added to determine the amount.

    For Example, 

    If my friend deposited 100,000 rupees in a bank for 3 years and it accrued interest at a rate of 4% annually.

    Then, 

    Principal (P) = 100,000

    Time (T) = 3 years

    Rate (R) = 4% p.a.

    The values in the simple interest formula should be substituted;

    SI  = (P * R * T) / 100 

          = (100000 * 4 * 3) / 100 

          = 12000

    She earned an interest of 12000 rupees

    The total amount received by her would be 

    A = P + I

        = 100,000 + 12,000

        = 112,000

    What is a Compound Interest?

    The interest that is calculated on both principal and previous interest and is compounded on a regular basis is known as compound interest. The interest is computed on a new principal every time. This principle is the cumulation of the accrued interest and the original principal.

    The formula for calculating the amount: 

    Compound interest can be calculated annually, semi-annually, quarterly, or even monthly. This is similar to how reinvested interest in an investment accelerates the growth of the principal over time. It is exactly what money does due to compound interest. Banks and other financial institutions only calculate the amount using compound interest.

    The total amount at the conclusion of the time period, which includes the principle and compound interest, is represented by the formula above. Moreover, by deducting the principal from this sum, we can get the compound interest.

    To compute compound interest:

    In the above expression,

    • P is the principal amount
    • r is the rate of interest(decimal)
    • n is frequency or no. of  times the interest is compounded annually
    • t is the overall tenure.

    For example, 

    If an investment yields a monthly compounded return of 4%. Let’s calculate the value after 5 years, on rupees 7,000 initial investment.

    Earnings of 4 percent compounded monthly are calculated using the formulas (r) = 0.04 and (n) = 12. The first investment or (P)=7000 and the time period or (t) = 5

    Let us first calculate the value of A (the value after 5 years). Apply the formula now using the values that are known:

    A = P (1 + r / m)mt

        = 7000 ( 1 + 0.04 / 12) 12 * 5

        ~ 8547

    Now, the compound interest can be calculated by subtracting the principal from the final amount

    CI= A – P

    CI= 8547 – 7000

    CI= 1547

    What is the power of compounding?

    The power of compounding is the process through which interest accrued and is added back to the principal amount over time, increasing the value of an investment. Investors use the concept of compound interest to leverage the power of compounding. Compound interest raises the potential interest for the subsequent cycle by earning interest on your principal amount and adding it back to the principal.

    The advantages of the ability of compounding are as follows:

    • It assists in significantly increasing the principal amount over time.
    • It enables investors to generate returns while also raising the return potential for the following cycle.
    • When compared to simple interest, the power of compounding accelerates the rate of return on investments.
    • Any financial instrument can use the power of compounding to boost its return potential.
    • In-depth financial understanding is not necessary for successful implementation.

    Difference Between Simple Interest and Compound Interest?

    If put in the simplest way, simple interest is beneficial if you are borrowing money, whereas compound interest is helpful if you are investing. For borrowers like us, simple interest is preferred because you aren’t paying interest on interest. Simple interest makes paying off debt easier.

    Compound interest, on the other hand, can help you build wealth over time as the earnings retained here produce income.

    Another important point of distinction is that while the principal remains constant when computing simple interest, it varies for the calculation of compound interest.

    Conclusion

    Both simple and compound interests are widely used for interest calculations and are important to understand. While simple interest is common for taking short-term debts which last for less than a year, compound interest is mostly applied on loans having longer time periods. 




  • Commercial mortgage-backed securities (CMBS)

    Commercial mortgage-backed securities (CMBS)

    If you’re considering getting into the commercial real estate market, it’s a good idea to get familiarized with CMBSs. This post will give you a better understanding of what they are and how they can help you.

    Commercial mortgage-backed securities, or CMBS as they are popularly called, are fixed income securities with an underlying commercial real estate as a mortgage for the payment of coupons and principal invested. Unlike the traditional mortgage-backed securities, which have residential real estate as underlying mortgages, CMBS have commercial properties as the mortgage.

    Purpose

    The major purpose of CMBS, like MBS, is to provide liquidity options to commercial lenders. They allow the lenders to reduce the risk of their financing by allowing them to create derivatives of the loans into financial instruments and sell them out in the commercial market as investment opportunities. Meanwhile, it also gives investors the ability and risk appetite to invest in these instruments and generate regular cash flows through coupon payments. Retail investors can invest in these instruments through third-party products such as mutual funds and exchange-traded funds (ETFs) that specialize in investing in such products. Direct investments in such products are limited to ultra-high net worth individuals and family offices due to the large ticket size in these products.

    Structure

    The structure of CMBS works on the pooling of loans given by lenders for commercial properties. These loans are pooled together on the basis of their cash flow to create fixed-income securities that they can sell to investors. The securities are divided into multiple layers basis the risk that they carry in terms of credit and loss. The major classification of these securities include:

    Investment grade bonds – These are securities that carry lower risk in terms of credit and loss and thus have better credit ratings such as AAA, AA, and other higher ratings from credit rating agencies. These are considered safer investment opportunities for investors.

    Non-investment grade bonds – These are pooled commercial loan accounts that carry a higher risk of credit and loss compared with investment graded and thus are lower by credit rating agencies such as BB, B, etc. Since these carry higher risk, they are suitable for investors with a risk appetite. They will, however, have a higher coupon to compensate for the larger risk. 

    Unrated bonds – These bonds carry the highest risk in terms of credit and loss probability and thus are unrated by credit risk due to this potent danger. Investors only with the highest risk appetite and ability to bear the loss should invest in such bonds.

    Diagrammatic representation of CMBS  

    Benefits

    CMBS have multiple benefits across the value chain for borrowers, lenders and investors.

    Borrowers – Since the borrower is mortgaging their property for the loan, they can procure a lower interest on the monies. Further, they can also generate a higher value of loan basis the valuation of the underlying property. Further, in many cases, the upfront fees are also lower than traditional loans lowering the overall cost to the borrower.

    Lenders – The most significant benefit to the lender is that they can securitize the loan portfolio, thus improving the overall cash flow in their financial portfolio. They can also enhance their loan portfolio, thus improving their overall balance sheet size and revenue opportunities.

    Investors – It provides investors with an opportunity to invest in a fixed income portfolio of securities basis their risk-return appetite considering the wide type of bond tranches available in this segment.

    Drawbacks

    While CMBS loans are a suitable conduit for all parties in the CMBS ecosystem, there are also some drawbacks to these securities.

    High valuation – Since these bonds are pooled loan accounts, these are of high value, which is beyond the reach of individual investors who want to take exposure to these securities. Only ultra-high net worth individuals or family offices tend to have the monies to directly invest in these securities, limiting the investment opportunities for investors. Investors need to route their investments through ETFs or mutual funds that invest in these securities.

    Complex – These CMBS loans have a complex structure compared with traditional loans since they need to be collateralized before they are securitized. Further, since the underlying securities are commercial properties, the valuation is relatively complicated compared with residential properties. Because of the complexity of the products, these instruments require multiple participants in the value chain, which includes various types of servicers, trustees, custodians and credit rating agencies, to finally be put up these instruments in the market for investment purposes.

    Summing up

    CMBS are an excellent conduit to convert commercial lending into collateralized fixed income securities for investment purposes. However, unlike traditional mortgage-backed securities (MBS), CMBS loans are mortgaged on commercial properties and thus are more complex than the former. Investors should look at the underlying tranche of CMBS, such as investment grade, non-investment grade and unrated bonds, to identify the risk of credit and loss before making any investment decision basis their risk-return profile. Individual investors can route their investments in these instruments through mutual funds or ETFs that invest in such securities. In contrast, ultra-high net worth individuals and family offices can afford to invest directly in these instruments.

  • Capital Expenditures – Definition, Overview and Examples

    Capital Expenditures – Definition, Overview and Examples

    Imagine you are at an airport. Try looking closely at the aerodrome area where your aircraft is parked for departure. Those airlines must spend millions to maintain such large aircraft, upgrade technologies and buy passenger buses with growing demand every year. Depending on the model, even an outdated commercial aeroplane can easily cost a few million in maintenance. The investments put into these long-term assets by the airline companies for purchase and upgradation to improve the efficiency of the airline company is basically what we call capital expenditure. Let’s look into more details.

    What are Capital Expenditures?

    By definition, capital expenditures (also known as CapEx or capital expenses) are large investments in long-term assets that businesses undertake to sustain or grow their operations, such as buildings, machinery, pieces of equipment, land, furnishings and fittings.

    Capital expenditures significantly impact the financial position of an organization both in the short and long term. Making informed CapEx decisions is therefore crucial for a company’s financial stability. 

    Types of Capital Expenditures

    A capital expense might be either tangible such as a machine—or intangible—like a patent. 

    The expenditure made by the company in either of the below 4 areas is generally categorized as a capital expenditure. 

    Expenditure on Diversification

    Some expenses are made in order to expand the company’s offerings and attain multiple goals.

    Expenditure on Expansion

    The completion of new projects or the expansion of the existing asset base that aids in boosting production capacity

    Expenditure on Replacement

    Outdated machinery and equipment that needs to be replaced due to deterioration, ageing, and technological advancement.

    Making Strategic Investments

    Decisions about strategic investments lead to the purchase of assets like land, property, etc. That will assist the company in the long run.

    Importance of Capital Expenditures

    For instance, you operate a local food cafe and you want to start a delivery system with the profits you gained in a year. Would you buy a new van, rent out one or hire a contract delivery service? Your decision should be smart enough to make your business grow, develop reach to a greater number of potential customers and generate profit.  

    Smart capital investments support business expansion. From the standpoint of long-term financial planning, CapEx analysis helps decision-makers in determining if an asset will deliver a good rate of return. 

    Some other important considerations are:

    Long-term effects

    Effects of CapEx continue for an ample amount of time. A business’s ease of operation now could be due to previous CapEx. 

    High fixed cost

    While spending on fixed assets may be costly at first, there are significant potential long-term benefits for businesses or organizations.

    Depreciation 

    CapEx leads to an increase in the asset account. This result is a rise in depreciation once the capital assets are used. Hence, the value of the capital asset decreases and the company gains tax advantages as well.

    Business Valuation

    CapEx is a significant factor in business valuation and evaluating the new worth of the entity. The valuation of the existing capital assets is crucial in cases of business sales, merger and acquisition agreements, etc.

    Challenges with Capital Expenditures

    Despite the importance of capital expenditure decisions, some capital expenses may add to the complexity. Here are some challenges:

    Unpredictability

    Large capital asset investments by businesses with the aim to increase profitability may sometimes result in losses, as some outcomes aren’t always assured. Even though it is impossible to completely remove risk, companies must account for it during financial planning to reduce the possibility of losses.

    Temporal Expansion

    Both industrial undertakings and infrastructure projects often spread out the expenses and benefits of capital expenditure over a considerable amount of time. A temporal gap of this magnitude makes it difficult to estimate the discount rate and establish equivalence.

    Issues with measurement

    Identifying, quantifying, and predicting the expenses associated with capital expenditures can be a challenging accounting process.

    Efficient Capital Expenditure Budgeting Practices

    Budgeting for capital expenditures is a key management task. Making the right choices might help the firm reach new heights. However, given the sum of money at stake and the length of these initiatives, one bad decision might push the company to close down. Here are a few techniques:

    Create a Plan Before You Begin

    Finding the project’s scope, setting reasonable timelines, and making sure the entire plan has been reviewed and authorized are necessary before beginning a project. You should consider how many internal resources, such as labor, supplies, money, and services, the project will need.

    Think long-term

    You must decide whether you will borrow money to buy the capital asset or set aside cash reserves to make a purchase. Typically, saving money for a purchase means that you will have to wait a while before receiving the asset you want. However, taking on debt and risking future borrowing issues are both consequences of borrowing money.

    Both options may benefit your business in the long run. You just need to decide which option is better for which project.

    Gather Accurate Data

    You need to obtain credible information in order to develop the budget and produce reports.

    Use effective budgeting tools

    The kind of budgeting software you choose should be based on factors including the project’s scope, the program’s speed, and the likelihood of mistakes.

    Form Clear Policies

    A big firm may have a significant number of people and departments involved in managing capital expenditures, thus it is important to establish clear policies that everyone can adhere to in order to keep the budget on track.

    Levels of Details Should Be Optimal

    A budget that is made with too much detail may take too long to create and, by the time it is finished, it may contain information that is no longer relevant. So, an ideal balance is necessary.

    Capital Expenditures Example

    Before looking into the example, let’s check out the formula to calculate CapEx:

    CapEx = PPE (current period) – PPE (prior period) + Depreciation (current period)

    where, PPE is Property, Plant & Equipment.

    You own a coffee shop, and you recently purchased a new coffee maker, some furnishings, and a new computer. All this is done to boost sales for the coming year.

    The information required to determine CapEx for that year, after looking at the balance sheet and income statement, is as follows:

    At the start of 2019, PPE was $10,000 and by the end, it was PPE: $20,000. Depreciation: $5,500

    CapEx = $ [(20,000 – 10,000) + 5,500]

                = $ 15,500

    Hence, the capital expenditure = $15,500.

    Wrap Up

    Capital expenditures help businesses to acquire, maintain, or enhance assets. It can be either a tangible asset like a machine or an intangible asset like a patent. Capital expenditures might be categorized as (1) costs to maintain current levels of operation inside the organization and (2) costs to support increased future growth. CapEx analysis helps decision-makers decide if an asset will generate a good rate of return from the perspective of long-term financial planning. Since its rate of return might be unpredictable, having an effective CapEx budget is an ideal solution for every company.

  • Carriage Inwards (Freight Inwards) – Meaning, Debit or Credit?

    Carriage Inwards (Freight Inwards) – Meaning, Debit or Credit?

    Business is nothing but a chain of activities involving capital, labor, and innovation to produce goods and services. One such vital aspect of holistic business operation is – the movement of goods to the intended stakeholders. 

    There are different stages of business operations that rely on diverse sources of input and output resources. So, in accounting, the cost of shipping or handling goods is categorized into two segments: carriage inwards and carriage outwards.

    Today, we will talk about the carriage inward meaning, its accounting application, and the basic differences between carriage inwards and carriage outwards. 

    What is Carriage Inward?

    Carriage Inward is the cost incurred during transit of the goods or assets purchased. It constitutes all the expenses obtained while transporting goods. When the buyer makes purchases of capital assets, raw materials, or inventory, they need to be consigned to the intended locations, such as warehouses or business areas, for further operations.

    Let’s see an example of a carriage inwards journal record.

    A company purchases goods worth ₹10,000 and pays an additional ₹1,000 as freight inwards, i.e., cost of transportation.

    (Being carriage inwards paid while purchasing goods)

    Accounting Treatment of Carriage Inwards

    In the books of account, freight inward is treated as a direct expense and included in the cost of purchased goods. We display it on the debit side of the trading account. The buyer is liable to pay all such expenses related to transit.

    Journal Entry: Purchasing Goods

    Carriage inwards in trading account shown on the debit side, while purchasing inventory or goods.

    (Being carriage inwards paid while purchasing inventory)

    The next step is transferring freight inwards to the trading account. The buyer may add value to the COGS (Cost of goods sold).

    (Transferring of carriage inwards to the trading account)

    Journal Entry When Purchasing Fixed Assets

    When purchasing a fixed asset, carriage inwards is treated as a part of capital expenditure. Here, the shipment costs are added to the overall cost of the fixed asset. 

    (Carriage inwards is paid inclusively with the purchase of a fixed asset)

    Differences between Carriage Inwards and Carriage Outwards

    Popularly, there are two types of transit expenses – carriage inwards and carriage outwards. One represents the expense of procuring goods or assets from the supplier, whereas, the other denotes the transportation charges of selling goods to the customers. 

    We have learned about freight inward meaning and its accounting treatment. Let’s find out the meaning and its accounting application.

    Carriage Inwards vs. Carriage Outwards

    Carriage outward and carriage inward in trial balance are shown on the debit side, as both are recorded as expenses. There are some fundamental differences as well. We will look into these distinctions and their application in the books of accounts.

    Here is a comprehensive table detailing the differences between carriage inwards and carriage outwards:

    Basis
    Carriage Inwards
    Carriage Outwards
    Meaning
    Expenses incurred for transit/freight while purchasing goods.
    Charges incurred for transportation/freight while selling or delivering the goods.
    Borne By
    The buyer bears it most of the time while purchasing the goods.
    The seller or buyer of the goods bears the expense, as per the terms of the sale.
    Type of cost
    It is a direct expense and forms part of total goods costs for the purchaser or buyer.
    It is an indirect expense and forms the part of selling and distribution costs for the seller.
    Accounting Treatment
    Carriage inward is shown on the debit side in the books of trading accounts.
    Carriage outwards comes under the debit side in the books of the profit-and-loss account.
    Capitalization
    Capitalized only when a fixed asset is purchased.
    It is a revenue cost and is never capitalized.
    Other Names
    Freight inward, freight in or transportation inward
    Freight inward, freight in or transportation inward

    Conclusion

    Transportation of goods is a vital aspect of business operation. Carriage inwards is a transit cost paid by the buyer of the goods. It is associated with the process of buying goods or raw materials and making finished products. Hence, all the expenses are included in the calculation cost of goods sold. 

    If a business is purchasing a fixed asset, it will include the expenses in the overall cost of the acquisition.

    Mostly, buyers are liable for the cost of carriage inwards. However, in rare cases, the transportation cost is split between buyer and seller as per the sale agreement. It is essential to record transportation costs appropriately in the books of buyers and sellers for better understanding.