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

Determine the npv of a company, Example of NPV Value A company is fac...

Example of NPV Value A company is faced along with the following five (5) investment opportunities as:   Cost NPV P.I = Total P.v

Calculate operating leverage of tax rate, A firm has sales of Rs. 10,00,000...

A firm has sales of Rs. 10,00,000. Variable cost is 70%, total cost is Rs.9,00,000 and Debt of Rs. 5,00,000 at 10% rate of interest. If tax rate is 40% calculate:

Explain the term - giving margin money to broker, Explain the Giving Margi...

Explain the Giving Margin Money to Broker Marin  is  the  amount  of  money  which is provided  by customer to the brokers who have agreed to trade their securities. It may

Choose Variables for a sensitivity analysis, You are asked to select three ...

You are asked to select three variables for a sensitivity analysis of weighted average cost of capital, what would you choose and why? Weighted average cost of capital is th

Calculate effective annual cost, What is the effective annual cost of skipp...

What is the effective annual cost of skipping the discount and paying at the end of the net period for the following credit terms: 6/10, net 70? please show work"

Describe the role of insurance companies, Describe the role of insurance co...

Describe the role of insurance companies. Role of Insurance Companies: The main objective of insurance companies is to prevent individuals and firms (termed as policy-hol

Capital market authority (cma), Capital Market Authority (CMA) Was est...

Capital Market Authority (CMA) Was established in 1990 with an Act of Parliament to assist, in creation of a conducive environment, for growth and development of capital marke

Calculate the one period european call option, Question: a) A bank len...

Question: a) A bank lends you $1750 at an initial nominal yearly interest rate of 7.5% compounded semi-annually. However, the interest rate will rise to 9.2% after the first

Dow Theory, Dow theory elliot wave theory

Dow theory elliot wave theory

Motgage Broker Assgnment, ollowing a personal introduction, and before you ...

ollowing a personal introduction, and before you begin gathering information about the clients’ existing financial situation or needs, there are certain disclosures you are require

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