GB 518 Unit 5 Exercises 9-4, 10-1, 10-16, 11-2 and 11-15

gb518_unit05_student_template.xlsx

Instructions

The Template is provided to help you complete your assignment successfully.		Enter you Name here ======>
There are hints and guidance within the templates. For Example,
some fields will have a note attached - as designated by the red triangle in the
upper right corner of the cell.
Some final cell totals or answers will give you a notice if the answer is correct.
For example, if you have gotten the right answer, you may see a note "Correct",
or "Good!" appear beneath or to the side of that cell.
But, not all exercises or problems will provide feedback. So, be sure you do your
best on all of the assignments. And, if you have any questions, please do not
hesitate to bring your questions to me. The preferred way to communicate
your assignment related questions will be in the Virtual Office.
However, please remember that we do not discuss solutions in the Virtual
Office. So, do not post partially completed template files, and do not
post your solutions. But DO ask as specific a question as possible without
giving away an answer.
One final note - in almost every template, the cells that allow you to enter something
will be background highlighted using =	Yellow.
In each assignment, you will be able to enter you name in the designated cell here
in the "Instructions sheet". Please be sure to input you name in the template, and
name the file according to the assignment instructions when you save it.
Thank you and I look forward to working with you on your assignments.

GB 518 Unit 5 Assignment
	Student:	0
	Exercise 9-4
			Start	Term of	Maturity
			Date	Note	Date
Part	1	Maturity date Computation =			31-Dec-99	<--There is no Check Date for Part 1..
Part	2a.
	Date	Description	Dr	Cr
	15-May	Cash
		Notes Payable			Try again
		Borrowed cash - issued note.

Part	2b.
	Date	Description	Dr	Cr
	14-Jul	Interest Expense*
		Notes Payable
		Cash			Try again
		Repaid note plus interest.
	* Principal
	x Interest rate			12%
	x Fraction of year		60/360
	Total interest

GB 518 Unit 05 Assignments
	Student:	0
	Exercise 10-1 (15 minutes)
			Par	Annual	Portion	Semi-
			Value	Interest %	of Year	Annual $
Part	1	Semiannual cash interest payment =				$0	Try again.
Part	2	Journal entries
	2011
	(a)
	Jan. 1	Cash
		Bonds Payable			Try again.
		Sold bonds at par.
	(b)
	30-Jun	Bond Interest Expense
		Cash			Try again.
		Paid semiannual interest on bonds.
	(c)
	Dec. 31	Bond Interest Expense
		Cash			Try again.
		Paid semiannual interest on bonds.
Part	3
	2011
	(a)
	Jan. 1	Cash*
		Discount on Bonds Payable
		Bonds Payable			Try again.
		Sold bonds at 98. *($1,700,000 x 0.98)
	(b)
	Jan. 1	Cash*
		Premium on Bonds Payable
		Bonds Payable			Try again.
		Sold bonds at 102. *($1,700,000 x 1.02)

Student:	0
	Exercise 10-16
Part	1a.	Total	Total	Debt-to-
		Liabilitites	Assets	Equity
	Current debt-to-equity ratio =			ERROR:#DIV/0!	ERROR:#DIV/0!
Part	1b.	Total	Total	Debt-to-
		Liabilitites	Assets	Equity
	Potential debt-to-equity ratio =			ERROR:#DIV/0!	ERROR:#DIV/0!
Part	2
	Click here to start your response.

GB 518 Unit 05 Assignment
	Student:	0
	Exercise 11-2
Part	1
	Feb. 20	Cash
		Common Stock, No-Par Value	Try again.
		Issued common stock for cash.
Part	2
	Feb. 20	Cash
		Common Stock, $20 Par Value
		Contributed Capital in Excess of Par
		Value, Common Stock	Try again.
		Issued common stock for cash.
Part	3
	Feb. 20	Cash
		Common Stock, $8 Stated Value
		Contributed Capital in Excess of
		Stated Value, Common Stock	Try again.
		Issued common stock for cash.

GB518 Unit 5 Assignment
	Student:	0
		Market Value/Share		Divided by	EPS		Price-Earnings Ratio
	Stock
	1		¸			=	ERROR:#DIV/0!
	2		¸			=	ERROR:#DIV/0!
	3		¸			=	ERROR:#DIV/0!
	4		¸			=	ERROR:#DIV/0!
	Enter the analysis in text box.
	Click here to start your response.