College: Yuba Community CollegeCourse: Accounting 1 LAB (online)Platform/Website: Cengage...

Question

College: Yuba Community CollegeCourse: Accounting 1 LAB (online)Platform/Website: Cengage (cengage.com)Email:  XXXXXXXXXXPassword: Evangel1995Once on the dashboard, proceed to go click on the "eBook: Excel Applications for Accounting Principles". A new window will open that shows the chapters on the left-hand side of the page. Scroll down and select "P11: Bond Pricing and Amortization." This chapter goes hand in hand with the spreadsheet you are to complete.The name of the lab assignment for this week is "BONDSCM". It is due by 11:59 on Wednesday, May 19, 2021.*****MUST INCLUDE:*****- What if Section- Chart Analysis Section- Tickler Section

Nitish Lath · Accepted Answer

Worksheet
	
	BONDS
	Bond Pricing and Amortization
	Data Section
		Face value of bond			$2,000,000
		Years to maturity *			20
		Stated interest rate			10.0%
		Effective interest rate			9.0%
		* Worksheet is designed for use with bonds having a maturity of
		12 years or less and paying interest annually.
	Answer Section
		Bond issue price				$2,182,571
	Amortization Schedule - Straight Line Method
		Cash		Interest	(Disc.)	Bond
	Year	Paid	Amortization	Expense	Premium	Carrying Value
	0				182,571	2,182,571
	1	200,000	(9,129)	190,871	173,442	2,173,442
	2	200,000	(9,129)	190,871	164,314	2,164,314
	3	200,000	(9,129)	190,871	155,185	2,155,185
	4	200,000	(9,129)	190,871	146,057	2,146,057
	5	200,000	(9,129)	190,871	136,928	2,136,928
	6	200,000	(9,129)	190,871	127,800	2,127,800
	7	200,000	(9,129)	190,871	118,671	2,118,671
	8	200,000	(9,129)	190,871	109,543	2,109,543
	9	200,000	(9,129)	190,871	100,414	2,100,414
	10	200,000	(9,129)	190,871	91,285	2,091,285
	11	200,000	(9,129)	190,871	82,157	2,082,157
	12	200,000	(9,129)	190,871	73,028	2,073,028
	13	200,000	(9,129)	190,871	63,900	2,063,900
	14	200,000	(9,

College: Yuba Community College Course: Accounting 1 LAB (online) Platform/Website: Cengage (cengage.com) Email: XXXXXXXXXX Password: Evangel1995 Once on the dashboard, proceed to go click on the...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment