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
Asset: - An asset stands for an item of value owned and controlled by an organization which can generate revenue for the organization or can help in generating the organization re

I have an assignment for my finance class. The company that i have FOR industry analysis is COSTCO WHOLESALES CORP THAT ITS STOCK IS IN DISCOUNT AND VARIETY StORES INDUSTRY. I need

Marginal cost of finance This is cost of new finances or additional cost a company has to pay to raise and use additional finance is given by: (Total cost of marginal finan

Hatch System - Stock Exchange This is an automatic system based on the assumption such when investors sell at a certain percent age below the top of the market and buys at a s

If you inherited $ 45,000 today and invested all of it in a security that paid a 7 percent rate of return, how much would you have in 25 years?

Define the process of Opening an Account with Broker After a broker has been selected, the investor has to place an order on the broker. The broker will open an account in t

Why do some investors prefer high-dividends paying stocks? Why ,ight other investors prefer low-dividend paying stocks?

Determinants of Working Capital Needs There are few factors that determine the firm's working capital needs. These factors are comprehensively enclosed with a Textbook of Busi

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

Struggling with your final year projects, terms paper writing, research paper writing, thesis writing, engineering and programming projects? Experts are available 24x7 to help you