Calculate monthly payment and present value

Assignment Help Financial Management

Reference no: EM131863283

You want to buy a Honda Civic that costs you $15,000. But you have only $5,000 in your savings account, which means you should borrow $10,000 from the Fairfax Honda dealer. The dealer tells you the interest rate of the loan is 12% annually and the loan period is 5 years based on your credit.

1. You need to figure out how much the monthly payment will be if I take the loan of $10,000 from the dealer. You use Goal Seek function in Excel to answer the question.

2. Calculate monthly payment and present value to how much you borrow, also using goal seek.

Reference no: EM131863283

Questions Cloud

Make a full class definition for a class named counter : Make a full class definition for a class named Counter, and containing the following members:A data member counter of type int.

Conflict of interest between an it worker self-interest : Describe a situation in which there could be a conflict of interest between an IT worker's self-interest and the interests of a client.

The investor rate of return was : The stock was originally purchased at $25 per share, and in 1 year the investor sells the stock for $30. The investor's rate of return was?

Research for the wlan solution : What are some new trends in wireless technology that a company should research for the WLAN solution?

Calculate monthly payment and present value : You want to buy a Honda Civic that costs you $15,000. Calculate monthly payment and present value to how much you borrow, also using goal seek.

Describe the components of an ics and a scada system : Question A: Describe the components of an ICS and a SCADA system. Provide examples of how each are configured and used in the industry.

What is which an event viewer and performance monitor : What is which an event viewer and performance monitor? How can these tools improve the management of our network environment?

Analyze role of the central bank in the economic environment : Describe the global economic climate in which the company is operating. Explain the role of the Central Bank in the economic environment.

How to program with python3 : Assign user_str with a string from user input, with the prompt: 'Enter a string:n' Hint -- Replace the ? in the following code:user_str = ?('Enter a string:n'

User Account

All Pages