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

Draw the total expenses vs. time curve, For the set of activities shown in ...

For the set of activities shown in the table below, draw the total expenses vs. time curve using the following data: The labor rates are as follows: Labor # 1 (L1) rate = 30

Depreciation, Which depreciation method would produce the higher NPV and ho...

Which depreciation method would produce the higher NPV and how much higher would it be?

Aafafa, ksklklsdfmklsnakakngjkalkgblakbgklabgklagkbaskgbljas a kalks las l...

ksklklsdfmklsnakakngjkalkgblakbgklabgklagkbaskgbljas a kalks las lgaskgbak a lv aslglaksglas la sla

Characteristics of sole proprietorship, Characteristics of sole proprietors...

Characteristics of sole proprietorship The main characteristics of sole proprietorships are as follows: 1) Ownership- The ownership of the business unit is by one person.

What is the role of a broker in security transactions, What is the role of ...

What is the role of a broker in security transactions? How are brokers compensated? Ans: Brokers handle orders to sell or buy securities. Brokers are agents who work in place o

Micro economics, effect of gdp in the domestic market

effect of gdp in the domestic market

Debenture finance, Debenture Finance A type of long term debt raised a...

Debenture Finance A type of long term debt raised after a company sells debenture certificates to the holder and raises finance in return. The term debenture has its source fr

Money and banking course, Ask questioSay that a buyer of bonds values good ...

Ask questioSay 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

Advantage of bill - source of finance, Advantage of Bill - Source of Financ...

Advantage of Bill - Source of Finance Advantages of necessitating a Bill as a Source of Finance They are a faster means of raising finance whether drawer is credible.

Solutions - relationship between auditors and shareholders, Solutions to th...

Solutions to the conflict - Relationship between Auditors and Shareholders 1. Firing The auditors may be detached from office at the AGM via the shareholders. 2. Lega

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