QRB501 Phoenix Quantitative Techniques in Financial Valuation Problem Paper Purpose of Assignment

The purpose of this assignment is to provide students an opportunity to practice and learn the time-value of money concepts covered during Week 4. Students will understand how to evaluate future values, present values, interest rates, and time periods for financial investments.

Don't use plagiarized sources. Get Your Custom Essay on

QRB501 Phoenix Quantitative Techniques in Financial Valuation Problem Paper Purpose of Assignment
The purpose of this assignment is to provide students an

Just from $13/Page

Assignment Steps

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.

Format your paper consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

Note: Please ensure the formulas are in the excel spreadsheet. (Showing work) 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

Simple Interest (SI)

Maturity Value

=PRODUCT(B4:B6)

=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

Simple Interest (SI)

Maturity Value

— Please make sure that the time periods for Time and Rate match.

=PRODUCT(B3:B5)

=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

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

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

Find the ordinary and exact interest for a loan of $1000 at a 5% annual

interest rate. The loan was made on March 15 and is due May 15.

Loan date

Loan Due Date

Exact time

days

=B5-B4

Principal

Rate

Time

Loan date

Loan Due Date

Exact time

days

Principal

Rate

Time

Ordinary Simple Interest (SI)

Exact Simple Interest (SI)

=PRODUCT(B8:B10)

=PRODUCT(G8:G10)

=G5-G4

=PRODUCT(G8:G10)

Find the bank discount and proceeds using ordinary interest for a loan to Michelle Anders for $7,200

at 8.25% annual simple interest from August 8 to November 8.

Loan date

Loan Due Date

Exact time

days

Face Value (F)

Discount Rate (D)

Time Period (T)

Bank Discount (B)

years –> ‘Convert Exact time in days to years

=PRODUCT(B8:B10) OR =B8*B9*B10

Proceeds (P)

=B8-B11

=B5-B4

What is the effective interest rate of a simple discount note for $8,000,

at an ordinary bank discount rate of 11%, for 120 days?

Face Value (F)

Discount Rate (D)

Time Period (T)

Bank Discount (B)

years –> ‘Convert Exact time in days to years

=PRODUCT(B4:B6) OR =B4*B5*B6

Proceeds (P)

=B4 – B7

Rate

=B7/PRODUCT(B9, B6)

SOLVED EXAMPLE

What is the effective interest rate for the ﬁrst year for a loan of $20,000

for three years if the interest is compounded quarterly at a rate of 12%?

Quoted Rate

12,00% quarterly

No. of compounding

periods per year

EAR

4 For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo

12,55% =EFFECT(B5, B6)

1. Ross Land has a loan of $8,500 compounded quarterly for four years at 6%. What is the effective interest rate for the ﬁrst y

Quoted Rate

No. of compounding

periods per year

EAR

For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo

=EFFECT(B11, B12)

2. Find the effective interest rate for the ﬁrst year for a loan for four years compounded semiannually at an annual rate of 2%

Quoted Rate

No. of compounding

periods per year

EAR

For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo

=EFFECT(B17, B18)

3. What is the effective interest rate for the ﬁrst year for a loan of $5,000 at 10% compounded daily for three years?

Quoted Rate

No. of compounding

periods per year

EAR

For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo

=EFFECT(B23, B24)

4. Depending on the issuer, a typical credit card agreement quotes an interest rate of 18 percent APR. Monthly payments are

What is the actual interest rate you pay on such a credit card?

Quoted Rate

No. of compounding

periods per year

EAR

For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo

=EFFECT(B30, B31)

5. Find the effective interest rate for a loan of $3,500 at 10% interest compounded quarterly.

Quoted Rate

No. of compounding

periods per year

EAR

For Quarterly, type 4; for semiannually, type 2; for annually, type 1; for monthly, type 12; fo

=EFFECT(B36, B37)

SOLVED EXAMPLE

Tim Bowling has $20,000 invested for three years at a 5.25% annual rate compounded daily.

How much interest will he earn?

Initial Investment (PV)

Quoted Rate

Compounding Frequency

Number of compoundings (m)

Quoted Rate divided by m = RATE

Number of Years

NPER (Num. of years * m)

Ending Amount (FV)

Compound Interest

$20.000

5,25%

Daily

365

0,0144%

3

1095

$23.411,35

$3.411,35

Choose one

For Quarterly, type 4; for semiannually, type 2; for a

Exercise

Find the future value of a $15,000 money market investment at 2.8% annual interest compounded daily for three years.

Initial Investment (PV)

Quoted Rate

Compounding Frequency

Number of compoundings (m)

Quoted Rate divided by m = RATE

Number of Years

NPER (Num. of years * m)

Ending Amount (FV)

Compound Interest

Choose one

For Quarterly, type 4; for semiannually, type 2; for a

for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365

for semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365

SOLVED EXAMPLE

The Holiday Boutique would like to put away some of the holiday

profits to save for a planned expansion. A total of $8,000 is needed in three years. How much

money in a 5.2% three-year certificate of deposit that is compounded monthly must be invested

now to have the $8,000 in three years?

Future Value Needed (FV)

Quoted Rate

Compounding Frequency

Number of compoundings (m)

Quoted Rate divided by m = RATE

Number of Years

NPER (Num. of years * m)

Amount Invested Now (PV)

$8.000

5,2%

Monthly

12

0,4333%

3

36

$6.846,78

Choose one

For Quarterly, type 4; for semiannually, type 2; for a

Exercise

How much should be invested now to have $15,000 in six years if interest is 4% compounded quarterly?

Future Value Needed (FV)

Quoted Rate

Compounding Frequency

Number of compoundings (m)

Quoted Rate divided by m = RATE

Number of Years

NPER (Num. of years * m)

Amount Invested Now (PV)

Choose one

For Quarterly, type 4; for semiannually, type 2; for a

r semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365

r semiannually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365

Jamie Juarez needs $12,000 in 10 years for her daughter’s college education.

How much must be invested today at 2% annual interest compounded

semiannually to have the needed funds?

Future Value Needed (FV)

Quoted Rate

Compounding Frequency

Number of compoundings (m)

Quoted Rate divided by m = RATE

Number of Years

NPER (Num. of years * m)

Amount Invested Now (PV)

Choose one

For Quarterly, type 4; for semiannually, type 2; for annually, ty

A loan of $8,000 for two acres of woodland is compounded quarterly at an annual

rate of 6% for ﬁve years. Find the compound amount and the compound interest.

Initial Investment (PV)

Quoted Rate

Compounding Frequency

Number of compoundings (m)

Quoted Rate divided by m = RATE

Number of Years

NPER (Num. of years * m)

Ending Amount (FV)

Compound Interest

Choose one

For Quarterly, type 4; for semiannually, type 2; for annually, ty

ually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365

ually, type 2; for annually, type 1; for monthly, type 12; for daily, type 365

Purchase answer to see full

attachment

Why should I choose Homework Writings Pro as my essay writing service?

We Follow Instructions and Give Quality Papers

We are strict in following paper instructions. You are welcome to provide directions to your writer, who will follow it as a law in customizing your paper. Quality is guaranteed! Every paper is carefully checked before delivery. Our writers are professionals and always deliver the highest quality work.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Reasonable Prices and Free Unlimited Revisions

Typical student budget? No problem. Affordable rates, generous discounts - the more you order, the more you save. We reward loyalty and welcome new customers. Furthermore, if you think we missed something, please send your order for a free review. You can do this yourself by logging into your personal account or by contacting our support..

Essay Delivered On Time and 100% Money-Back-Guarantee

Your essay will arrive on time, or even before your deadline – even if you request your paper within hours. You won’t be kept waiting, so relax and work on other tasks.We also guatantee a refund in case you decide to cancel your order.

100% Original Essay and Confidentiality

Anti-plagiarism policy. The authenticity of each essay is carefully checked, resulting in truly unique works. Our collaboration is a secret kept safe with us. We only need your email address to send you a unique username and password. We never share personal customer information.

24/7 Customer Support

We recognize that people around the world use our services in different time zones, so we have a support team that is happy to help you use our service. Our writing service has a 24/7 support policy. Contact us and discover all the details that may interest you!

Try it now!

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our reputation for excellence in providing professional tailor-made essay writing services to students of different academic levels is the best proof of our reliability and quality of service we offer.

Essays

When using our academic writing services, you can get help with different types of work including college essays, research articles, writing, essay writing, various academic reports, book reports and so on. Whatever your task, homeworkwritingspro.com has experienced specialists qualified enough to handle it professionally.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our professional editor will check your grammar to make sure it is free from errors. You can rest assured that we will do our best to provide you with a piece of dignified academic writing. Homeworkwritingpro experts can manage any assignment in any academic field.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.