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

What does beta measure and how is it interpreted, The Beta of several indus...

The Beta of several industry sectors is shown below. Industry                                                                                            Beta (β) Banks

Draw a budget constraint , The price of bread is $0.50 per pound, and the p...

The price of bread is $0.50 per pound, and the price of butter is $0.25 per ounce. Channing spends all of her income, buying 12 pounds of bread, 7 ounces of butter, and nothing els

Hedging at Porsche, 1. Should Porsche hedge its foreign exchange risks? 2...

1. Should Porsche hedge its foreign exchange risks? 2. How does Porsche hedge its foreign exchange risk? 3. What is the best hedging strategy? 4. How did Porsche build its Vo

Revenue Reserves - Retained Earnings, Revenue Reserves - Retained Earnings ...

Revenue Reserves - Retained Earnings These are undistributed earnings.  Those reserves are retained for the given reasons like: A. To create up for the fall in profits so a

Advantages of central depository system or cds, Advantages of Central Depos...

Advantages of Central Depository System or CDS 1. It shortens the registration procedure in the stock exchange that is high speed of registering shareholders. 2. It improve

Define financial factors that influence value of a business, List and expla...

List and explain the three financial factors that influence the value of a business. Ans: The three issues that influence the value of a firm's stock price are cash flow , ti

Finance Instrumant and Market , What factors would affect company consider ...

What factors would affect company consider in choosing option for capital-raising

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

Smsi and s&p, The financial data is of little value in its raw form. Howeve...

The financial data is of little value in its raw form. However, the same may be analyzed and be put in the form more meaningful to the recipients. This is normally done by using va

What are the methods of underwriting, What are the Methods of Underwriting ...

What are the Methods of Underwriting An underwriting agreement may take any of the below three forms: (i) Standing behind the issue: Under this method, underwriter guarant

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