GB 518 Unit 5 Exercises 9-4, 10-1, 10-16, 11-2 and 11-15
KnowledgeCatsgb518_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. | |||||||||
EX 9-4
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 |
Ex 10-1
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) | |||||||
Ex 10-16
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. | |||||
Ex 11-2
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. |
Ex 11-15
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. | ||||||||