Question: please show formulas and manual calculation ! not just an excel sheet 6. A two year bond is sold at discount for $1453.20. Its semi-annual

please show formulas and manual calculation ! not just an excel sheet

6. A two year bond is sold at discount for $1453.20. Its semi-annual coupons are $25. Its first amount for accumulation of discount is P = $11.33. Construct an amortization schedule for this bond in the table below. Amount for Interest accumulation earned of discount Half- Coupon 1453.20 25.00 11.33 2 25.00 .co 25.00 A 25.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The Berndt Corporation expects to have sales of $10 million. Costs other than depreciation are expected to be 80% of sales, and depreciation is expected to be $1 million. All sales revenues will be...

please show formulas and manual calculation ! not just an excel sheet a) Consider a two year bond with annual coupons. Find the yield rate of this bond if its price is $1411, its redemption value is...

please show formulas and manual calculation ! not just an excel sheet 5. Consider a three year $1000 par value bond with a redemption value of $1200 and with 8% coupons paid quarterly bought to yield...

Qa. If the one year spot rate is 4% and the forward rates for years 2, 3, 4, 5 are 5%, 7%, 8%, and 6%, respectively, then today's interest rate on a five-year bond should be : 4% 5% 6% 7% 8% One...

Hello my friend please assist me with my discussion Interest Rates Negotiation is a soft skill that might just be one of the most important skills you will ever learn. For this Discussion you will...

Could someone please show me how to work these out in Excel? I am having a bit of trouble with the formulas and how to get the correct answers. Cell references would be appreciated. Thanks Home...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

**Please show formulas** Argo Airlines, a privately held firm, is looking to buy additional gates at its home airport for $500,000. Argo has $150,000 in the bank but that money may not be spent as it...

please show formulas used in excel 4. Check figures: - total cost of shirt purchases: $371,380 - total manufacturing overhead: $91,031 - ending cash balance: $51,824 - net operating income: $175,370...

*PLEASE SHOW FORMULAS* Ruiz Company issued bonds on January 1 and has provided the relevant information. The Controller has asked you to calculate the bond selling price given two different market...

sorry for long question. please fill in any of the blanks left in the excel sheet below. please show formula's ToyWorks Ltd. is a company that manufactures and sells a single product, which they call...

Projected sales units of XYZ Corporation are as follows: I. Three Months II. Three Months III. Three Months IV. Three Months Product C 15 10 5 20 Target sales price for Product C: 5 TL/unit 24. What...

(a) Show that ke 2 = 1.44 MeV fm, where k is the Coulomb constant and e is the electron charge. (b) Show that hc = 1240 MeV fm.

city street fund portfolio 5 0 2 million and liabilities 2 2 million if a larger investor redeems 2 million shares what is the net asset value

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...