The biggest problem on your mind..

Is it really that big a problem or is it just the biggest of the small problems you have now?

Is it the sort of problem you might have liked to have a year or two ago?

It’s easy to find yourself in a constant cycle of issues, problems, and unhappiness. So, if you aren’t smiling much for many days in a row, it’s probably time to get some perspective.

If you’re still feeling overwhelmed, here’s the question that helps me get perspective – Is there anyone out there who would LOVE to have the sort of problems you have?

The answer, almost always, is yes.

1000 Good Morning Quotes

On Tuesday, 5th August 2009, I started a habit of sending a quote as soon as I woke up in the morning. My friends and I were just into my 4th year of university and thanks to the effects of the global economic crisis, our spirits weren’t incredibly upbeat about the prospect of hunting for full time jobs during the year. So, the idea here was to make sure we all started the day with a positive thought.

For the first few months, I used to send my friends an SMS and then I gradually began posting these on this blog. Over time, this evolved into a free daily email service that community members could subscribe to and is now even available as a once-a-week email on Fridays for those who do not wish to receive an email every day. I also post them on my short form blog – www.alearningaday.me.

Sending these quotes is typically the first thing I do on a weekday. It helps me start the day with a smile and also makes sure I have a byte sized learning as soon as I’m up. I hope to make my quote repository available someday soon so you can use them to find quotes you want as well.

Aside from the many wonderful quotes I’ve gathered over the past 4 years, I’ve learnt 2 very valuable lessons.

First, I’ve learnt to appreciate more quotes than I used to by looking for the spirit of the quote. I’ve learnt to take them with a pinch of salt. Taking them literally always leads to the sort of debates that follows contradictory sayings like “many hands make light work” and “too many cooks spoil the broth.” Neither is wrong – what’s most important is to think of the spirit of the quote and apply context.

Second, I’ve learnt that life is more fun when you view it with a belief in abundance. A year or so into sending these quotes, I began worrying about running out of great quotes. So, I began saving up – every time I came across a good quote, I’d stash it away for the future. Such miserly behavior was ridiculous and took away all the fun. The switch thankfully flipped a few months later and suddenly, quotes became fun again! 1000 quotes down, I’m sure the best is yet to come..

For all those of you who’ve supported these quotes by liking them, sharing them, and subscribing to them – you’ve played a big part in helping me learn. Thank you for that.

Rockstar Analyst Series 1 – Setting up a Spreadsheet for Analysis

Set up: To ensure our discussions have a proper basis and requisite depth, I’ve put together a basic spreadsheet with financials of Acme Co. Please download the spreadsheet here – I will use a shared Dropbox folder for this series – if you prefer to have access to the whole folder instead of downloading a spreadsheet every time I update it, do send me an email and I’ll share.

I’ll now point out the basic bits of set up that I do every time I get hold of a set of financials for analysis with the “why.” While this is a very very simple version of financials, this will do for the purposes of our discussion. Also, there is no right and wrong here – I’m putting together a list of things that work for me and I look forward to hearing from you on what works for you in the comments.

7 set up habits I have found useful.

1. Set up a control sheet. As you will have noticed, we have a very basic control sheet set up but the importance of this sheet will become apparent as the analysis gets bigger/more complicated. For now, we use it to simply set “named ranges” for currency conversions.

image

The benefit of the control sheet will become obvious when you have to change conversion rates mid way through the analysis to reflect a new market rate/internal finance rate. If you go to Formulas -> Name Manager, you will see the named range set up.

2. Clean up the base sheet. The base analysis sheet is one you will lose a LOT. So, clean it up by making sure the columns and basic numbers make sense. Depending on the size of the data you receive, this clean up can take many hours and can even extend to a few days. This involves cross checking with the finance team to make sure the totals make sense.

Make sure you do basic checks e.g. are there any rows with negative sales? If so, why? This can be done by running a simple sort or filter.

3. Differentiate important columns with colors. I prefer using a background color for key pieces of data (numbers in this case). I also use a bright yellow highlighter for columns I have added and orange for existing columns.

image

4. Remove any formulae you added after the number checks. In this case, I’ve left some of the formulae in the rows for discussion e.g. Net Sales = Sales after Discount – Rebate. As a general rule, it’s best if you replace the numbers by copying the entire column, pasting with values once you know the numbers make sense.

5. REALLY understand the way the numbers work. Every company/business unit uses different terms and methods of calculation. Make sure you really understand the assumptions behind the numbers. As a rule, NEVER make any assumptions about the workings of financial numbers. Do a basic clean up and then sit with a finance person who understands them to make sure you have the same basis of understanding.

6. Remove outliers for the purpose of your analysis and document methodology. Most excel sheets are primarily used to make useful charts for management. You will have a few outliers in the data every once in a while

I’ve used very simple discounts, rebates, and cost calculations here but this will not be the case in real financial sheets. There will always be outliers that need to be cleaned out. Make sure you document these in the “Control” sheet as the underlying assumptions behind your analysis.

7. Keep the spreadsheet clean and avoid version control. A spreadsheet is like your work desk – the more organized and orderly it is, the easier it is to work with. As you add tabs for analysis, continue to keep them clean. I typically remove gridlines (View->uncheck gridlines) and add in borders around my data to make sure it’s easy to focus. This is a personal preference.

Also, name your spreadsheet well so you avoid version control. Notice the naming convention – “130703 AcmeCo Financials – ALAD Rockstar Analyst Series v1r.” Having the date (2013, 07, 03), the version (1), and the initials of the person who made the last edits (r) ensures you have no trouble identifying versions.


Series introduction

Asking for help

I gave some really good consulting advice to a friend a couple of days ago on why it’s important to ask for help. He had had some challenges with an issue he was facing that a few of us were happy to help him with. And we did.

“So hard to ask for help.” – he said.

“Yeah. It’s funny how we often forget that we actually strengthen relationships when we allow people to help.”  – I said playing Master Yoda for a moment.

A day later, I found myself completely overwhelmed. I felt like I had been sitting with a block on my head until a wiser friend pointed out I had been really jumpy for the past 3 days. The root cause of the problem? I wasn’t asking for help!

And so I did – I buzzed friends late in the night last night and did some old school problem finding and problem solving.  I feel much better today. I learnt 3 things –

1. It IS very hard to ask for help. I recognize some people actually find it very easy to ask for help – too easy some might say – but for those who find it hard, it is indeed very hard. And close framily DO love to be of help wherever possible. It’s a real win-win if done right.

2. It is one thing giving great consulting advice. It’s quite something else applying it to yourself. The rules always seem different.. they aren’t. Problems are less obvious when we are too close to them.

3. Life has this way of coming around a full circle. It’s a great opportunity to laugh when that happens! I laughed out loud when I realized this last night and I have a big grin on my face as I type this post out. Very few things are as amusing as our failures to walk our talk.. :-)

Oh, and one more thing, it really helps to have people close to you who point out to you when you are behaving stressed. That was the trigger for the self reflection and it was a very useful one.

Why Life is Perfect

It’s very easy to be caught up in the hard grind that is the “day-to-day.” It’s also easy to stop noticing the absurdity of an answer like “Okaaayyyy” to the “How is life?” question simply because that seems to be the default answer.

Just okay? We live in a world where we have more conveniences and sources of joy than we can ever imagine. We can live many thousand miles apart from near and dear one and still reach them with the click of a button. Poverty is lower than it has ever been and is decreasing quickly.

Sure, you have a misfortune or two but difficulties make the journey interesting. And you can’t be the hero of your own story without overcoming tough challenges anyway. Even the challenges we face are perfectly engineered – never insurmountable and always require us to stretch just a little bit extra and open our minds so we can become equal to the challenge. Isn’t that amazing?

Every bit of this life is perfect. Let’s not let all the noise about the world’s imperfections change our mind about that. That’s just a sign that the news companies are doing a “perfect” sales job…

When someone asks you “how is life” today, try saying “Perfect!” At any rate, it’ll make you smile and feel better and that wouldn’t be so bad now, would it?

On Long Term Investing and Indexes

This week’s learning is part 4 of a 5 part series on Personal Finance and Investing inspired by 3 books – The Investors Manifesto by William J Bernstein, I Will Teach You to Be Rich by Ramit Sethi, and The Millionaire Teacher by Andrew Hallam. (Part 12, 3)

The only known reliable long term investment strategy is investing in index funds.

What are index funds? Index funds are computer managed funds that are a representation of the whole market. If you own the index of the whole stock market for example and Apple’s value is 3% of the stock market, 3% of your index will contain Apple’s stocks.

The assumption behind indexes is that while individual stocks may go up and down, the whole market will grow in the long term (for the US stock market in the last century, growth has averaged around 8% per year and for the US bond market, this number is around 4-5% (subtract 2-3% inflation for real return))

How do you set up a portfolio? Your portfolio needs to have a collection of stock and bond indexes. Stocks are the source of long term growth but are volatile. Bonds have slower growth but will help you sleep peacefully at night.

– Your bond allocation % should be around your age (the older you are, the less risk you take)
– Keep your portfolio split VERY simple. Reduce overhead – aim to rebalance only once every few months

How do you keep investing and balance your portfolio?

– Make investing a purely mathematical exercise – decide your allocation and stick to it
– Imagine you have 30% bond, 70% stock allocation and your your stock allocation has gone up to 80% of the total in the past month/year – invest your money in bonds to bring the ratio back to 30-70
– Don’t worry about the markets. Just keep buying low and sell when you need to

clip_image001

Sketch by EB

Derek Sivers, founder of CDBaby.com has followed Bernstein’s methods ever since he sold his company for $22 million. Derek’s advice is as follows – Think very very long term i.e. 20-40 years. Your labor and active businesses are the only way to get rich. Investing is so you will have enough when you retire.

Bill Bernstein’s Book recommendations –

– Psychology – Your money and your brain by Jason S
– Business – Common sense on Mutual funds by Jack Bogle

Next week, we round all of this up with the final learning of the series.

The Victim, the Fighter, and the Artist

“All the world’s a stage” – said Shakespeare. Perhaps he was among the few who realized how central acting is to our lives.. for we all play 3 roles in alternation throughout the course of our lives. We are either the victim, the fighter, or the artist.

The Victim I am what I experience.

We are all born victims. As babies, we are powerless to do anything but cry. As we grow up, however, the victim habit is either trained out by parenting, mentoring, and self reflection.. or not.

We play victim when we choose to have no emotional distance between us and our experiences. If something bad happened to us today, we must be bad or unlucky. Why else did this happen to me? Since we’re not strong enough to face reality, we choose to do one of two things as a victim – blame or hide. Blame is the easier option and we take it whenever we see an opportunity. And, if we see no way out, we choose to hide.

As victims, we try very hard to shape reality so we come out on top and are often willing to ignore right and wrong. The coward never discusses right or wrong. The coward doesn’t like logical arguments since he knows that’s not how he will get his way. He languishes in fundamentalism – attempting to propel a belief that things were best in the past. He faces the resistance (that toxic force that gets in the way of us doing anything good) and fails again and again and again.

The resistance is very powerful – which is why we see a Hitler and an Osama Bin Laden rise every generation. Adolf Hitler wanted to study to be an artist but he found it so hard to fight the resistance to discover the best of himself that he waged a world war instead. Hitler and Osama Bin Laden were cowards of the worst kind but it’s important to remember they weren’t different from us. They just succumbed to the resistance and got into the habit of playing victim all their lives.

The victim is like the potato in hot water – he appears strong as he jumps in and comes out in pieces.

The Fighter – I am what I achieve.

At some point, either thanks to tough parenting or self reflection, we realize that we have more power than we give ourselves credit for. We face the realization that “I need to face reality and I can shape it.”

We learn that we can get what we want if we stop crying and start fighting for it. The fighter is all about the “I.” She realizes that our education systems are designed the way they are for a reason – to remind us that it’s a dog-eat-dog world out there. It’s important to be fiercely independent, compete, and become the best she can possibly be.

For survival’s sake, she must become the craftsman and set out to achieve glory. It’s war and nobody remembers the loser. This war is about fame, glory, and the sweet taste of victory. She wins because she is incredibly good. And she will work harder, fight longer, and persist to get her way and win. If she’s lucky, she will play fair and not the let the victim cloud her judgment to fight unfair. She’s been trained to view the world with cynicism since she needs a shell to guard her strong exterior. A cynic, after all, is just an extremely passionate person who doesn’t want to get hurt.

The fighter does understand emotional distance from her experiences; while still affected by her experience, her hard cynical shell protects her from it. She realizes she has the power to choose and chooses to focus on what she does in the ‘here and now’.

The fighter is like the egg in hot water – she goes in soft but comes out harder and tougher.

The Artist – I am..well..me.

The artist appears the moment we come to a profound conclusion – “There is no reality, only perception. It’s all invented and I might as well spend my time inventing a reality that makes me happy.”

It’s all invented, isn’t it? Scores, grades, brands, and competitions are just human inventions. The artist realizes that, in her imagination, she has at her beckoning the most powerful ally of them all. She realizes that she needn’t view the world as a race with winners and losers. She can choose to view it as an infinite game where she has been given the privilege to play. There isn’t just one winner – there are as many winners as we like. The pie is abundant and fills up the moment someone takes a piece. It is a world of possibility and she is out to create meaningful art.

The artist believes that the best lies ahead. In fact, she spends her entire life trying to create this reality against all odds. Yes, the artist is a touch deluded. She is deluded enough to ignore the news broadcaster who focuses on all the negative events in the world but aware enough to understand the role she has to play to make this world a better place. To be an artist, she requires a level of wisdom to view the world as a collection of possibilities. The artist’s task is the hardest of the three – she has to succeed first where the victim fails by fighting the resistance and keeping it at bay. She has to then make it a habit to do so by simply being herself, by being vulnerable, and by putting herself out there without any shell to protect her as the artist can’t and won’t tolerate cynicism.

The artist “gets” emotional distance in a way that the fighter can’t really grasp. She realizes that she is not defined by what she does. What she does is a part of her but it’s why and how she does things that makes her unique. This realization comes with a responsibility to use her gifts well and it comes with a humility as she accepts her role in making this world better. And yet, she doesn’t let her grandiose dreams get in the way of singing, dancing, and having fun. She makes ‘being happy’ an art form.

The artist like a coffee bean in hot water – it not only accepts the need to adapt but also changes the nature of the water and adds a beautiful aroma to it. It’s all invented and it invents a possibility that never previously existed.

How does this apply to us?

Look back to the past six months and you will notice that you have been the victim, the fighter, and the artist in alternation. You will also know which one you have been for the majority of the time. There are 3 things we must understand.

1. No one can make this choice for us. Our parents, mentors, and friends and can talk to us about being proactive and happy but we will never get there if we don’t make the choice ourselves. The victim, the fighter, and the artist are parts of us. We must accept them as they are and choose who we want to be most of the time. After a severe setback or disappointment, the victim WILL naturally take over. It’ll just be up to us to choose how long we give ourselves time to “play victim.” It’s okay to blame, wail, and waft in self pity once in a while. We just need to make sure it isn’t habitual.

2. It is all invented. We might as well invent a possibility that makes us happy.

2. It is all invented. We might as well invent a possibility that makes us happy. Repeat this as many times as required.

We are all artists.. our best selves are, at least. And if we aren’t making choices that bring out our best selves, what the hell are we doing on this planet anyway?

2 hour rule after facing a disappointment

The 2 hours after facing a disappointment or setback are the worst. Emotions rule. Logic loses out pretty darn comprehensively.

I’ve made some really dumb decisions after disappointments that I’ve regretted almost immediately. So, here’s a suggestion for a simple fix – after you face a disappointment, don’t do ANYTHING for 2 hours. If it’s a really big disappointment, perhaps take 6 hours or even 12 hours if necessary so you have some time to sleep over it or speak to someone “safe” i.e. someone who won’t take offence if you say something stupid.

The other side of the coin is to apologize profusely, forgive yourself, and move on. I trust you will bad enough to give a proper apology. That’s the easy part, however. The difficult part is to forgive yourself and move on because you’ve now managed to worsen the emotions after the disappointment.

So, get out of your room, go listen to music, or go out for a run. No action for 2 hours please..

The Creator-Consumer Gap and the 4 question survey

I have lost count of the number of survey links I’ve clicked on from hotels/services that want my feedback. In general, if it is a service I care about, I do click as I’d generally love to help. But, the moment I see that the question I answered is part of page 1 of 21, I generally quit.

As far as surveys go, the biggest reason for crap surveys is the creator-consumer gap. Either the creator has forgotten what it is like to be a consumer or is too busy pleasing his boss.

How do we fix it? Keep it simple. I believe most “quality check” surveys require 4 questions in 1 page – the only button on the page should be a large “Submit” in the bottom.


1. How did we do? (1-10 rating with 10 being perfect and 1 being dismal)

2. If not a 10, how could we make it a 10?

3. What are things we did better that we need to do more of?

4. Any other specific comments/feedback/praise?


Thank you. Let’s move on.

And sure, you can add 20 other questions in 20 different pages – but just remember that you’re minimizing the chances that a consumer who cares will ever get through a survey and give you useful feedback.

Keep it simple.

The Rock Star Analyst Series

I’m excited about a new series idea that came to mind this week. I’ve been thinking about a work related series that I would have energy for. The “Work Hacks Wednesdays” series died an untimely death simply because I felt it was getting too generic and too forced.

This new series idea is called “The Rock Star Analyst” series. Thanks to the mountains of data flying around, every one of us needs to have an analytical hat that we can put on at will. Some make their livelihood doing just that while others (especially those more senior) need it every once a while.

This series is going to focus on a lot of practical tips to get the most out of Microsoft Excel and Microsoft PowerPoint for analytical purposes but will contain a few bonus topics on creating good presentations and using Microsoft OneNote – an excellent tool very few seem to be familiar with. I intend to approach it from the point of view of someone asking “why” questions on each of these features and will point you to the best resources I know for more advanced learning. Of course, each of these tools is incredibly powerful and there are whole websites and businesses dedicated to making the most out of them – my goal would be to cover the 80% with minimal effort.

The rough plan for the series as it sits on my head is as follows –

I. Excel Rock Star
1. Analysis 101 – Setting up an excel sheet for analysis (Clean up source data, use a control sheet, and understand named ranges)
2. Modeling 101 – Basics to build and work with financial models (Absolute and relative referencing 101, working with huge data sheets, and leveraging excel resources)
3. Shortcuts to excel success (shortcuts in the excel sense of the word :))
4. Pivot Table magic
5. Flexing the ‘Index + Match’ muscle
6. All about the Powerful IFs – SumIfs, AverageIfs, Countifs
7. More IF power – Nesting Ifs with ORs and ANDs
8. Exploring arrays formulae
9. Macros 101
10. Signing off on your excel sheets like Leonardo da Vinci
12. Other stuff I don’t know so well (Useful formulae like trends and offset-indirect, excel analysis tools like regression, and data tables)

II. PowerPoint Rock Star
1. PowerPoint shortcuts and setting up your quick access toolbar
2. Charting 101 and an introduction to powerful charting tools
3. Templates 101
4. Making awesome presentations (fonts, alignments, design, etc.)
 
III. OneNote Rock Star
1. OneNote awesomeness 101 (leveraging OneNote for research, information capture)
2. “To do” system idea on OneNote

And I would love to hear from you if there are any topics you’d like me to cover – please just leave a note in the comments or via email. Very happy to help!