Snowbirds Resort, Inc. has a chain of facilities located in the southern part of the United...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Snowbirds Resort, Inc. has a chain of facilities located in the southern part of the United States that caters to clients who generally live in northern states who want to escape the cold of winter. To finance their operations, the company offers a mix of investment bonds and stock offerings. In order to entice investors to the company, management needs to provide information on the performance of the bonds offered, as well as predictions for stock valuation. Two new bonds are being offered to investors. One bond has a 10 year maturity, and the second has a 30 year maturity. Management has asked you to write up the data on the bonds so that it can be distributed as part of the investor package. This information for each of the bonds includes the number of periods until it is callable, the periodic yield, annual coupon rate, and other areas of interest for investor evaluation. The information for each bond is outlined below. Directions: For each of the bonds, calculate the data for each item criteria outlined below. Enter your data to the blue cells. Use Excel to aid you with your calculations and refer to the provided "Hints" for your calculations. Answer the Analysis Question once all calculations have been completed. Bond # 1: 10 Year Maturity Bond #1 is a 10 year, 4.5% semiannual coupon bond. It has a par/face value of $5,000 and may be called in 6 years at a call price of $7,500. The bond sells for $5,250. Complete the information in the table below. Bond Information Years to maturity: Periods per year: Periods to maturity: Coupon rate: Par/face value: Periodic payment: Current price Call price: Years till callable: Periods till callable: 10 2 20 4.5% $5,000 $112.50 $5,250 $7,500 6 12 Formulas How long it is for Number of times it pays interest number of years x number of payment periods 25 years x 2 period Your interest rate Face value...aka the value of the bond Par value x (coupon rate / periods per year) Sale price Amount paid should the bond be called early... aka the person using the bond money pays their loan off early When they can call it in, meaning pay you the $6000 for it number of years x number of periods Based on the bond information above, calculate the following information for Bond #1: Periodic Yield to Maturity - Annual Yield to Maturity = Annual Coupon Rate = Current yield = Periodic Yield to Call = Annual Yield to Call = Bond #2: 30 Year Maturity Bond Information Years to maturity: Periods per year: Periods to maturity: Coupon rate: Par/face value: Periodic payment: Current price Call price: Years till callable: Periods till callable: 30 2 6.25% $3,000 Hints: Try using rate function of Excel and enter periods to maturity, periodic payment, negative current price, par value; this is the yield for each period you own the bond $3,000 $7,500 10 Use your periodic yield to maturity and the periods per year; this is your yield for each year Bond #2 is a 30 year, 6.25% semiannual coupon bond. It has a par/face value of $3,000 and may be called in 10 years at a call price of $7,500. The bond sells for $3,000. Complete the information in the table below. This is a dollar value, not a percent; the payment amount you can expect each year Ann. Coupon Rate / Current Price; yield based on current conditions Try using the RATE function of Excel Use your periodic yield to call x periods per year, this is your yield for each year until the bond is callable Formulas How long it is for Number of times it pays interest number of years x number of payment periods 25 years x 2 period Your interest rate Face value... aka the value of the bond Par value x (coupon rate / periods per year) Sale price Formulas using rate function, enter periods to maturity, periodic payment, negative current price, par value Amount paid should the bond be called early... aka the person using the bond money pays their loan off early When they can call it in, meaning pay you the $6000 for it number of years x number of periods Periodic yield to maturity x periods per year. Periodic payment x periods per year Ann. Coupon / Current Price Rate function using: periods to call, periodic payment, negative current price, call price Periodic yield to call x periods per year Based on the bond information above, calculate the following information for Bond #1: Periodic Yield to Maturity = Annual Yield to Maturity - Annual Coupon Rate = Current yield = Periodic Yield to Call = Annual Yield to Call = Hints: Try using rate function of Excel and enter periods to maturity, periodic payment, negative current price, par value; this is the yield for each period you own the bond Use your periodic yield to maturity and the periods per year; this is your yield for each year This is a dollar value, not a percent; the payment amount you can expect each year Ann. Coupon Rate / Current Price; yield based on current conditions Try using the RATE function of Excel Use your periodic yield to call x periods per year, this is your yield for each year until the bond is callable Formulas using rate function, enter periods to maturity, periodic payment, negative current price, par value Periodic yield to maturity x periods per year Periodic payment x periods per year Ann. Coupon / Current Price Rate function using: periods to call, periodic payment, negative current price, call price. Periodic yield to call x periods per year Analysis Question: In your opinion, which bond is the better purchase for investors? Why do you feel it is the better purchase? Explain your answer using a minimum of 3 sentences. Snowbirds Resort, Inc. has a chain of facilities located in the southern part of the United States that caters to clients who generally live in northern states who want to escape the cold of winter. To finance their operations, the company offers a mix of investment bonds and stock offerings. In order to entice investors to the company, management needs to provide information on the performance of the bonds offered, as well as predictions for stock valuation. Two new bonds are being offered to investors. One bond has a 10 year maturity, and the second has a 30 year maturity. Management has asked you to write up the data on the bonds so that it can be distributed as part of the investor package. This information for each of the bonds includes the number of periods until it is callable, the periodic yield, annual coupon rate, and other areas of interest for investor evaluation. The information for each bond is outlined below. Directions: For each of the bonds, calculate the data for each item criteria outlined below. Enter your data to the blue cells. Use Excel to aid you with your calculations and refer to the provided "Hints" for your calculations. Answer the Analysis Question once all calculations have been completed. Bond # 1: 10 Year Maturity Bond #1 is a 10 year, 4.5% semiannual coupon bond. It has a par/face value of $5,000 and may be called in 6 years at a call price of $7,500. The bond sells for $5,250. Complete the information in the table below. Bond Information Years to maturity: Periods per year: Periods to maturity: Coupon rate: Par/face value: Periodic payment: Current price Call price: Years till callable: Periods till callable: 10 2 20 4.5% $5,000 $112.50 $5,250 $7,500 6 12 Formulas How long it is for Number of times it pays interest number of years x number of payment periods 25 years x 2 period Your interest rate Face value...aka the value of the bond Par value x (coupon rate / periods per year) Sale price Amount paid should the bond be called early... aka the person using the bond money pays their loan off early When they can call it in, meaning pay you the $6000 for it number of years x number of periods Based on the bond information above, calculate the following information for Bond #1: Periodic Yield to Maturity - Annual Yield to Maturity = Annual Coupon Rate = Current yield = Periodic Yield to Call = Annual Yield to Call = Bond #2: 30 Year Maturity Bond Information Years to maturity: Periods per year: Periods to maturity: Coupon rate: Par/face value: Periodic payment: Current price Call price: Years till callable: Periods till callable: 30 2 6.25% $3,000 Hints: Try using rate function of Excel and enter periods to maturity, periodic payment, negative current price, par value; this is the yield for each period you own the bond $3,000 $7,500 10 Use your periodic yield to maturity and the periods per year; this is your yield for each year Bond #2 is a 30 year, 6.25% semiannual coupon bond. It has a par/face value of $3,000 and may be called in 10 years at a call price of $7,500. The bond sells for $3,000. Complete the information in the table below. This is a dollar value, not a percent; the payment amount you can expect each year Ann. Coupon Rate / Current Price; yield based on current conditions Try using the RATE function of Excel Use your periodic yield to call x periods per year, this is your yield for each year until the bond is callable Formulas How long it is for Number of times it pays interest number of years x number of payment periods 25 years x 2 period Your interest rate Face value... aka the value of the bond Par value x (coupon rate / periods per year) Sale price Formulas using rate function, enter periods to maturity, periodic payment, negative current price, par value Amount paid should the bond be called early... aka the person using the bond money pays their loan off early When they can call it in, meaning pay you the $6000 for it number of years x number of periods Periodic yield to maturity x periods per year. Periodic payment x periods per year Ann. Coupon / Current Price Rate function using: periods to call, periodic payment, negative current price, call price Periodic yield to call x periods per year Based on the bond information above, calculate the following information for Bond #1: Periodic Yield to Maturity = Annual Yield to Maturity - Annual Coupon Rate = Current yield = Periodic Yield to Call = Annual Yield to Call = Hints: Try using rate function of Excel and enter periods to maturity, periodic payment, negative current price, par value; this is the yield for each period you own the bond Use your periodic yield to maturity and the periods per year; this is your yield for each year This is a dollar value, not a percent; the payment amount you can expect each year Ann. Coupon Rate / Current Price; yield based on current conditions Try using the RATE function of Excel Use your periodic yield to call x periods per year, this is your yield for each year until the bond is callable Formulas using rate function, enter periods to maturity, periodic payment, negative current price, par value Periodic yield to maturity x periods per year Periodic payment x periods per year Ann. Coupon / Current Price Rate function using: periods to call, periodic payment, negative current price, call price. Periodic yield to call x periods per year Analysis Question: In your opinion, which bond is the better purchase for investors? Why do you feel it is the better purchase? Explain your answer using a minimum of 3 sentences.
Expert Answer:
Answer rating: 100% (QA)
To calculate the various yields for Bond 1 we will use the given information and the provided formulas Bond 1 is a 10year 45 semiannual coupon bond wi... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
James has $15,000 in his saving account now. (a) What is the amount he deposited one year ago in his saving account if the account has a rate of return of 10%? (b) Calculate the earned amount of...
-
UV light causes sunburn, whereas visible light does not. Suggest a reason.
-
Distinguish between (1) concurrent and (2) additional or planned tests of controls. b. Indicate the range of assessed levels of control risk that evidence from each type of test of controls may...
-
The following are six journal entries Keene Engineering, Inc., made during the month of April. Requirement 1. For each transaction shown, determine the accounts affected, the type of account, whether...
-
Q1. Use the information below for J.C. Penney and Intel to answer the following questions. a. Calculate the values for (A) and (X). Revenue for INTC is more than (__________ / 10 times) greater than...
-
Question 5: A company is considering making or buying a certain component that it needs. The purchase cost is $9 per piece. To make the part, the company needs to rent a machine at the cost of $4000...
-
This case study explores two networks, an outsourced group of housing benefit caseworkers and production workers in a specialist chemicals company, and considers the effect that each network had on...
-
Samresh purchased three motor cycles on 1st January, 2014, the cash price being * 56,000. The purchase is on the instalment system, * 15,000 being paid on the signing the contract and thereafter...
-
A candy company made $406.38 for every 78 boxes of candy they sold. Write an equation that can be used to express the relationship between the total amount earned(t) and the boxes et candy they...
-
Simplify x= -10102-4.5.8 2.5
-
The Project Risk Management textbook and the PMBOK Guide processes are designed to be simple, scalable formats for performing risk management that can be applied to any project. 1-What are the...
-
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments-Molding and Fabrication. It started, completed, and sold...
-
As per Scientific Glass, Inc.: Inventory Management case study, What were the merits and risks of implementing the proposed policy changes, of reverting back to fewer warehouses, and of centralizing...
-
The manager of Home Office Supplies has prepared the following information on a transhipment problem. Locations labelled 1,2 and 3 are supply points; locations 4 and 5 are intermediate transhipment...
-
XYZ Inc. a calendar year, accrual basis corporation, had the following items during 2021: Gross revenue from operations Cost of goods sold $420,000 ($180,000) $9,000 LT capital gain .LT capital...
-
In 1967, a Chicago brewer, Meister Brau, Inc., began making and selling a reduced-calorie, reduced-carbohydrate beer under the name LITE. Late in 1968, that company filed applications to register...
-
Donna drove an automobile into Terrys garage and requested him to make repairs for which the charge would be $125. Donna, however, never returned to get the automobile. Two months later, Carla saw...
-
Explain the international dimensions of antitrust law, securities regulation, the protection of intellectual property, and employment discrimination.
-
If the correlation coefficient is equal to 0, the slope of the least-squares regression line will be equal to _____________________ . In Exercises 57, fill in each blank with the appropriate word or...
-
In Exercises 1316, compute the least-squares regression line for the given data set. xy 1 2 3 5 5 6 9 7
-
In Exercises 1316, compute the least-squares regression line for the given data set. x 42 36 14 18 23 36 17 y 72 68 25 31 42 42 65 32
Study smarter with the SolutionInn App