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

Maximum price of uniformed bonds, Say that a buyer of bonds values good bon...

Say that a buyer of bonds values good bonds at $500 and values bad bonds at $250. Sellers of both good and bad bonds value them at $350. If the fraction of good sellers and bad s

Analysis, Inventories turnover 8 times 4 times Re...

Inventories turnover 8 times 4 times Receivable days 63 days 40 days

System intergration, system integration and infrastructure development is t...

system integration and infrastructure development is the

Advantage and disadvantage of sole proprietorship, Advantage and Disadvanta...

Advantage and Disadvantage of Sole Proprietorship Advantage of Sole Proprietorship High supervision of employees Income motivate owner Sole trade mostly ski

Getting money, how i can get enough money with out doing any works ???????...

how i can get enough money with out doing any works ????????????

Finance, This case has been framed in order to test the skills in evaluatin...

This case has been framed in order to test the skills in evaluating a credit request and reaching a correct decision

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

Stock repurchase, Stock Repurchase The company can buy back also sever...

Stock Repurchase The company can buy back also several of its outstanding shares instead of paying cash dividends. This is identified as stock repurchase and or bought back or

Calculate interest rate, Imagine Joy is the manager of a bank named Money ...

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 re

Types of jobbers in stock market, Types of jobbers in Stock Market The...

Types of jobbers in Stock Market There are three kinds of jobbers as: a) Bulls A jobber buys shares while prices are down and hold them in anticipation such t

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