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
style to minimize losses • Meta-goals Speed over accuracy Accuracy over speed • Ad cue Effects Affect and emotion Product facts • Choice of compromise brand Lower probability Higher as compromise brand is less extreme and thus less risky • Importance of “fi t” in brand extensions Less important More important‚ as “fi t” reduces risk TABLE 10–2 Differences in Regulatory Focus 374 Part Three Internal Infl uences extroversion‚ and as a consequence‚ engage in very different behaviors designed
Premium Big Five personality traits Personality psychology
Unit Title: Unit sector reference: Level: Credit value: Guided learning hours: Unit expiry date: Unit accreditation number: Principles of safeguarding and protection in health and social care HSC 024 2 3 26 31/05/2015 A/601/8574 Unit purpose and aim This unit is aimed at those working in a wide range of settings. This unit introduces the important area of safeguarding individuals from abuse. It identifies different types of abuse and the signs and symptoms that might indicate abuse is occurring
Premium Management Education Educational psychology
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
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
evf Mrs. Zbegner English Compare and Contrast Essay October 16‚ 2013 There are many similarities and differences between the different stories of the people who had to fight for civil rights‚ or their place in society. Rosa Park’s “My Story‚” and Charlayne Hunter-Gault’s “In My Place” are two stories that share some of the same qualities and style‚ but also differ in other aspects such as their content and theme. Both authors tell their story about fighting for
Premium Rosa Parks Social movement COINTELPRO
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
Personal Budget Exercise – MS Excel (These instructions are also attached here as a Word document) Creating a spreadsheet to track personal expenses is an excellent use of Microsoft Excel. For this exercise‚ you will create a spreadsheet to enter a personal budget and track actual expenses for the year. You may choose to use real data or create a fictitious budget using a monthly income amount of $2‚500. Here are suggested budget categories if you are not using a real budget. At a minimum‚ you
Premium Spreadsheet Typography Microsoft Excel
Introduction Corporate governance is concerned with the structures and systems of control by which managers are held accountable to those who have a legitimate stake in an organization. It has become an increasingly important issue for organizations for three main reasons. The separation of ownership and management control of organizations (which is now the norm except with very small businesses) means that most organizations operate within a hierarchy‚ or chain‚ of governance. This chain represents
Premium Corporate governance Board of directors
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