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

Stock market index, Stock Market Index Definition of Stock Market Ind...

Stock Market Index Definition of Stock Market Index An index is a numerical figure that measures relative change in variables between two type of durations. Examples

Bird-in-hand theory, Bird-in-hand Theory Advanced via John Leitner in ...

Bird-in-hand Theory Advanced via John Leitner in year 1962 and furthered with Myron Gordon in year 1963. Argues such shareholders are risk averse and prefer specific. Dividend

Term structure of interest rates, Term Structure of Interest Rates The...

Term Structure of Interest Rates The term structure of interest rate give details the relationship between the term to maturity and interest rates and the differences between

Real estate, A home buyer lists her home at a 7% commission rate and wants ...

A home buyer lists her home at a 7% commission rate and wants to net 45,000 after paying the mortgage balance of 68,000 and the broker''s commission. To the nearest dollar, what sh

Solutions to agency problem, Solutions to agency problem The bondholde...

Solutions to agency problem The bondholders might receive the following procedures to protect themselves from the process of the shareholders that might dilute the value of th

Drawback of stock repurchases, Drawback of Stock Repurchases 1. High ...

Drawback of Stock Repurchases 1. High price A company may find it not easy to repurchase shares at their recent value and price paid may be higher to the detriment of rem

Find out operating leverage, (i) Find out operating leverage from the follo...

(i) Find out operating leverage from the following data: Sales                             Rs.50000 Variable Cost               60% Fixed Cost                   Rs.12000

How capital budgeting decisions affect a company’s value, Give an example o...

Give an example of how capital budgeting decisions affect a company's value, strategy or operations. Companies always tend to look for capex projects which will add value to

Calculate the current stock price, The Bim-Bom Company is expected to pay a...

The Bim-Bom Company is expected to pay a dividend of $3.10 per share at the end of the year, and that dividend is expected to grow at a constant rate of 4.00% per annum.  The compa

CH 4 Problems, Homework Chapter 4 A mortgage loan in the amount of $100,000...

Homework Chapter 4 A mortgage loan in the amount of $100,000 is made at 12% interest for 20 years. Payments are to be monthly in each part of this problem. a. What will monthly

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