Reference no: EM131516016
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 support that the agency is proposing
: Discuss the support that the agency is proposing the firm to acquire in entering the contract
|
|
Business school edition-walt disney prospectus
: Students are to go to the Thomson One site and find the prospectus filed on December 19, 2008, by Walt Disney Company (ticker symbol, DIS).
|
|
Distinguish dividends and stock splits
: Distinguish dividends and stock splits. Which factors influence dividend payout? Please include references so I can research this further.
|
|
Compute the future value
: Compute the future value in year 8 of a $3,200 deposit in year 1 and another $2,700 deposit at the end of year 3 using a 10 percent interest rate.
|
|
Concepts to support statements and assumptions
: What is the total amount you will pay for the car (principal and interest) in each of the steps 1,2,3 and 4.
|
|
Design private subnetworks
: Complete the table below for CIDR Prefixes, available IP addresses and Their Decimal Equivalent - design and accommodate the above 10 subnets,
|
|
What was your realized? return
: a. What was your realized? return? b. How much of the return came from dividend yield and how much came from capital? gain?
|
|
Portfolio weights of the three stocks in portfolio
: What are the portfolio weights of the three stocks in your? portfolio? What is the expected return of your? portfolio?
|
|
Expected return of a portfolio
: What is the expected return of a portfolio that consists of 60% Autodesk stock and 40% Costco? stock, according to the? CAPM?
|