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 central depository system or cds, Advantages of Central Depos...

Advantages of Central Depository System or CDS 1. It shortens the registration procedure in the stock exchange that is high speed of registering shareholders. 2. It improve

#title. EM13545112., Define benefit plan for the employee participants

Define benefit plan for the employee participants

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.

Calculate the average daily stock cost, Question: Unsatisfactory contro...

Question: Unsatisfactory control of spare parts in a particular mechanical workshop is resulting in high carrying costs for some items and high stock-out costs for others. A st

Oogenesis - gametogenesis, Oogenesis - Gametogenesis The maturing proc...

Oogenesis - Gametogenesis The maturing procedure in oogenesis leading to the formation of ovum begins before birth but is not completed until after puberty. The primary oocyte

Overdraft finance, Overdraft Finance This finance is perfect to need a...

Overdraft Finance This finance is perfect to need as bridging finance in sense such should be required to solve the company's short term liquidity problems in specific those o

Head office and branch or subsidiary, Head Office and Branch or Subsidiary ...

Head Office and Branch or Subsidiary MNC has diverse operations set up in dissimilar geographical locations. The HQ acts like the principal and the subsidiary like an agent he

Calculate the current price of the common stock, Church Inc. is presently e...

Church Inc. is presently enjoying relatively high growth because of a surge in the demand for its new product. Management expects earnings and dividends to grow at a rate of 25% f

Financial Institution Regulations, Why are financial institutions heavily r...

Why are financial institutions heavily regulated, with specific focus on their ability to increase or reduce the money supply?

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