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 icon This 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
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).
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
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
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
Image of page 5

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

View Full Document Right Arrow Icon
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
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
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
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.
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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern