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

Financial structure or dividend policies, Every time a listed company does...

Every time a listed company does a share buyback, investors and media alike would debate fiercely on the merits of such a scheme. There are investors who prefer buybacks to high

Interest, #what is an interest?

#what is an interest?

Money and banking course, Ask questioSay that a buyer of bonds values good ...

Ask questioSay that a buyer of bonds values good bonds at $500 and values bad bonds at $250. Sellers of both good and bad bonds value them at $350. If the fraction of good sellers

Investment analysis, Investment Analysis Any type of company will inve...

Investment Analysis Any type of company will invest finance for the sake of deriving a return that is useful for four main purposes as: 1. To reward the owners or shareholder

Tests of term structure of interest rates theories, Tests of Term Structure...

Tests of Term Structure of Interest Rates Theories Various tests have been conducted mainly in USA and they show that all the three (3) theories have some validity and therefo

Explain the both dividend yield and earnings yield, Explain the both Divide...

Explain the both Dividend Yield and Earnings Yield Dividend Yield: Dividend yield is the ratio of per share expected dividends, to current market price of share. Earnin

Basel committee on banking supervision, Question 1: ‘The Basel II frame...

Question 1: ‘The Basel II framework provides a range of options for determining the capital requirements for, inter-alia, credit risk and operational risk to allow banks and s

Retirement, Ask quQUESTION 1 1. In the ratio test used to determine whether...

Ask quQUESTION 1 1. In the ratio test used to determine whether a qualified plan is nondiscriminatory, what is the minimum percentage of nonhighly compensated employees who must be

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