Question: please answer from question E and on Problem 5-41 a. Find the FV of $1,000 invested to earn 10% after 5 years. Answer this question
Problem 5-41 a. Find the FV of $1,000 invested to earn 10% after 5 years. Answer this question by using a math formula and also by using the Excel function wizard. b. Now create a table that shows the FV at 0%, 5 % , and 20% for 0, 1, 2, 3, 4, and 5 years. Then create a graph with years on the horizontal axis and FV on the vertical axis to display your results. c. Find the PV of $1,000 due in 5 years if the discount rate is 10%. Again, work the problem with a formula and also by using the function wizard. d. A security has a cost of $1,000 and will return $2,000 after 5 years. What rate of return does the security provide? e. Suppose California's population is 36.5 million people, and its population is expected to grow by 2% annually. How long will it take for the population to double? g. How will the PV and FV of the annuity ch ange if it is an annuity due rather than an ordinary annuity? h. What will the FV and the PV for problems a and c be if the interest rate is 10% with semiannual compounding rather than 10 % with annual compounding? i. Find the annual payments for an ordinary annuity and an annuity due for 10 years with a PV of $1,000 and an interest rate of 8%. j. Find the PV and the FV of an investment that makes the following end-of-year payments.. The interest rate is 8%. Suppose you borrow $15,000. The interest rate is 8 %, and it requires 4 equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, prrincipal repaymen ts, and beginning and ending loan balances
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
