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

Bureaucratic system of management, "Managerial leadership considers that th...

"Managerial leadership considers that the focus of school leaders ought to be on functions, tasks and behaviours and if these functions are carried out competently the work of othe

calculate the growth rate, The Mountain Fresh Company had earnings per sha...

The Mountain Fresh Company had earnings per share (EPS) of $6.32 in 2006 and $11.48 in 2011. The company pays out 30 percent of its earnings as dividends per share (DPS), and the

Budget, Why good judgement is important when making budgeting decisions

Why good judgement is important when making budgeting decisions

Constraints of venture capital in us, Constraints of Venture Capital in US ...

Constraints of Venture Capital in US 1. Require of rich investors in US, thus inadequate equity capital. 2. Inefficiencies of stock market - NSE is investors and inefficien

Cash and bonus issue - dividend, Cash and Bonus Issue - Dividend For a...

Cash and Bonus Issue - Dividend For a firm to pay cash dividends, it should contain adequate liquid funds.Though, under conditions of liquidity and financial constraints, a fi

Market for funds, Market For Funds Market for Funds and Financial Inst...

Market For Funds Market for Funds and Financial Institutions in Middle Asia 1. Financial markets refer to an elaborate system of the financial institution and arrange

Explain the both dividend yield and earnings yield, Explain the both Divide...

Explain the both Dividend Yield and Earnings Yield Dividend Yield: Dividend yield is the ratio of per share expected dividends, to current market price of share. Earnin

Throughput accounting, state a case where throughput according system is re...

state a case where throughput according system is required

WACC, #The following is the existing capital structure of Company XYZ Ltd. ...

#The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.

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