Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Basic Finance Expert

Problem:

A 2015 Ford Mustang convertible in ‘Gotta Have it Green Metallic' is retailing for $36,000. If you put $5000 down on the vehicle, and obtain approval for a 2.19% car loan compounded monthly for 5 years,

Question:

Question 1: What are the monthly payments and the total interest that is paid on the loan in 5 years?

Question 2: To pay a half as much in interest over the life of the loan at the same rate, how long should the vehicle be financed for (round final answer to the nearest month) and what is the new payment per month? Parts (a) and (b) should be set up in Excel, using intrinsic functions for the calculation of the payments and goal seek to determine the new time period.
Show your all work.

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M91145900

Have any Question?


Related Questions in Basic Finance

A couple thinking about retirement decide to put aside 3700

A couple thinking about retirement decide to put aside $3,700 each year in a savings plan that earns 7% interest. In 10 years they will receive a gift of $17,000 that also can be invested. a. How much money will they hav ...

Louise mcintyres monthly gross income is 3600 her employer

Louise McIntyre's monthly gross income is $3,600. Her employer withholds $760 in federal, state, and local income taxes and $310 in Social Security taxes per month. Louise contributes $160 each month for her IRA. Her mon ...

Joshua borrowed 500 on january 1 2017 and paid 25 in

Joshua borrowed $500 on January 1, 2017, and paid $25 in interest. The bank charged him a service charge of $10. He paid it all back at once on December 31, 2017. What was the APR? (Enter your answer as a percent rounded ...

Joshua borrowed 1200 for one year and paid 60 in interest

Joshua borrowed $1,200 for one year and paid $60 in interest. The bank charged him a service charge of $9. If Joshua repaid the loan in 12 equal monthly payments, what is the APR? (Enter your answer as a percent rounded ...

Cost of capital problem - wacc paramount roofing inc went

COST OF CAPITAL Problem - WACC Paramount Roofing Inc. went public by issuing 1 million shares of common stock at $50 per share. The shares are currently trading at $64 per share. Current risk-free rate is 5.2%, and marke ...

Answer as thorough as possible include an explanation of

Answer as thorough as possible, Include an explanation of your recommendations or trading strategies. Should you early exercise the following American-style put option? If not always, under what situation would you early ...

Assignment - tax issues associated with financial

Assignment - Tax Issues Associated with Financial Planning Understanding the tax consequences of your financial planning decisions is very important. These decisions may sometimes have life-long consequences in addition ...

Please help me with the following homework problemyou are

Please help me with the following homework problem: You are estimating your companies external financing needs for the next year. At the end of next year you expect that owners equity will be $80 million, total assets wi ...

A young couple decide to take advantage the current

A young couple decide to take advantage the current first-time home buyer credit and buy a new house. With their combined income, they can afford to make a maximum of $800 monthly payment. With their credit history, they ...

A 1000 par value bond sells for 1216 it matures in 20 years

A $1,000 par value bond sells for $1,216. It matures in 20 years, has a 14 percent coupon, pays interest semiannually, and can be called in 5 years at a price of $1,100. Calculate the bond's yield to maturity.

  • 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