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

The case of Apple, From the above case shareholders are very worried that a...

From the above case shareholders are very worried that apple is having too much cash,discuss six reasons why shareholders are so worried

Investment analysis, Investment Analysis Any type of company will inve...

Investment Analysis Any type of company will invest finance for the sake of deriving a return that is useful for four main purposes as: 1. To reward the owners or shareholder

A. michael spence, A. Michael Spence An American economist who was awar...

A. Michael Spence An American economist who was awarded by the Nobel Memorial Prize in Economic Sciences. Spence is a lecturer of management at Stanford University in the Gradu

Market for funds, Market For Funds Market for Funds and Financial Inst...

Market For Funds Market for Funds and Financial Institutions in Middle Asia 1. Financial markets refer to an elaborate system of the financial institution and arrange

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.

Potential investors - measuring business performance, Potential Investors -...

Potential Investors - Measuring Business Performance Potential investors These parties are interested in a company in total both on long and short term basis in particula

Determine total expenditure, Determine the amount you would be willing to p...

Determine the amount you would be willing to pay for a $1,000 par value bond paying $80 interest each year (annual) and maturing in 12 years, assuming you wanted to earn a 9% rate

Yard stick required in ratio analysis, Yard Stick Required in Ratio Analysi...

Yard Stick Required in Ratio Analysis 1. Past performance of the company The company's previous performance past ratio is needed to gauge or measure the company's present

Finance final, • Company X has $100,000 face value of outstanding bonds con...

• Company X has $100,000 face value of outstanding bonds consisting of 100 $1,000 face value bonds with a 4% annual coupon and 20 years remaining until maturity. The bonds are cur

Explain the different life insurance products, Question: Company XYZ cu...

Question: Company XYZ currently operates a General Insurance company and would like to start selling life insurance products. The intended market is composed of both financial

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