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

Disadvantage of leasing an asset, Disadvantage of Leasing an Asset A. ...

Disadvantage of Leasing an Asset A. It is a pre-conditional finance as on the needs of asset B. In the long term the lease charges might out-weigh the cost of buying own as

Weighted average cost of capital, Below is information provided for tw...

Below is information provided for two companies, A and B.  Assuming a risk-free rate of 2.5%, an effective tax rate of 40%, and a market risk premium of 5.5%, estimate th

Define the direct finance and indirect finance in markets, Define the direc...

Define the direct finance and indirect finance in markets. In direct finance, borrower-spenders borrow funds directly by lenders into the financial markets through selling them

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

Calculate the profit and segment of the organization, Food and Beverages ...

Food and Beverages Rooms, Restaurants and Other Services Other Income Total $ $ $ Sale

Common Stock Valuation, Bates, inc. pays a dividend of $1.25 and is current...

Bates, inc. pays a dividend of $1.25 and is currently selling for $36.95. If investors require a 12% return on their investment, what growth rate would Bates Inc. have to provide t

State the determinants of return, State the Determinants of Return T...

State the Determinants of Return Three major determinants of the rate of return expected by investor are: (i) Time preference risk-free real rate. (ii) Expected rate o

Average rate of return - down payment, 1.  Determine what is the future val...

1.  Determine what is the future value of $20 a week for 10 (ten) years at 6 percent interest? Assume the first payment takes place at the end of this week. 2.  Kristina started

Importance of working capital management, Importance of Working Capital Man...

Importance of Working Capital Management The finance manager must understand the management of working capital since of the following purpose: a) Time devoted to working c

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