{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

QRB501_r10_Quantitative_Techniques_in_Financial_Valuation_Problem_Set_Excel_Template (2).xlsx

QRB501_r10_Quantitative_Techniques_in_Financial_Valuation_Problem_Set_Excel_Template (2).xlsx

Info iconThis preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
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 The instructor will then know where you made a mistake and provide you valuable feedback and partial cr
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
e cell. redit (if appropriate).
Background image of page 2
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
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Find the maturity value of a loan of $1,750 for 28 months at 9.8% simple interest per year. Principal Rate Time -- Please make sure that the time periods for Time and Rate match. Simple Interest (SI) Maturity Value
Background image of page 4
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
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 6
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
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
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
Background image of page 8
interest rate. The loan was made on March 15 and is due May 15. Loan date Loan date Loan Due Date Loan Due Date Exact time days Exact time days Principal Principal Rate Rate Time Time Ordinary Simple Interest (SI) Exact Simple Interest (SI) Find the ordinary and exact interest for a loan of $1000 at a 5% annual
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
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.
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}