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

Find out operating leverage, (i) Find out operating leverage from the follo...

(i) Find out operating leverage from the following data: Sales                             Rs.50000 Variable Cost               60% Fixed Cost                   Rs.12000

Determining the rules for resolving conflict, Instructions: Read the Herzbe...

Instructions: Read the Herzberg findings related to extrinsic and intrinsic factors driving job satisfaction, dissatisfaction and motivation. To what extent should employers feel r

Stock repurchase, Stock Repurchase The company can buy back also sever...

Stock Repurchase The company can buy back also several of its outstanding shares instead of paying cash dividends. This is identified as stock repurchase and or bought back or

Importance of interest rates, Importance of Interest Rates These are o...

Importance of Interest Rates These are of a specifically relevance to a finance manager since: i) They measure the cost of borrowing. ii) Interest rates in a country influen

Debentures and bonds, how can debentures be explained in class in term of g...

how can debentures be explained in class in term of game, role play etc....?

THE CASE OF THE MISSING BONDS RATING, Three of these companies have bonds t...

Three of these companies have bonds that carry investment - grade ratings. The other 3 companies carry junk - bond ratings. Judging by the information in the table, which 3 compani

Finance calculation, #ques1. Steve and Ed are cousins who were both born on...

#ques1. Steve and Ed are cousins who were both born on the same day, and both turned 25 today. Their grandfather began putting $2,500 per year into a trust fund for Steve on his 20

Solution to the agency conflict, Solution to the Agency Conflict The g...

Solution to the Agency Conflict The government can acquire the following actions to protect itself and its interests. 1. Acquire monitoring costs E.g. the gover

Benefits ordinary share capital - financing, Benefits Ordinary Share Capita...

Benefits Ordinary Share Capital - Financing Benefits of using ordinary share capital in the financing They facilitate projects particularly long-term projects since they

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