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
You are required to select any one company of your choice which is listed on either Dubai Financial Market (DFM) or Abu Dhabi Securities Market (ADSM). Send me an email giving at l

Future Ltd is a leading music entertainment company in the country and the stocks of the company are actively traded in the stock exchange. For the year just ended few days back,

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

Comparison to a Competing Firm In Mergent Horizon, return to the competitor page, but now enter the list of competitors "As Defined by the Company."  From this list select a f

Homework Chapter 4 A mortgage loan in the amount of $100,000 is made at 12% interest for 20 years. Payments are to be monthly in each part of this problem. a. What will monthly

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 re

Bell is considering two marketing options for the Canadian launch of their internet-based video streaming service in the first quarter of 2012.   i. A  "soft" launch using prima

ksklklsdfmklsnakakngjkalkgblakbgklabgklagkbaskgbljas a kalks las lgaskgbak a lv aslglaksglas la sla

Suppose the ABC Corporation is currently all-equity financed and would like to increase its value by issuing debt. The firm has annual earnings before interest and taxes of $7,0

The construction of a highway is broken into 14 activities as shown in the following table. Draw a bar chart of this construction project. Activity ID Desc