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

Leverage or gearing ratios, Leverage or Gearing Ratios Leverage or gea...

Leverage or Gearing Ratios Leverage or gearing ratios are as follow: a) Debt ratio = Total debts/Total assets Whereas total debt = fixed charge capital + liabilities.

Primary markets - financial markets, Primary Markets - Financial Markets ...

Primary Markets - Financial Markets These are markets such deal along with securities that have been issued for the first moment. The money flows directly from transferor or t

Asset management, Which of the following is not considered to be an investm...

Which of the following is not considered to be an investment objective

Define the term- origination, Define the term- Origination Originati...

Define the term- Origination Origination offers to the work of investigation, analysis and processing of new project proposals. Origination starts before an issue is really

Financial position, what is the financial position of the company in term...

what is the financial position of the company in term of leverage, liquidity and fluidity? Were the position better in 2013 compared to 2012 ? Possible ratios : - Levera

Timing of investment a stock exchange, Timing of Investment a Stock Exchang...

Timing of Investment a Stock Exchange The ideal way of creation profits on the stock exchange is to buy on the bottom of the market or lowest M.P.S and sell at the top of the

Net cash flow, Assignment: Mr. Ali wants to start “Rent-A-Car” business. He...

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.

Irr or internal rate of return, IRR or Internal Rate of Return This me...

IRR or Internal Rate of Return This method is a discounted cash flow technique that uses the principle of NPV.  It is described as the rate such equates the present value of c

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

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

Hi, continous time finaince expert

continous time finaince expert

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