Calculate interest rate, Finance Basics

Assignment Help:

Imagine Joy is the manager of a bank named Money Talks Bank of Virginia. This bank has recently issued new loans to customers. Joy wants you, the business analyst to prepare a report for him. The details of the report and the data are given below. You must use functions to calculate interest rate, down payment, monthly payment, and average selling price for each loan item.

Table values

Loan Term

Interest Rate

% Required for Down Payment

15

0.0575

0.15

20

0.06

0.2

30

0.0625

0.25

 

Customer

Selling Price

Loan Term

 

Allen

265354

30

Arnold

328788

15

Barber

500000

15

Bollis

112485

30

George

350000

30

Hood

761978

20

Morgan

192940

15

Paul

606563

20

Pinder

319765

30


Related Discussions:- Calculate interest rate

Operational and financial aspects , In mergers, acquisitions, or other rela...

In mergers, acquisitions, or other relationships between hospitals and physician groups, what are the benefits to each party from entering into an arrangement with the other? What

Competitors and general public, Competitors and General Public - Measuring ...

Competitors and General Public - Measuring Business Performance Competitors These are interested in the company's presentation from the market share point of view and wi

Computing the real rate & flat tax, Quetion1: You are earning 5.2 percent ...

Quetion1: You are earning 5.2 percent on a certificate of deposit. Inflation is running 3.5 percent. What is the real rate of return on your investment? Question2: Search for

Finance, finance is divided into _____ and___________

finance is divided into _____ and___________

Cost of retaining finance, Cost of Retaining Finance This will contain...

Cost of Retaining Finance This will contains dividends for share capital and interest for debt finance or can say tax deducted or like effective cost of debt.  Though, when co

Venture capital, Venture Capital Venture capital is a form of investme...

Venture Capital Venture capital is a form of investment in new small risky enterprises utilized to get them started via specialists called venture capitalists. Venture capital

Foreign trade balance, Foreign Trade Balance If the Government buys or...

Foreign Trade Balance If the Government buys or imports much more than it sells or exports there will be a trade deficit such will require financing.The most important source

Characteristics of an efficient tax system, Question 1 a) What are the...

Question 1 a) What are the main characteristics of an Efficient Tax system? b) What are the instruments of Public Finance and explain their efficiency. c) Explain what

Calculate future value, Your grandparents put $1,000 into a saving account ...

Your grandparents put $1,000 into a saving account for you when you were born 30 years ago. This account has been earning interest at a compound rate of 7%. What is its value today

What is the execution of order in the stock exchange, What is the Execution...

What is the Execution of order in the Stock Exchange When broker receives the margin money and is clear about the order received by him, he puts details in the 'order book'.

Write Your Message!

Captcha
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