Reference no: EM13177694
On January 1, 2010 Sycamore Co. issued 7%, 5 year bonds with a face amount of 5 million dollars. The market yield for bonds of similar risk and maturity was 8%. Interest is paid semiannually on June 30 and December 31
1. Prepare an amortization table for Sycamore Co. assuming the effective interest method is used. Follow the format of the amortization table on page 792 in your text. Round amounts to the nearest dollar. Include all 10 payments in your table and totals for cash paid, interest expense, and discount amortized.
2. Prepare an amortization table for Sycamore Co. assuming the market rate was 6% and the effective interest method is used. Follow the format of the amortization table on page 793 in your text. Round amounts to the nearest dollar. Include all 10 payments in your table and totals for cash paid, interest expense, and premium amortized.
3. Prepare an amortization table for Sycamore assuming the market rate was 8% and the company elected to use the straight-line amortization method since the results were not materially different from the effective int. method.
Use excel's formula functions to complete your amortization tables. In other words, don't just do the tables by hand and then copy your numbers into excel. The whole point of using excel is to make this a more efficient process. If you do the tables manually and copy the numbers into excel you will receive a 0/20. You may need to manually enter the interest expense and discount/premium amortization on the last payment so that your carrying value of the bonds at 12/31/2014 is $5,000,000.
|
How does the demand for bonds vary
: What is the relation between the price of the bond and the interest rate? If the interest rate is 8%, what is the price of the bond today? How does the demand for bonds vary with the price of bonds?
|
|
Write a rule that relates the daredevil height
: The opening of the cannon pictured at the left is 16 feet above the ground. The daredevil, who is shot out of the cannon, reaches a maximum height of 55 feet after about 1.56 seconds and hits a net that is 9.5 feet off the ground after 3.25 second..
|
|
What amount will get after retirement
: Matt is a 25 year old engineer, and his salary next year will be $60,000. Matt expects that his salary will increase at a steady rate of 5% per year until his retirement at age 65. If he saves 10% of his salary each year and invest these savings a..
|
|
Use the straight-line method
: Suppose a business purchases a new tractor at an original cost of $42,000. Further, suppose this tractor has a useful life of 8 years and a salvage value of $10,000.
|
|
Prepare an amortization table for sycamore
: Prepare an amortization table for Sycamore Co. assuming the effective interest method is used and prepare an amortization table for Sycamore Co. assuming the market rate was 6% and the effective interest method is used
|
|
Find any absolute or local maximum and minimum values
: find any absolute or local maximum and minimum values of f(x)=8-2x if x≥6.
|
|
Determine price elesticity of demend
: Studies indicate that the price elasticity of demand for cigarettes is about .4. If a pack of cigarettes currently costs $2, and the government wants to reduce smoking by 20 percent, by how much should it increase its price?
|
|
What is the percent of decrease
: A handbag originally cost $85.00. Now it is priced at $68.00. What is the percent of decrease?
|
|
How the operating cycle data relate to working capital
: Use the BOP analysis to briefly discuss how the operating cycle data relate to the amount of working capital and the current and acid-test ratios.
|