Software for Financial Analyst

[andyvongteam]

What kind of software that financial analyst usually used?

[wsthost]

This would depend on the type of financial analyst. Please clarify which department/function you are referring to.

Assuming you are referring to investment banking, equity research, private equity-type functions, the answer is, of course, Excel. All of our financial modeling training courses are done in Excel.

If referring to statistical related quant jobs (black-box coding), then it varies - from stats software like MatLab to Monte Carlo like Crystal Ball or @Risk, etc

If referring to more internal finance departments within finance that are more geared towards accounting and operations, then it would be more along the lines of SAP or other institutional accounting software.

[andyvongteam]

This is for investment bank, private equity, merger, and acquisition job. Are we using is regular Excel? please advise more specific so I can purchase one and practice for the next interview. Thanks.

[wsthost]

Regular Excel correct. Buy a PC laptop with Office for PC.
And one doesn't just "learn Excel", one must use Excel.

Get up the learning curve fast:
http://www.wstselfstudy.com/programs.html

[andyvongteam]

I'm not good on excel. Do you have a class to train on how to use excel for this particular use or I have to take excel class out?

[wsthost]

Yes, please sign up for our Excel Fundamentals for the Finance professional which will get you up to speed on Excel before the intensive financial modeling in Excel.
http://www.wstselfstudy.com/packagetech.html

[andyvongteam]

I just complete the package 1, but I'm really not fully understand all the topic that cover in package 1. I am switching career from commercial real estate agent to finance. Therefore, I doesn't have any finance back ground. Can you please advise what should I do or take to catch myself. Thank you so much

[wsthost]

For the full accounting overview, you would need to take the Accounting Bootcamp course.
this is equivalent to 1-2 semesters of accounting, taught by the Dean of NYU Stern:
http://www.wstselfstudy.com/accountingboot.html

this will set the proper foundation for you to return to the Package 1 courses.

[andyvongteam]

I didn't quite understand Accounting For Held to Maturity Securities section: Please advise to help me understand this section.
I have purchased the package 1 a few months ago, but I did not understand anything at all, so I purchased the Accounting bootcamp course as instructor advise, and now the package 1 is no longer in my account anymore. Please advise what is happen.

Thanks,

[wsthost]

Your package expired!
One of our account representatives should have just gotten back to you or will very shortly.

Accounting for held-to-maturity is under the marketable securities section of the Accounting Bootcamp.

The short answer for HTM securities is that it is not marked-to-market and the unrealized gains and losses are not recognized on IS nor does it flow thru OCI.

Please let us know specific questions that you have so that we may better assist you.

[andyvongteam]

Can we build Execl financial modeling with MAC? or I have to purchase window?

[andyvongteam]

Can we build Execl financial modeling with MAC? or I have to purchase window?

[wsthost]

We highly encourage you to have Windows, specifically Excel for PC. In the corporate world, it is Excel for PC not Mac. The shortcut and menus are also different (although similar). If you insist on Excel for Mac, then please download our Mac Excel shortcut sheet so you know the comparable keystrokes.

If you are preparing yourself for Wall Street, don't be penny-wise and dollar foolish. Invest in your career and education.

[andyvongteam]

THANK YOU SO MUCH. I WILL PURCHASE PC WINDOW NOW.

[andyvongteam]

Can you please advise me on which courses should I need to be master on for the investment banking job? I am changing a career, so investment banking is my new career and this is what I dream to do. Please help me and guide me to the right direction for investment banking career, and what should I need to learn and do in order to grow big in investment career. PLEASE HELP. A TRILLION THANKS.

[wsthost]

Yes, someone will get back to you asap.

[andyvongteam]

How to calculate the Enterprise Value?

[wsthost]

Please take our Corporate Valuation Methodologies course, which is part of Package 4:
http://www.wstselfstudy.com/programs.html
http://www.wstselfstudy.com/package4.html