Amortization Schedule Computations
Not what you're looking for?
John Gunho wants to purchase a condominium, he will be taking out a mortgage for the condo. The purchase price for the condo is $42,000 at an annual rate of 7.2%. He reviewed his options for the term, and he knows the effects of compounding interest, so he plans to take a one year term mortgage.
(1) Create an amortization schedule for the entire term of the loan (12 months).
(2) How much interest did he pay for the term of the loan?
(3) Most mortgages are compounded monthly. Using the compounded formula determine the future value of the loan and the interest paid.
(4) Is there a discrepancy between (2) and (3)? Use complete sentences to explain the discrepancies or lack of discrepancies? Hint: What does the Compounded formula not consider?
(5) Attach this instruction to your work.
Purchase this Solution
Solution Summary
The amortization schedule is given in an Excel file. All computations and formulas used for the amortization schedule are in the Excel file.
Solution Preview
1
Refer to the Excel file for the amortization schedule. All computations are shown in the file.
2
From the computations shown in the Excel file, it can be ...
Education
- MSc, California State Polytechnic University, Pomona
- MBA, University of California, Riverside
- BSc, California State Polytechnic University, Pomona
- BSc, California State Polytechnic University, Pomona
Recent Feedback
- "Excellent work. Well explained."
- "Can you kindly take a look at 647530 and 647531. Thanks"
- "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
- "GREAT JOB!!!"
- "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
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.
Motivation
This tests some key elements of major motivation theories.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.