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

Foundation of Building Wealth, I am struggling with a PowerPoint Presentati...

I am struggling with a PowerPoint Presentation 8-10 slide the calculations and understanding Traditional IRAs and Roth IRAs, I guess that I need to prepare this for an audience. Sh

Managerial finance functions, Managerial Finance Functions Require ski...

Managerial Finance Functions Require skilful execution, control and planning of financial activities.  Hence there are four significant managerial finance functions. Such are

Solutions - shareholders and management conflict, Solutions - Shareholders ...

Solutions - Shareholders and Management Conflict Conflicts between management and shareholders may be resolved as follows like: 1. Pegging or attaching managerial compens

Cum. and ex. - terms used in capital market authority, Cum. And Ex. - Terms...

Cum. And Ex. - Terms Used in Capital Market Authority           These prefixes are written in front of other words as like capital, rights and dividends to qualify them."Cum" i

Uses and application of ratios, Uses and Application of Ratios Ratios ...

Uses and Application of Ratios Ratios are required in the following ways via managers in different firms. 1. Evaluating the efficiency of assets employment to generate sale

Becoming a tutor, How to become a tutor in this platform?

How to become a tutor in this platform?

Average rate of return - down payment, 1.  Determine what is the future val...

1.  Determine what is the future value of $20 a week for 10 (ten) years at 6 percent interest? Assume the first payment takes place at the end of this week. 2.  Kristina started

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

How capital budgeting decisions affect a company’s value, Give an example o...

Give an example of how capital budgeting decisions affect a company's value, strategy or operations. Companies always tend to look for capex projects which will add value to

Estimate the economic rate of return, Production data has been fit to a Fet...

Production data has been fit to a Fetkovich type curve. Given the following information, answer the questions: Date of first production plotted for the Fetkovich type curve matc

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