Unlocking a Powerful Tool to enhance your work quality — Charts in Excel are a powerful function, and many people do not utilize their capabilities to the fullest. Visuals are meant to help you see trends, and help you analyze. Whether it is related to general business, or other industries, you may be asked to create charts. Stacked bar charts…

Classes, Automation, and Learning Fundamentals — 2020 was a challenging time for everyone, and it was no exception for me. Travel plans were postponed, work was re-located to be fully online, and it has been hard to adjust, to say the least. The purpose of this article is to look back on some of the most…

Reality includes penny-pinching and being bored all the time — FIRE, or the “Financial Independence, Retire Early” movement is a popular personal finance concept where you compile an investment nest egg with your savings, and live off your savings, allowing you to retire earlier than the usual 65 years of age. Let me be clear, I believe saving is a…

Here’s what they are, and how they work — Within the range of services that an investment bank provides, there is a common mandate which often reaches the news headlines. Notable transactions include Disney & Pixar, Google & Android, Exxon & Mobile, just to list a few. These deals show us a story where there are benefits to a…

Modern Portfolio Theory and using statistics properly to invest — Technical analysis involving analyzing patterns, moving averages and other similar voodoo magic is essentially useless. For technical investors, many get caught up in the weeds and use their statistics, programming, and mathematical skills incorrectly. The first concept taught in finance courses around the world is that past performance should not…

Distinguishing Between a Salesperson and an Independent Advisor — These days, a dark secret of many financial institutions is that the advisers they hire do not consider your best interests. What I mean by this is that without a regulatory body providing them a set of standards, they are free to suggest investment options that may not be the…

Business lessons to take from government policies — As a Canadian citizen who’s working from home up north, I’ve been worrying about my US neighbors and friends. My coworkers all have health insurance, but thinking about the people without it makes me deeply disheartened. With the greatest pandemic that the modern era has ever faced going on, it’s…

History often repeats itself, and bubbles still exist today. — Since the beginning of capital markets and investments, investors have been lured by the promise of high returns and speculative neighbors. Most recent in an investor’s memory may be the spectacular volatility of Bitcoin and similar cryptocurrencies, or the recent decline in the cannabis industry. If you’ve studied the intricacies…

Automate your real estate analysis with Pandas and Numpy — Real estate analysis isn’t complete without automating the calculation of mortgage payments. We’ll look to create our mortgage calculator from scratch in both Excel and Python. By the end of this article, you’ll know exactly how to conduct your analysis for different types of loans and mortgages when you’re confronted…