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 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%
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
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)
What is the easy way to create forms in different sheets.......
In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......
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
