Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Finance


Home >> Basic Finance

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.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91982544
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Basic Finance

Wandering rv is evaluating a capital budgeting project that

Wandering RV is evaluating a capital budgeting project that is expected to generate $36,950 per year during its six-year lie. If its required rate of return is 10%, what is the value of the project?

The stock of business adventures sells for 65 a share its

The stock of Business Adventures sells for $65 a share. Its likely dividend payout and end-of-year price depend on the state of the economy by the end of the year as follows: Dividend Stock Price Boom $2.40 $73 Normal ec ...

Metallica bearings inc is a young start-up company no

Metallica Bearings, Inc. is a young start-up company. No dividends will be paid on the stock over the next nine years, because the first needs to plow back its earnings to fuel growth. The company will pay a $7 per share ...

What is the expected return of a portfolio with 25 invested

What is the expected return of a portfolio with 25% invested in UK stock and 75% in the U.S. if the U.S. return was 15% and the UK was 12%? What is the portfolio risk of the portfolio in the questions above if the correl ...

Five years from today you plan to invest 4900 for 8

Five years from today, you plan to invest $4,900 for 8 additional years at 7.8 percent compounded annually. How much will you have in your account 13 years from today? $13,008.88 $8,936.06 $7,133.29 $9,439.74 $9,322.51

This is what it gives me fornbsptreasury

This is what it gives me for Treasury securities:  Maturity Yield 1 year 6.0% 2 years 6.2% 3 years 6.4% 4 years 6.5% 5 years 6.5% Question: Assume that the pure expectations theory of the term structure is correct. What ...

A corporate bond is currently selling for 840 it has 5

A corporate bond is currently selling for $840. It has 5 years till maturity, 6% coupon, and YTM=10%. What is the par value?

In 1895 the first putting green championship was held the

In 1895, the first Putting Green Championship was held. The winner's prize money was $230. In 2016, the winner's check was $1,430,000. a. What was the percentage increase per year in the winner's check over this period? ...

Franks is looking at a new sausage system with an installed

Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped ...

What are the steps to find stock price in 15 years if abcs

What are the steps to find stock price in 15 years if ABC's next dividend is expected to be $6.16, its required return is 18%, its growth rate is 7%. How to find current stock price if ABC Company's last dividend was $0. ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved