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

Importance and solution of dividend decisions, Importance and Solution of D...

Importance and Solution of Dividend Decisions Dividends decisions are integral part of a firm's strategic financing decision. It is hence a plan of action adopted by managemen

Advantages of floatation of new shares, Advantages of Floatation of New Sha...

Advantages of Floatation of New Shares 1. It facilitates the matter of securities to increase new finance, creation a company less dependent on retained earnings and banks.

The profitability index for the investment, Question   Clifton-Peters L...

Question   Clifton-Peters Ltd is a manufacturer of household goods located in Melbourne. They presently make and wholesale fruit juicers, blenders and baking equipment. The Gen

Earning method - bases of valuation, Earning method - Bases of Valuatio...

Earning method - Bases of Valuation The business is valued according to the net stream of income it is expected to create over its lifetime. Determination of maintaina

Calculate the percentage of equity of firm sells, Consider an economy with ...

Consider an economy with three dates {t=0, 1, 2}. A firm has assets in place that generate an output (profit) of either 40 in state L or 160 in state H at t=2. Bothe states equally

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

Assignment, Following details are related to three companies which are iden...

Following details are related to three companies which are identical except in terms of ''''r''''. Company ABC Ltd. MNC Ltd. XYZ Ltd. Cost of capital 10% 10% 10% Earn per Share Rs

Example of baumol's model, Example of Baumol's Model ABC Ltd. creates ...

Example of Baumol's Model ABC Ltd. creates cash payments of Shs.10, 000 per week.  The interest rate at marketable securities is 12 percent and every moment the company sells

State the realised and expected return, State the Realised and Expected Ret...

State the Realised and Expected Return Return is not as simple a notion as it appears to be as it's not guaranteed, it is mostly expected, and it may or may not be realized.

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