Asked Dec 3, 2019
Yield to maturity (Expected/Current) 9%    
Number of Years to Future Liability 9.00    
Future Liability $7,500    
  Bond 1 Bond 2 Bond 3
Coupon rate 6.00% 7.000% 8.00%
Maturity 12 18 24
Face value 1,000 1,000 1,000

Compute the amount to be invested to meet the future liability noted in the data. This future liability is due in 9 years. Please show work using excel


Expert Answer

Step 1

We need to use the concept of time value of money to solve the question. According to the concept of time value of money, the worth of money at the present time is more compared to the identical sum at some time in future, that is, we can earn interest on the money we have at the present time. 

Step 2

Given that the future liability is $7,500
Number of years or time period is 9 years
Interest rate (refers to the yield to maturity) is 9% , and we will take the annual payments as zero to calculate the present value in this case.

Step 3

We can determine the present valu...

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in



Time Value

Related Finance Q&A

Find answers to questions asked by student like you
Show more Q&A

Q: Carolina's house burned and she lost household items worth a total of $50,000. House insured for $16...

A: Calculation of Amount of Insurance for Personal Belongings:The amount of insurance for personal belo...


Q: Problem Set for Credit Card Debt MATH 113: Section 9.4a Page 2 of 2 3. Rachel is purchasing a new ca...

A: a.Calculate the maturity period to repay the debt as follows:MS-Excel --> Formulas --> Financi...


Q: Financial analysts forecast Wal-Mart Stores (WMT) growth for the future to be 12.00 percent. Their r...

A: Calculation of Value of Stock:The value of stock is $43.23.Excel Spreadsheet:


Q: Calculate the price of a 6.5 percent coupon bond with 27 years left to maturity and a market interes...

A: Calculation of Bond Price:The bond price is $693.77.Excel Spreadsheet:


Q: Circuit City Stores (CC) recently paid a $.24 dividend. The dividend is expected to grow at a 23.80 ...

A: Given that the recent dividend is $.24, current stock price is $8.76 and the dividend is expected to...


Q: You own a furniture manufacturing company. You are looking to expand into glass furniture and need t...

A: a)The expected rate of return on a project in relation to total initial cost of the project is known...


Q: What methods can be used to delay a firm’s cash outflows?

A: Cash Outflows: It is the cash that go away from a business. Such cash can be used for paying staff s...


Q: The principal  P is borrowed at a simple interest rate R for a period of time T. Find the loans Futu...

A: Calculation of Future Value and Total Amount Due:The future value is 7,605 and total amount due is 4...


Q: 8. A credit card company determines a card holder's minimum monthly payment by adding all new intere...

A: a.) Computation:Hence, the minimum due as on December 1st is $34.55.