Question
. Provide solutions to the following. Answer the following questions and use the excel finance function to answer the questions. show the excel equation. 1.
. Provide solutions to the following.
Answer the following questions and use the excel finance function to answer the questions. show the excel equation.
1.
Payday loans are very short-term loans that charge very high interest rates. You can borrow $500today and repay $575 in two weeks. What is the compound annual rate implied by this 15 percent rate charged for only two weeks?
2. Payday loans are very short-term loans that charge very high interest rates. You can borrow $200 today and repay $225 in two weeks. What is the compound annual rate implied by this 12.5 percent rate charged for only two weeks?
3. What is the interest rate of a 4-year, annual $1,000 annuity with present value of $3,500?
4.
Mr. Jones decides to purchase a car for $10,000.The dealer offers to finance the car at 8% interest over a 4 year period.What is the payment amount that Mr. Jones would be expected to pay?
5.
You wish to buy a $20,000 car. The dealer offers you a 5-year loan with an 5 percent APR. What are the monthly payments?
6.
Joey realizes that he has charged too much on his credit card and has racked up $5,000 in debt. If he can pay $150 each month and the card charges 18 percent APR (compounded monthly), how long will it take him to pay off the debt?
7.
Mrs. Simpson is saving for her retirement.If she makes a payment of $1,000 at the end of each month for 15 years and earns a rate of 5.25% compounded 12 times per year, how much will she have in her retirement account when she is ready to retire?
8.Monica has decided that she wants to build enough retirement wealth that, if invested at 7 percent per year, will provide her with $3,000 monthly income for 30 years. To date, she has saved nothing, but she still has 20 years until she retires. How much money does she need to contribute per month to reach her goal?
9.Hank purchased a $28,000 car two years ago using an 8 percent, 5-year loan. He has decided that he would sell the car now, if he could get a price that would pay off the balance of his loan. What is the minimum price Hank would need to receive for his car?
10.Using the same data that is in problem #9, how much principle did Hank pay during the12 months he had his car?
11.W11.What is the future value of a $500 annuity payment over eight years if interest rates are 14 per14 percent?
Using
12.What is the present value of a $775 annuity payment over six years if interest rates are 11 percent?
13.
What is the present value of a $1,200 payment made every year forever when interest rates are4.5 percent?
14.
A loan is offered with monthly payments and a 15.5 percent APR. What is the loan's effective annual rate (EAR)?
15.
Assume that you contribute $300 per month to a retirement plan for 25 years. Then you are able to increase the contribution to $500 per month for 20 years. Given a 9 percent interest rate, what is the value of your retirement plan after 45 years?
16.What is the interest rate of a 6-year, annual $10,000 annuity with a present value of $45,000?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started