# WK5 Quantitative Techniques In Financial Valuation

*label*Mathematics

*timer*Asked: Feb 3rd, 2019

*account_balance_wallet*$10

### Question Description

# Apply: Quantitative Techniques in Financial Valuation Problem Set

- Due Feb 04, 11:59 PM
- Not Submitted
- POINTS 10

Objectives:

**Resources: **Quantitative Techniques in Financial Valuation Problem Set Excel^{® }Template

**Save** the Quantitative Techniques in Financial Valuation Problem Set Excel^{® }Template to your computer.

**Read** the instructions on the first tab.

**Complete** the twelve exercises located in the template and record your answers in the highlighted spaces.

**Click **the Assignment Files tab to submit your assignment.

**Tags:**mathematics mathematics business business accounting Quantitative Techniques Financial Valuation Valuation Problem Set

## Tutor Answer

Hey! Kindly find the attached answer. Thank you and all the best.

Instructions:

Week 5 Individual Assignment

Total Number of Questions - 12

Total Points: 6

1. You have twelve problems - on each tab of this Excel file.

2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell.

The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if appropria

back and partial credit (if appropriate).

Find the interest paid on a loan of $1,200 for three years at a simple interest rate of 5% per year.

How much money will you pay after three years?

Principal

Rate

Time

$1.200

5%

3

Simple Interest (SI)

Maturity Value

$180 =PRODUCT(B4:B6)

$1.380 =Principal + SI

Find the maturity value of a loan of $1,750 for 28 months at 9.8% simple interest per year.

Principal

Rate

Time

$1.750

9,80%

2,33 -- Please make sure that the time periods for Time and Rate match.

Simple Interest (SI)

Maturity Value

$400 =PRODUCT(B3:B5)

$2.150 =Principal + SI

Find the simple interest rate of a loan of $5,000 that is made for three years and requires $1,762.50 in interest.

Principal

Time

SI

Rate

$5.000

3,00

$1.762,50

11,75%

762.50 in interest.

A loan of $16,840 is borrowed at 9% simple interest and is

repaid with $4,167.90 interest. What is the duration of the loan?

Principal

Rate

SI

Time

$16.840

9,00%

$4.167,90

2,75 years

33 months

How much money is borrowed if the interest rate is 9.25% simple interest

and the loan is made for 3.5 years and has $904.88 interest?

SI

Rate

Time

Principal

$904,88

9,25%

3,50

$2.795,00

Find the ordinary and exact interest for...

*flag*Report DMCA

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors