Excel For Finance Tips What is a Basis Point ?

In the banking world, a lot of numbers are quoted as 'basis points' - 1/100th or 1%.

it's easy to format whole numbers as "bp", but it's not ideal as you need to convert the decimal number by multiplying by 10,000 to geta whole number and then have a format as Code:

#,##0" bp";[Red]-#,##0" bp"

Is there a way to automatically scale a number using a format, so that 0.0065 can be formatted as bp? I've large tables of interest margins that need formatting as bp but will be used in revenue calculations, and don't want to replicate them needlessly

I know you can do thousands and millions, but can't see a way to do it in single magnitudes

Is there a way to change a data point setting on an individual basis based on a specific property?

For example . . .

The info I want to graph:
Property x-axis y-axis A

1

3

B

2

7

B

3

12

A

4

20

A

5

30


After I graph x-axis vs y-axis, is there a way to make all the data points with "Property A" a blue circle and all the data points with "Property B" a green triangle?
(this is a simplified example, I have about 8 different properties and I do not want to have to sort and create individual series)

Thanks for your help

Hi all

I would like to find out if there is a formula to do this.

I want to count from each cell that doesn't contain "0".
So if cell C2=100, I want to be able to count the number g1*2 from that cell and return a value.
But then I want to start another count from c5 to the number of g1*2 and then another count from c8 etc basically any cell that contains a value other than "0", I want to start a count from.

The point of this is that the half life will expire after that count, so I want to be able to add the drug levels on an ongoing basis until the count of the half life has been reached. But there will be further dosing along the way before this half life is reached and these values need to be added to the existing value until the half life expires.


Hope this makes sense.

Thanks

Ryan

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?

I am setting up my portfolio in yahoo finance and wanted to know if there is a way to link it up with my microsoft 2003 excel spreadsheet and yahoo stock portfolio so that I can have it automatically update in real time.

Please help

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

Hi,

I have a challenge building a financial model in excel. I'm modeling the profit margin of a potential contract with different time frames. Unfortunately, due to upfront revenue (with no underlying cost) incurred only in year 0, my profit margin % decreases as I extend the time frame. This causes problems with contract evaluation as it would conclude that shorter contracts are always better.

For example

Category YR 0 YR 1 Total
Rev 30,000 100,000 130,000
Costs 0 70,000 70,000
Net Profit 30,000 30,000 60,000

Margin 46%

I'd just like to hear a comparison