Excel For Finance Tips - What is Present Value ?

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?

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

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 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

Hello- I am using the Web Query function in Excel 2002 to import data from Yahoo Finance into an Excel sheet. I get the data OK but when i am trying for instance to use stocks quotes for financial calculations (like basic sums, perf, graphs..), those aren't in a format that work; i tried to change the format into a number one, but that doesn't work either. Would you have any advice ? Attached is one example (thanks Rob for the advice)

I'd just like to hear a comparison

The following code fills down column B for rows 3 to 110, regardless
of the inserted "If Not IsEmply' statement.
I've got formulas in Column A from row 3 to 110, but visible values in
rows 3-5. I want it to fill the for the visible values only.

Code:

Sub CopyTest()
Dim OutPL As Worksheet

Sheets("Pull").Activate
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
 For i = lastrow To 3 Step -1
   If Not IsEmpty(Cells(i, "A")) Then
      lastrow = Cells(Rows.Count, 1).End(xlUp).Row
   Set OutPL = Sheets("PULL")
OutPL.Cells(i, "B").Value = Sheets("Bill OF MATERIAL").Cells (4, "D").Value
     End If
          Next i
                    End Sub

Any help is appreciated.

Thanks,

BDB

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O