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

Student., what type of assets does Intel own and the most significant asset...

what type of assets does Intel own and the most significant asset to the company and why?

Calculate the incremental net present value, The following NPV's have been ...

The following NPV's have been calculated to determine if a compressor installation should be accelerated from Year 3 to Year 7. The compressor cost is $1,500,000.   a. C

C.O.L.A., What are some good examples of C.O.L.A?

What are some good examples of C.O.L.A?

Finance Project , Five years ago, you bought a house for $151,000, with a d...

Five years ago, you bought a house for $151,000, with a down payment of $30,000, which meant you took out a loan for $121,000. Your interest rate was 5.75% fixed. You would like to

What does beta measure and how is it interpreted, The Beta of several indus...

The Beta of several industry sectors is shown below. Industry                                                                                            Beta (β) Banks

Define two instances of liquidity ratio and efficiency ratio, Define two in...

Define two instances of Efficiency Ratio, Liquidity Ratio, Leverage Ratio? 1. Define two instances each of 'Efficiency Ratio', 'Liquidity Ratio', 'Leverage Ratio' and 'Prof

AGENCY, explain any four actions or transactions by shareholders that could...

explain any four actions or transactions by shareholders that could be harmful to the interests of debt holders (sources of conflict). estion #Minimum 100 words accepted#

Preparing contract note in the stock exchange, Preparing Contract Note in t...

Preparing Contract Note in the Stock Exchange Clerk takes the details of the day's transaction to the broker at the end of working day. Broker scrutinizes all transactions o

Conservative approach - financing current assets, Conservative Approach - F...

Conservative Approach - Financing Current Assets An exact similar of asset life along with the life of the funds required to finance the asset may not be possible. A firm that

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