Angel Demirev

Business Scholar at the University of Utah

Read this first

Lessons from a Week on Wall Street

I spent last week visiting fifteen companies in New York, New Jersey, and Connecticut to learn more about professionals working in all areas of finance. Along with eleven other students, I met with analysts, associates, managing partners and directors, SVPs, CIOs and CEOs from investment banks, venture capital firms, international corporations, boutique trading firms, consulting divisions, and personal wealth advisory enterprises.

The experience had a profound impact on my educational goals and expected career path. Our hosts were very informative and inspirational across the board. Here are some key takeaways from our discussions:

  • As an intern, come in early, show intellectual curiosity in every aspect of your work, and offer to help with any project even if it is outside your sphere.
  • Volunteer for the bad assignments at work. You will gain new experience and stand out.
  • Financial...

Continue reading →

Portfolio optimization using the efficient frontier and capital market line in Excel

Modern portfolio theory attempts to maximize the expected return of a portfolio for a certain level of risk. The theory is that by diversifying through a portfolio of assets we can get a higher return per unit of risk than we can by holding an individual asset, and that by adjusting the weights of each asset in a portfolio we can create an optimal portfolio for each investor’s level of risk aversion. Assuming that markets are efficient and that the assets in a portfolio aren’t perfectly correlated, we can reduce the total variance of a portfolio at any given expected return by combining assets in various weights.

Imagine a graph with risk on the X axis (measured as standard deviation of the asset’s historical returns) and dividend-adjusted return on the Y axis (measured as an average of historical return). We can plot every possible combination of risky assets in a portfolio to find...

Continue reading →

A better method for training

When I first started my internship this summer, production efficiency for the teams I was working with was calculated by recording output on a whiteboard and crunching numbers on a calculator every 15 minutes. I developed an automated tool to track production in a quicker, more accurate, and more precise way using Google Forms and Spreadsheets. As the internship came to a close, my primary goal became ensuring that the system I developed would be sustained when I’m gone.


In teaching how my spreadsheet works, I discovered that very few people had a working knowledge of Excel! I decided to create a development plan for one of the natural leaders [we’ll call her Kate] in the team. She had never before used Excel and wasn’t too familiar with computers in general; I wanted to create a quick, effective training on spreadsheets and the inner workings of the spreadsheet I had created. My...

Continue reading →

Protecting a DSLR at a Festival of Colors

There are a ton of posts that’ll have you scared to take a DSLR to to a color festival or run. I want to share my own color-proof seal for the Holi Festival of Colors in Utah that managed to keep my DSLR completely clean for under $15.

Shopping List

  • Lens Filter (I chose a cheap $10 lens filter)
  • Plastic Wrap
  • Gallon Ziplock Bags (I chose Freezer since it’s thicker than Storage)
  • Gaffer Tape
  • Rubber Bands

I wanted to protect the entire camera from all color particles and leave only the cheap lens filter and lens hood exposed to color. I experimented for hours to find the best way to seal my gear, and this is what I came up with -

Take the lens hood off and tighten the lens filter onto the lens. The filter adds a few millimeters to the height of the lens, and you’ll want to take a piece of plastic wrap (the length about 1.5x the circumference of the lens, the width being about the size of...

Continue reading →