Here is a video going over finding the standard deviation of an asset portfolio in Excel and explaining the use of MMULT and TRANSPOSE functions in portfolio analysis.

You may be scratching your head- we know bubbles exist; but maybe they don't or perhaps they need to be redefined?

Organizations need to loosen controls a bit to allow innovation to flow (and because perfect control and prediction doesn't exist anyways). Additionally, they should promote the learning and adaptability of the organization (the use of 'smart as a competitive advantage').

Many business professionals want to reduce the amount of time that they spend working on their businesses but their businesses depend on them or some other significant person. Generally speaking, this is referred to as key person risk. It is a risk to the business (and, such as with investment management firms, to the consumer) because if one of the key persons leave for some reason (departure, illness, etc) then the business will experience significant operational burdens, w

For what the book is trying to accomplish and the time period, this is great and the fundamental premise is relatively straightforward: the previous generation of finance saw normal human behaviors as irrational.

You should probably have a basic understanding of statistics before reading this article, but I go over the main points and you can view the file below.

Lower interest rates prompt more lending, and lending creates money, which leads to inflation (currency supply goes up, reducing demand per unit of supply, pushing currency value down).

If Alberta were to separate, at the very least, there would be significant economic uncertainty that would likely translate to higher unemployment, capital flight, and so on. Additionally, they are not poised to separate in any way- there is no separate currency, no legal precedent, and no 'central bank of Alberta' (among other things you would need). In summary, its an extremely pointless proposal.

Some of the findings are unsurprising: education of management is significantly correlated with improved LBO returns, buyout success depends on vintage year, IPO exits deliver the highest returns, and so on. However, some of the findings feel very surprising to read

pretty good overview of business strategy at a top down level and at some of the divisional levels, such as marketing and finance

I write a bit about some more advanced graphing ideas in Excel

However, as food for thought if you are hiring people, the research has shown that, since at least 1986, experience isn't even a decent predictor of job (task or contextual) performance.

These signs are to assess the chance of accounting malfeasance and are not necessarily the same checks you would use in a financial health assessment.

Today, I'm going over some basic Excel graphing, we'll do some more complicated stuff later. I'd recommend that, if you're completely new to Excel, spend some time with the menus where you find these features.

A lot of businesses get into trouble from time to time and its important to have processes in place for dealing with trouble as it comes. Fortunately, we have detailed templates and checklists for this. For the purposes of this article, I'm going to summarize the processes that take place.

Ultimately, good planning requires judgement and flexibility.

I go over the recent trade issues but switch to focus on housing in the second half.

I will go over the Dave Berkus valuation method (DBM), which is a pretty straightforward method for valuing pre-revenue startup companies.

I go through a discounted cash flow (DCF) model for Moderna

Data tables in Excel are basically simple, multi-modal inserts that can allow you to filter and sort through data (press the downward arrows on the table header). Download our short data tables Excel sheet.