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
Accounts Payable Turnover Ratio Ratio for Account Payable Turnover is as Follow: Creditors/accounts payable turnover = Annual credit purchases /Average creditors

Ask question #MinimQuestion You are the financial accountant of Donald Bhd, a manufacturer and wholesaler of soft drinks. Donald Bhd is in direct competition with Fizz Bhd and Po

Which of the following is true with regards to rising interest rates. A. Use long-term loans to take advantage of current low rates. B. The term of the loan is ot impacted by risin

Mortgages - Financial Institutions An arrangement of the property being purchased provides the security for funding. Other assets may be employed like security for funding o

An industrial engineer proposed the purchase of a RFID Fixed Asset Tracking System for the company's warehouse and weave rooms.  The engineer though that the system would provide a

Suggestion regarding Credit limit. Should it be approved or not, what should be the amount of credit limit that electronics give to Booth Plastics.

Stock Market Index Definition of Stock Market Index An index is a numerical figure that measures relative change in variables between two type of durations. Examples

Conditions for Lease Finance Lease finance is ideal within the following circumstances: a) Whenever the asset depreciates faster. b) Whenever the asset is matter to obso

Functions of Central Depository System or CDS 1. Immobilization of securities that is removal of physical movement of securities. 2. Dematerialization that is removal of ph

The table below gives data on the average number of football games attended per year among a population of students at a small college, separately by major. All students are in one