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

Profit maximization - objectives of business entity, Profit maximization - ...

Profit maximization - Objectives of Business Entity Conventionally, this was considered to be the main goal of the firm. Profit maximization refers to getting the highest poss

Partnership deeds, Partnership Deeds This is an important document whic...

Partnership Deeds This is an important document which governs the members in partnership firm. It covers among other things the following points:      i. The name, location,

Earnings method or earning basis valuation, Earnings Method or Earning Basi...

Earnings Method or Earning Basis Valuation By using the earning valuation method, a company will employ its P/E ratio to value its shares. P/E    =  MV/E MV    =   E x P

Islamic banking, what is the exact nature of IDB sukuk

what is the exact nature of IDB sukuk

Stock exchange in india, give an introduction about stock exchage in india...

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

Agency relationship between government and the shareholders, Agency Relatio...

Agency Relationship between Government and the Shareholders Shareholders and via extension, the company they own operate within the environment requiring the charter or licens

Net present value method - example, Net Present Value Method - Example ...

Net Present Value Method - Example Jeremy limited wishes to expand its output by purchasing a new machine worth 170,000 and installation costs are estimated at 40,000/=.  In t

Cash cycle and cash turnovers, Cash Cycle and Cash Turnovers Cash Cycl...

Cash Cycle and Cash Turnovers Cash Cycle refers to the amount of time which elapses from the point whenever the firms create a cash outlay to purchase raw materials to the poi

Find the required return, Marbela Corporation's stock had a required return...

Marbela Corporation's stock had a required return of 12.75% last year, when the risk-free rate was 6.4% and the market risk premium was 5.5%.  Now suppose the market risk premium d

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