Hmmm kay I am taking corporate finance and realize that it would be way easier if I had a good grip on Excel...any good tutorials out there? any tips on learning corp. fin.? i am no good at math...
Results 1 to 14 of 14
Thread: Excel and corp. finance...
-
10-01-2004, 02:54 PM #1
Troll
- Join Date
- May 2002
- Location
- SF
- Posts
- 3,627
Excel and corp. finance...
-
10-01-2004, 03:00 PM #2
mutant
- Join Date
- Nov 2002
- Posts
- 9,578
For grad school I got a book called something like, "Excel for MBA". It came with a CD that had spreadsheets pre-built for most cor fin questions. As far as learing cor fin, it really depends on if your prof is more into theory or application. Generally, you only need to read about a quarter of the text. Don't get too worked up about the derivation of the formulas and stuff. If your no good with math, why are you taking cor fin? If you're getting an MBA with a concentration in marketing, don't worry. No marketing guy ever got finance, I deal with it every day.
-
10-01-2004, 03:00 PM #3
Smooth side down
- Join Date
- Oct 2003
- Location
- 20 steps from the hot tub
- Posts
- 3,774
Excellent, you will make a superb CFO someday. Or perhaps an auditor.
Originally Posted by gonzo
-
10-01-2004, 03:01 PM #4
mouthbreather
- Join Date
- Sep 2001
- Location
- portland of the west
- Posts
- 4,083
genius Originally Posted by gonzo
edit: motherfucker, it IS 10 characters with the quote.
edit 2: goddammit, now i look like i'm slow. i hate this shit.fine
-
10-01-2004, 03:05 PM #5
Registered User
- Join Date
- Oct 2003
- Location
- SLC
- Posts
- 696
Once you've learned net present value and IRR you've got it. The rest is just fancy words that make finance people feel important.
-
10-01-2004, 03:05 PM #6
Troll
- Join Date
- May 2002
- Location
- SF
- Posts
- 3,627
I hated math in high school. i figure with a little practical application in my head now it will be better. thanks for the tip foggy - i'll check that out.
-
10-01-2004, 03:29 PM #7
Bring on the snow
- Join Date
- Sep 2004
- Location
- People's Republic of Boulder
- Posts
- 796
Gonz,
I am in my second year of Biz School. I have some nifty excel spreadsheets already prefabbed. Send me a PM with your email and I can send them over. They will allow you to get the hang of things much faster.
UTDave was right, NPV and IRR are what you are often after. But, you have to get the numbers to plug into those equations to make it all happen.
Good luck.
-
10-01-2004, 08:57 PM #8
Registered User
- Join Date
- Sep 2004
- Location
- champlain valley
- Posts
- 5,830
utah dave's got it right. the rest is jargon. as to learning npv and irr there are HP business calculators with manuals that will give you clear examples. Also excel has has functions that calculate each. Originally Posted by UTdave
I'm an accounting grad, now programmer that is not a math geek. I just know basic algebra cold - the stuff you learned in 7th or 8th grade. the most important thing to know is order of precedence and what you do on one side of the equal sign you have to do on the other. For MBA stuff is this all you need until you hit calculus.
-
10-01-2004, 09:01 PM #9
Temporary
- Join Date
- Aug 2004
- Location
- Vegas
- Posts
- 904
http://www.ozgrid.com/
It's a forum... I've used it, it's pretty good, watch out for the crazy nerds galore on there though.“Don’t want to sound like a dick or nothing but it says on your chart you’re fucked up. You talk like a fag, and your shit’s all retarded.”
-
10-01-2004, 10:34 PM #10
Cube Jockey
- Join Date
- Nov 2002
- Location
- White room @ 49th & 8th
- Posts
- 733
i know a guy.
why didn't you just email me, you doosh?You know, there's like a butt-load of gangs at this school. This one gang kept wanting me to join because I'm pretty good with a bowstaff.
-
10-02-2004, 07:11 AM #11
HEY NOW
- Join Date
- Oct 2002
- Location
- Aspen, CO
- Posts
- 2,133
tech talk, beeyatch.
Corp fin = bad memories. The excel stuff and formulas are fine, it's just the way that the test questions are designed to fuck you up that makes me mad.
Also, glad to have a Honk sighting - was wondering where he'd got to...
"When restraint and courtesy are added to strength, the latter becomes irresistible."
Mohandas Gandhi
-
10-02-2004, 01:31 PM #12
Troll
- Join Date
- May 2002
- Location
- SF
- Posts
- 3,627
i try to avoid discussing excel, powerpoint, and investment banking with close friends... Originally Posted by Honc
-
10-02-2004, 05:22 PM #13
Cube Jockey
- Join Date
- Nov 2002
- Location
- White room @ 49th & 8th
- Posts
- 733
tough but fair, although that severely limits my conversation potential Originally Posted by gonzo
stall: i've been in and out, primarily lurking. would love to catch up one of these days and discuss this winter's schedule. a weekend at the peruvian is certainly not out of the question.
later magsYou know, there's like a butt-load of gangs at this school. This one gang kept wanting me to join because I'm pretty good with a bowstaff.
-
10-02-2004, 05:32 PM #14
~
- Join Date
- Apr 2002
- Location
- Gare du Lyon
- Posts
- 4,896
1: Open Excel.
2: In a blank worksheet, select "Save as" and choose "Save as web page".
3: Click on Publish and Add interactivity.
4: Save as any name you like.
5: Load in the page with MS Internet Explorer, Excel will appear in the webpage.
6: Go to row 2000 Column WC
7: Highlight all of row 2000 and press Tab to make column WC the active column.
8: Hold the keys Ctrl, Alt, Shift and click on the Office Icon
Bookmarks