Question

In: Accounting

Please do it by type not pics. 1.$2,000,000 ten year note with 10% interest. The market...

Please do it by type not pics.

1.$2,000,000 ten year note with 10% interest. The market rate is 8.5%. The interest payments are made monthly and interest compounds monthly.

·         How much cash was received in year 1?    

·         What was the amortized amount of the premium in year 2 - month 3?      

·         How much interest revenue was recognized in year 3 - month 4?

·         What is the carrying value of the note at the end of year 4?          

·         What is the balance of the discount account correlated with this note at the end of year 3?

Solutions

Expert Solution

First we would calculate the present value of the note
Monthly Interest rate 0.833333 10%/12
Note Amount 2000000
Monthly Market interest rate 0.708333 8.5%/12
Monthly Interest Amount 16666.67
Using the PV function in excel we get
($2,201,636.17)
Price of note is $2,201,636.17
Payments Interest Received Interest Revenue on market value Amortization of note Discount/Premium on bond Value of note market value of note
0 201636.2 2000000 2201636
1 16666.67 15594.92 -1071.747129 200564.4 2000000 2200564
2 16666.67 15587.33 -1079.338671 199485.1 2000000 2199485
3 16666.67 15579.69 -1086.983987 198398.1 2000000 2198398
4 16666.67 15571.99 -1094.683457 197303.4 2000000 2197303
5 16666.67 15564.23 -1102.437465 196201 2000000 2196201
6 16666.67 15556.42 -1110.246397 195090.7 2000000 2195091
7 16666.67 15548.56 -1118.110642 193972.6 2000000 2193973
8 16666.67 15540.64 -1126.030592 192846.6 2000000 2192847
9 16666.67 15532.66 -1134.006642 191712.6 2000000 2191713
10 16666.67 15524.63 -1142.039189 190570.5 2000000 2190571
11 16666.67 15516.54 -1150.128634 189420.4 2000000 2189420
12 16666.67 15508.39 -1158.275378 188262.1 2000000 2188262
13 16666.67 15500.19 -1166.479829 187095.7 2000000 2187096
14 16666.67 15491.93 -1174.742394 185920.9 2000000 2185921
15 16666.67 15483.61 -1183.063486 184737.9 2000000 2184738
16 16666.67 15475.23 -1191.443519 183546.4 2000000 2183546
17 16666.67 15466.79 -1199.882911 182346.5 2000000 2182347
18 16666.67 15458.29 -1208.382081 181138.1 2000000 2181138
19 16666.67 15449.73 -1216.941455 179921.2 2000000 2179921
20 16666.67 15441.11 -1225.561457 178695.6 2000000 2178696
21 16666.67 15432.43 -1234.242517 177461.4 2000000 2177461
22 16666.67 15423.68 -1242.985068 176218.4 2000000 2176218
23 16666.67 15414.88 -1251.789546 174966.6 2000000 2174967
24 16666.67 15406.01 -1260.656388 173706 2000000 2173706
25 16666.67 15397.08 -1269.586038 172436.4 2000000 2172436
26 16666.67 15388.09 -1278.578939 171157.8 2000000 2171158
27 16666.67 15379.03 -1287.635539 169870.2 2000000 2169870
28 16666.67 15369.91 -1296.756291 168573.4 2000000 2168573
29 16666.67 15360.73 -1305.941648 167267.5 2000000 2167267
30 16666.67 15351.48 -1315.192068 165952.3 2000000 2165952
31 16666.67 15342.16 -1324.508012 164627.8 2000000 2164628
32 16666.67 15332.78 -1333.889944 163293.9 2000000 2163294
33 16666.67 15323.33 -1343.338331 161950.5 2000000 2161951
34 16666.67 15313.82 -1352.853644 160597.7 2000000 2160598
35 16666.67 15304.23 -1362.436357 159235.3 2000000 2159235
36 16666.67 15294.58 -1372.086948 157863.2 2000000 2157863
37 16666.67 15284.86 -1381.805898 156481.4 2000000 2156481
38 16666.67 15275.08 -1391.593689 155089.8 2000000 2155090
39 16666.67 15265.22 -1401.450811 153688.3 2000000 2153688
40 16666.67 15255.29 -1411.377755 152276.9 2000000 2152277
41 16666.67 15245.29 -1421.375014 150855.6 2000000 2150856
42 16666.67 15235.23 -1431.443087 149424.1 2000000 2149424
43 16666.67 15225.09 -1441.582475 147982.5 2000000 2147983
44 16666.67 15214.88 -1451.793684 146530.7 2000000 2146531
45 16666.67 15204.59 -1462.077223 145068.7 2000000 2145069
46 16666.67 15194.24 -1472.433603 143596.2 2000000 2143596
47 16666.67 15183.81 -1482.863341 142113.4 2000000 2142113
48 16666.67 15173.3 -1493.366957 140620 2000000 2140620
How much cash was received in year 1? 200000.00
What was the amortized amount of the premium in year 2 - month 3 1183.06
How much interest revenue was recognized in year 3 - month 4? 15369.91
What is the carrying value of the note at the end of year 4? 2140620.00
What is the balance of the discount account correlated with this note at the end of year 3? 157863.17

Related Solutions

Please do it by type not pics. 1.A 6.30 percent coupon bond with 10 years left...
Please do it by type not pics. 1.A 6.30 percent coupon bond with 10 years left to maturity is priced to offer a yield to maturity of 7.6 percent. You believe that in one year, the yield to maturity will be 7.0 percent. What is the change in price the bond will experience in dollars? change in bond price =
Please do it by type not pics. 1.You are considering an investment in Roxie's Bed &...
Please do it by type not pics. 1.You are considering an investment in Roxie's Bed & Breakfast Corp. During the last year, the firm's income statement listed an addition to retained earnings of $10.20 million and common stock dividends of $3.10 million. Roxie's year-end balance sheet shows common stockholders' equity of $44.9 million with 19 million shares of common stock outstanding. The common stock's market price per share was $9.30. What is Roxie's Bed & Breakfast's book value per share?...
Please do it by type not pics. 1.Explain the factors that influence the ability of countries...
Please do it by type not pics. 1.Explain the factors that influence the ability of countries and populations to develop into modern industrialized countries? a.Per class discussion what role does the “rule of law” play in economic development? b.Why does your instructor believe this is the most important factor in economic development? c.Compare the role of TFP to capital accumulation is economic development d.Compare the divergence in the standard of living across the Earth two hundred years ago to that...
Please do it by type not pics. 1.The Great Recession (2007 to 2009) changed the nature...
Please do it by type not pics. 1.The Great Recession (2007 to 2009) changed the nature and direction of the macroeconomic debate because: a.the financial crisis threatened to collapse the entire economy, an outcome not predicted by classical models. b.the prior direction of the macroeconomic debate was on the New Classical and Real Business Cycle models. c.the technology boom of the 1990s seemed to validate the Real Business Cycle model. d.of all of the answers in this question. e.the recession...
Please do it by type not pics. 1.Consider a 3.05 percent TIPS with an issue CPI...
Please do it by type not pics. 1.Consider a 3.05 percent TIPS with an issue CPI reference of 184.9. At the beginning of this year, the CPI was 191.6 and was at 201.5 at the end of the year. What was the capital gain of the TIPS in dollars? What was the capital gain of the TIPS in percentage?
Please do it by type not pics. 1.The empirical tit of ttte production model: The table...
Please do it by type not pics. 1.The empirical tit of ttte production model: The table below reports per capita GDP and capital per person in the year 2014 for 10 countries. Your task is to fill in the missing columns of the table. a.Given the values in columns 1 and 2, fill in columns 3 and 4. That is, compute per capiiz GDP and capital per person relative to the U.S. values. b.In column 5, use the production model...
Please do it by type not pics. 1.Waller Co. paid a $0.153 dividend per share in...
Please do it by type not pics. 1.Waller Co. paid a $0.153 dividend per share in 2000, which grew to $0.333 in 2012. This growth is expected to continue. What is the value of this stock at the beginning of 2013 when the required return is 15.3 percent? 2.Consider a firm that had been priced using a 12 percent growth rate and a 14 percent required return. The firm recently paid a $2.05 dividend. The firm just announced that because...
Please do it by type not pics. 1.China Inc. sales rice to Wok This Way Inc....
Please do it by type not pics. 1.China Inc. sales rice to Wok This Way Inc. on account for $100,000. The terms of the sale are 3/10, n/30. China Inc. expects that Wok This Way Inc. will take the discount. Assume China Inc. uses the net method. What is the amount of sales discount debited when the payment is received in the discount period? 2.China Inc. sales rice to Wok This Way Inc. on account for $100,000. The terms of...
Please do it by type not pics. 1.The following table contains per capita real GDP for...
Please do it by type not pics. 1.The following table contains per capita real GDP for 11 countries for the years 1950 and 2014. Compare a selected group of country’s GDP as compared to Argentina. Are there any “unusual” observations you can make about the data? Based on your knowledge of the countries, discuss some possible explanations of why some countries do better than others. Next, calculate the average real GDP growth rate for each country. I would recommend copying...
Please do it by type not pics. The Early Break Restaurant (EBR) is a privately owned...
Please do it by type not pics. The Early Break Restaurant (EBR) is a privately owned restaurant open seven days a week from 5:00 AM to 2:00 PM. EBR specializes in breakfast and lunch. It is owned and operated by Rose Marie. Rose acts as hostess (seating customers, maintaining a waiting list) and the only cashier. Her trusted friend, Morey Fennel, is the restaurant manager.   Morey also prepares a weekly list of supplies that are needed by EBR and verifies...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT