Reference no: EM131354347
On January 1, 2016, the Blue Devil Corporation issued $20,000,000 of ten-year bonds. The bonds carried a stated interest rate of 5 percent, with interest payable semiannually on June 30 and December 31.
1. Using the Excel PV function, determine the proceeds of the bond issuance assuming a 6 percent effective (market) interest rate. Write your function and the answer below: PV(rate,nper,pmt,fv,type) =
2. Create an amortization table In Excel for the entire term of the bonds using the effective interest method of amortization. A formula or copying a formula is required for all cells that contain numbers.
3. Using the Excel PV function, determine the proceeds of the bond issuance assuming a 4 percent effective (market) interest rate. Write your function and the answer below:
4. Using sheet 2 of the same file you created for step 2, repeat step 2 above assuming that the market interest rate is 4 percent.
|
Please evaluate the equal annual annuity
: Please evaluate the equal annual annuity for the following repeated project. The initial investment for the project is $1 million and it will produce cash flows $0.5 million, $1.0 million, $0.8 million in year 1, 2 and 3. The discount rate is 5%.
|
|
Evaluating two different cookie-baking ovens
: You are evaluating two different cookie-baking ovens. The Pillsbury 707 costs $70,000, has a 5-year life, and has an annual OCF (after tax) of –$11,300 per year. The Keebler CookieMunster costs $96,500, has a 7-year life, and has an annual OCF (after..
|
|
Leaving the irr the same for moderate risk projects
: Meds R Us has just finished evaluating several projects. Their cost of capital is 10%. NPV’s are calculated by the firm’s current cost of capital. Meds R Us now performs a risk assessment of the projects. They adjust for project risk by raising the c..
|
|
Finished evaluating several projects
: Meds R Us has just finished evaluating several projects. Their cost of capital is 10%. NPV’s are calculated by the firm’s current cost of capital. If Meds R Us has a Capital Budget limit of $120,000, and assuming the projects are of the same risk, wh..
|
|
Determine the proceeds of the bond issuance assuming
: On January 1, 2016, the Blue Devil Corporation issued $20,000,000 of ten-year bonds. The bonds carried a stated interest rate of 5 percent, with interest payable semiannually on June 30 and December 31. Using the Excel PV function, determine the proc..
|
|
What will be after-tax cash flow of this sale
: Suppose you sell a fixed asset for $126,000 when its book value is $146,000. If your company’s marginal tax rate is 40 percent, what will be the effect on cash flows of this sale (i.e., what will be the after-tax cash flow of this sale)?
|
|
What are the depreciable value of the equipment
: The Nullcom Inc. is considering to purchase a new machine. The cost of the machine is $200,000 and installation of $10,000. The machine will be depreciated straight-line to zero. The new machine needs an increase of new working capital of $30,000. Wh..
|
|
Analyzing the cost of debt for firm
: You are analyzing the cost of debt for a firm. You know that the firm’s 14-year maturity, 8.2 percent coupon bonds are selling at a price of $776.45. The bonds pay interest semiannually. If these bonds are the only debt outstanding for the firm, answ..
|
|
What are the depreciable value of the equipment
: The Nullcom Inc. is considering to purchase a new machine. The cost of the machine is $200,000 and installation of $10,000. The machine will be depreciated straight-line to zero. The new machine needs an increase of new working capital of $30,000. Wh..
|