eduFire - Live Video Learning
27 post(s), 12 voice(s)
altaf al ali
6 post(s)
|
topic under financial introduction: QUESTIONS: Technical & operating data: Production 88000 MWH |
TheWhite Prince
1,384 post(s)
|
wow, it is mostly languages. you need solver or goal seeker in excel. |
Koichi C
Admin
1,374 post(s)
|
42? |
Tyler Rear
660 post(s)
|
Lol, Hopefully some out there will get the reference. Unfortunately I do not have an answer for the problem. I think I need someone to help me with the problem I have with that problem. |
|
TheWhite Prince
1,384 post(s)
|
that is a very complicated problem, solved only by goal seeker or solver, or any other similar software, trust me it is so hard for the human mind to do that operation. |
Giulio P
79 post(s)
|
I know the answer. Only I am torn between “#DIV/0!” and “#REF!”. |
Marco C
Admin
1,651 post(s)
|
yes? ;-) |
|
TheWhite Prince
1,384 post(s)
|
the answer is 0, where is my prize, please send it to Egypt, i will give you the address if the value of the prize is big, like a nice Mercedes , or a flat in San Stefano four season |
|
Giulio P
79 post(s)
|
Wait… we all want to get paid. After all, the topic said “answer this question and get paid” and not “answer this question correctly and get paid”. |
Mair Lloyd
648 post(s)
|
This is the second time I have seen this type of problem posted and I think Kamal is the man to teach us how to solve it. So ….. all it requires is to ask him to give a paid lesson or two ;)…. when we know how much Altaf is willing to pay, we can all decide whether we can make a profit by going to Kamal first :) |
|
Tyler Rear
660 post(s)
|
Get paid in what is the question, Oreos, Pandas, micro fibers? |
|
Mair Lloyd
648 post(s)
|
Hmm I don’t think I could cope with being paid in Pandas ….. |
|
Tyler Rear
660 post(s)
|
At least you could run your own petting zoo or zoo period. |
|
Mair Lloyd
648 post(s)
|
Well now, that would be quite a career change for me, but I am always up for a challenge. I am not sure petting Pandas is a good idea though…. |
Dave Keays
942 post(s)
|
@Koichi; I think 42 only works as an answer when the question isn’t known. |
Katherine Ga...
349 post(s)
|
I’ll try my luck and go for NO. I would not invest in this project. =) |
|
Giulio P
79 post(s)
|
“At least you could run your own petting zoo or zoo period.” Al long as they are not “fractional” Pandas. |
|
TheWhite Prince
1,384 post(s)
|
hey ya altaaaaaaaaaaaaaaf, where are you? you left us discussing the problem and just disappeared…… |
|
altaf al ali
6 post(s)
|
im afraid it was my fault posting the question this way its actually solved using excel and calculating each item than compare the results so 24 , zero its not correct and need to explain or comment on the answer it is very hard for me to solve and when i paste it #div and other stuff showed like this but really thanks for trying :) |
|
altaf al ali
6 post(s)
|
QUESTIONS: Technical & operating data: Production 88000 MWH Tranche 1 rate 10.00% this is the question all |
|
Mair Lloyd
648 post(s)
|
@Altaf, honestly, your best bet it is to pay for a session with Kamal . None of us knows how to solve this, but he will be able to teach you how to do it. |
SmallHands Fund
2 post(s)
|
Not going to answer this question because (ugh) that would take too much work and I have a class (on Investing!) to teach in less than an hour …. but here are some thoughts: To Estimate FCF: First you need your Net Income then you add in Amortization/Depreciation, but you already have this because the problem tells you your EBITDA is 82% of sales (WOW!), so if you have a number for sales, take 82% of that …. if you don’t make up a number. Most likely your professor (I assume this is for a class) wants sensitivity analysis done too, so you’ll need to solve for various sales levels anyway. Anyhow, once you have that number minus out Changes in Working Capital and Capital Expenditures …. you have these numbers too Changes is listed as 20 days worth of sales (so annual sales/365 * 20) and …. if I understand your information correctly …. CapExpend is the same? Once you have FCF for various levels you should be able to do IRR (Internal Rate of Return) or NPV (Net Present Value) for the figures and decide whether the investment is good or not. I’ve never done IRR with FCF so I would probably do it with just the EBITDA, but I’d ask your professor about this just to be sure. Get out Excel and work with it. No one is going to do this work for you because the people who know how to do it know how much work it really is :) Good Luck! |
|
SmallHands Fund
2 post(s)
|
Hahaha and any minute now Kamal Das is going to come in and correct me I just know it! XD XD XD Like being back in business school! |
Shiira G.
60 post(s)
|
I just wanted to say “woah!!!!” @ SmallHandsFund. As I learned in Japanese, atama ga ii desu (you have a good head). Saddened I can’t take your upcoming investment class(es). Would sure help clear up some financial management issues I had a hard time with during this last semester. Hoping I can work with Kamal over the summer as he also has a good head. You tutors ROCK on eduFire!!! |
Kamal Das
180 post(s)
|
@ Mair, thanks so much for recommending me :) @SmallHandsFund, great to see you hosting a class on investing. Nice directions in helping Altaf solve the problem. @ Altaf, best would be to attend a class by someone teaching finance than trying your luck with some kind soul who may provide the right solution with reasoning. Why not join SmallHandsFund’s next class? |
Copyright 2007-2008 Education Revolution. All Rights Reserved.
