Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Related questions
Question
thumb_up100%
You are thinking of pursuing an actuarial career, so you have agreed to serve as an intern at Love Actuaries LLP.
The managing partner, Karen Thompson, has asked you to do some quick calculations for her. She wants you to use the current yield curve, flat at 6%, in your calculations.
Client Annie Inc. has a pension plan that pays pension benefits annually at a rate of $10 million per year, starting one year from today. The pension obligation will end in 40 years. Karen wants to know the duration of these required pension payments.
Client Billy Mack Co. wants to immunize its pension obligations (present value = $150 million with a duration of 22 years) with two $1000 face
Thirdly, client Colin Limited’s pension plan obligation has a duration of 16 and a convexity of 29. Colin’s immunization strategy will use 3 bonds, issued by firms named Eleonore, Frissel, and Greta, respectively.
The bonds have the following parameters:
|
Bond |
|
Duration |
|
Convexity |
|
Eleonore |
|
9.00 |
|
29.00 |
|
Frissel |
|
21.00 |
|
35.00 |
|
Greta |
|
28.00 |
|
56.00 |
Required:
- What is the duration of Annie’s required pension payments?
Hint: Starting with Spreadsheet 16.1 of Bodie_9Ce_Ch16.xlsx, copy the formulas for coupon bonds, adjusting them to extend for the full 40 years of payments, and determine the duration. - Calculate the money Billy Mack should allocate to each of these bonds to immunize its pension against interest rate risk. (Again, modify Spreadsheet 16.1 for the coupon bond’s duration.)
- What weights should Ms. Thompson recommend for Colin’s strategy?
Transcribed Image Text:AutoSave OFF
Home Insert Draw
1
2
3
4
5
6
Paste
B22
X
A
A. 8% coupon bond
Ready
Geneva
B
I U
Sum:
fx
Sum:
Period
B
Spreadsheet 16.1
Page Layout
123+
4
123+
✓ C...
4
0.05
V
C
Time until
Payment
(Years)
0.5
1.0
1.5
2.0
10
Accessibility: Good to go
0.5
1.0
1.5
2.0
Formulas
7
8
9
10 B. Zero-coupon bond
11
12
13
14
15
16 Semiannual int rate:
17
18 *Weight = Present value of each payment (Column E) divided by the bond price
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
V
V
Α' Α΄
A.
V
D
Spreadsheet 16.2
Cash flow
40
40
40
1040
Data
0
0
0
1000
Review
E
PV of CF
(Discount rate=
5% per period)
38.095
36.281
34.554
855.611
964.540
0.000
0.000
0.000
822.702
822.702
Spreadsheet 16.3
ab
F
View
Weight*
0.0395
0.0376
0.0358
0.8871
1.0000
0.0000
0.0000
0.0000
1.0000
1.0000
+
Tell me
ab
Wrap Text v
Merge & Center ✓
G
Column (C)
times
Column (F)
0.0197
0.0376
0.0537
1.7741
1.8852
0.0000
0.0000
0.0000
2.0000
2.0000
H
Bodie_9Ce_Ch16
General
$
V
% 9
J
.00
✈0
V
Conditional Format
Formatting as Table
K
L
Cell
Styles
DNN
M
Insert v
Delete ✓
Format v
N
WE
1889
Σ
V
V
AP. O.
V
|8
Find &
Sort &
Filter Select
O
1.9
I
P
Share
Analyze
Data
Comments
Jasperactive
for Office
99%
R
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 6 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- A student wants to save for her retirement. At the end of every year, she deposits 475 in a brokerage account with an expected annual return of 4.3%. How much money will she have in the account in 30 years? Enter your answer as a number with 2 places of precision (i.e. 1.23). Do not include dollar signs or commas.arrow_forwardYour job pays you only once a year for all the work you did over the previous 12 months. Today, December 31, you just received your salary of $60,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 8 percent of your annual salary in an account that will earn 10 percent per year. Your salary will increase at 3 percent per year throughout your career. How much money will you have on the date of your retirement 40 years from today? (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16)) Future valuearrow_forwardAssume that you will have a 10-year, $20,000 loan to repay when you graduate from college next month. The loan, plus 10 percent annual interest on the unpaid balance, is to be repaid in 10 annual installments of $3,255 each, beginning one year after you graduate. You have accepted a well-paying job and are considering an early settlement of the entire unpaid balance in just three years (immediately after making the third annual payment of $3,255). Prepare an amortization schedule showing how much money you will need to save to pay the entire unpaid balance of your loan three years after your graduation. (Round your answers to the nearest dollar amount. Enter all amounts as positive numbers.) Interest Period Date of Graduation Year 1 Year 2 Year 3 Annual Payment Annual Interest Expense @10% a. Actual net-of-tax interest cost b. Effective interest rate Reduction in Unpaid Balance Unpaid Balance One of the advantages of borrowing is that interest is deductible for income tax purposes. a.…arrow_forward
- 1) Your job pays you only once a year, for all the work you did over the previous 12 months. Today, December 31, you just received your salary of $75,000 and you plan to spend all of it. However, you want to start saving for retirement beginning next year. You have decided that one year from today you will begin depositing 10 percent of your annual salary in an account that will earn 9.5 percent per year. Your salary will increase at 3.4 % per year throughout your career. How much money will you have on the date of your retirement 35 years from today? Give typing answer with explanation and conclusionarrow_forwardYou are working for a finance firm and a client comes to you and wants to know how much money they should put in an annuity (which earns 2.885% interest compounded quarterly) at the end of each three months for the next 36 years. Their goal is that when they retire at the end of 36 years, they would like the quarterly withdrawals from the annuity to total $68,000 per year and that the annuity is to last for the next 23 years. You are to determine the amount which your client needs to deposit into the annuity at the end of each three months for the next 36 years so that they can meet their retirement goal. Do the following: Show all your work that you used to answer this problem. Label the steps and important values as you solve the problem. Note that when you use the TVM Solver, show the all variables and the values you entered (into the variables) and solved for. Find the total amount of interest client will earn (from the time they start contributing to the account to when they…arrow_forwardAssume that you will have a 10-year, $10,000 loan to repay when you graduate from college next month. The loan, plus 8 percent annual interest on the unpaid balance, is to be repaid in 10 annual installments of $1,490 each, beginning one year after you graduate. You have accepted a wellpaying job and are considering an early settlement of the entire unpaid balance in just three years (immediately after making the third annual payment of $1,490). Prepare an amortization schedule showing how much money you will need to save to pay the entire unpaid balance of your loan three years after your graduation. (Round amounts to the nearest dollar.)arrow_forward
- You have just finished your undergraduate degree and you have two career options: Option 1: Accepting a job offer with the starting salary of $75,000 per year (paid at the end of the year) and an annual raise of 2% pa (guaranteed). You will work in this company for 40 years. Option 2: Choosing a graduate program which will cost you $28,000 per year for the next two years (paid at the beginning of each year). Following the graduate school, you can get a job that offers the initial salary of $85,000 (paid at the end of the Year 3) with an annual raise of 3% pa (guaranteed). You will work in this company for 38 years. a. If you use the discount rate of 10% pa, which option is more lucrative for you? b.At what discount rate will you be indifferent between these two career options? (Hint: You need to use the incremental cash flows to answer this question) c. If option 2 (i.e., work after grad school) comes with a signing bonus (paid at the beginning of Year 3), at what signing bonus will…arrow_forwardYou plan to establish a college education fund for your child. The current cost of college is $12,000 per year and you expect this to increase by 5% per year. You plan to deposit money into an account earning 10% per year at the end of each of the next 18 years. You will withdraw the amount required for college at the end of years 18-22. You want the deposit to be low initially and grow by the rate of your salary increase, which you estimate to be 3.5%. What will be the first deposit?How much will be in the account after 8 years?arrow_forwardI need help solving the probelm below in excel 8.Your client wants to have $2 million in her retirement account in 20 years. How much should the client deposit in the account at the end of each year to achieve her goal if we assume an annual return of 8%?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education