Reference no: EM13899384
I would like to have the solution to the following sample problems in EXCEL format, so that I can see the formulas used. Thanks.
1. What is the current value of a zero-coupon bond that pays a face value of $1,000 at maturity in 9 years if the appropriate discount rate is 7%.
Please round your answer to the nearest cent.
2. What interest rate is implicit in a $1,000 par value zero-coupon bond that matures in 5 years if the current price is $430.
Please specify your answer in decimal terms and round your answer to the nearest thousandth (e.g., enter 12.3 percent as 0.123).
3. What is the current value of a $1,000 bond with a 8% annual coupon rate (paid annually) that matures in 9 years if the appropriate discount rate is 5%.
Please round your answer to the nearest cent.
4. What is the current value of a $1,000 bond with a 5% annual coupon rate (paid semi-annually) that matures in 6 years if the appropriate stated annual discount rate is 8%.
Please round your answer to the nearest cent.
|
Analyze and discuss small business growth
: In this paper, students will analyze and discuss small business growth in terms of growth strategy, business forms, short and medium term goals, financing assistance, organizational structure and staffing needs, customers and promotion, and ethics an..
|
|
What is the present value of a series of payments received
: What is the present value of a series of payments received each year forever, starting with $400 paid one year from now and the payment growing in each subsequent year by 9%? Assume a discount rate of 11%.
|
|
What fraction of the sky have the constellations moved
: Naked Eye Observing Project- What fraction of the year is the interval between your two observations (for example, 3 months is 1/4th of a year)? Approximately what fraction of the sky have the constellations moved across
|
|
What is equivalent monetary amount in terms of present worth
: What is the equivalent monetary amount in terms of present worth? Show the appropriate variable values, and then solve using the current monetary value formula.
|
|
What is the current value of a zero-coupon bond
: What is the current value of a $1,000 bond with a 5% annual coupon rate (paid semi-annually) that matures in 6 years if the appropriate stated annual discount rate is 8%.
|
|
What amount of time is necessary to realize given situation
: I anticipate having the amount of $4,000.00 after an unknown period of time. The monetary present worth is $2,357.35. The rate is 4.7%. What amount of time is necessary to realize this situation?
|
|
What is net present value of the more attractive generator
: What is the net present value of the more attractive alternative?
|
|
Ecker company reports
: Ecker Company reports $ 2,700,000 of net income for 2013 and declares $ 388,020 of cash dividends on its preferred stock for 2013. At the end of 2013, the company had 678,000 weighted average shares of common stock.
|
|
Discuss substantively three strategic economic resource
: Define the term capital budgeting. Within your definition, discuss substantively three strategic economic resource allocation issues that affect law enforcement entities and the justice system when capital investment decisions are contemplated.
|