Please show work in detail for each problem. If you need to use excel, please do so.
1.) Determine the present values (PVs) if $5,000 is received in the future (i.e., at the end of each indicated time period) in each of the following situations:
a. 5 percent for ten years
b. 7 percent for seven years
c. 9 percent for four years
2.) Assume you are planning to invest $5,000 each year for six years and will earn 10 percent per year. Determine the future value (FV) of this annuity if your first $5,000 is invested at the end of the first year.
3.) Determine the present value (PV) now of an investment of $3,000 made one year from now and additional $3,000 made two years from now if the annual discount rate is 4 percent.
4.) What is the present value (PV) of a loan that calls for the payment of $500 per year for six years if the discount rate is 10 percent and the first payment will be made one year from now? How would your answer change if the $500 per year occurred for ten years?
5.) Determine the annual payment on a $15,000 loan that is to be amortized over a four-year period and carries a 10 percent interest rate. Prepare a loan amortization schedule for this loan.
6.) Assume a bank loan requires an interest payment of $85 per year and a principal payment of $1,000 at the end of the loan's eight-year life.
a. At what amount could this loan be sold for to another bank if loans of similar quality carried an 8.5 percent interest rate? This is, what would be the present value (PV) of this loan?
b. Now, if interest rates on other similar quality loans are 10 percent, what would be the PV of this loan?
c. What would be the PV of the loan if the interest rate is 8 percent on similar quality loan?
7.) Determine the annual payment on a $500,000, 12 percent business loan from a commerical bank that is to be amortized over a five year period.