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

  Financial models have a variety of useful applications

Financial models have a variety of useful applications. Users of financial models must possess a firm grasp of the input risk and limitations of the model in order to use these tools apparently. Share a financial model with the class that you feel co..

  Gas-powered and an electric-powered forklift truck

Davis Industries must choose between a gas-powered and an electric-powered forklift truck for moving materials in its factory. Because both forklifts perform the same function, the firm will choose only one.

  How much interest will you pay to bank during year four only

Assume you borrow $100,000 from a bank to buy a house at 7% interest for 30 years with monthly payments. How much do you need to pay every month? And how much interest will you pay to the bank during year 4 only?

  What’s the bonds current yield-bonds value change

Assume that the company that you selected for the Module 1 SLP has a bond outstanding that matures in 20 years and has a coupon rate of 6.5%. The par value of the bond is $1,000. A bond matures in ten years and is currently selling for $1,125. The bo..

  What is the appropriate inflow and outflow relationship

Find an existing budget from a published source. Detail should be extensive enough to present a challenge. Use this checklist for building a budget and critque your work. what is the proposed volume for the new budget period? what is the appropriate ..

  Determine the increase in the firms average cash balance

Assuming that Exman could reduce the time required to process customer payments by 1.5 days, determine the increase in the firm's average cash balance.

  No preferred stock or any other outstanding claims

Hadley Inc. forecasts the year-end free cash flows (in millions) shown below. Year 1 2 3 4 5 FCF -$22.37 $37.8 $43.7 $52.1 $55.5 The weighted average cost of capital is 9%, and the FCFs are expected to continue growing at a 3% rate after Year 5. The ..

  Amount to use as annual sales figure when evaluating project

Winnebagel Corp. currently sells 26,400 motor homes per year at $39,600 each, and 10,560 luxury motor coaches per year at $74,800 each. The company wants to introduce a new portable camper to fill out its product line; Required: What is the amount to..

  What rate of return are you earning on this policy

You just paid $360,000 for a policy that will pay you and your heirs $13,200 a year forever. What rate of return are you earning on this policy? 3.42 percent 3.96 percent 2.04 percent 3.54 percent 3.67 percent

  What is the proportion of equity in capital structure

Jack’s Construction Co. (JCC) has 80,000 bonds outstanding that are currently selling at par (face) value. Bonds with similar characteristics are currently yielding 8.5%. The company also has 4 million shares of common stock outstanding. What is the ..

  Foundation with an annual cash donation

The Harsper Foundation was just notified that an anonymous benefactor gifted the Foundation with an annual cash donation. The Foundation will receive an initial amount of $25597, which will decrease by 3% per year. The Foundation will receive the cas..

  Shirts is a specialty retailer offering t-shirts

Custom Tailored Shirts is a specialty retailer offering T-shirts, sweatshirts, and caps. Its most recent annual sales consisted of $21,000 of T-shirts, $18,000 of sweatshirts, and $2,900 of caps. What sales amount should be used when evaluating the P..

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