Amortization Schedule for bond interest and amortization
Not what you're looking for?
Devon Harris Company sells 10% bonds having a maturity value of $2,000,000 for $1,855,816. The bonds are dated January 1, 2007, and mature January 1, 2012. Interest payable annually on January 1.
Instructions:
Set up a schedule of interest expense and discount amoritzation under the effective interest method (Hint: the effective interest rate must be computed). Remit in excel
Purchase this Solution
Solution Summary
The solution explains how to prepare an amortization Schedule for bond interest and discount amortization.
Solution Preview
Please see the attached file
We first calculate the effective rate using the RATE function in excel
Issue Price 1,855,816
Maturity 5 years
Annual Interest 200,000
Par Value 2,000,000
Effective interest rate 12%
The effective ...
Purchase this Solution
Free BrainMass Quizzes
MS Word 2010-Tricky Features
These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking