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
Foreign Exchange Hedging Strategies at General Motors: Transactional and Translational Exposures Prepared By: Danial Wahaj Khan EXECUTIVE SUMMARY: This report is based on a practical scenario solution of General motors. The report addresses the problem given in scenario which is the change in policy of hedging with detailed reasoning. The report then looks at the different available hedging instruments to the firm. Profitability of both instruments has been compared and lowest cost option was
Premium Forward contract Foreign exchange market Currency
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
ISSN 0825-5822 The texts published in the series "Cahiers du CETAI" are solely the responsibility of their authors. Cahier de recherche THE NONORTHODOX CURRENCY BOARDS: THE CASE OF BULGARIA Nikolay NENOVSKY* and Kalin HRISTOV* 2001-01 January 2001 * Bulgarian National Bank‚ Research Department; University of National and World Economy‚ Department of Finance‚ Sofia‚ Bulgaria. Copyright © 2001. Centre d’études en administration internationale (CETAI)‚ École des Hautes Études commerciales
Premium Central bank Monetary policy Federal Reserve System
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
Reporting 5 Usefulness of Information produced 6 Conclusion 7 Appendix A: Reference 8 EXCEL VS. SAGE LINE 50 Introduction Ease of Use Other than sales‚ purchases and expenses being keyed in for Sage has more systematic approach than Excel as it has a flow for the user to trail. Another advantage of Sage would be the handling of stock which stock inflow and outflow could be track with the system compare to Excel which has database to trail stock. As from MTT has a problem with the stock as there
Premium Financial audit Auditing Audit
Major risks and implications of those risks for the conduct of the audit. Financing and market risk The Company generally borrows on a long-term basis and is exposed to the impact of interest rate changes and foreign currency fluctuations. Debt obligations at December 31‚ 2007 totaled $9.3 billion‚ compared with $8.4 billion at December 31‚ 2006. The net increase in 2007 was primarily due to net issuances of $573 million and the impact of changes in exchange rates on foreign currency denominated
Premium Debt Currency Balance sheet
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
Chapter 1 Question | Answer | Excel is an electronic version of what? | a spreadsheet | Excel stores documents as files called _________ | workbooks | The contents of an active cell are displayed in the ______________ | formula bar. | Charts can be either__________ or __________ | as an embedded chart sheet‚ as a separate chart sheet | The default name given to an Excel workbook before it is renamed is ______________ | Book1 | By default‚ excel starts with _____ many worksheets? | 3
Premium Control key Spreadsheet File format