Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Finance


Home >> Basic Finance

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.:- M92324743
  • Price:- $25

Priced at Now at $25, Verified Solution

Have any Question?


Related Questions in Basic Finance

Common stock versus warrant investment tom baldwin can

Common stock versus warrant investment Tom Baldwin can invest $6,300 in the common stock or the warrants of Lexington Life Insurance. The common stock is currently selling for $30 per share. Its warrants, which provide f ...

A firm has a profit margin of 39 percent a capital

A firm has a profit margin of 3.9 percent, a capital intensity ratio of 1.5, and a debt-equity ratio of .7. What is the firm's ROE? Can someone help me understand how to solve this?

What factors are involved in cash flow management as they

What factors are involved in cash flow management as they relate to various payment methods and What kinds of payment terms might the business venture have with its vendor to help manage its cash flow?

In todays environment how could firms balance their

In today's environment, how could firms balance their marketing activities while meeting the demand of consumers from the main culture as well as from a subculture?

Question1 considering the follow premerger information

Question: 1. Considering the follow premerger information about a bidding firm (Firm B) and a target firm (Firm T). Assume that both firms have no debt outstanding. Firm B Firm T Shares outstanding  5,400   1,300    Pric ...

What is the present value of a bond with a par value of

What is the present value of a bond with a par value of $1,000 and a 4.5% coupon rate that is paid semi-annually for 10 years at 5% interest? (round to the nearest dollar)

Question - you are advising a group of investors who are

Question - You are advising a group of investors who are considering the purchase of a shopping center complex. They would like to finance 75 percent of the purchase price. A loan has been offered to them on the followin ...

An executor may value assets as of the date of death or the

An executor may value assets as of the date of death or the alternate valuation date 6 months after death. Assuming the estate is eligible to elect, and the executor elects, the alternate valuation date, which of the fol ...

You take out a 25-year 210000 mortgage loan with an apr of

You take out a 25-year $210,000 mortgage loan with an APR of 12% and monthly payments. In 16 years you decide to sell your house and pay off the mortgage. What is the principal balance on the loan?

You are about to invest some money in a bond fund the

You are about to invest some money in a bond fund. The management fee of the fund is quite low, it only charges a fee of 2%/year on the assets managed. However, you do not believe the bond fund manager has superior abili ...

  • 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