How much the monthly payment will be if you take the loan

Assignment Help Financial Management
Reference no: EM131361377

You want to buy a Honda Accord that costs you $20,000. But you have only $5,000 cash, so you need to borrow $15,000 from the Fairfax Honda dealer. The dealer tells you the interest rate of the loan is 8% annually and the loan period is 5 years based on your credit. You need to figure out how much the monthly payment will be if you take the loan of $15,000 from the dealer. Use Goal Seek function in Excel.

Reference no: EM131361377

Questions Cloud

Your firm to process the payments from customers : It takes your firm 4.5 days to prepare and mail out all the monthly statements to your customers. On average, the mail time between your firm and your customers is 2.6 days. Customer checks take an average of 1.8 days to clear the bank. You have dete..
Assignment-testing for one-way anova : You had the chance earlier in the week to practice with the one-way ANOVA and obtain peer feedback. Now it is time to put all of that good practice to use and answer a social research question with the one-way ANOVA. As you head into the assignmen..
Discussion: research design for one-way anova : Similar to the previous week's Discussion, this Discussion assists in solidifying your understanding of statistical testing by engaging in some data analysis. This week, you will once again work with a real, secondary dataset to construct a resear..
What is the volume per conduction electron : Could these conduction electrons be treated using classical statistics at 10 000 K?
How much the monthly payment will be if you take the loan : You want to buy a Honda Accord that costs you $20,000. But you have only $5,000 cash, so you need to borrow $15,000 from the Fairfax Honda dealer. The dealer tells you the interest rate of the loan is 8% annually and the loan period is 5 years based ..
Calculate the net-profit margin for each of these years : Above is a comparative income statement for Cecil, Inc. for the years 2010, 2011, and 2012. Calculate the net-profit margin for each of these years. Comment on the profit margin trend.
What changes will you make in future quarters : What was your marketing strategy for each of the decisions entered into the simulation game in Quarter #1?What were the results of your decisions? Analyze the results in terms of success or failure. What changes will you make in future quarters?
Create an annotated bibliography : You will create an annotated bibliography with entries that are well organized and include consistently strong summaries of the sources. You will also evaluate each source, and ensure you have clear and correct critiques of each source.
Explain the difference between the epidermis and dermis : Explain the difference between the epidermis and dermis with a minimum of three characteristic differences. What role does collagen and elastic fibers have within the skin? What sensory receptors are found within the skin? Describe the variance with..

Reviews

Write a Review

 

Financial Management Questions & Answers

  The highest price that an investor can pay for the bond

A $1000 par value bond has 8% semiannual coupons and is redeemable for $1100 on any coupon date from the 11th coupon through the 20th coupon, for $1150 on any coupon date from the 21st coupon through the 30th coupon, and for $1200 on any coupon date ..

  What are payments worth to you on the day you enter college

Your grandmother is gifting you $100 at the beginning of each month for four years while you attend college to earn your bachelor's degree. At a 6 percent annual interest rate, what are these payments worth to you on the day you enter college?

  Calculate the equity capital ration

Calculate the equity capital ration. If 2 billion in bad loans were removed from the bank's assets, show how the equity capital ratio would change.

  Find current rates on fed funds loans

Using Internet resources find current rates on fed funds loans, T-bills, commercial paper and banker’s acceptances. Are the rates similar? Why do they differ? Calculate the effective annual rates for each type instrument. Keep the terms as similar as..

  Describe a corporate fraud incident

"Corporate Fraud" Please respond to the following: Organizations must adhere to strict anti-fraud requirements in how they prevent, detect, and correct fraud-related incidents. Search on the Internet and select and describe a corporate fraud incident..

  What would be the value of the investment

The treasurer of a major U.S. firm has $31 million to invest for three months. The interest rate in the United States is .30 percent per month. The interest rate in Great Britain is .34 percent per month. The spot exchange rate is £.630, and the thre..

  Net working capital should considered in project cash flows

NET working capital should be considered in project cash flows because

  Graphic design is considering two alternative projects

Haley graphic design is considering two alternative projects. Both projects have initial cash outlays of $10,000. Project A has an expected life of two years with after tax cash inflows of $6000 and 8000 at the end of 1 and 2 years respectively.

  Not exercise the option and what would be your gain or loss

You have purchased a call option contract on Smith & Smith common stock. The option contract is for 100 shares. The option has an exercise price of $43.00 and S & S’s stock currently trades at $40.00. The option premium is quoted at $2.00. If the sto..

  Calculating cost of debt

Drogo, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 23 years to maturity that is quoted at 97 percent of face value. The issue makes semiannual payments and has an embedded cost of 5 percent annually. What..

  Retirement account pays

Your retirement account pays 8% interest compounded monthly. You plan on having $1 million in the bank on the day you retire. You playing to work for 40 years and then retire. How much were you had to take out of your pay check at the beginning of ea..

  Compare the capital gains for the interest rate

Calculate the price of the bond for a market interest rate of 3% per half year. Compare the capital gains for the interest rate decline to the losses incurred when the rate increases to 5%

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd