Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In this course, author Curt Frye shows how to perform a wide range of financial calculations quickly and easily using the many financial functions found in Excel 2010. The course details dozens of functions for evaluating cash flows; calculating depreciation; determining rates of return, bond coupon dates, and security durations; and more.
When you're offered the opportunity to invest in a discounted security, you might know everything about the investment except for its annual yield. If so, you can find that yield by using the YIELDDISC function. To use that function and to find the annual yield of an investment, you need to know the following five things. The first is the settlement date that is the date do you take possession of the investment. Next is the maturity date and that is the date that the investment comes to an end. Next is the price and that is the amount that you pay per $100 of face value for the bond.
Next is the redemption value. That's almost always going to be $100, but it doesn't have to be. Then next you have the basis and basis refers to the way that you count days in the month and a year. Basis 0, which is what we're using here, is the North American standard and it says that every month has 30 days and therefore there are 360 days in the year. If we were change to basis number 1, then we would have actual days. So that would be 365 days in a non-leap year, 366 in a leap year, and then either 28 or 29 days in February, respectively.
So with that information in mind, we can calculate the annual yield of this security. So click in cell C10, type an equal sign and then type yielddisc and a left parentheses so we can start entering in the cell references for the arguments. First is settlement date that's in C3 comma. Maturity date is C4, comma. The price and again that's price for $100 of face value is in C5, comma.
Redemption value C6 and the basis C7, then a right parentheses. It looks like everything is in order in the formula, all the references are good, so I'll press Tab and see that the annual yield of this investment is 6.35%. Finding a discount security's yield lets you compare it to other potential investments, which helps you make sound decisions.
Find answers to the most frequently asked questions about Excel 2010: Financial Functions in Depth.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.