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
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
Complete the following tasks by using the Microsoft® Excel®document provided in Course Materials: Format appropriate cells for currency. Merge title cells. Construct a bar graph using the existing data and provide labels and a legend. Insert a border around data. Freeze the first column of the data set. Sort the daily spending amounts in ascending order. Using the Tools menu‚ set the Excel spreadsheet to be protected. Calculate the sum of the entire data set. Calculate
Premium Microsoft Excel Microsoft Spreadsheet
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
SBUS10050 Excel Exam The Excel Practical Exam: You will be asked to complete a financial forecast for a small company. You will each receive a unique excel file. The file contains a set of instructions on the ‘Instructions’ sheet‚ a set of data on the ‘Excel test data’ sheet and a sheet containing the set of definitions of financial terms (also given at the end of this document). You are required to follow the instructions to complete a financial forecast‚ create a graph and answer a descriptive
Premium Costs Variable cost Cost
Microsoft Excel supports many kinds of charts to help you display data in ways that are meaningful to your audience. When you use the Chart Wizard to create a chart — or when you use the Chart Type command to change an existing chart — you can easily select the type you want from a list of standard or custom chart types. For an overview of some standard chart types and their subtypes‚ click any or all of the following: Column charts A column chart shows data changes over a period of time or illustrates
Free Chart Bar chart Pie chart
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
DISCUSSION: After using both languages‚ Microsoft Excel and MATLAB (MATrix LABoratory)‚ on the same module experiments from 1 to 4‚ I observed the following: * For Microsoft excel‚ * It uses spreadsheet application where each elements or data values are distributed in cells. * Most statistical computations are easy to solve due to the manner of data organization where data are inserted on cells arranged in numbered rows and letter-named columns. * It is easy to plot
Premium Spreadsheet Microsoft Excel Microsoft
Private tuition Many parents send their children for private tuition after school hours. The main reason for this is that they want their children to perform well in the examinations. They feel that the normal lessons in school are not good enough for their children to excel‚ thus the need for private tuition. One advantage of taking private tuition is that the child gets personal attention from the tutor. This may not be possible in the crowded classrooms of today’s schools. So the tutor’s
Free Teacher Education School
Arazmi 1101107184 Siti Aishah Osman 1101107070 Nur Aqilah Abd Wahab 1101106900 Nur Afiqah Aluai 1101106679 Asyraf Hazazi bin Adinan 1101107939 Nur Amorah binti Ghafar 1101108317 Wan Farah Ruzanna 1101108600 Di Napoli Template Definition of Di Napoli; Di Napoli is a master trader who has written a book entitled “Trading with Di Napoli’s Levels”. He did not trade with Forex but his methods and use of Fibonacci is well known all over the world. As can be seen above
Premium Technical analysis Green Line