Calculate interest rate, Finance Basics

Assignment Help:

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


Related Discussions:- Calculate interest rate

Advantages of stock repurchase, Advantages of Stock Repurchase 1. It m...

Advantages of Stock Repurchase 1. It may be seen as a true signal since repurchase may be motivated with management belief that firm's shares are undervalued. It is true in in

Cash management, A compnay can arrange for a secured loan amounting to 150,...

A compnay can arrange for a secured loan amounting to 150,000,000 for one year at an interest rate of 18% per annum based on the initial balance of the loan. The lender also imposs

Agency theory, Agency Theory An agency relationship arises whether on...

Agency Theory An agency relationship arises whether one or more parties identified the principal contracts or hires another identified an agent to perform on his behalf some

Describe briefly the term measures of variability, Question: (a) (i)...

Question: (a) (i) Define the term multicollinearity. (ii) Explain why it is important to guard against multicollinearity. (b) (i) Sometimes we encounter missing value

What is bond rate, What is Bond Rate It is interest rate received on...

What is Bond Rate It is interest rate received on the face value or the par value of the bond. If a company or government issues a 10-year bond with 100$ as face value and 1

Dow Theory, Dow theory elliot wave theory

Dow theory elliot wave theory

the trade-off theory of capital structure, Please describe the trade-off t...

Please describe the trade-off theory of capital structure and how it vary from the Modigliani and Miller theorem with taxes.

Functions of the financial markets, Functions of the Financial Markets ...

Functions of the Financial Markets Functions of the Financial Markets or Institutions in Economy 1. Allocation of financial resources to the mainly productive units. Saving

Financial analysis, Bell is considering two marketing options for the Canad...

Bell is considering two marketing options for the Canadian launch of their internet-based video streaming service in the first quarter of 2012.   i. A  "soft" launch using prima

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd