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

Growth rates and hypothetically, Growth Rates Most ...

Growth Rates Most Recent Fiscal Year Fiscal Year (-1) Fiscal Year (-2) Fiscal Year (-3) Annu

Financial analysis , You are required to select any one company of your cho...

You are required to select any one company of your choice which is listed on either Dubai Financial Market (DFM) or Abu Dhabi Securities Market (ADSM). Send me an email giving at l

Financial forecasting, Financial Forecasting Financial forecasting ref...

Financial Forecasting Financial forecasting refers to determination of the firm of financial requirements in advance. Financial forecasting is needs financial planning using b

Leverage and coverage ratios, Leverage and Coverage Ratios   (The dat...

Leverage and Coverage Ratios   (The data for interest coverage are in I-Metrix's liquidity ratios section.  The others listed in this table are in the leverage ratios section

Calculate average price-earnings ratio, Regan Inc., was founded nine years ...

Regan Inc., was founded nine years ago by brother and sister Carrington and Genevieve Regan. The company manufactures and installs commercial heating, ventilation, and cooling (HVA

Interest rate levels and stock prices, Interest Rate Levels and Stock Price...

Interest Rate Levels and Stock Prices Interest rates contain two effects on corporate profits: a) Since interest rate is a cost, and like the higher the rate of interest the

Costs of capital, a bond that has a 1000 per value and a contract or coupon...

a bond that has a 1000 per value and a contract or coupon interest rate of 12.8%. The bond is selling for a price of $1125 and will mature in 10 years. The firm''s tax rate is 34%

Partnership, Partnership Definition -Partnership may be defined as a re...

Partnership Definition -Partnership may be defined as a relationship between persons carrying on a business in common with a view of profits. In partnership business, two or mo

Discuss capital budgeting techniques, Discuss capital budgeting technique...

Discuss capital budgeting techniques including : the Payback Rule, IRR, NPV, and the Profitability Index. Be sure to discuss the advantages and disadvantages of each one.  Di

Partnerships - types of business organisations, Partnerships - Types of B...

Partnerships - Types of Business Organisations Defination "The relationship, that exists with persons carrying on a business in common by a view of profit." Formati

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