Question: I am having trouble understanding where to put the assumptions in order to find NPV. THe imformation I need is the ? in the excel
I am having trouble understanding where to put the assumptions in order to find NPV. THe imformation I need is the ? in the excel cells below. Please share how you can to the conclusion.
Financial Option 3: $30 Million Investment in Bonds Rationale for investment:
The business thats offering these bonds for sale contracts with another business in China to assemble computer components. The Chinese business is known to have used child labor in the past, but claims it has stopped this practice. However, the U.S. business selling these bonds has not investigated to verify whether these claims are true or not.
Assumptions to consider:
10-year bond
8% coupon
Priced at a discount: $95
Discount rate is 9%
| Bonds | |||||||||||||||||
| Initial Investment | ? | ||||||||||||||||
| Annual Cash Inflows | ? | ||||||||||||||||
| Discount Rate | ? | NPV = | $0 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
| Number of Years | ? | Cash Flows | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |||||
| Principal Returned | ? | ||||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts