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

ekkarill92 answered 1 year ago

Next > < Previous

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...

Subjects