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

Calculate the one period european call option, Question: a) A bank len...

Question: a) A bank lends you $1750 at an initial nominal yearly interest rate of 7.5% compounded semi-annually. However, the interest rate will rise to 9.2% after the first

Example of payback period method, Example of Payback Period Method Sup...

Example of Payback Period Method Suppose a project costs Sh.80,000 and will produce the following cash inflows as:                                  Cash inflows      Accumu

What is bond rate, What is Bond Rate It is interest rate received on...

What is Bond Rate It is interest rate received on the face value or the par value of the bond. If a company or government issues a 10-year bond with 100$ as face value and 1

Meaning of a sentence, on this sentence: "all have an interest in understan...

on this sentence: "all have an interest in understanding what drives trade" please explain what''s meaning of "what drives trade"?

Significance of investment decisions, Significance of Investment Decisions ...

Significance of Investment Decisions a) Such type of decisions is importance since they will influence the company's size or like fixed assets, retained and sales earnings.

Time value of money, How to calculate the present value of assignment??

How to calculate the present value of assignment??

Tax differential theory, Tax Differential Theory Advanced via Lichtenb...

Tax Differential Theory Advanced via Lichtenberger and Ramaswamy in 1979.They argued that tax rate on dividends is higher quite than tax rate on capital gains. Thus, a firm th

Valuation of business, Valuation of Business A business may be valued ...

Valuation of Business A business may be valued for different type of reasons that as for merger, acquisition, or takeover or liquidation or outright sale.  During purchasing a

Time value of money, One of the projects the US loan would fund is to build...

One of the projects the US loan would fund is to build earthquake-resistant buildings. The project will begin in March 2013, last for two years and is expected to have the followin

Captive insurance, discuss the meaning and advantage of captive insurance

discuss the meaning and advantage of captive insurance

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