Profile

Cover photo
Tim Mayes
Works at Metropolitan State University of Denver
Lives in Denver, CO
143 followers|596,442 views
AboutPostsPhotosYouTubeReviews

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 +Cengage Learning PTR for the translations!
24
5
Óscar A.'s profile photoEdward Jawor's profile photosachin oak's profile photoSamuel Tom's profile photo
Add a comment...

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
Debra Dalgleish's profile photoTim Mayes's profile photo
2 comments
 
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. :-)
Add a comment...

Tim Mayes

Shared publicly  - 
 
Excel covariance builder add-in video from TVMCalcs.com.
2
Add a comment...

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
Add a comment...

Tim Mayes

commented on a video on YouTube.
Shared publicly  - 
 
+21yesygirl 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.
1
walid zohair's profile photoTim Mayes's profile photo
2 comments
 
+walid zohair You're welcome. I'm glad to here that the site was helpful.
Add a comment...
Have him in circles
143 people
Dale L's profile photo
Scott Mallon (AnAmericanInBangkok)'s profile photo
Miguel Alban's profile photo
Jiji Magutu Kinya's profile photo
Susan Fulton's profile photo
Ken Puls's profile photo
alex isakov's profile photo
Roland Giscombe's profile photo
Raymond Tucker's profile photo

Tim Mayes

Shared publicly  - 
 
And now available ¡en español!
2
Tim Mayes's profile photoEdgar Lazo's profile photo
7 comments
 
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!
Add a comment...

Tim Mayes

Shared publicly  - 
 
Look at what happened on Emmy's car after the latest snowfall. Rolled up snow. Strange.
3
Add a comment...

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
Add a comment...

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
Tim Mayes's profile photo
 
Thanks David. I hope that you can make use of it.
Add a comment...

Tim Mayes

Shared publicly  - 
3
Add a comment...
People
Have him in circles
143 people
Dale L's profile photo
Scott Mallon (AnAmericanInBangkok)'s profile photo
Miguel Alban's profile photo
Jiji Magutu Kinya's profile photo
Susan Fulton's profile photo
Ken Puls's profile photo
alex isakov's profile photo
Roland Giscombe's profile photo
Raymond Tucker's profile photo
Basic Information
Gender
Male
Work
Occupation
Finance Professor
Employment
  • Metropolitan State University of Denver
    Finance Professor, 1992 - present
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Denver, CO
Previously
Orlando, FL
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 - a year ago
reviewed a year ago
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 - a year ago
reviewed a year 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 - 2 years ago
reviewed 2 years ago
4 reviews
Map
Map
Map
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 - 2 years ago
reviewed 2 years ago