Calculate interest rate, Finance Basics

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

Posted Date: 2/23/2013 2:26:41 AM | Location : United States







Related Discussions:- Calculate interest rate, Assignment Help, Ask Question on Calculate interest rate, Get Answer, Expert's Help, Calculate interest rate Discussions

Write discussion on Calculate interest rate
Your posts are moderated
Related Questions
There are four different commonly used financial hedging techniques and some operational hedging techniques that firms use to manage currency risk. Drawing on literature, critical


Internal finance can avoid the agency costs of debt and equity finance. In practice it is the most important source of funding. (a) Discuss potential problems of internal financ

Describe the duties of the financial manager in a business firm? Financial managers calculate the firm's performance, define what the financial consequences will be if the firm

Example of Conversion Ratio and Conversion Price ABC Company Ltd books as:   10.000, Sh.20 ordinary share capital 10,000, Shs.10 8% preference share c

#questioxcvxcvn..

Reasons for Different Interest Rate Interest rates may differ in different market and market segment since: i) Size of the loan: Deposits above specific amounts into the

Capital Structure Ratio Gearing/Leverage/Capital Structure Ratio The ratio signifies the extent whether the firm has borrowed fixed charge capital to finance the

ksklklsdfmklsnakakngjkalkgblakbgklabgklagkbaskgbljas a kalks las lgaskgbak a lv aslglaksglas la sla

Merchant Banks - Banking Institution Merchant Banks begun life as merchants and begun to control in financial firms, during the 19 th Century . The merchant banks act like a