Profile

Tim Mayes
Works at Metropolitan State University of Denver
Lives in Denver, CO
159 followers|814,736 views

Stream

Tim Mayes

Discussion  -

My book, "Financial Analysis with Microsoft Excel, 7th ed.", is now available in three languages (English, Chinese, and Spanish). I only speak English, so thanks to for the translations!﻿
23
6

Tim Mayes

Shared publicly  -

Look at what I just got! I am calling on the Chinese government to purchase a copy for every citizen. :-)﻿
2

Thanks Deb. I had no idea that this was in the works. The inside is a kind of weird mix of English and Chinese. Hopefully, I'll get a report on how many copies sell in China and/or Taiwan. I'm guessing it will be somewhat less than a billion. :-)﻿

Tim Mayes

Shared publicly  -

Excel covariance builder add-in video from TVMCalcs.com.﻿
2

Tim Mayes

Discussion  -

Do you ever need to create a variance/covariance matrix, say for calculating the standard deviation of a portfolio? If so, then you might be interested in the major update for my Covariance Matrix Builder add-in for Excel 2010 or 2013.

It can handle any reasonable number of securities (more than 500), and will also calculate and report the matrix condition number.

It is free and open source. See my blog post for details.﻿
1

Tim Mayes

Discussion  -
6

Congrats Timothy.﻿

Tim Mayes

Shared publicly  -
2

16 communities

Tim Mayes

Shared publicly  -

And now available ¡en español!﻿
2

Chinese! That's crazy! Now 1/5 of the world population will be able to read you.
Sure thing I will ask them to get a few copies, I will be doing THEM a favor!﻿

Tim Mayes

Shared publicly  -

Look at what happened on Emmy's car after the latest snowfall. Rolled up snow. Strange.﻿
3

Tim Mayes

Shared publicly  -

Do you know how a "make-whole" call works for corporate bonds? Learn three ways to determine the call price in Excel.﻿
This tutorial demonstrates how to calculate the make-whole call price of bond using Microsoft Excel using the NPV function, the Price function, and the PV function
1

Tim Mayes

Shared publicly  -

I just posted an update to my Variance/Covariance Matrix Builder add-in for Excel 2010 or 2013. If you need to create "live" variance/covariance matrices, especially for large datasets, you will want to check this out. It will easily create the matrix for all of the stocks in the S&P 500 if you have the data.﻿
2

Thanks David. I hope that you can make use of it.﻿

Tim Mayes

Shared publicly  -
1
1

Tim Mayes

commented on a video on YouTube.
Shared publicly  -

I can't seem to respond directly to your question, so I hope that you see this. You can eliminate the risers by placing spaces between every second data point. It is all about laying out your data. I cannot find this data set, but here is a sample of how to arrange the data:
X Var               Y Var
0.00               10.51%
165,973.14     10.51%

165,973.15     12.13%
580,906.00     12.13%

580,906.01     12.37%
802,773.26     12.37%

Everything else is the same. Make sure that you select the entire range (including blanks) when creating the chart.

You can also do it with formatting in the chart. Click the point at the top of a riser twice (not a double click) to select it. Then, format the data point and set it to No Line. Do this for each riser. I think it is much easier to set up your data appropriately.﻿
Communities
16 communities
Places
Currently
Denver, CO
Previously
Orlando, FL
Work
Occupation
Finance Professor
Employment
• Metropolitan State University of Denver
Finance Professor, 1992 - present
Basic Information
Gender
Male
Love this place, we go once a week. The food is great, the staff friendly, and it is typically quiet.
Public - a month ago
reviewed a month ago
Nathan came out to replace the keypad for my garage door opener (the old one had quit working). Nice guy, knowledgeable, he arrived on time, and the price was reasonable. He did the job quickly. Since he was here, I asked him to look at my garage door and opener to see if there were any problems. He looked and said that everything was good. He didn't attempt to sell me anything or suggest service that I didn't need. I will definitely call him whenever I have garage door problems in the future.
• • •
Public - 2 years ago
reviewed 2 years ago
We went to Luke's last night for the first time and had a great meal. I had a perfectly medium rare filet with salad, sweet potato, and carrots. My date had the salmon, salad, baked potato, and mushrooms. For dessert we had the white chocolate bread pudding. It was all excellent. We don't drink alcohol, so the bill was a very reasonable \$66 for two. It was a Monday night, so it wasn't too busy. The decor is very nice and the service was very good. I highly recommend giving it a try.
• • •
Food: ExcellentDecor: Very GoodService: Very Good
Public - 3 years ago
reviewed 3 years ago
5 reviews
The staff at the Treads Lakewood shop are a great bunch. Always very friendly and helpful. Last year they did a tune-up on an old (very) road bike for me and this year I purchased a new road bike from them. There are several bike shops within five miles or so of this shop, but Treads is the best in my opinion.
Public - 3 years ago
reviewed 3 years ago
I can't believe how crowded this place is, even on a Tuesday night at 6:00 PM. The food is so-so as is the service. I had the chicken marsala and the chicken was tough (overcooked) and the serving size was quite small. The best part was the crab cakes, which were excellent, though, again, the serving size was quite small for the price. We won't be returning.
Food: Poor - FairDecor: GoodService: Good
Public - 3 years ago
reviewed 3 years ago