Question
In: Finance
challenge problem. each holiday season, Michael received a U.S. savings bond from his grandmother. Michael eventually...
challenge problem. each holiday season, Michael
received a U.S. savings bond from his grandmother. Michael
eventually received twelve savings bonds. the bonds vary in their
rates of interest and their face values. Assume today is December
31, 2011. what is the value of this portfolio of U.S. savings
bonds? on what date does each of the individual bonds reach its
face value or maturity date ( note that the price is half the face
value)? estimate to the nearest month and year for each
bond. Note the bonds continue earning interest past
their maturity dates.
issue
D,
price, face V, interest R,
maturity D
12/31/90.
$25.
$50.
6.0%
?
12/31/91.
$25.
$50.
5.0%
?
12/31/92.
$50.
$100.
3.0%
?
93.
$25.
$50.
6.0%
?
94.
$50.
$100.
4.0%
?
95.
$25.
$50.
5.0%
?
96.
$25.
$50.
4.0%
?
97.
$25.
$50.
4.0%
?
98.
$50.
$100.
3.0%
?
99.
$25.
$50.
6.0%
?
12/31/ 2000
$25.
$50.
3.0%
?
12/31/2001
$50.
$100.
4.0%
?
Total.
$400
Solutions
Expert Solution
The following are the data inputs in spreadsheet:
The following are the obtained results in spreadsheet:
jeff jeffy answered 1 year agoRelated Solutions
- Share your experience with unions and your knowledge of the labor relations process
- Discuss the function of being embodied in the formation of consciousness in phenomenological view.
- A person pushes a 10.5-kg shopping cart at a constant velocity for a distance of 37.6...
- Question 2 (b) Consider a person standing in a breezy room at 20°C. Determine the total...
- Gantt chart for home renovation project
- A corp is considering paying dividends to shareholders.The corp has a $2.00 of per share earnings...
- To better understand the importance of organization structure in your life, do the following assignment. Select...