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

Acd, Struggling with your final year projects, terms paper writing, researc...

Struggling with your final year projects, terms paper writing, research paper writing, thesis writing, engineering and programming projects? Experts are available 24x7 to help you

Systems and subsystems, SCENARIO You have just moved out of home and have ...

SCENARIO You have just moved out of home and have a part-time job that pays you $18 per hour after tax (you work 20 hours a week). You also have $5000 in a savings account. You

Determinants of required rate of return, Determinants of Required Rate of R...

Determinants of Required Rate of Return 1.Risk free rate - This is the interest rate such would exist on default free securities like Treasury bills and bonds. Risk free

Fixed asset and total asset turnover ratio, Fixed Asset and Total Asset Tur...

Fixed Asset and Total Asset Turnover Ratio Fixed asset turnover = Annual Sales / Fixed Assets This ratio indicate the efficiency along with which, the fixed assets we

THE CASE OF THE MISSING BONDS RATING, Three of these companies have bonds t...

Three of these companies have bonds that carry investment - grade ratings. The other 3 companies carry junk - bond ratings. Judging by the information in the table, which 3 compani

Assignment, How would you explain the value of financial planning to friend...

How would you explain the value of financial planning to friends or family? Which topics will you discuss with children in your life? Which topics do you feel are most imp

Capital budgeting, Definition of 'Capital Budgeting': The process in w...

Definition of 'Capital Budgeting': The process in which a business calculates whether projects such as building a new plant or investing in a long-term risk are worth pursuing

Management of account receivable, Management of Account Receivable In ...

Management of Account Receivable In order to keep current customers and attract new ones, most firms find it necessary to offer credit. Accounts receivable represents the exte

Product mix, what are the qualitative factors to be considered when decidin...

what are the qualitative factors to be considered when deciding on product mix

Hedging at Porsche, 1. Should Porsche hedge its foreign exchange risks? 2...

1. Should Porsche hedge its foreign exchange risks? 2. How does Porsche hedge its foreign exchange risk? 3. What is the best hedging strategy? 4. How did Porsche build its Vo

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