Has anyone used the @risk application in excel from pallasades? Im trying to do a monte carlo simulation and just downloaded the program but am not really sure how to get started. An nudge in right direction would be great.
Mr. Excel,
Recently I saw an example of the Excel "Risk" function being applied to an automobile dealer problem. Have returned to Excel Help and Microsoft.com and am unable to find. Would appreciate guidance on how to relocate.
Thank you.
Mariner191
Hello all,
I built a model to calculate IRR based on sales. That means the other things such as COGS was based on the level of sales. The sales was tied with the selling price per unit, and the number of units sold. So right now, if I want to run a sensitivity analysis by using @Risk for selling price and the number of units sold, could you please give me the instruction on how to do it?
Thanks so much in advance.
Minh
Hello all,
I built a model to calculate IRR based on sales. That means the other things such as COGS was based on the level of sales. The sales was tied with the selling price per unit, and the number of units sold. So right now, if I want to run a sensitivity analysis by using @Risk for selling price and the number of units sold, could you please give me the instruction on how to do it?
Thanks so much in advance.
Minh
Hi,
I'm trying to automate risk maps (probability versus impact) in Excel. Does anyone or has anyone had experience with these? I'd be greatly appreciative for any help or advise anyone could offer.
Regards
Jose Aguilera
P.S. I can send through more detailed information once you've decided whether you think you'd be able help me out.
Hi,
I'm trying to automate risk maps (probability versus impact) in Excel. Does anyone or has anyone had experience with these? I'd be greatly appreciative for any help or advise anyone could offer.
Regards
Jose Aguilera
P.S. I can send through more detailed information once you've decided whether you think you'd be able help me out.
I'm trying to set up a formula that will determine the last amount of cash flow in a stream of payments that is required to reach a certain return. For example, if I have these cash flows YR 0 -50,000,000, YR 1 4,922,955, YR 2 7,086,093, YR 3 8,486,159, I want a formula that will determine how much cash flow I need in YR 4 to achieve a 10% IRR. Any suggestions?
I need to write an Excel function that returns best price of a government bond.
The actual handwritten formula is quite complicated, impossible to display
here, and the input values for this formula are-----------------
Accrued days, Number of coupon period days, Days from settlement to next
coupon date, coupon periods per year, number coupon periods between
settlement & redemption, annual yield, discount rate.
hey guys, so i am trying to import
HTML Code:
http://finance.yahoo.com/q/hp?s=MSFT
that type of information into excel via macro. i can do it by importing it via webquery but the problem is that i need more than one page (go all the way down and there is a NEXT button to get information that is older)
so i am trying to import not just one page, but lets say import 5 or 6 (which will give me a years data on a stock vs. the 3 months)
and then down the road, id like to get rid of the line that shows the dividend payout, but that isn't too important right now.
is this possible what i am asking?
Hi
I have made a excel sheet where i have put the names of several stocks in which i am interested. I have also used the facility of Import external data-New web query and given the Yahoo finance link
However, i am having trouble in importing the data as it says the file name should not contain ? wherein the yahoo web query contains the ? in the middle.
Is there any solution.
The surprising part is that i can edit the query and get the rates but it does not refresh, which means that i have not given the wrong path.
Also 1 out of 10 times it gets refreshed but 9 times it gives invalid web query
I shall be thankful if the members can help me out
I am attaching my Excel sheet for ready reference
Thanks
