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

Constraints of venture capital in us, Constraints of Venture Capital in US ...

Constraints of Venture Capital in US 1. Require of rich investors in US, thus inadequate equity capital. 2. Inefficiencies of stock market - NSE is investors and inefficien

The importance of tax, Discuss business taxes and their importance in finan...

Discuss business taxes and their importance in financial decisions

Timing of investment a stock exchange, Timing of Investment a Stock Exchang...

Timing of Investment a Stock Exchange The ideal way of creation profits on the stock exchange is to buy on the bottom of the market or lowest M.P.S and sell at the top of the

Calculate return on common equity, At the end of the fiscal year ending Jun...

At the end of the fiscal year ending June 30, 2003, Microsoft reported common equity of $64.9 billion on its balance sheet, with $49.0 billion invested in financial assets (in the

Broker - stock market, Broker - Stock Market 1. A dealer on the ...

Broker - Stock Market 1. A dealer on the market who that sells and buys securities on behalf of the public investors. 2. And he is an agent of investors 3. He is t

Basic economic order quantity model , Basic economic order quantity (EOQ) m...

Basic economic order quantity (EOQ) model  This model is one of the oldest and most commonly used in inventory control. It is based on a number of assumptions:  The dem

Functions of central depository system or cds, Functions of Central Deposit...

Functions of Central Depository System or CDS 1. Immobilization of securities that is removal of physical movement of securities. 2. Dematerialization that is removal of ph

State the determinants of return, State the Determinants of Return T...

State the Determinants of Return Three major determinants of the rate of return expected by investor are: (i) Time preference risk-free real rate. (ii) Expected rate o

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