Question: Formulas need to be completed in Excel. Find the interest rates implied by each of the following: 2a. You borrow $1500 today and promise to
Formulas need to be completed in Excel.

Find the interest rates implied by each of the following: 2a. You borrow $1500 today and promise to repay the loan by making a single payment of $2114.00 in 5 years. 4. How long will it take your money to triple given the following interest rates? (Assume annual compounding) 4c. 15% 5. After graduating from college you make it big - all because of your success in business finance. You decide to endow a scholarship for needy finance students that will provide $5000 per year indefinitely, beginning 1 year from now. How much must be deposited today to fund the scholarship under the following conditions. 5b. The interest rate is 10% and the first payment is made 6 years from today instead of 1 year from today. (Assume annual compounding) Note: This will require 2 calculations: Growth of the endowment from Year 0 to Year 6, and; Size of endowment in Year 6 that is needed to provide scholarships
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
