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
Disadvantages of Payback Period 1. Does not receive into account time value of money and supposes that a shilling obtained in the 1 st year and in the N th year have the sim

give an introduction about stock exchage in india,,includig BSE


where can I get money and how can I manage it

Question   Clifton-Peters Ltd is a manufacturer of household goods located in Melbourne. They presently make and wholesale fruit juicers, blenders and baking equipment. The Gen

Profitability Index or P.I. P.I. (benefit-cost ratio) = Present value of inflows / Present value of cash outlay Whether P.I. is greater than 1.0, invest and whereas less th

(Interest-rate risk) Philadelphia Electric has many bonds trading on the New York Stock Exchange. Suppose PhilEl''s bonds have identical coupon rates of 9.125% but that one issue m

Present Value of Uneven Periodic Sum - DCF Technique As in investment decisions it is very rare to acquire even periodic returns and in most cases a company will generate a st

1. Suppose company A expects to increase unit sales of i-phone by 15% per year for the next 5 years. If you currently sell 3 million i-phones in one year, how many phones do you ex