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‚ Bond2:
Premium Bond
Hinduism‚ which is both a way of life and a religion‚ focuses on what it’s like to be human and what people really want out of life. Hinduism revolves around a cycle of lifetimes: the one you are in now‚ the one before you‚ and the one after you. One has as many lifetimes as needed to reach the next caste system through dharma‚ the right way to act morally and through social duty (caste) and karma‚ the moral law of cause and effect. In order for a person to liberate themselves from ego (which
Premium
process for thinking about your ideal future‚ and for motivating yourself to turn your vision of this future into reality. The first step in setting personal goals is to consider what you want to achieve in your lifetime (or at least‚ by a significant and distant age in the future). Setting lifetime goals gives you the overall perspective that shapes all other aspects of your decision-making. To give a broad‚ balanced coverage of all important areas in your life‚ try to set goals in some of the following
Premium Goal Management Psychology
CD-ROM Included! “John Walkenbach’s writing style makes the difficult seem easy in this book that can be used as a reference or read cover to cover. You won’t find a more comprehensive book on Excel 2010 than this!” —Dick Kusleika‚ Microsoft MVP‚ DailyDoseOfExcel.com • Searchable PDF of the book • Understand functions‚ charts‚ worksheets‚ and workbooks System Requirements: See the CD Appendix in the book for details and complete system requirements. • Master “what-if” analysis
Premium Spreadsheet Microsoft
Excel Formulas and Functions Microsoft Office Excel is used to store data and crunch numbers in all types of businesses. The spreadhseet program’s power lies in Excel functions and Excel formulas‚ which allow all sorts of data analysis‚ from simple sums to standard deviations. Consider this Cheat Sheet your quick and easy Excel tutorial. Excel Functions You’re Likely to Use Some Excel functions apply to specific subject areas‚ but others are general and apply to all needs. The following list
Premium Spreadsheet Mathematics Reference
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
Zeinab Abdel-Hak October 28th‚ 2013 ENG 1010 Differences In Our Society’s Eating Habits When it comes to the topic of nutrition‚ most of us agree that in order to live a long healthy life one must eat right and choose nutritious alternatives to preserved and fast food products. The incredibly complicated and confusing question of what we humans should eat in order to be maximally healthy is a huge problem that lingers in our every day lives. In recent discussions of nutrition‚ a controversial
Premium Nutrition
An Experience of A Lifetime I use to always sit and wonder if people realized how many teens were victims of dating violence. Looking around public places with fear in my eyes‚ I could see people don’t see the abuse that goes on in some relationships. I‚ on the other hand‚ can see abusive relationships almost everywhere and almost everyday. I never noticed them until I was part of one. Being part of an abusive relationship changed my life and me as a person. I was once part of an abusive
Premium Bullying Abuse Physical abuse
Concepts of Lifetime Fitness September 1‚ 1997 Homeostasis is the state of equilibrium in which the internal environment of the human body remains relatively constant. Two excellent examples of homeostasis are how the body maintains a constant temperature and blood pressure during strenuous physical activity or exercise. Although there are many other activities in the body that display homeostasis‚ I will only discuss these two. Temperature in the human body is usually kept at approximately
Premium Temperature Metabolism Heart
APPENDIX B Excel Template Instructions for the Glo-Brite Payroll Project (Using Excel 2010) The Excel template for the Payroll Project is an electronic version of the books of account and payroll records. This is not an automated payroll system‚ but an example of how you might use a spreadsheet program to keep payroll records and account for payroll transactions. You will need to follow the instructions in the textbook to complete the project. The instructions provided below will enable
Premium Spreadsheet Bookkeeping