Reference no: EM131226628
Amortization Project (Due September 20, 2015) Finance 510 - Davenport University
Objective: The assignment will help you to understand how changes in loan terms and payments will affect the total amount you pay.
1. Create an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will pay on this loan.
2. Copy the table from Step 1, make an extra principal payment of $2,000 on the first day of year two. How does this change the total interest you will pay on this loan?
3. Create an amortization table in Excel for a new car loan for 30,000 for three years at 5%. Determine the total amount of interest you will pay on this loan.
4. Copy the table from Step 3, change the interest rate to 2%. How does this change the total interest that you will pay on the loan?
5. What is the total amount you will pay for the car (principal and interest) in each of the steps 1,2,3 and 4.
Assignment requirements:
Any calculations must be turned in via Excel
Format and presentation of information should be easy to follow and will be considered in final grade
Use class tools and concepts to support statements and assumptions.
Assignment length should be adequate to cover the topic.
|
Discuss the legal and ethical issues surrounding solyndra
: Apply three general legal concepts that were discussed in the required readings, i.e. Appendix B or other materials from the required readings. Make sure you include in-text citations to the course materials, as failing to cite your sources will ..
|
|
Relevant global leadership concerns of the future
: 1. Analyze relevant global leadership concerns of the future. 2. Analyze emerging leadership theories for driving a leadership agenda. 3. Defend the selection of a leadership theory for driving a leadership agenda
|
|
Exploration and discussion of theoretical concepts
: The assignment will include exploration and discussion of theoretical concepts, practice models and approaches as well as relevant ethical considerations including the awareness of self.
|
|
Important role at both the strategic and tactical levels
: How does the Quality Office play an important role at both the strategic and tactical levels in enabling the organization to strive for quality and performance excellence? The research and development function is positioned at the "fuzzy front end" o..
|
|
Create an amortization table in excel for a new car loan
: Create an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will pay on this loan.
|
|
Link the article you find in the discussion forum
: List the headline/title of your selected article in the Subject Line of your post. Link the article you find in the Discussion Forum.
|
|
Gain support from the project sponsor
: Identify the planning tasks performed as part of project time management. What is the critical path for a project? Why is it important to know which tasks are on the critical path? How would you gain support from the project sponsor on the tasks o..
|
|
Parity-temporary advantages or sustained advantages
: Identify three firms you might want to work for. Using the VRIO framework, evaluate the extent to which the resources and capabilities of these firms give them the potential to realize competitive disadvantages, parity, temporary advantages, or susta..
|
|
Features of these hmos would appeal to a patient
: Staff Model HMO vs. Group Model HMO Paper The paper is due at the end of this two week learning plan. The paper should be 2 to 4 pages in length. The paper is due by Sunday midnight at the end of the second week of Learning Plan Two. Define which fea..
|