time to next coupon | 1 year | 2 year | 3 year | 4 year | 5 year | 6 year | 7 year | 8 year | 9 year |
Coupon period | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 |
Interest | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 | 70 |
PVF at 6% YTM | 0.943 | 0.890 | 0.840 | 0.792 | 0.747 | 0.705 | 0.665 | 0.627 | 0.592 |
PV | 66.03773585 | 62.2997508 | 58.77334981 | 55.44655643 | 52.3080721 | 49.34723783 | 46.55399795 | 43.91886599 | 41.43289245 |
PV of remaining coupon at end of year 1 | 476.1184592 |
. BIU Alignment Font mat Painter Sard - XE Problem 6-19 Suppose that General Motors Acceptance Corporation issued a...
Please include cell references. Problem 6-12 Suppose a 10-year, $1,000 bond with an 8% coupon rate and semiannual coupons is trading for $1,034.74 Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the...
Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when it was issued was 6%. What was the price of this bond when it was issued? Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy paste a formula...
Ortiz Berk Dellazo_ Har Review view v Tel me what you Home General Wrap Test Tent Page Layout Formule Data Times New Roma - 4 AA== C . Conditional Formatas Formatting Table * cut Copy" Format Painter Alignment Font Clipboard F G H Problem 6-18 Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7% (annual payments). The yield to maturity on this bond when...
Problem 5-21 You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800,000. The mortgage is currently exactly 1872 years old, and you have just made a payment. If the interest rate on the mortgage is 5.25% (APR), how much cash will you have from the sale once you pay off the mortgage? Complete the steps below using cell references to given data or previous...
Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $1,000, and a coupon rate of 7.6% (annual payments). The yield to maturity on this bond when it was issued was 6.5%. Assuming the yield to maturity remains constant, what is the price of the bond immediately after it makes its first coupon payment? After the first coupon payment, the price of the bond will be $ . (Round to the nearest...
plz do it through excel, thank you X == General Times New Roman - 14 - AA BIU - OA . Paste Wrap Text Merge & Center - EE $ -% Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Alignment GH Problem 5-21 You have just sold your house for $1,000,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $800.000. The mortgage is currently exactly 1872 years old,...
Please type the formula of how do you get the answer, For example, D16=E2*D3 Thank you J35 1 x ✓ fx ADVANCED PROBLEM 6-2 FOR SPREADSHEET APPLICATION Callable bond and call premium. Edward has just purchased a callable bond and wants to determine the bond's potential payoff price if it is called at any time during its callable life. The callable bond is a twenty-year semiannual bond that an issuer can call starting at year ten. It is callable every...
airements 1 In cell D11, by using cell references, calculate the monthly interest rate of the current credit card (1 pt.). 2 In cell D12, by using cell references, calculate the interest payment on the current credit card (1 pt). Note: The output of the expression or function you typed in this cell is expected as a positive number. 3 In cell D13, by using cell references, calculate the monthly interest rate of the new credit card (1 pt.) 4...
1. Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $ 1,000 and a coupon rate of 7.7 % (annual payments). The yield to maturity on this bond when it was issued was 6.2 %.What was the price of this bond when it was issued? When it was issued, the price of the bond was $.......... (Round to the nearest cent.) 2. Your company currently has $ 1,000 par, 5.75 %...
Suppose that General Motors Acceptance Corporation issued a bond with 10 years until maturity, a face value of $ 1, 000, and a coupon rate of 7.1 % (annual payments). The yield to maturity on this bond when it was issued was 5.8 %. What was the price of this bond when it was issued?