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

OPTION, DEFINE THE TERM OPTION IN DETAIL?

DEFINE THE TERM OPTION IN DETAIL?

Determine the classification of new issue market, Classification of New Iss...

Classification of New Issue Market New market can be classified as: (i) A market where firms go to public for the first time through initial public offering (IPO). (ii

Individual or component costs of capital, flotation cost of 15% for bond, b...

flotation cost of 15% for bond, bonds 8%,$1,000 par value, 16 year maturity

Real Estate - Mortgage Prequalification, Bob and Jackie came to your bank s...

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 (

Define the process of opening an account with broker, Define the process of...

Define the process of Opening an Account with Broker After a broker has been selected, the investor has to place an order on the broker. The broker will open an account in t

Homework, the two problems below (P1 and P2). Five marks each. Part marks w...

the two problems below (P1 and P2). Five marks each. Part marks will be allocated, but if you have the incorrect answer then you cannot expect to get more than half marks. Project

Define the direct finance and indirect finance in markets, Define the direc...

Define the direct finance and indirect finance in markets. In direct finance, borrower-spenders borrow funds directly by lenders into the financial markets through selling them

Retirement, Ask quQUESTION 1 1. In the ratio test used to determine whether...

Ask quQUESTION 1 1. In the ratio test used to determine whether a qualified plan is nondiscriminatory, what is the minimum percentage of nonhighly compensated employees who must be

Commercial banks - banking institutions, Commercial Banks - Banking Institu...

Commercial Banks - Banking Institutions These are financial institutions such accept deposits of money from the universal public, safeguard the deposits and create them availa

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