Question

In: Finance

Prepare a spreadsheet using Excel or a similar program in which you compute the items listed...

Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9.

Kaufman Enterprises has bonds outstanding with a $1,000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $1,175. The bonds may be called in 5 years at 109% of face value (Call price = $1,090). a. What is the yield to maturity? b. What is the yield to call if they are called in 5 years? c. Which yield might investors expect to earn on these bonds? Why? d. The bond’s indenture indicates that the call provision gives the firm the right to call the bonds at the end of each year beginning in Year 5. In Year 5, the bonds may be called at 109% of face value; but in each of the next 4 years, the call percentage will decline by 1%. Thus, in Year 6, they may be called at 108% of face value; in Year 7, they may be called at 107% of face value; and so forth. If the yield curve is horizontal and interest rates remain at their current level, when is the latest that investors might expect the firm to call the bonds?

Solutions

Expert Solution


Related Solutions

Prepare a spreadsheet using Excel or a similar program in which you compute the items listed...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9. Kaufman Enterprises has bonds outstanding with a $1,000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $1,185. The bonds may be called in 5 years at...
1. Understand how to use EXCEL Spreadsheet (a)  Develop proforma Income Statement Using Excel Spreadsheet (b)  Compute  Net Project...
1. Understand how to use EXCEL Spreadsheet (a)  Develop proforma Income Statement Using Excel Spreadsheet (b)  Compute  Net Project Cashflows, NPV,  and IRR (c) Develop problem-solving and  critical thinking skills and make long-term investment decisions 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $200,000 2) New equipment cost $(200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $(35,000) 10) Operating cost (60% of Sales) $(120,000) 4) Related start up cost $(5,000)     (as a percent...
Using Excel prepare a spreadsheet to show the profit and loss figure for the last financial...
Using Excel prepare a spreadsheet to show the profit and loss figure for the last financial year. The profit and loss should be shown as dollars and as a percentage. Enter the raw data below, applying as many presentation Features (Font, Font Size, Font Color, Number Formats and Color, Cell Shading, Text Rotation, etc) to it as you wish. Apply appropriate number formats to your numbers. Center your spreadsheet horizontally on the page Give your spreadsheet an appropriate title and...
Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard), prepare...
Using the financial statement provided (an Excel spreadsheet with the data is available on Blackboard), prepare a complete Statement of Cash Flows that shows both the direct method and the indirect method for summarizing cash flow from operating activities. Note to complete the assignment you will need to calculate items such as dividends paid (Retained Earnings & AOCI2019 – Net income2019 – Retained Earnings & AOCI2018) and capital expenditures (Net PP&E2018 – Book Value of PP&E Sold2019 – Depreciation Expense2019...
To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be...
To complete this comprehensive exercise, use the Excel spreadsheet program. In this exercise you will be using linear programming and Solver in Excel to solve the problem described in the following scenario. At Goodman Shipping, the load master wants to determine the mix of cargo to be carried on the next trip. The ship's volume limit for cargo is 100,000 cubic meters, and its weight capacity is 2,310 tons. The master has five different types of cargo from which to...
Prepare an Excel spreadsheet to present your financial decisions for two projects using NPV, IRR and...
Prepare an Excel spreadsheet to present your financial decisions for two projects using NPV, IRR and the Payback Period techniques. There are two mutually exclusive projects A and B.  Both projects require an investment of $10 million but the timing is different for the rest of the expected net cash flows. For project A                           For project B Period 0 =    - $10.0 m            - $10.0 million Period 1 =           6.5                       3.5 m Period 2              3.0                        3.5 Period 3 =           3.0                          3.5 Period 4 =           1.5                          3.5 Total Inflow = $14.0m                $14.0m Prepare 3...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$  26,500 Units started during April ......................................................................................................................................100,000 Units...
Your task is to create the 2021 Budget in an Excel Spreadsheet.  You only need to prepare...
Your task is to create the 2021 Budget in an Excel Spreadsheet.  You only need to prepare an Income Statement Assume: The company will sell 16,000 bicycles at an average price of $2,500 each Cost of Labor is 20% of Sales Cost of Materials is 10% of Sales Variable Overhead is 6% of Sales Fixed Manufacturing Overhead is $4,000,000 Office Salaries are 5,000,000 Office Deprecation Expense is $500,000 Lease Expense of Corporate Office is $2,000,000 Advertising is $1,000,000 Income Taxes are...
(a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR...
(a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $200,000 2) New equipment cost $(200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $(35,000) 10) Operating cost (60% of Sales) $(120,000) 4) Related start up cost $(5,000)     (as a percent of sales in Year 1) -60% 5) Inventory increase $25,000 11) Depreciation Use...
CASE STUDY USING EXCEL SPREADSHEET You work for Theo Walcott Tours Ltd which provide tourists and...
CASE STUDY USING EXCEL SPREADSHEET You work for Theo Walcott Tours Ltd which provide tourists and visitors with ‘experiences’ of Perth and its surrounds. Your manager is currently investigating introducing another product, which are ‘Luxury’ helicopter rides over beautiful bushland. Each trip would be 50km in total. Your manager wants you to use cost-volume-profit analysis in order to help assess the plan’s feasibility. She provides you with the following estimated data: Selling price per trip: $600 (total for 3 customers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT