Posts by: Guest 1| Wall St. Training

toggle formula in cell display
Hi, i accidentally hit some stroke and now one of my row only shows formula (ie =a16*b5) instead of the calculated result. how can i change that. thx

Go to post

by Guest 1.

added 11 years ago

How to value a company if we do or don't invest?
Full Question: We are using DCF to value an existing equity investment. The company is planning a capital increase two years down the road. We may or may not participate in the capital increase. My question is how should value our existing equity investment under these two scenarios (whether we ... Read More

Go to post

by Guest 1.

added 11 years ago

stock trading
Here's a question that was posed to us: "in my financial markets class, we have a mock trading competition going on, and whomever wins at the end of the semester (70 or so days) will get a 10% increase in total points for the semester, which could potentially boost the grade up a letter. i, obviousl... Here's a question that was posed to us: "in my financial markets class, we have a mock trading competition going on, and whomever wins at the end of the semester (70 or so days) will get a 10% increase in total points for the semester, which could potentially boost the grade up a letter. i, obviously, really want to win; how do you suggest i go about this / what should i be looking at research-wise?"

our short answer:

If you aren't following the mkt each day, this is tough if not impossible to teach since your actions and selections now will affect the end portfolio value. In short, Identify the sectors that you think will outperform the market. Your goal isn't to maximize your profits but to beat the rest of the class. So considering what's going on now in the mkt, read up on interent, WSJ etc on what industries will do the best in this craphole of an economy. Then, within that sector, pick the best companies. The way to win is to totally pick specific stocks and not diversify. However the risks are obvious. If you don't pick the right stocks you really lose.

For instance, things to think about:
- traditionally in good times, small cap stocks do well as they usually play into niche areas. In bad times, small caps don't do well because no one is buying and they have less room for buffer since they don't have as much economies of scale
- clearly the banking sector is hurt right now. No one is immune but if you think there are a couple outliers, then pick them
- oil & gas: as oil prices go up, integrated oils like exxonmobil do well, refineries like valero don't. As oil goes up, airlines suufer. Opposite is true. So take a stance on oil prices. Read up on full implications and make a decision
- retailers - discounters like wmt do well now, as does costco. But then costco got hurt more than wmt since costco had less room to quickly raise prices whereas wmt is able to control prices more but costco has a lot of private label (kirkland) so when costs up, they couldn't pass along as quickly
- since you are now literally living thru history, and the bailout hasn't passed yet, ask, who will benefit most when it does pass? Make the bet
- think global economics and the balance of payments and interest rate parity. As the US needs to issue more debt in future for bailout and other reasons, the $ will likely continue to depreciate. So pick companies with lots of international exposure. However, its relative to europe and asia - if they suffer more than US, then dollar will appreciate, if not, then reverse
- you probably can't short else you can do lots of stuff. Pick the opposite and short them to magnify returns

Final assessment: research all the different trends and relationships. Identify what you believe will happen and go from there. This is what portfolio mgrs do and takes yrs to perfect. Welcome to finance. Read More

Go to post

by Guest 1.

added 11 years ago

UNINSTALL WST ADD-INS FROM EXCEL 2007
How do I remove all WST add-ins from my excel. I have tried deleting, however, in the add ins option the Wall St training images are still available. I want to uninstall them completely. Thank you.

Go to post

by Guest 1.

added 11 years ago

Re: Cash Circular
Many thanks! I will give it a try once this drink (and the few that followed it) have worn off!

Go to post

by Guest 1.

added 11 years ago

How do convertible bonds affect total capitalization?
Full Question:
Assume we convert all the in-the-money convertible bonds. Would this effect a firm's total capitalizaiton? If, no, then do we simply move the amount of CB from debt to stockholder's equity? Thanks.

Go to post

by Guest 1.

added 11 years ago

Finance 101: Calculator
Hello,

I am going to buy a calculator - can anyone recommend?

Should I go for financial or scientific?

Thanks,
Adrian

Go to post

by Guest 1.

added 11 years ago

Return On Equity (ROI)
Question: why is [color=#FF0000:34q7ajk1][b:34q7ajk1]ROI=g/(1-d)[/b:34q7ajk1] [/color:34q7ajk1]d: divident payout ratio; g: dividend growth rate? How was this equation derived? :roll:

Go to post

by Guest 1.

added 11 years ago

Issues with Center No Merge
I'm using the macro Cntrl + Shift + E, and at first, it works fine when I set it in the template. I open the template and import my data so the report populates. I need to recenter (no merge) the title because I have fewer columns than I did on my original template. I attempt to use the macro aga... Read More

Go to post

by Guest 1.

added 11 years ago

Basic Fundamental Knowledge
Prior to this training, I have not ever tried to make good use of quick keys. I see the light. Is there some fundamental logic that will help me know when to use CTRL + something vs ALT + something?

Go to post

by Guest 1.

added 11 years ago