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

Example of dividend basis valuation, Example of Dividend Basis Valuatio...

Example of Dividend Basis Valuation Company Laxmi Synthetics pays a dividend of 10% on its Sh.60 par value ordinary shares.  This company uses a discount rate of 15%.  A

Access to capital markets and ownership structure, Access to Capital Market...

Access to Capital Markets and Ownership Structure  Ownership Structure A dividend policy may be driven with Time Ownership Structure as like in small firms whereas manage

Cash deficit and cash surplus, What is cash deficit?And what is cash surplu...

What is cash deficit?And what is cash surplus?Describe each of them in detail.

Creative technology ltd, Download a set of financial statements "Creative T...

Download a set of financial statements "Creative Technology Ltd" From that set of Financial Statements. IN YOUR OWN WORDS, understand what the main revenue  streams of the business

Important points for shareholders and creditors, Important Points for Share...

Important Points for Shareholders and Creditors 1. In raising capital, the borrowing firm will constantly question the financial securities in form of preference shares

Calculate the yield to maturity, Suppose the current yield curve is as foll...

Suppose the current yield curve is as follows: (a) Calculate the current market prices of two bonds with the following annual cash flows: Bond A: A coupon of $60 is due

Money or discount markets - financial markets, Money or Discount Markets - ...

Money or Discount Markets - Financial Markets 1. Are discount and acceptance financial institutions 2. This is a market for S.T funds growing up in one year. Money market w

Tom and Martha Holt Case Study., Which of the following retirement plan alt...

Which of the following retirement plan alternatives would allow Tom the greatest deductible contribution while providing him with only a small cash flow commitment each year based

Risk-free interest rate-corporate tax rate, XYZ is considering a capital re...

XYZ is considering a capital restructuring to allow $300 million in debt. Currently, XYZ is an all-equity firm with earnings before interest and taxes of $260 million. Assume unlev

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