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

Question: Suppose that a security is presently selling for a price of $65, the nominal interest rate is 8%, and the security volatility is 0.15. a) Determine Delta of a Euro

Assignment: Mr. Ali wants to start “Rent-A-Car” business. He wants to start this business with at least 20 cars. He estimates that the required investment for the business is Rs.

Tank Industries Washers decides to pay the following dividends over the next four years: $2.50, $3.20, $4.75 and $5.20 respectively (starting at time 1). a.    After year 4, the

Example of Accounting Rate of Return Method                                    Shs. Project X cost              500,000 Scrap value                 100,000 Stream of

Imagine Joy is the project coordinator in a company where four projects are running concurrently. He's employed you as the senior business analyst to perform some financial calcula

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

Bob and Jackie came to your bank seeking an FHA mortgage. They want to know how large a mortgage they would be qualified for and what the terms would be. Bob is a pastry chef (

Joint Stock Companies - Types of Business Organisations Initiators contribute to the capital support of those companies via the purchase of shares of those companies. These co

Obtain a copy of a Comprehensive Annual Financial Report (CAFR) for a state or local government for which you would have an interest. Answer the following questions regarding that