Introduction to Investments Finance 340 Excel Assignment #3: Bond Portfolio Immunization Objectives: - Bond portfolio immunization. - Excel ‘Data Table’. The in-class hand-on example is based on Handout exercise 6. Problem: You will be paying $13‚159.32 for a Hawaii trip in 7 years. The market interest rate is 4%‚ so the present value of the obligation is $10‚000. 1) Construct a portfolio of two Bonds (Bond1: Coupon payments 3% paid annually‚ face value $1000 and maturity 5 years
Premium Bond
Week 6 Excel PF008 A14 Introduction to Spreadsheets A spreadsheet is an electronic file that contains a grid of columns and rows used to organize related data and perform calculations. Excel is a spreadsheet program used to create and modify electronic spreadsheets. An electronic spreadsheet makes data-entry changes easy‚ and if the formulas are correctly constructed‚ the results recalculate automatically and accurately. A worksheet is a single spreadsheet that typically contains descriptive
Premium Spreadsheet
Excel is not actually a DBMS ( MS-Access is ) and MS Word is not also a DBMS . DBMS stands for Database Management system which implies that information is stored in a Database with tables and records consisting of fields .Excel can do some of these functions but is not a DBMS and MS Word stores data in flat files as such and is therfore not a DBMS. One of many Excel’s talents is its data storage; we can store a lot of data in Excel workbook. Excel 2010 64 bit can create a workbook with a size of
Premium Microsoft Microsoft Office Database management systems
QUESTION 1 a) By giving practical examples discuss the difference between Cyber war and Cyber terrorism. b) E-Learning is becoming increasingly popular in our society. In view of this‚ many students are studying with foreign universities through e-learning. Outline the limitations and impact of having graduates through e-learning. QUESTION 2 Doctors‚ lawyers and teachers all need a license or state certification to practice their profession. Are computer practitioners similar enough to these professionals
Premium Attack War Attack!
FIN 320 EXCEL SHEET Problems Please solve the problems below using an excel sheet and the excel functions. 1) (15 pts) A firm is considering a project with an initial investment of $170‚000 and required return of 12%. The following cash flows are expected over the 8year life span of the project: Year Cash flows 1 35‚300 2 46‚200 3 50‚000 4 22‚620 5 15‚100 6 5‚200 7 11‚740 8 89‚300 a) Calculate the Net Present Value (NPV) of the project. Should the
Premium Cash flow Cash
If you feel confident‚ please change the answers to what you think is right‚ otherwise‚ xuse CtrlAltM to comment. 0125 All coding questions are on the codeshare link. Multiple Choice 1. d is correct // d) derefrencing garbage? ie no memory actually allocated // 2. c) // d) neither winner() nor loser() can make the assignment //I think 2 is c‚ because it is a virtual function but not a pure virtual function‚ so we can call it from the base class 3. c)
Premium Object-oriented programming
providing onsite and telephone support to customers with Microsoft Excel questions. On this particular day‚ you are presented with the following three situations: Situation 1: A business professional wants to use Excel to organize data for the monthly expense report. He has never used Excel and is inquiring about the functions that would support him with this task. Situation 2: A husband is having difficulties with his Excel spreadsheet. He has been trying to track his monthly grocery spending
Premium Microsoft Microsoft Excel Spreadsheet
Assurance of Learning Exercise 1A‚ Step 4 Using the Cohesion Case‚ the www.finance.yahoo information‚ the 2009 Annual Report‚ and the Industry Survey document‚ on a separate sheet of paper list what you consider to be MCD’s three major strengths‚ three major weaknesses‚ three major opportunities‚ and three major threats. Each factor listed for this exercise must include a %‚ #‚ $‚ or ratio to reveal some quantified fact or trend. These factors provide the underlying basis for a strategic plan
Premium Credit rating
Workbook (2012). Module/Week Reading & Study Assignments Points 1 Earley & Wheeler: Preface‚ chs. 1–5‚ 28‚ 30 McRaney: ch. 1 Whaley & Wheeler (2011): chs. 1–5 6 presentations Listening Guide Course Requirements Checklist Class Introductions DB Forum 1 Conversion Testimony 10 0 50 50 2 Earley & Wheeler: chs. 6‚ 10‚ 11‚ 32 Fay: chs. 1–4 Whaley & Wheeler (2011): chs. 6–12 Whaley & Wheeler Workbook (2012): Week 1 4 presentations 1 video 1 website Recovery Testimony 4MAT Book Review: The Great Commission
Premium Harshad number Final examination The Final
Date Reviewed : Date of IE : Date Issued : Date Due : Unit Assessment Information Qualification : Higher National Diploma in Computing and Systems Development Unit Code & Title : L/601/0446– Unit 02 - Computer Systems (No 1 of 1) Assessment Title & No’s : Learning outcomes and grading opportunities: LO 01:Understand the function of computer systems | Learning Outcomes | LO1.1 | LO1.2 | LO1.3 | | | | | LO 02: Be able to design computer
Premium Computer Computer software Hard disk drive