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

Cost of redeemable debentures and preference shares, Cost of Redeemable Deb...

Cost of Redeemable Debentures and Preference Shares Redeemable fixed return securities have an exact maturity period.  The cost of those securities is called redemption yield

investors are risk neutral, At t = 0, a 3-year, 7% coupon corporate bond w...

At t = 0, a 3-year, 7% coupon corporate bond with face value $1,000 is trading at a credit spread of 15%. The risk free rate is constant and equal to 4% for all maturities. The rec

What are potential solutions, Internal finance can avoid the agency costs o...

Internal finance can avoid the agency costs of debt and equity finance. In practice it is the most important source of funding. (a) Discuss potential problems of internal financ

Comparison between debt finance and ordinary share capital, Comparison betw...

Comparison between Debt Finance and Ordinary Share Capital Differences between Debt Finance and Ordinary Share Capital as Equity Finance as   Ordina

Net present value method - example, Net Present Value Method - Example ...

Net Present Value Method - Example Jeremy limited wishes to expand its output by purchasing a new machine worth 170,000 and installation costs are estimated at 40,000/=.  In t

Analysis, Inventories turnover 8 times 4 times Re...

Inventories turnover 8 times 4 times Receivable days 63 days 40 days

Money market mutual funds (), why i cant found date for mmmfs like total as...

why i cant found date for mmmfs like total asset or number of share or return ???? i search alot and i found words instead of number

Determining the rules for resolving conflict, Instructions: Read the Herzbe...

Instructions: Read the Herzberg findings related to extrinsic and intrinsic factors driving job satisfaction, dissatisfaction and motivation. To what extent should employers feel r

Determine the utility of the entrepreneur, Suppose an entrepreneur owns a f...

Suppose an entrepreneur owns a firm which has two production opportunities. Technology A generates an output (net profit) of 10 in state 1, an output of 20 in state 2, and an outpu

Example of asset based valuation, Example of Asset Based Valuation Ext...

Example of Asset Based Valuation Extracted information from the books of Kent Limited.   Current liabilities Bank overdraft    Sh. 300,000

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