How to perform Vertical Analysis of Income Statement (Coca Cola vs Pepsi)

Download the practice file by clicking on the link below if you would like to practice along with me.

Download Link:

https://learnaccountingfinance.com/wp-content/uploads/2021/03/vertical-income-statement-analysis-coca-cola-vs-pepsi-download-free.xlsx

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

In this video, I explain vertical analysis of income statement (in Excel) by comparing the real income statements of Coca Cola and Pepsi.

What is vertical income statement analysis?

Vertical analysis is a top to bottom analysis of income statement where amounts for all line items in the income statement are converted to a percentage of a base amount (usually total revenue or Net Sales). This analysis is done to see the relative size of each type of income or expense with respect to the revenue (base).

When is Vertical Analysis used?

Vertical analysis of income statement can be used when trying to understand the size and significance of the components of income statement (hence reflected in percentage), and also to compare financial statements of difference companies either in the same or different industries, which may or may not be of similar size or revenue base. Converting amounts into percentage gives a particularly good idea for comparison, as you will see in the video above. Although Pepsi’s total revenue is more than double Coca Cola’s revenue, you can still compare the two income statements and analyze them to make informed decisions.

Vertical Analysis vs Horizontal Analysis

While vertical analysis looks at the components of income statements and their relative size, horizontal analysis looks at changes in the financial statements over a period of time. It is usually reflected in terms of year over year growth or decline.

Connect:

https://www.instagram.com/learnaccountingfinance

Home

Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Course: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://www.udemy.com/course/learn-financial-analysis-of-variances-in-profit-and-sales/?couponCode=YOUTUBE10

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.

Sort Pivot Table Values largest to Smallest, by Names, Dates and More!

Download Link

Download the practice file by clicking on the link below if you would like to practice along with me.

https://learnaccountingfinance.com/wp-content/uploads/2021/03/pivot-table-sorting-tutorial-data-shared.xlsx

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

Learn how to sort pivot table data from largest to smallest values and vice versa for multiple columns including Customer names, months and Values. In this video, I will explain the basics and advanced uses of Sorting Pivot Table Data.

Sort Pivot Table values from Largest to Smallest:

We start with very simple sorting of Customer Names based on the largest value of Sales amount. Then we start adding other fields in the pivot table and see how it impacts the Sorting.

Sort Pivot Table Manually

E.g. we add the countries in the Pivot Table report, and manually change the order resulting in Manual Sorting of the Data.

Sort Pivot Tables by Subtotals and Grand totals

We can also sort Pivot Table based on subtotal values or Grand Total values. Just click on the Cell for the field you are looking to sort and then click the sort ascending or Descending button for this to work.

Checking Pivot Table Sort Settings

We can also check current Pivot Table Sort settings by right clicking on any field and Value and then clicking on Sort à More Sort Options. This shows exactly how the current sorting is setup in the Pivot Table.

Sort Pivot Table by Months and Dates

We also take a look at how we can sort dates or months in Pivot Tables. By default, if the dates or months are entered in correct format, the Pivot Table will sort them based on Oldest to Newest. However, we can change that setting and Sort based on values for each date as well as sort from Newest to Oldest date or month.

Issues with Sorting, Errors in Sorting data

Sometimes, you may not be able to sort values when there are no subtotals or Grand Totals to click and Sort on. In this case, you can still sort Pivot tables data even though you do not add the subtotals. You can do this by right clicking on the Field you want to sort by values, and then click on Sort, and then More Options. Then Choose Ascending or Descending Sort option. Finally, select the value field you want to sort based on, from the Drop down selection available.

Connect:

https://www.instagram.com/learnaccountingfinance

Home

Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.

Pivot Table Calculated Field and Calculated Item (Automate Pivot Table Reporting Calculations)

Download the practice file by clicking on the link below if you would like to practice along with me.

Download Link:

https://learnaccountingfinance.com/wp-content/uploads/2021/02/pivot-tables-calculated-fields-and-calculated-items-practice-file.xlsx

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Apply Calculated Field and Calculated Items to your Pivot Tables and automate calculations for reporting and analysis. This is such a time saver for Excel users and something every Excel user should learn. In this advanced tutorial of pivot tables, you will learn the use and examples of apply Pivot Table Calculated Field and Calculated Items options. Here is the link to the video tutorial:

What are Pivot Table Calculated Fields? Calculated Fields are calculations within the Excel Pivot Tables based on the fields or columns already available in the data. You can create many calculations inside the pivot table so that when you slice and dice or update the pivot table, the calculations also get updated with it.

What are Calculated Items? Calculated items represent Pivot table calculations of the data inside each field. So for example, if you have Calendar month, Sales and Standard margin as three fields available in the data set. Any calculation at the filed level such as std margin % calculated from Sales and Std margin field is done by clicking on “Calculated Fields” on the Fields, Items and Sets button of the Pivot Table Analyze menu. However, any calculations at the level of the data itself, for example calendar month Feb minus Jan is done by clicking on the Calculate Item selection of the same menu.

Why is Calculated Item grayed out or turned off sometimes? It matters what field or cell you have selected on the Pivot Table as it impacts turning On or Off of the Calculated Item feature. If you have selected a Values cell, then Calculated Field will be available but Calculated Item will be greyed out. In order to make the Calculate Item option available you will need to select one of the Cells from the Rows section of the Pivot Table.

Can we use Formulas when Calculating Fields and Items? Yes. this is exactly what the Calculated Fields and Calculated Items are for. However, the application of formulas is not entirely the same as the formulas in regular excel cells. Some formulas do not work at all and some formulas do not work the same way as they would work in a regular spreadsheet cell.

How to use IF statement in Calculated Fields and Items You can use the IF Statement with the syntax as normal in the Calculated Fields and Items calculation. Look at the video where I shared how I used the IF function to calculate sales commission %, and then nested AND function with the IF function to calculate a conditional bonus calculation.

What does List Formula do in a Pivot Table Analyze Menu? The list Formula option creates a separate spreadsheet and shows all the Calculated Fields and Calculated items used in a pivot table. This helps you to see any time the calculated fields which are not originating from the raw data set. This is also very helpful when you are reviewing a pivot table file that was prepared by someone else who included calculated items and calculated fields in the file.

I think using advanced pivot table functions such as Calculated Fields and Calculated Items help the Excel users significantly in being productive and creating and refreshing reports quickly with automated calculations. This saves time and avoids chances of mistakes when formulas are maintained outside of the pivot table calculations.

Connect:

https://www.instagram.com/learnaccountingfinance

Home

Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Course: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click on the link for a detailed video course (at a special price). You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://bit.ly/3xjMR8t

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance.

How to lookup Names with Spelling Errors (All kinds of spelling differences, Approximate Match)

Download the file by clicking on the link below if you would like to practice along with me.

Download Link:

https://learnaccountingfinance.com/wp-content/uploads/2021/02/sample-file-fuzzy-lookup-for-download.xlsx

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

How to lookup and have an exact match between two columns where the spellings are different with all kinds of spelling mistakes, spaces and characters? In this video, I will show how you can use Excel fuzzy lookup tool to solve this time consuming problem.

Here is the Link to download the Excel Add-in called Fuzzy Lookup: https://www.microsoft.com/en-ca/download/details.aspx?id=15011

Often you find yourself comparing two reports or data sets where the names or text strings are similar but do not match exactly. As a human, you can tell that they are the same, but you cannot look up data using the exact match features of Vlookup or Xlookup. In this case, the Fuzzy lookup tool comes in handy. In this video, I show you how to install and use the Add-in to lookup Company names, or Customer Names from two separate data sources, so that you dont have to spend time manually finding the names and then copying and pasting the values from one table to the other.

I have used this method when trying to compare sales reports from two different sources which have the customer names, one report has the freight costs by customer and the other report has the sales by customer. When I try to bring the two together by using a vlookup or an Xlookup, I am unable to do that because the names do not exactly match. In addition, the differences in spelling do not follow a set pattern, so I cannot even use wildcard matches or be creative about using additional Excel formulae to help with the lookup. In this case technology becomes really useful. My recommendation is to use the Fuzzy lookup tool or add-in which can be downloaded from the Microsoft website and installed in Excel. This is such a time saver. I will show in the video the setup of the tables to use the fuzzy logic add-in as well as the use of the “Similarity threshold” to help lookup majority of the company names in the example. By the way, the sample data includes Revenues and Net Profits for 25 of US top Fortune 500 companies by revenue. You can also download the sample Excel from the link provided. Hope this video helps!

Connect:

https://www.instagram.com/learnaccountingfinance

https://www.learnaccountingfinance.com

Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

Hope you find the information in the video helpful. If you like to watch more videos in accounting, financial analysis and controller ship, videos that help you directly in doing your job, subscribe to my channel. If you liked the video, I would love if you could LIKE it and leave a comment. If you have any questions or feedback, again leave a comment. Lets stay connected at #learnaccountingfinance #lookupnames #spellingdifference

How to calculate Selling price Cost, Margin, Discount and Rebates (All Considered)

DOWNLOAD LINK (EXCEL TEMPLATE)

Download The Excel file here, if you would like to practice along with watching the video. https://learnaccountingfinance.com/wp-content/uploads/2021/01/calculate-selling-price-with-cost-and-margin-discount-and-rebates-shared.xlsx

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

Do not forget to subscribe to my Youtube Channel.

Note: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates.

How do you calculate selling price of a product with cost and margin, while taking into account discount and rebates offered to the customer. If you have tried this calculation of a selling price of a product which requires not only the calculation of markup as you only have margin %, but also complicating the calculation are the discount and rebate factors, you probably ended up seeing a Circular Reference error in Excel. This is because the Selling price needs to be calculated, but discount and rebate / commission are also calculated based on the selling price. In this video, I will show you how computers and Excel can help.

Here is the Video …

Microsoft Excel comes with a built in Solver add-in that does the calculation for you. The Solver Add-in is an advanced version of the Goal Seek function and can even consider constraints to the calculation. All you need to do is to set up the product cost calculation template in a way that the Solver Add-in can do the calculation for you. If you had to do it on your own, you would have to use the trial and error method. But with the Excel Solver Add-in, you don’t have to worry, as it is very quick and easy to calculate selling price of a product so that you can achieve the target margin as well as consider discount and rebates and commissions (if applicable). So, if you are provided with, say discount of 1% and rebates of 3% that the customer would usually be able to claim, you can consider this in the product pricing decisions, and with the help of this calculation, you can calculate exactly the price you need to sell for, in order to still achieve the margin % that was originally required.

Connect with me:

https://www.instagram.com/learnaccountingfinance

https://www.learnaccountingfinance.com

Thank You!

Learn Accounting Finance

How to use Excel XLOOKUP Function – 7 tips for Reporting and Analysis using XLOOKUP

DOWNLOAD LINK

Click here to download the Excel sample data file so that you can practice along with me. https://learnaccountingfinance.com/wp-content/uploads/2021/01/learn-xlookup-excel-shared.xlsx

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

Do not forget to subscribe to my Youtube Channel

Learn how to use Excel XLOOKUP and what this function can do for you. In this video, I will share 7 practical ways in which you can use the new XLOOKUP function which serves as a perfect replacement for both VLOOKUP and XLOOKUP.

We start with a real life work situation where you have to respond with data requests quickly. The first situation being where the General Manager is asking for Sales for specific customers within 5 minutes. Not only do you provide him the information requested within 5 minutes, but you go above and beyond to provide additional information that he may be interested in. In the second example, your Manager is asking you to complete and send the sales commission file based on annual sales and commission plan. You use XLOOKUP Match mode functionality to quickly respond to the Manager with the completed sales commission report.

In the third example, you have been asked by the Purchasing Manager to provide him help with pulling the most recent purchase price from a long list of materials and purchase history. You use the Search Mode argument of the XLOOKUP function to reverse the order of the data and provide by material SKU, the most recent purchase price and earn bragging rights.

In the fourth example, the external auditors have asked you to provide information related to customers, in a layout which is the opposite of how your sales data is set up. Knowing well that XLOOKUP can replace horizontal lookup or HLOOKUP, you quickly pull the information in the requested format and respond to auditor’s request.

Finally I share a tip that I have personally been using since the VLOOKUP days which would help you avoid XLOOKUP error, when by mistake the data ranges (lookup array and return array) are not aligned. This tip actually saves a lot of time as well and has been one of my favorite tips.

If you have more questions, or would like to learn about advanced ways of using XLOOKUP, please leave a comment. If you enjoy the information provided in the video, please do not forget to press Thumbs Up

Connect with me:

https://www.instagram.com/learnaccountingfinance

https://www.learnaccountingfinance.com

Thank You!

Learn Accounting Finance

6 Advanced Pivot Table tricks for Financial Analysis and Reporting

DOWNLOAD LINK

Click here to download the Excel sample data file so that you can practice along with me. https://learnaccountingfinance.com/wp-content/uploads/2020/12/advanced-pivot-tables-sample-data-learn-accounting-finance-1.xlsx

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

Do not forget to subscribe to my Youtube Channel

Microsoft Excel pivot tables are a great tool for simplifying data analysis and reporting. It pays off to learn these advanced pivot table tips and tricks as it can save you hours in time, and also increases your accuracy. The advanced pivot table tips and tricks are a must know for everyone involved in analyzing data or creating and presenting reports. Here are the tips and tricks that are shared in this video…

  1. Apply custom filter using Grouping

2. Grouping to create Data Range or buckets

3. Grouping Dates using Pivot tables

4. Creating Pivot table calculated fields

5. Combining and analyzing two reports in different formats

6. Pivot table slicers and slicer connections

We will start with the powerful grouping function available with the pivot tables. We will look at different examples of grouping, including custom grouping when you want to create a new group that is not available in the source data. After creating custom grouping, you will be able analyze data at the new group level which is extremely useful.

Connect with me:

https://www.instagram.com/learnaccountingfinance

Home

Thank You!

Learn Accounting Finance

Commonly used financial terms every new Financial Analyst and Accountant should know!

In this article, we will describe and explain some of the terms most commonly used during discussions of financial performance and business meetings. Understanding what these terms means is essential if you are a new or potential Corporate Finance professional such as a Financial Analyst in the FP&A department, or even a new Accounting and Finance professional. It helps significantly in the job interview process as well if you are interviewing for a job in such Finance roles as you are expected to know what they mean and demonstrate experience of their use.

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

The key financial and business terms we will discuss in this article are as follows:

  1. MTD, QTD, YTD
  2. Plan, Budget, Forecast, LE
  3. Gross Profit, Net Profit, EBIT and EBITDA
  4. Variance, Favorable and unfavorable variance
  5. YoY, vs LY, vs Bud

MTD – represents Month to Date. The ‘To date’ captions are usually used to represent financial performance or activities for a period of time. MTD will always be followed by the name of a month e.g. “MTD August” means results or performance from the start of August (i.e. 1st August) to the current date of the month of August. However, MTD is more commonly used to refer to the entire month, and can also be used to refer to a month that has already finished. For example, if you are currently in the month of August, then ‘MTD April’ will represent the financial performance for the entire month of April.

QTD – represents Quarter to Date. QTD represents the performance from the start of the Quarter to the current date. E.g. if the company’s financial or fiscal year runs from January to December, and you are looking at the performance of Q4 (ie October to December), QTD would represent performance for the period starting from October 1st to the current date. If the current date is December 15th, then QTD will represent the period from Oct 1st to Dec 15th (roughly 2.5 months).

YTD – represents Year to Date. This term refers to the financial performance, KPIs or activities from the the start of the year to the current date. Again, most commonly, this term is used to refer to the period from the start of year to the end of the most recent month. Similar to MTD, YTD is also followed by month. So, for example, “YTD March” refers to the results related to the period starting from the 1st of January and finishing on March 31st. It is important to remember that the fiscal year or reporting year of some companies may not be the standard January to December period. For example, for a company, the financial reporting year may start from July and end in June of the next year. In this case, the YTD period will start from July, and in this case, YTD September will only reflect the performance for the three months period from July to September.

Note: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel templates.

Plan or Budget – Most companies have an annual budget cycle, where well before the start of the year, an extensive and thorough exercise is conducted to plan and quantify the expected (or desired) financial results of the next year. The final outcome of the exercise is called “Budget” or “Plan”, and is represented in the form of budgeted income statement, budgeted balance sheet, and often a budgeted cash flow statement. However, a lot of detail may be available as back up to the numbers reflected in these budgeted financial statements. For budgeted income statement, it is common to start with YTD actual performance of the current year, and then add forecast for the rest of year. The full year forecast (including YTD actual numbers) for the current year then becomes the basis for the next year budget. Budgeted balance sheet and budgeted cash flow statements follow the budgeted income statement with additional assumptions for the budget year.

Forecast – The budget or plan is prepared usually once a year. However, things change quickly, therefore many organizations have forecasts in place as well. A forecast is an estimate of the financial performance, but is typically less extensive and thorough when compared with the budget exercise. The frequency of forecasting also varies. Some companies revise forecasts every month, while others may revise them every quarter or even every six months. It is important to note that while forecasts are revised frequently, the budget remains the same. Therefore, when comparing actual results, often the comparison is done both against the Plan (Budget) as well as the current forecast. This is because budget is not rendered completely irrelevant as a result of the availability of a Forecast. Some bonuses and commissions might still be linked to the original budget, and therefore keeping an eye on the performance vs budget is important.

LE – represents Latest Estimate. This term is used to define the most recently communicated or approved estimate of financial performance, specially related to sales. It is similar to a “forecast”, but different in that a forecast is usually submitted at the start of a quarter or a month, but latest estimate can be provided in the middle of a month or quarter as well. A typical example would be, for example at the start of the month of January, a sales forecast is submitted, lets say of $100,000 for the month. However, every Monday, the forecast is reviewed, and then based on new information, the forecast for the month is revised. Lets say, on the 15th of January, based on actual sales so far and information provided from Sales team, it now appears that sales for the month of January by the end of the month will be $120,000. This will be presented in the form of Latest Estimate (LE). So the forecast is still $100,000, but the latest estimate is now $120,000. Usually, a separate column is used to reflect latest estimate next to budget, forecast or prior year actual numbers.

Note: Not all organizations use Latest estimate, and often the term Forecast is used interchangeably with latest estimate.

Gross Profit – Gross Profit can be calculated with the following formula:

Gross Profit = Revenue – Cost of goods/services sold

where revenue represents the proceeds from the sale of products or services, and Cost of goods/services sold represents the cost of producing or procuring the goods, or in the case service, the cost of rendering the service related to the revenue earned.

What is important is that for the calculation of gross profit, other expenses required to operate the business (also known as Operating expenses) are not deducted from revenue. Gross profit only looks at the profit when considering costs of product or service, and not the operating costs of business. Here is a video I created explaining Gross profit, and the difference between Gross profit and Net profit in more detail…

Net Profit – Net Profit considers all the costs including cost of operating business such as selling, general and admin costs including taxes and interests etc. So, Net profit can be calculated with the formula below:

Net Profit = Gross Profit – Operating costs – interest and taxes

or Net Profit = Revenue – Cost of goods/services sold – Operating costsinterest and taxes

Net profit is also referred to as the bottom line, as this is literally found at the bottom of the income statement, and also reflects the overall net profitability of the business.

FYI: Revenue is often referred to as “Top line” as most income statements start with Revenue at the top.

EBIT – represents Earnings Before Interest and Tax, and is a very commonly used measure of the financial performance EBIT reflects the net profit or net income of a business excluding a) interest and b) tax expense, and can be represented with the formula:

EBIT = Net Profit plus (Interest and Tax expense)

What is the importance or use of EBIT? EBIT simply shows you the operational performance of a business before considering interest and tax expense. Think of it this way … if you are an investor looking to invest in a company, you are interested in knowing the EBIT from operations of a company because the interest and tax expenses may not remain the same when you buy the business. You may have extra cash available and might not need the same level of borrowing as the existing business, or the taxation rules that apply to you may be completely different. By looking at EBIT, you can tell exactly what a business can make from its operations on its own before factors such as interest and tax are taken into account.

EBITDA – represents Earnings Before Interest, Tax, Depreciation and Amortization. In calculating EBITDA, we remove depreciation and amortization expenses in addition to interest and tax expenses. Depreciation and amortization are often referred to as ‘non-cash’ expenses. This is because, the actual outlay of cash has often already taken place in the past. Depreciation is a systematic allocation of the cost of fixed assets over the useful life of the asset. So, for example, if a building is purchased at the cost of $1 million, and the useful life of the building is determined to be 25 years. Although the total cost of purchase ($1 million) may have been paid in year 1, a portion of the cost will be recorded in the income statement every year till the completion of the 25 years. Similarly, amortization is the allocation of cost of intangible periods over a pre-defined period of time.

Why is EBITDA important? When looking at the net profitability of a business, depreciation and amortization create two problems; 1) timing difference between the actual cash flow and the recording of expense in the income statement (as in the example above), and 2) different companies my use different methods or assumptions when calculating depreciation and amortization. As a result of these problems, it is often a good idea to take a look at EBITDA, specially when comparing two or more companies for their operational performance. EBITDA helps you compare the performance of companies by excluding the impact of financial, accounting and taxation decisions.

YOY – represents Year over Year. This usually represents a comparison of prior year to current year. You will hear the phrase ‘Year over year growth’ or ‘year over year decline’. A YoY growth of 2% in sales e.g, represents that sales have increased by 2% vs last year. The formula for this will be:

YoY Sales Growth = (Current year Sale Prior year sale ) / Prior Year Sale

However, the calculation does not need to be for the entire 12 months period. You can also have YoY growth or decline for a period of three months, six months or any number of months or days. For example, you may compare the sales of January to March period of last year with the same period (January to March) of the current year. The key is to compare the same number of months, when doing this comparison.

Variance – Variance simply represents difference. It can represent difference from target, difference of previous performance, difference from estimate or expectation and difference from budget.

Unfavorable Variance – For example, if the target for a sales representative for a month was to make a 100 sales of a given product. but the actual sales he or she made in that month turned out to be 90, the variance in this case is -10. It is denoted by a minus or negative sign because it is an unfavorable variance. This is because the more a sales representative can sell, the better it is for the company as well as the sales representative. Therefore, selling less than target is an unfavorable variance and is a negative situation denoted by a negative sign.

Favorable Variance – If, however the actual sales were 105 units, this would be a favorable situation and the variance would be represented by a positive sign, being +5 units.

Note that the higher the sales or income vs target, the more favorable the variance is. However, the higher the expenses are vs target the more unfavorable the variance, as expenses have an unfavorable impact on the profitability of a company.

vs LY and vs Bud – vs LY represents Versus Last Year (often also referred to as versus prior year), and vs Bud represents Versus Budget. Both of these terms are used to compare against actual current year performance. So, for example, vs LY would represent the difference between actual results this year, and the results for the same period last year. Similarly, vs Bud will represent the difference between actual results this year, and the amount budgeted for the current year. As an example, if actual revenue for current year was $10,000, budgeted revenue for current year was $12,000 and revenue from last year was $7,000. Then, in this case variance vs last year is +$3,000 (because actual sales in the current year are higher) and variance vs budget is -$2,000 (because actual sales in the current year are below the budgeted amount).

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Are you an accounting and finance professional looking to improve your financial analysis skills? Make sure you connect with us by subscribing to the email list. We will be sharing practical tips and advice that will help you transform you career this year. Click here to subscribe to our email list.

We also have a YouTube channel (called LearnAccountingFinance) with helpful accounting and finance, Microsoft Excel and Finance career related videos. You can find our channel by clicking on the link LearnAccountingFinance.

Make these 4 Changes to Your Resume before you apply for your next Job

Your resume or CV is your gateway for landing jobs. In most cases, you apply by submitting your resume. If you do not have a job, second to networking with the right people, updating your resume is the most important thing you can do. It is worth spending a lot more time than you already have. But what is wrong with your resume? Why does nobody contact you after you have applied.

The Mindset of Hiring Managers

When I did not know what goes on behind the scenes, I was so upset with not getting any responses from the employers that I started believing that most of the job postings are fake. But that is not true. Unfortunately, in the field of Accounting and Finance, despite many open vacancies, the number of applicants for each job is usually very high. As a result the only option left with the hiring managers, whether from Finance or HR function, is to quickly skim through the resumes and shortlist candidates. Do you know what this means? This means they are looking to eliminate candidates first before they start really going through the resumes in more detail to see if the candidate is the right fit. This is why tailoring your resume to each job posted is so important. Here are my 3 tips on tailoring your resume that will make it stick, and lead to an interview call.

1) Be Selective

Let me suggest to you here that despite your keenness on landing any and every job interview, you need to be selective as well. Just like the hiring managers, you should be able to eliminate jobs postings that do not seem relevant to your experience. Guard your energy level when applying for jobs. From the available list of job postings you should be able to short list jobs that you think are at least a 75% match with your experience and skills. I am not saying that you do not apply on job postings that are under 75% match, they can be part of your second round, once you are caught up with all the 1st grade matches. In the world of abundant applicants, quality and uniqueness is the key.

2) First things First

Once you have identified the jobs, read the description slowly and try to create a mental picture of what the role looks like. What are the challenges that the current employers are facing? What would be there ideal candidate for this role? Then start listing the experience, skills and achievements that match the requirement. Make sure to list the most important skills for the job first. The first few seconds of reading your resume are the most crucial so that you do not become part of the elimination list. If they read the first few lines of your resume, chance that they will read the rest of it increases dramatically, and so do the chances of you being called for interview.

3) Add examples, stats and numbers

Once you have the mental picture of the job requirements, you know exactly which of your experiences, skills and examples you need to highlight early in your resume so that it lights up the tired eyes of your recruiters or hiring managers. For example, if the role is related to the manufacturing industry, and you have worked for a manufacturing company as well as a retail and and a service firm, you know they will be most interested in your manufacturing experience. I can even predict that if you get an interview call, they will be asking questions mostly about your time and experience in the manufacturing company.

So, you need to highlight the same experience. Your resume will be heavy on your manufacturing experience. Not only that, even your experience details for retail and service industry should highlight skills that are similar to, or transferable to the manufacturing industry. Add numbers and details. If you helped the company save costs. Don’t just say that! Mention how you did that and how much cost you saved. For example you can state on your resume; “helped save $300,000 by identifying vendor billing errors over a period of three months” (true story by the way!). It does not really matter if the amount is small. It shows that you care and are always looking to add value to your organization which makes you stand out from the crowd. If you got promoted quickly, mention that. If you received a special award or recognition for your performance, mention that. Whatever is true and can make you stand out without sounding overly arrogant, you should include in your resume with examples and numbers.

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

4) Always include a carefully written cover letter

I have never submitted a resume without a cover letter. Even if the job posting clearly asks for a two page resume, my two page resume will always be followed by a cover letter. Ideally, the cover letter should be the first page the hiring managers or recruiters should see. A well written cover letter can make all the difference. Generally, the resume is very rigid and restricted in the quantity and type of information you can include in it.

A cover letter can take the form of a conversation though and that is where lies its power. I do not recommend the cover letter being longer than a single page. But you can summarize your most important strengths and skills, directly related to the job in the cover letter. The cover letter should be written in such a way that if someone does not even read your resume, they know what you bring to the table. This does not mean you summarize all your skills, experience and qualifications on the cover letter. The cover letter is all about exactly what you have determined to be the most important skills and experience required based on reading the job posting. Use formatting such as bold and italics to guide the eye of the recruiter to the most important and interesting facts about you.

Note: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special discounted price for readers of this post) showing exactly how this is done. You also learn how to analyse and present the results of the variances to management.

In order to make the cover letter stand out, I have often included remarks, or comments received during my previous employments. For example, once while I was a Senior Financial Analyst, the CFO of the organization remarked, “you have raised the bar in the FP&A department”. Guess what? this phrase is a permanent fixture, typed in bold format, in all of my cover letters. By doing this, the reader gets intrigued and likes to read more on the cover letter. Once you have there attention for 15 seconds, you are probably off of their elimination list and the likelihood of them calling you for interview also increases significantly. You can also include similar statements or remarks in your cover letter, as long as they are true.

I hope these 4 tips that I have shared with you will help you significantly in getting your dream job quickly, as they helped me when I first learnt and applied them. Leave a comment and let me know about your experience.

I have a YouTube channel with helpful accounting and finance, Excel and career related videos. You can find my channel by clicking on the link LearnAccountingFinance.

If you would like to be notified of my new articles and video posts, make sure you join my email list by clicking here and subscribing to my email list. Lets connect! All the best!

How to make Memorable Finance Presentations every time!

Are you about to make a Finance presentation? Is it about the financial performance of your company? or is it a business review? Don’t worry! In this article, you will learn exactly how to make your Financial presentations memorable. You can use headings in this article as your checklist for making presentations. Check off all the items during your financial presentation, and you will be making great presentations consistently.

Would you like to work with me to get one on one training, or to solve your specific workplace challenges, book your 15 minute consultation here: https://calendly.com/learnaf

Note: If you would like to learn in detail, how to calculate all income statement variances and the impact they have on sales, gross profit and ebitda, both in $ and %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special price for readers of this post) showing exactly how this is done. You will also learn how to analyse and present the results of the variances to management and will be able to download solved variance calculation Excel files.

In order to make a Finance presentation, or any presentation, you need to consider the following three key ingredients:

Ingredients

  1. Yourself
  2. Your presentation / Slide
  3. Your audience

1. Yourself

1a. Your Purpose – Story Telling!

Before you even start collecting all the data, charts and information, understand that you have one purpose for your presentation. You will be telling a story. This will save you countless hours of collecting and organizing unnecessary information, that goes into slides that you later have to eliminate from your presentation. This happens a lot. You could use this time to add so much more value. Having a story telling mindset gives you direction and focus.

But what does story telling mean, when it comes to financial presentations? It means “what happened?”, “what does it mean?” and “whats next?”. Most accounting and finance professionals stop at the what happened stage. This is good information, but it leaves the audience unfulfilled. They need closure. And that comes in the form of what does it mean? and what should be done next?.

For example, you mention in your presentation that sales have increased by $50,000 year over year. This reflects what happened. First, you can add a little more detail to what happened by explaining, for example, that $40,000 or 80% of the total increase is a direct result of price increase for a major customer, while the remaining $10,000 or 20% resulted from increased quantity sold overall. To explain what it means, you can highlight that the business is growing in the Northern region and one of your largest customers has agreed to increased pricing. This may mean there is room to increase prices to customers at least in the Northern region. Now, for what’s next, you can suggest reviewing prices for other customers in the region, and also looking at how the price increase was negotiated for this customer, so that it can be replicated for other customers.

You will be really telling the story if you can add a few personal details. For example, in the case of the sales price increase, may be one of the sales rep has worked exceptionally hard, or may be a new sales rep joined the team, and you can share some details of their performance for the year that should help motivate other sales team members as well.

Note: If you would like to learn in detail, how to calculate sales variances and the impact they have on sales $, profit $ and profit margin %, and how to explain performance vs budget and prior periods, click here for a detailed video course (at a special discounted price for readers of this post) showing exactly how this is done. You also learn how to analyse and present the results of the variances to management.

1b. Preparation and Self Confidence

Once you understand that the main purpose of almost all of your presentations is telling stories, you know how to prepare. Look for information that supports a story you are trying to tell. If you do not know what story to tell, let the data guide you. Here are a few tips for boosting self confidence before presenting financial results:

  • Practice presenting. This is a simple way to get better at presenting. You can even practice at your home. Use a camera to record yourself presenting. You will learn so much about your presenting style and what needs to be improved. Record yourself presenting multiple times, each time trying to fix areas you identified. One of the issues you will notice is that you are speaking too fast. Slow down! and see how dramatically it improves your presentation.
  • Exercise! you should exercise every day any way. However, on the day of your presentation, work out a little. It helps calm you down and feel good. It could be as simple as a short 10 minutes run around the block.
  • Be ahead of schedule! Get into the meeting room or presentation hall early and test the equipment, such as projector and microphone etc. You do not want to be scrambling to fix audio and video issues with your audience waiting in the room. This will give you a very shaky start.
  • Use strong body language postures before the presentation to make you feel confident. Research suggests that two minutes of power posing for example, standing tall with arms wide open, or standing like super man with hands on your hips dramatically improves your confidence. I have personally tried this and it has worked really well for me.

1c. Dealing with Data Issues

This is part of your preparation. However, for the accounting and finance community, this is so common that it deserves a separate heading. Many of us deal with data issues on a frequent basis. The data may be incomplete or unreliable. An approach that many of us take is to lay this out in the presentation. We talk about how there is not enough reliable data to provide any conclusion. For example, when explaining an increase in the cost of sales, you may state that it may be that part of the increase in cost of sales is due to purchase price increase, however, our systems do not capture this data correctly, so we cannot really say that.

The problem with such a statement is that it does not really help your audience. Spend some more time during the preparation and data gathering stage of your presentation so that you can really provide conclusive statements. If you drill down with the aim of determining whether purchase price increase is a factor, you will probably find a way to tell whether it is a factor or not with reasonable certainty. You might even be able to quantify the impact. You spend a little more time thinking, and look for some more information that is already available, that may not have occurred to you. Note how much better this statement sounds compared to the previous one. Our Cost of sales has increased by $20,000, 30% of this increase, which is $6,000, is a direct result of increase in purchase price of Product A, compared to last year.   

Note: If you would like to learn how purchase price variance is calculated and accounted for, click on… https://learnaccountingfinance.com/2019/09/12/how-to-calculate-purchase-price-variance-ppv-and-track-ppv-accounting-entries-in-sap/

1d. Your Credibility

Credibility is something you develop over time, but it helps a lot when making financial presentations that your audience already places a high level of reliance on you. This reliance is a resultant of the quality of service you have already provided. Every time you have been asked for some ad-hoc information or analysis, did you provide a response that was well presented and accurate? As an accounting or finance professional, you will inevitably have to make financial presentations some time in your career.

You can start working on your credibility factor immediately. Every time you share financial information, double check to determine accuracy. Read you email from a reader’s perspective and make it easy on the eyes. Make sure any attachments to your email are printer friendly, not just in terms of consumption of ink, but also in terms of page alignments so that the user of information can print the attachment without the need to adjust print settings. What if they were in a hurry to take your printed attachment into a meeting of their own, only to find upon arriving at the printer, that it was printed, split from the middle, on 50 pages. Over the course of my career, I have noted that these small things matter a lot and create a perception of quality and reliability, which is your friend when making financial presentations

2. Your Presentation / Slides

2a. Too much material

If you have practiced your slides, you will know how much time you need to make the presentation. If enough time is not allotted to you, or things are running behind schedule, and you will be getting much less time than was originally allotted to you, here is what you should do. Instead of skimming over the slides quickly trying to make sure you present all of your slides, decide on eliminating a few slides completely. Present the remaining slides in the same way as you had prepared to. This way your presentation will still be memorable, actually this might make it even better.

Even if you have the full allotted time, do not go through your slides quickly. Do not move the cursor around a lot. Do not toggle from Powerpoint to Excel and other files a lot. Apply a calm and steady approach. Let your audience absorb information. Eliminate any information that does not contribute to your overall presentation story.

2b. The use of slides and clutter

If you have more than 5 objects on a slide (including text, pictures and graphs), your audience will begin to struggle cognitively, as they are trying to read or make sense of whats on the screen, as well as listen to you. So limit the number of objects to a maximum of five, but the lesser the better.

Focus only on one issue or topic in one slide, that should be obvious from the title at the top. Do not lump multiple topics or points in one slide. This will help you make clear presentations as well. It does not matter if you end up having a lot of slides. Its OK as long as your message is focused and clear on each slide and there is no clutter on the slides.

2c. Numbers vs Images / Charts

You probably know this already, but our human mind loves charts and pictures. We can always present numbers and results better in terms of graphs and pictures. Some graphs such as waterfall chart, bar graphs, and pie charts are great in visually summarizing results. The best thing about charts is that they are memorable and thus make your presentations memorable.

Her is an example. A waterfall chart that clearly explains a lot of detail in a very simple graphic. Click on the video below to see how you can create an automated waterfall chart in Excel.

2d. Visibility of Slides

Is all the information on your slide easily visible to farthest member of the audience? This includes pictures and specially text. Check font size and color scheme. Try and keep all the content more towards the center and away from the borders of the slide.

3. Your Audience

3a. Know them / Understand them

This is linked to the first step in this article. Your purpose or story. It is crucial that you know who your audience is. If you are presenting financial results to a CFO, or a bunch of Finance professionals, your language and level of detail will be completely different from when you are presenting to, say, factory labor.

One idea that really helps in this case is trying to put yourself in your audience’s shows, or better, in their minds. Try to see their perspective. What do they already know? What would they like to know? What would make them connect with what you are saying? You can get better at this by asking a lot of questions in all your presentations, and allotting a good chunk of time for your audience to ask questions. Over a period of time, you will find a pattern, and you will be able to classify the type of audience and the material that you can present to them.

3b. Engage them

The best way to engage audience is by telling stories and asking questions or sharing interesting facts. Make sure they are aligned with the subject of your presentation though. In engaging audience, eye contact is important too. Many presenters, during their presentations, look at their audience by glancing quickly over everyone in all directions. While they may feel, they are making a connection and engaging with everyone by looking all across the room or hall, but actually real engagement only happens with real, one-to-one eye contact.

A better approach, therefore, is to make and keep eye contact with individuals over the course of the presentation. Let people feel as if you are talking directly to them. Hold the eye contact until you finish the sentence, and then make eye contact with another person and do the same. You will start seeing a lot more heads nodding and a lot more people taking interest in what you have to say. If you see someone who is shy, and uncomfortable with the eye contact, let them go. Do not make them uncomfortable.

3d. Feedback and recognition

It is possible that some people who have helped you in preparing the presentation, or helped you with an aspect of the achievement you are sharing in the presentation, are sitting in the room as well. What better way to thank them than recognize them among others for their contribution. This demonstrates your thoughtfulness. They will remember you for this. If they are your subordinates, they will see you as a great leader. Their motivation will get a boost. Others will also recognize your thoughtfulness. All of this making a great combo for a memorable presentation.

In conclusion, remember the three ingredients of a memorable finance presentation. It takes time to master the details, but knowing them and then consciously working on improving these skills will make you a great presenter in no time. I am sure you will already see a big difference in your next presentation. So, I wish you all the best! and would love to see your comments on what you think about these tips, or if you have applied any of them, how did they work out for you.

Make to sure to connect with me by signing up with your email address. Lets connect! Click here to subscribe to my email list.

Here is a link to my YouTube channel LearnAccountingFinance where you will see helpful video tutorials related to accounting, finance  and Microsoft Excel.