# Quantitative Techniques in Financial Valuation Problem Set, math homework help

*label*Mathematics

*timer*Asked: Apr 17th, 2017

*account_balance_wallet*$20

### Question Description

12 problems on excel sheet

### Unformatted Attachment Preview

Purchase answer to see full attachment

## Tutor Answer

Hi Please check the attached file for detail, let me know if you have any questions, thank youBest, James

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

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 ordinar...

*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