Using Microsoft Excel 2010 Advanced Skills Using Microsoft Excel Advanced Skills Excel contains numerous tools that are intended to meet a wide range of requirements. Some of the more specialised tools are useful to only certain types of people while others have value for more general excel users. These exercises will cover some of the advanced features that may be useful for most excel users. These features will include cell naming‚ cell notes‚ conditional formatting‚ data validation
Premium Spreadsheet Microsoft Microsoft Office
Descriptive Statistics using Excel May 2011 / Dr Rensvold Open the Excel spreadsheet labeled "Example Database." The first page is the Data Dictionary. The Variable Label is the "handle" used for computation. The Variable Name is longer and more descriptive. The Values column shows the numerical values associated with categorical variables. In the data dictionary‚ you can see that the only categorical (nominal) variable is SEX. The others are ratio variables (why?) Click on the Data tab
Premium Data Spreadsheet Statistics
Financial Analysis using Excel Function Information requirements for function Dates Prices and par values Frequency‚ and related Yields and interest/ discount rates Discount Any amount paid at maturity ? Frequency of payme nts pa First coupon Redemption amount Investment amount # of periods Settlement Par/coupon Maturity COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPPCD COUPNUM DURATION MDURATION PRICE PRICEDISC PRICEMAT RECEIVED YIELD YIELDDISC YIELDMAT ACCRINT
Premium Spreadsheet
The Risk of using Macros in Excel What is a primary security risk that user should acknowledge when using macro? Well I think that keeping control of the macros in the Microsoft programs are very important to the security of the user’s computer. From what I read in the reading and a little research letting the wrong macro get a hold of your computer can be a disruptive to your computer. From what I found out in one of the websites called ComputerWeekly.com Saran(2001)‚ “ an advisory notice by
Premium Microsoft Office Security Carnegie Mellon University
Using EXCEL for Asset Allocation and Performing Market Efficiency Studies 1. Introduction There are several features in EXCEL that are very useful for asset allocation and performing market efficiency studies. These features used in conjunction with live or historical data allows one to apply the sophisticated techniques discussed in this class in practical situations. This write-up will introduce students to the various mathematical and statistical functions available in EXCEL and explain
Premium Variance Linear algebra
Boston Consulting Group Matrix (BCG Matrix) Basic of BCG Bigger the Market share of a product has or faster the Market growth of a product is better for a company Market Growth Rate ? Low High High Market Share Low The BCG model is based on the product life cycle theory that can be used to determine what priorities should be given in the product portfolio of a business unit. To ensure long-term value creation‚ a company should have a portfolio of products that contains both high-growth
Premium Marketing Product management Strategic management
Graduate School of Business Administration University of Virginia UVA-F-1238 Duration and Convexity The price of a bond is a function of the promised payments and the market required rate of return. Since the promised payments are fixed‚ bond prices change in response to changes in the market determined required rate of return. For investor’s who hold bonds‚ the issue of how sensitive a bond’s price is to changes in the required rate of return is important. There are four measures of bond
Premium Bond Bonds
THE WEST AFRICAN EXAMINATIONS COUNCIL NOVEMBER/DECEMBER 2014 WEST AFRICAN SENIOR SCHOOL CERTIFICATE EXAMINATION THE VERY FINAL INTERNATIONAL TIMETABLE DATE PAPER CODE SUBJECT/PAPER DURATION TIME(G.M.T.) Wednesday 27th P3043 French 3 (Oral) 40mins Time for paper will be arranged by August‚ 2014 the Council Friday‚ 29th P7023A Foods and Nutrition 3 (Practical Planning Session) 1hr 08.30 hrs. – 09.30 hrs. August‚2014 P7033A Home Management 3 (Practical Planning
Premium Time Livestock
5 Hedging Interest-Rate Risk with Duration Before implementing any kind of hedging method against the interest-rate risk‚ we need to understand how bond prices change‚ given a change in interest rates. This is critical to successful bond management. 5.1 Basics of Interest-Rate Risk: Qualitative Insights The basics of bond price movements as a result of interest-rate changes are perhaps best summarized by the five theorems on the relationship between bond prices and yields. As an illustration
Premium Bond Bonds
of the bond will increase to 100.04. What is the modified duration of the bond? a) 5.0 b) -5.0 c) 4.5 d) -4.5 Example 1-6: FRl\1 Exam 1998--Question 22 What is the price impact of a 10-basis-point increase in yield on a 10-year par bond with a modified duration of 7 and convexity of 50? a) -0.705 b) -0.700 c) -0.698 d) -0.690 Example 1-8: FRl\1 Exam 1998--Question 20 Coupon curve duration is a useful method for estimating duration from market prices of a mortgage-backed security (MBS).
Premium Bond Bonds