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

Determinants of working capital needs, Determinants of Working Capital Need...

Determinants of Working Capital Needs There are few factors that determine the firm's working capital needs. These factors are comprehensively enclosed with a Textbook of Busi

Advantages of overdraft finance, Advantages of Overdraft Finance ...

Advantages of Overdraft Finance 1. It is useful in financial crisis such an accountant cannot forecast because of abrupt fall in profits so liquidity problems. 2. In

IRR, How to compute the IRR of data

How to compute the IRR of data

What are the financial intermediaries, What are the financial intermediarie...

What are the financial intermediaries? Financial Intermediaries: a. Mutual funds b. Pension funds c. Life insurance companies d. Banks

Who is floor broker, Who is Floor Broker Floor brokers aren't many in n...

Who is Floor Broker Floor brokers aren't many in number. They execute orders for fellow  members  and  receive  a  share  brokerage  commission  charged  by  a commission broke

What are the factors influencing selection of investment, Investment  Attri...

Investment  Attributes/  Factors  Influencing  Selection  of  Investment In  choosing specific  investments,  investors  would require definite  ideas  regarding  features

Market model - methods of computing cost of capital, Market Model - Methods...

Market Model - Methods of Computing Cost of Capital This model is utilized to establish the percentage cost of ordinary share capital cost of equity (K e ). If an investor is

Horizontal financial analysis, For this assignment you are acting as a fina...

For this assignment you are acting as a financial analyst for Apple Inc. Apple Inc. Is one of the most innovative companies worldwide. For example, in November 2012 Apple sold 3 mi

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