Time value of money

hw in finance

Time value of money worksheet # 1 (5.1 to 5.3). BFIN 3321
Use your calculator to complete the following problems. Show your work and highlight your answer. Upload your solution on blackboard.
1. Margot’s grandparents gave her $2,500 for her birthday. She opened a savings account that pays 3% annually. How much money will she have in 7 years?

N=  
I=  
PV=  
PMT=  
FV=  

2. Your parents will retire in 18 years. They currently have $200,000 and they think they will need $1,000,000 at retirement. What annual interest rate must they earn to reach their goal, assuming they don’t save any additional funds?

N=  
I=  
PV=  
PMT=  
FV=  

3. If you deposit $50,000 in an account that pays 5% annual interest, how long will it take to double your money?

N=  
I=  
PV=  
PMT=  
FV=  

4. Rebecca deposited $300 in an account that pays 6% compounded semiannually. How much money will she have in the account 5 years from now?

N=  
I=  
PV=  
PMT=  
FV=  

5. Jerry has $200,000 in his savings account. How much money did he deposit in the account 10 years ago if he earned 4% compounded monthly?

N=  
I=  
PV=  
PMT=  
FV=  

6. Amanda deposited $20,000 in an account that pays 8% annually. How long will it take her to triple the money if interest is paid every quarter?

N=  
I=  
PV=  
PMT=  
FV=  

Ordinary Annuity vs. Annuity Due.
7. At the end of each year you deposit $1,200 in a retirement account that pays 6%. How much money will you accumulate for your retirement if you plan to retire 40 years from now?

N=  
I=  
PV=  
PMT=  
FV=  

8. Starting today Andrew will deposit $750 per year in a retirement account that pays 6%. How much money will he accumulate for his retirement if he plans to retire 40 years from now?

N=  
I=  
PV=  
PMT=  
FV=  

9. You are looking into an investment that will pay you $5,000 per year for the next 8 years. If you require a 9% return, what is the most you would pay for this investment?

N=  
I=  
PV=  
PMT=  
FV=  

10. If today you pay $28,000 in exchange for an 8%, 15 year annuity, what will be the annual cash flow?

N=  
I=  
PV=  
PMT=  
FV=  

11. You will buy a house for $150,000. Your mortgage bank will lend you the money at 6% for 15 years. How much will you have to pay every month?

N=  
I=  
PV=  
PMT=  
FV=  

12. An insurance company is trying to sell you an investment policy that will pay you and your heirs $20,000 per year forever. If the required return on the investment is 7%, how much will you pay for the policy?
13. You bought a car for $15,000. You gave the dealer $5,000 as a down payment. The balance will be financed with a 4 year loan with an interest rate of 5%. What will your monthly payment be?

N=  
I=  
PV=  
PMT=  
FV=  


14. Calculate the effective annual rates for each of the following cases:

Stated Rate (APR) Number of Times Compounded Effective Rate (EAR)
7% Quarterly
12% Monthly
6% Semiannually

15. You just bought a house for $150,000. You have agreed to make 5 payments at the end of the year for 5 years with an interest rate of 5%. What will the annual payment be? Create a loan amortization schedule.

1
2
3
4
5

16. A first-round draft choice quarterback has been signed to a three-year, $25 million contract. The details provide for an immediate cash bonus of $2 million. The player is to receive $5 million in salary at the end of the first year, $8 million the next, and $10 million at the end of last year. Assuming a 15% discount rate, is the package worth $25 million? If not, how much is it worth?
17. You are evaluating an investment from a large financial services firm. The investment promises an initial payment of $8,000 at the end of this year and subsequent payments that will grow at a rate of 4% annually. If you use a 7 % discount rate for investments like this, what is the value of this investment?

Time Value of Money, Opportunity Cost, and Income Taxes Worksheet

Time Value of Money, Opportunity Cost, and Income Taxes Worksheet
FP/100 Version 1
4

University of Phoenix Material

Time Value of Money, Opportunity Cost, and Income Taxes Worksheet

Scenario 1: Time Value of Money / Cash Management Products
1. Use this Bankrate’s Simple Savings calculator to complete Scenario 1: http://www.bankrate.com/calculators/savings/simple-savings-calculator.aspx. You will enter the Initial Amount of Savings (Present Value), Annual Interest Rate (Rate of Return), and Number of Periods/Years into the calculator. The calculator will compute the Future Values.
In this scenario you will look at the impact of interest rates on your savings. Suppose that you have $2,000 of savings. You don’t anticipate needing to dip into these funds in the next five years. Based on the information provided in the table, calculate the future value (FV) of $2,000 at the end of years 1 and 5 if it were to be completely invested in each of the different cash management products.  
Enter your answers in the indicated cells of the table below. The Restrictions/Fees on Product Usage column relates to question 2 of Scenario 1.

Product Annual Interest Rate Restrictions/Fees on Product Usage FV at end of Year 1 FV at end of Year 5
Checking Account 0.00% · No minimum
· No limit on withdrawals
Answer:2000
Inputs:
Interest Rate per Time Period: 0
Number of Time Periods:
Present Value:
Answer:
Inputs:
Interest Rate per Time Period:
Number of Time Periods:
Present Value:
Savings Account 1.50% · No minimum
· Limited to 3 withdrawals per month
Answer:
Inputs:
Interest Rate per Time Period:
Number of Time Periods:
Present Value:
Answer:
Inputs:
Interest Rate per Time Period:
Number of Time Periods:
Present Value:
Certificate of Deposit (CD) 5% · $500 minimum balance
· Early withdrawal penalty: 180 days of interest plus $25
Answer:
Inputs:
Interest Rate per Time Period:
Number of Time Periods:
Present Value:
Answer:
Inputs:
Interest Rate per Time Period:
Number of Time Periods:
Present Value:

2. Based on your calculations and on all you have learned this week, how would you choose to save your $2,000? Consider things such as rate of return, inflation, taxes, liquidity, safety, restrictions, and fees, and explain the rationale for your decision. Respond in at least 50 words.
<Write response here.>
Scenario 2: Time Value of Money / Compounding Interest
3. Use this Bankrate’s Simple Savings calculator to complete Scenario 2: http://www.bankrate.com/calculators/savings/simple-savings-calculator.aspx. You will enter the Initial Amount of Savings (Present Value), Annual Interest Rate (Rate of Return), Interest Compounded, and Number of Periods/Years into the calculator. The calculator will compute the Future Values.
In this scenario you will start with a big deposit and see how interest, compounding, and time will change the balance over time. Suppose that you inherit $10,000 from your late uncle. You save this money and do not deposit any more money to the account. Determine how much money you would have at the end of each of the periods for each of the scenarios in the table below, assuming that you don’t make any withdrawals from the account over the period.
Enter your answers in the indicated cells of the table below:

 Annual Interest Rate Interest Compounded FV at the end of Year 5 FV at the end of Year 10 FV at the end of Year 30
2.00% Annually Answer: Answer: Answer:
2.00% Quarterly Answer: Answer: Answer:
8.00% Annually Answer: Answer: Answer:
8.00% Quarterly Answer: Answer: Answer:

4. Based on your calculations above, explain in your own words the impact of compounding interest.
<Write response here.>
Scenario 3: Cost of Credit / Opportunity Cost / Trade-Offs
 
5. In this scenario you will calculate the monthly payment and total interest paid on a car loan. Suppose that you need $15,000 to buy a used vehicle to get back and forth to work and school. You have $7,500 in a money market fund earning 1.00% per year, but you are not sure you want to use any or all of that money.
Using the tables in Exhibit 1-D, located on pp. 42-43 in the Ch. 1 Appendix of Focus on Personal Finance, determine the total amount of payment due at the end of each year, and divide by 12 to estimate the monthly payment for each of the following loan scenarios. Also, calculate the total amount of interest you would pay over the life of each loan. Be sure to show your work for opportunities to earn partial credit, where applicable.
For example, if you have the correct formula but put a decimal in the wrong spot you could earn partial credit. The first row in the table has been completed to demonstrate you how work can be shown.

Loan Amount Interest Rate Term Monthly Loan Payment = Amount Borrowed divided by “Table Factor in Exhibit 1-D” divided by 12 Total Amount of Interest = (Monthly Loan Payment * Term * 12) – Loan Amount
$7,500 6% 3 years Example:
7500/2.673=2,805.84
2,805.84/12= 233.82
Example:
(233.82*3*12) – 7,500= 917.52
$7,500 6% 5 years
$10,000 6% 5 years
$15,000 6% 5 years

 
6. Based on the above calculations, the price of the car, and the money available in a money market fund, which loan option would you suggest to someone purchasing a vehicle? Please explain the rationale and considerations for your decision.
<Write response here.>
7. In your own words, how would you summarize “opportunity cost”? How does the concept of opportunity cost apply to this decision? Explain in a brief paragraph.
<Write response here.>
Income Taxes
 
Each year you will need to file a federal income tax return by April 15th. While you may use software or a tax preparation professional to help you complete your return, there are still some terms of which you should have a basic understanding. Respond to the following to demonstrate your understanding. Each response should be at least 50 words.
8. Explain the differences between taxable income and adjusted gross income.
<Write response here.>
9. In your own words, define tax deduction, exemption, and tax credit.
<Write response here.>