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

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

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

Financial intermediaries, Financial Intermediaries These are instituti...

Financial Intermediaries These are institutions that link or mediate between the investors and savers: Some examples of financial intermediaries are as follow: 1. Comme

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

Calculate the current ratio, For each of the financial statement ratios lis...

For each of the financial statement ratios listed below calculate the ratio for the current year and for the prior year. (Note that in most textbooks, some of the ratios call for a

Venture capital, Venture Capital Venture capital is a form of investme...

Venture Capital Venture capital is a form of investment in new small risky enterprises utilized to get them started via specialists called venture capitalists. Venture capital

Explain the framework put forward by the basel committee, Question 1: a...

Question 1: a) Explain the framework put forward by the Basel Committee to ensure that banks and supervisors give appropriate attention to the second (supervisory review) and

Dividend policies and decisions, Dividend Policies and Decisions Divid...

Dividend Policies and Decisions Dividend policy determines the division of earnings among payments to stock holder's ad re-investment in the firm.  Hence now it looks at the f

Collection policy, Collection Policy The firm's collection policy may ...

Collection Policy The firm's collection policy may affect also our study.  The higher the cost of collecting accounts obtainable the lower the bad debt losses.  Therefore the

Unadjusted, $1,000 of insurance had not been used up by January 31. $325 of...

$1,000 of insurance had not been used up by January 31. $325 of insurance had been used up in January

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