Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Finance


Home >> Basic Finance

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.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91405348
  • Price:- $35

Priced at Now at $35, Verified Solution

Have any Question?


Related Questions in Basic Finance

A study finds that the prices of stocks prior to large

A study finds that the prices of stocks prior to large dividend increases show on average consistently positive abnormal returns. Is this a violation of the efficient market hypothesis? Explain

Question - time value of money answer the following

Question - TIME VALUE OF MONEY Answer the following questions: a. Assuming a rate of 10% annually, find the FV of $1,000 after 5 years. b. What is the investment's FV at rates of 0%, 5%, and 20% after 0, 1, 2, 3, 4, and ...

How does a firm navigate strategic management in the

How does a firm navigate strategic management in the context of an international environment? What complications does an international environment provide? What are the benefits of operating in an international environme ...

You have inherited an apple orchard and want to sell it in

You have inherited an apple orchard and want to sell it in the next four years. An expert in apple orchard valuation has estimated the after-tax cash flow you would receive if you sold at the end of each of the next four ...

The everly equipment companys flange-lipping machine was

The Everly Equipment Company's flange-lipping machine was purchased 5 years ago for $70,000. It had an expected life of 10 years when it was bought and its remaining depreciation is $7,000 per year for each year of its r ...

Your accounts receivable clerk m adams to whom you pay a

Your accounts receivable clerk, M Adams, to whom you pay a salary of $2,175 per month, has just purchased a new Acura. You decide to test the accuracy of the accounts receivable balance of $118,900 as shown in the ledger ...

Suppose you are going to receive 14100 per year for six

Suppose you are going to receive $14,100 per year for six years. The appropriate interest rate is 6.9 percent. a. What is the present value of the payments if they are in the form of an ordinary annuity?  (Do not round i ...

Question - analyze cash budgets inventory management and

Question - Analyze Cash Budgets, Inventory Management and Accounts Receivables Instructions - Assume the role of a manufacturing financial controller where you are making a presentation to the board of directors. Create ...

A stock price is currently 20 and at the end of 3 months it

A stock price is currently $20, and at the end of 3 months it will increase or decrease by 10%. The risk free rate is 5% per year (continuous compounding). Assume that ST is the price at the end of 3 months. what is the ...

A study finds that the prices of stocks prior to large

A study finds that the prices of stocks prior to large dividend increases show on average consistently positive abnormal returns. Is this a violation of the efficient market hypothesis? Explain.

  • 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