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

• Homework Help
• 21
• 100% (1) 1 out of 1 people found this document helpful

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

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

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

e cell. redit (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

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

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

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

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

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

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

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

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.
This is the end of the preview. Sign up to access the rest of the document.
• Summer '14
• JUDE

{[ snackBarMessage ]}

### What students are saying

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

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

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

Dana University of Pennsylvania ‘17, Course Hero Intern

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

Jill Tulane University ‘16, Course Hero Intern