Excel For Finance Tips Discount Factors

Anyone have a link to a site, or can explain how to do DF and NPV in Excel?
I saw a demo but have forgotten!

Only very basic for a few years.

Thanks

Anyone have a link to a site, or can explain how to do DF and NPV in Excel?
I saw a demo but have forgotten!

Only very basic for a few years.

Thanks

Hi, I've been trying to produce the factors of a number into a single cell. I have found the one for outputting them into a column, but need a few thousand, so cant have it in this format. I need randbetween(1,100) in column A and the factors in B. So A1=12 B1=1,2,3,4,6,12. The commas don't necessarily need to be there.

I also will need in the next step produce Prime factors in one single cell. Eg A1=12 B1=2, 2, 6

Sorry if it's been asked before, but I've had a search and can't quite find what I need.

Thanks in advance!

Hey Guys, I really hope you can help, maybe its the fact I am working on a Saturday but I can't figure this out and it should be simple.

THE PROBLEM

I have to work out the average rake from a pot size on poker client sites, however there are many variables that affect the answer and a limiting factor, and its this limiting factor I am having problems with for example.

avg pot is $330, the rake is 5%

so $330 * 5% = X

however the maximum time a hand can be raked is up to $2 how would I include this.

The whole calculation should be;

(((AVG POT * RAKE PERCENTAGE) * Number of poker hands)* Number of poker tables)))

Just missing the limiting factor that every hand can only be raked upto $2, does any one know how I would include this?

Thanks Guys.

Hey Guys, I really hope you can help, maybe its the fact I am working on a Saturday but I can't figure this out and it should be simple.

THE PROBLEM

I have to work out the average rake from a pot size on poker client sites, however there are many variables that affect the answer and a limiting factor, and its this limiting factor I am having problems with for example.

avg pot is $330, the rake is 5%

so $330 * 5% = X

however the maximum time a hand can be raked is up to $2 how would I include this.

The whole calculation should be;

(((AVG POT * RAKE PERCENTAGE) * Number of poker hands)* Number of poker tables)))

Just missing the limiting factor that every hand can only be raked upto $2, does any one know how I would include this?

Thanks Guys.

Greetings:
I am fairly competent with Excel, but very much a novice with stastics.

To simplify my question, I present this hypothetical:

Suppose I want to know what factor or factors allow me to run a mile under six minutes.
I have a spreadsheet with each row representing one day, because I run the mile test once each day. For each row in column A I have input a "1" if I ran under six minutes and a "0" if I did not.
I have 210 additional columns that reflect data such as:

In Column B I record how many hours of sleep I got that night.
In Column C I record what fruit I ate for breakfast that day.
In Column D I record whether I played ball with my kids.
In Column E I record the outside temperature.
In Column F I record how much water I drank for the day.
Etc.

At the end of the month I determine that I have run under 6 minutes on 18 of the 30 days. What I want is for Excel to tell me what factors most led to success. For example, the program might reveal that on the 10 days that I ate bananas I ran well on 8 of those days. And further, on 6 of the 7 days that I both ate bananas AND got eight hours sleep, I ran well. Thus the highest percentage or correlation for successful running was eating bananas AND getting eight hours sleep. The next highest correlation was when I both drank a gallon of water AND it was between 70 and 75 degrees.

Can I get this type of information? Keep in mind, for my worksheet I have 210 columns per record, so there's not much space left to write formulas. Are there any statistical add-in programs that would provide this information better than Excel's capacity?

I hope that I have been sufficiently detailed.
Thank you in advance for the help!

A.L.

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.

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 have two sheets in one workbook in Excel. The first sheet is titled "TimeSheets" and the second is titled "Hours Log". What I am trying to do is when hours are worked and accounted for on the Timesheets page for a client, those hours then need to be deducted from the Hours log page. So this is what I need it to do:
IF cell I5 Through I8 has "client name1", then the number in N8 on TimeSheet page needs to subtract from the number in C5 on Hours Log and record the answer in cell D5 on the Hours Log sheet. I need this to update any time a change is made to hours on the "TimeSheet" page. The hours are in the (hh):mm format on both pages.

Any help would be great.

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?