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

Lock-box system, Lock-Box System In a lock-box system, the customer se...

Lock-Box System In a lock-box system, the customer sent the payments to a post office box. The post office box is emptied with the firm's bank at minimum once or twice all bus

Calculate the incremental net present value, The following NPV's have been ...

The following NPV's have been calculated to determine if a compressor installation should be accelerated from Year 3 to Year 7. The compressor cost is $1,500,000.   a. C

Concentration banking, Concentration Banking Firms along with regional...

Concentration Banking Firms along with regional sales outlets can designate specific of these as regional collection centre. Customers during these areas are necessitated to r

Assignment, according to given specialization take down an industry and in...

according to given specialization take down an industry and investigate its managerial hierarchy to describe each of one of the managerial work level functioning

Limitations of middle asia stock exchange index, Limitations of Middle Asia...

Limitations of Middle Asia Stock Exchange Index 1. The twenty (20) company's sample whose share prices are utilized to calculate the index are not true representatives. 2.

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

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

Bills of exchange, Bills of Exchange Bills of Exchange are a source of...

Bills of Exchange Bills of Exchange are a source of finance in specifically in the export trade. A bill of swapping is an unconditional arrange in writing addressed via one pe

Bank draft, what is bank draft?How it can be prepared?

what is bank draft?How it can be prepared?

Weighted average cost of capital, Weighted Average Cost of Capital We...

Weighted Average Cost of Capital Weighted Average Cost of Capital or WACC is also called the overall or composite cost of capital. Since various capital components have diffe

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