Calculate interest rate, Finance Basics

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

Posted Date: 2/23/2013 2:26:41 AM | Location : United States







Related Discussions:- Calculate interest rate, Assignment Help, Ask Question on Calculate interest rate, Get Answer, Expert's Help, Calculate interest rate Discussions

Write discussion on Calculate interest rate
Your posts are moderated
Related Questions
Question 1: (a) (i) What are Asset shares? (ii) State the purpose of calculating Asset shares. (b) Outline the five uses of policy Asset shares? (c) Lif

Working Capital a) Working capital or called gross working capital also, refers as current assets. b) Net working capital refers to current assets minus current liabilities

Price Earnings Ratio Valuation P/E ratio is traditionally employed for valuation of shares however it is an important ratio in the valuation of business. The P/E ratio is the

You are asked to select three variables for a sensitivity analysis of weighted average cost of capital, what would you choose and why? Weighted average cost of capital is th

Discuss capital budgeting techniques including : the Payback Rule, IRR, NPV, and the Profitability Index. Be sure to discuss the advantages and disadvantages of each one.  Di

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

the two problems below (P1 and P2). Five marks each. Part marks will be allocated, but if you have the incorrect answer then you cannot expect to get more than half marks. Project

Debtors Collection Period - Formula Fomula is given below: Debtors collection period = 365/ Debtors turnover Or (365 x Average debtors)/ Annual credit sales This

investment procedure of mutual fund

Illustrate the role of credit unions in depository institutions. Credit unions: Credit unions are non-profit institutions equally organised and owned through their member