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
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

Example of Capital Structure of a Company Example Company XYZ restricted has the given capital structure as:   10,000 Sh.10 ordinary shares 10,000

#ques1. Steve and Ed are cousins who were both born on the same day, and both turned 25 today. Their grandfather began putting $2,500 per year into a trust fund for Steve on his 20

Advantages of Central Depository System or CDS 1. It shortens the registration procedure in the stock exchange that is high speed of registering shareholders. 2. It improve

$1,000 of insurance had not been used up by January 31. $325 of insurance had been used up in January

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

Please list five common mistakes in capital budgeting that could either overstate or understate the value of a project.Bonus: explain the relationship between the errors above and

Management of Inventories Manufacturing firms contains three major kinds of inventories as: Work-in-progress Finished goods inventory Raw materials The firm

Goals of firm's Credit Standards The goal of the firm's credit policy is to maximize the value of such firm. To complete this goal, the evaluation of investment in receivables

The operating profit (EBIT) of ABC Ltd is Rs. 1,60,000. Its capital structure consists of the following: 10% Debentures Rs. 500000 12% Preference Shares 1