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
Bases of Share Valuation Share valuation can be done on the basis of income and asset values. On the basis of income still a share will be entitled to two forms of income. For


Advantages of Residual Theory 1. Saving on floatation costs No require to raise debt or equity capital as there is high retention of earnings that necessitates no floatat


Assignment: Mr. Ali wants to start “Rent-A-Car” business. He wants to start this business with at least 20 cars. He estimates that the required investment for the business is Rs.


The construction of a highway is broken into 14 activities as shown in the following table. Draw a bar chart of this construction project. Activity ID Desc

ollowing a personal introduction, and before you begin gathering information about the clients’ existing financial situation or needs, there are certain disclosures you are require

explain the financial planning process in a private limited company

Asset Based Valuation - Example K and K Company Limited is planning to absorb three other companies so as to realize its sales records of Sh.500, 000 per annum.  Its accountan