How to Prepare an Amortization Schedule
Not what you're looking for?
Jones just closed a $10,000 business loan that is to be repaid in three equal, annual, end-of-year payments.The interest rate on the loan is 13%. As part of his firm's detailed financial planning, Jones wishes to determine the annual interest deduction attributable to the loan.
a. determine the firm's annual loan payment
b. Prepare an amortization schedule for the loan
c. How much interest expense will Jones firm have in each of the next 3 years as a result of this loan?
Purchase this Solution
Solution Summary
This posting contains a formatted MS Excel file which illustrates how to prepare a loan amortization schedule.
Solution Preview
For your convenience, I have attached a formatted MS Excel spreadsheet containing the information below. I have attached notes as well as cell address information, which you be of help to you in gaining a better understanding of the covered material. Feel free to contact me in the future in the event that additional assistance is required.
Jones just closed a $10,000 business loan that is to be repaid in three equal, annual, end-of-year payments.
The interest rate on the loan is 13%. As part of his firm's ...
Purchase this Solution
Free BrainMass Quizzes
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.
Understanding the Accounting Equation
These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.