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
A City has determined that building a new water distribution system using a new source of water would have an annual costs of $5,750,000 and annual net benefits of $4,250,000. The

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

Distribution Policies   Most Recent Fiscal Year Fiscal Year (-1) Fiscal Year (-2) Fiscal Year (-3)

On 1 January 2008, a young artist called Michelangelo signed a contract with a charity named Art Angels, which supports young artists to do large projects. The agreement requires M

Jobbers or Speculators - Stock Market 1. This is a dealer who that trades in securities in his own right like a principal. 2. He can set prices and make active the market w

how can I get?

Bird-in-hand Theory Advanced via John Leitner in year 1962 and furthered with Myron Gordon in year 1963. Argues such shareholders are risk averse and prefer specific. Dividend

Define benefit plan for the employee participants

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

For this assignment you are acting as a financial analyst for Apple Inc. Apple Inc. Is one of the most innovative companies worldwide. For example, in November 2012 Apple sold 3 mi