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 and valuation ratio, Growth and Valuation Ratio This ratio indi...

Growth and Valuation Ratio This ratio indicates the growth potential of the firm in addition to determining the value of the firm and investment made via various investors.  T

Computer the fair value of the stock, Future Ltd is a leading music enterta...

Future Ltd is a leading music entertainment company in the country and the stocks of the company are actively traded in the stock exchange. For the year just ended few days back,

Accounts payable turnover ratio, Accounts Payable Turnover Ratio Ratio...

Accounts Payable Turnover Ratio Ratio for Account Payable Turnover is as Follow: Creditors/accounts payable turnover = Annual credit purchases /Average creditors

Tracking order, when will I receive my order and how will I receive it?

when will I receive my order and how will I receive it?

Business finance and financial management, Business Finance and Financial M...

Business Finance and Financial Management Business finance is the process through which a financial manager or accountant gives finance for business use as and whenever it i

Cost of retained earnings common equity, Clemson Software is considering a ...

Clemson Software is considering a new project whose data are shown below. The required equipment has a 3-year tax life, after which it will be worthless, and it will be depreciate

Gordeon''s Model, what is the price of the share net sales Rs.120lakhs ne...

what is the price of the share net sales Rs.120lakhs net profit margin 12.5% no. of equity shares 25,000 cost of equity shares 12% retention ratio 40% rate of interest(ROI) 16%

Calculate the weighted average cost of capital, Company XYZ stock is consid...

Company XYZ stock is considering the two new projects, Project A and Project B. The two projects have similar risk characteristics as the existing business. The managers forecast t

What are the types of money and bank regulations, What are the types of Mon...

What are the types of Money and Bank Regulations? Types of Money : a. Commodity money b. A commodity-backed money c. Fiat money Bank Regulations: a. Deposit i

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