Use Excel's Data tables when you cannot decide which supplier is really cheaper with different prices and rebate structures.
Email questions to: [email protected]

Full Course:
Access full course, including presentation, practice files and solved Excel file for P&L analysis: https://ebitda.thinkific.com/pages/start
FP&A playlist: https://www.youtube.com/playlist?list=PLcRqJFBzcNZWuJmu96M_SFbUIHAJ2aLZu
Take the poll: https://www.youtube.com/channel/UC7rg-IpTVtKCFcjOtOMGqag/community

Looking for more personalized help?

Connect:
https://www.instagram.com/learnaccountingfinance
https://www.learnaccountingfinance.com
https://www.tiktok.com/@learnaccountingfinance?lang=en
Subscribe: http://www.youtube.com/c/LearnAccountingFinance?sub_confirmation=1

In this video, we perform a supplier cost analysis by comparing two vendors, who offer different price per Unit, but also different rebate structures. We will create an Excel model to automatically calculate the cost (less applicable rebate) at different purchased quantities. We will then turn this calculation into Excel's powerful Data Tables, which calculate for us at different points, what will be the cost, less rebate amounts, for each vendor.

We then convert this information into a nice visualization (a line chart) to show us the evolution of cost at increasing purchased quantities. The chart makes it very clear, what decision we should make at different purchase volume levels. This type of financial analysis is great if you are an FP&A analyst or an accounting and finance professional. You business team will thank you for the simplified analysis that helps them make the right financial decision for the company.

Course Alert:
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 analyze and present the results of the variances to management and will be able to download solved variance calculation Excel templates. https://ebitda.thinkific.com/pages/start

Videos you may like:
Learn sales and profitability analysis in detail here: https://youtu.be/CNx1Xu3DWVY
Gross profit and gross profit margin explained: https://youtu.be/Px4pEhiTRdI
How calculate selling price and profits on Etsy: https://youtu.be/WsrdSr_IIhM
Standard Margin and Actual Margin - the Difference: https://youtu.be/p-Vbqh_j-ZY
How calculate selling price and profits on Etsy: https://youtu.be/WsrdSr_IIhM

Some Recommendations:
Are you a First Time or New Manager? Check this out: https://amzn.to/35qWzLc
Learn pivot table data crunching business skills here: https://amzn.to/3lgYB5E
Learn all about Excel in one place: https://amzn.to/3laCXQx
Learn what financial numbers really mean here: https://amzn.to/2HPYDUI
Accounting explained in 100 pages or Less: https://amzn.to/3rCProc
Note: At no extra cost to you, I may receive some commission if you purchase using the links above.

Although, we perform this analysis or cost less rebate comparison for only two vendors, but you can apply the lessons learnt to multiple vendors and multiple scenarios. This way for analysing information is synonymous to scenario analysis, but it helps you make a decision with much more concrete information.

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.