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

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

Accounts receviable , sir could you please tel me what is A/R process.

sir could you please tel me what is A/R process.

Evaluate the companys financing strategy, For any company that is quoted on...

For any company that is quoted on the London Stock Market, you are required to write a report to existing shareholders on any TWO of the following issues. Each answer carries equal

Channelling of funds from savers to spenders important, How is the channell...

How is the channelling of funds from savers to spenders very important? The channelling of funds by savers to spenders is very significant for two purposes: • One, lender-sa

Methods or techniques of financial forecasting, Methods or Techniques of Fi...

Methods or Techniques of Financial Forecasting 1. Use of Cash Budgets A cash budget is a financial statement showing as: a) Sources of capital and revenue cash inflows

Evaluate the probability, Evaluate the probability of 10 or more customers ...

Evaluate the probability of 10 or more customers arriving within 2 hours if on average 7 customers arrive within one hour. Customers arrive independently.

Risk structure of interest rates, risk structure of interest rates 1. Defa...

risk structure of interest rates 1. Default risk 2. Liquidity 3. Income tax consideration 4. Expectations theory

What are the features of stock exchange, What are the Features of Stock Exc...

What are the Features of Stock Exchange The key features of stock exchange are as below: (1) Organised Market: Stock Exchange is an organized market. Each stock exchang

Agency relationship between auditors and shareholders, Agency Relationship ...

Agency Relationship between Auditors and Shareholders Shareholders appoint auditors as per the provisions of Section 159(1)-(6) of the Companies Act. The auditors are believed

What financial report exactly do, What financial report exactly do? Fin...

What financial report exactly do? Financial reports tell its intended readers about all the financial information of the company for the period it is reporting. It also contain

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