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

Example of sales method, Example of Sales Method The balance sheet of ...

Example of Sales Method The balance sheet of XYZ Ltd as on date 31st December 2002 is as following:          Net fixed asset Current assets   F

Calculate the retrospective gross premium reserve, Question: A deferred...

Question: A deferred annuity policy is sold to a life aged 45 with the following benefits: • Basic payments start at $30,000 from age 65, increasing by $2,000 each year; •

Determaine the dol and business risk, From the following selected operating...

From the following selected operating date, determaine the DOL. Which company has the greater amount of business risk? Why? Particulars A Ltd

Cash cycle and cash turnovers, Cash Cycle and Cash Turnovers Cash Cycl...

Cash Cycle and Cash Turnovers Cash Cycle refers to the amount of time which elapses from the point whenever the firms create a cash outlay to purchase raw materials to the poi

Eye field - vertebrate eye, Eye Field - Vertebrate Eye The development...

Eye Field - Vertebrate Eye The development of eyes starts with evagination of the lateral wall of the forebrain. one on each side, which make the optic vesicles. By vital dye

Public finance, models of solving externalities in 1) external sector 2)pr...

models of solving externalities in 1) external sector 2)private sector

Finance, Pls help with this + provide references > Briefly outline the mos...

Pls help with this + provide references > Briefly outline the most recent balance of payments experience for China and comment on whether the balance of payments situation will ha

Financial Institution Regulations, Why are financial institutions heavily r...

Why are financial institutions heavily regulated, with specific focus on their ability to increase or reduce the money supply?

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