# Finance 510

**keisha804**

NO PLAG. PAPER HAS TO BE TURNED INTO TURNITIN

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.

- 8 years ago
- 5

**Answer(1)**

Purchase the answer to view it

- order_47161_114040_1.xls

**Bids(1)**

**other Questions(10)**

- HR power point presentation
- FIN 571 Week 2 Individual Assignment Text Problem Sets
- COM 155 WEEK 1-9 Entire GRADE A++ 100%
- CMGT 410 Week 3 Individual Assignment （MPP)
- 3 pages
- fin 534 finicial research report
- Homework for Raswriter
- • For each of the five variables, process, organize, present and summarize the data. Analyze each variable by itself using graphical and numerical techniques of summarization
- Three long parallel wires
- Cost Accounting - excel format

### Amortization Project (Due September 20, 2015) Finance 510 – Davenport University

NOT RATED8 years ago