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

Accounting rate of return method or arr, Accounting Rate of Return Method o...

Accounting Rate of Return Method or ARR This method utilizes accounting profits from financial status to assess the viability of investment proposal via diving the average inc

Throughput accounting, state a case where throughput according system is re...

state a case where throughput according system is required

Som120 project, Frequency distribution for amount charged with starting poi...

Frequency distribution for amount charged with starting point 1800, class width 1000. For income use starting point 20 and class width of 10.

Basic Business Math, A new pet shop wants to apportion their investment mon...

A new pet shop wants to apportion their investment money $132,000 for advertising, building upgrades, and education in the ratio of 5:4:3. How much money does each category get app

Shareholders and creditors, Shareholders and Creditors Shareholders A...

Shareholders and Creditors Shareholders And Creditors or bond or debenture holders Bondholders are lenders or providers of long term debt capital.  Usually they will provi

Example of accounting rate of return method, Example of Accounting Rate of ...

Example of Accounting Rate of Return Method                                    Shs. Project X cost              500,000 Scrap value                 100,000 Stream of

Define the term contractual savings depository institutions, Define the ter...

Define the term contractual savings depository institutions. Contractual savings institutions: Contractual savings institutions obtain funds at periodic intervals onto a

Calculate the volume of sales to earn profit, From the following informatio...

From the following information related to XYZ Ltd.; you are required to find out (a) contribution (b) Break-even point in units (c) Margin of safety, (d) Profit             Tota

CH 4 Problems, Homework Chapter 4 A mortgage loan in the amount of $100,000...

Homework Chapter 4 A mortgage loan in the amount of $100,000 is made at 12% interest for 20 years. Payments are to be monthly in each part of this problem. a. What will monthly

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