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

Advantages and disadvantage of profitability index, Advantages and Disadvan...

Advantages and Disadvantage of Profitability Index Advantages of profitability index a) Simple to understand and utilize. b) The part of NPV in the venture will show t

Limitations of middle asia stock exchange index, Limitations of Middle Asia...

Limitations of Middle Asia Stock Exchange Index 1. The twenty (20) company's sample whose share prices are utilized to calculate the index are not true representatives. 2.

Social responsibility - objectives of business entity, Social responsibilit...

Social responsibility - Objectives of Business Entity The firm must decide where to operate strictly in their shareholders' best interests or be responsible to their staff, th

Stock market index, Stock Market Index Definition of Stock Market Ind...

Stock Market Index Definition of Stock Market Index An index is a numerical figure that measures relative change in variables between two type of durations. Examples

Compute Interest Assignment, Based on the example in Lesson 2, compute your...

Based on the example in Lesson 2, compute your quarterly interest for three years if you deposit $500 at 8 percent, compounded quarterly. Remember to divide the 8 percent by 4 to g

Determine the utility of the entrepreneur, Suppose an entrepreneur owns a f...

Suppose an entrepreneur owns a firm which has two production opportunities. Technology A generates an output (net profit) of 10 in state 1, an output of 20 in state 2, and an outpu

Comparison a competing firm-analysts earnings estimates, Comparison to a Co...

Comparison to a Competing Firm In Mergent Horizon, return to the competitor page, but now enter the list of competitors "As Defined by the Company."  From this list select a f

Gloria the Investor, Gloria the Investor Gloria is a seasoned sales manage...

Gloria the Investor Gloria is a seasoned sales manager with a very large international company. Although she has a great deal of experience with sales, she has little experience w

Mgmt640, Monroe, Inc., is evaluating a project. The company uses a 13.8 per...

Monroe, Inc., is evaluating a project. The company uses a 13.8 percent discount rate for this project. Cost and cash flows are shown in the table. What is the NPV of the project?

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