Calculate the future value at the end

Assignment Help Corporate Finance
Reference no: EM132270137

Question 1: Future values For each of the cases shown in the following table, calculate the fu-fire value of the single cash flow deposited today at the end of the deposit period if the interest is compounded annually at the rate specified.

Case

Single cash flow

Interest rate

Deposit period (years)

A

$200

5%

20

B

4,500 8 7

C

10,000 9 10

D

25,000 10 12

E

37,000 11 5

F

40,000 12 9

Question 2: Present values For each of the cases shown in the following table, calculate the pres¬ent value of the cash flow, discounting at the rate given and assuming that the cash flow is received at the end of the period noted.

Case

Single cash flow

Discount rate

End of period (years)

A

87,000 12% 4

B

28,000 8 20

C

10,000 14 12

D

150,000 11 6

E

45,000 20 8

Personal Finance Problem

Question 3: Retirement planning

Hal Thomas, a 25-year-old college graduate, wishes to retire at age 65. To supplement other sources of retirement income, he can deposit $2,000 each year into a tax-deferred individual retirement arrangement (IRA). The IRA will earn a 10% return over the next 40 years.

a. If Hal makes annual end-of-year $2,000 deposits into the IRA, how much will he have accumulated by the end of his sixty-fifth year?

b. If Hal decides to wait until age 35 to begin making annual end-of-year $2,000 deposits into the IRA, how much will he have accumulated by the end of his sixty-fifth year?

c. Using your findings in parts a and b, discuss the impact of delaying making deposits into the IRA for 10 years (age 25 to age 35) on the amount accumulated by the end of Hal's sixty-fifth year.

d. Rework parts a, b, and c, assuming that Hal makes all deposits at the beginning, rather than the end, of each year. Discuss the effect of beginning-of-year deposits on the future value accumulated by the end of Hal's sixty-fifth year.

Question 4:

Compounding frequency, time value, and effective annual rates For each of the cases in the following table:

a. Calculate the future value at the end of the specified deposit period.
b. Determine the effective annual rate, EAR.
c. Compare the nominal annual rate, r, to the effective annual rate, EAR. What relationship exists between compounding frequency and the nominal and effective annual rates?


Amount of initial deposit

Nominal annual rate, r

Compounding
frequency, m

Deposit
period

Case

 

 

(times/year)

(years)

A $ 2,500 6%

2

5
B 50,000 12

6

3
C 1,000 5

1

10
D 20,000 16

4

6

Question 5: Rate of return and investment choice

Clare Jaccard has $5,000 to invest. Because she is only 2S years old, she is not concerned about the length of the investment's life. What she is sensitive to is the rate of return she will earn on the investment. With the help of her financial advisor, Clare has isolated four equally risky investments, each providing a single amount at the end of its life, as shown in the following table. All the investments require an initial $5,000 payment.

Investment Single amount  Investment life (years) 
A $8,400 6
B 15,900 15
C 7,600 4
D 13,000 10

a. Calculate, to the nearest 1%, the rate of return on each of the four investments available to Clare.

b. Which investment would you recommend to Clare, given her goal of maximizing the rate of return?

Attachment:- homework assignment template.rar

Verified Expert

Thomas will be in loss of $556,197 in case of delays the deposit by 10 years for receiving the accumulated fund at his 65th birthday on payment at ending of the period. If he deposits at the beginning of each year he will be in loss of $611,817. Clare should choose investment C as it will provide the maximum rate of return 38% which is much higher than other options. The compounding frequency has a significant impact on the effective interest rate by considering the nominal interest rate because an increase in the frequency will result in an increase in the effective interest rate.

Reference no: EM132270137

Questions Cloud

Briefly describe cyberbullying-what is cyberbullying : Where is cyberbullying occurring? Do the victims of cyberbullying experience it more at home or school? Why?
What is a python function that finds : What is a python function that finds the 10 most frequently occurring words of a text that are not stopwords?
Write reflection paper for the given chapters : However, many students find a brief summary before they begin their reflections to be helpful. If this is the case with you then you may opt in for an optional.
Role of regulations and acts : All efforts are put in place to help enhance the security of information assets. There are many Regulations, government acts, industry best practices
Calculate the future value at the end : Calculate, to the nearest 1%, the rate of return on each of the four investments available to Clare - Which investment would you recommend to Clare
Identify 3 three difference network monitoring tools : Which one will your recommended for your business and which one will you personally use to protect your home office network.
Intro to information systems : 1. List all courses that have "Intro to Information Systems" as prerequisite (HINT: use a subquery)
Associated with a cloud-based solution for the business : Show the costs associated with a cloud-based solution for the business? Outline the benefits associated with a cloud-based solution for the business?
Provider based on the functions of the business : Explain new risks associated with using cloud services based on the functions of the business? (detailed answer please)

Reviews

len2270137

3/30/2019 12:54:06 AM

I need assistance with the assignment problems in the attached files. please use the attached spread sheet template. Use the In addition, the Time Value of Money Spreadsheet Calculations Lecture for the spreadsheet file is attached if needed.

len2270137

3/30/2019 12:53:29 AM

. If you just input 13,000 in the cell C3, then that is not showing your work. There are some answer cells during the course where there is no data to input. You will just need to input a date or type in a word for your answer. You will also need to use the correct built-in Excel formulas in Excel when warranted. Be sure to go over the “Excel Example” file It will help you if you have never used a built-in formula in Excel. Note that simple math such as adding, subtracting, etc. are not considered built-in formulas.

len2270137

3/30/2019 12:53:21 AM

Please use the excel template included in the attachment Be sure to show your work in the blank gray Excel cells when warranted. Most of them will require you to use inputs to derive the answer. For example, if cell A1 contains 5,000 and cell B2 contains 8,000 and you need to add them together in cell C3, then in the cell C3 you would input the following: =A1+B2. Then push enter. When I click on the cell C3 I will see the you used the correct formula and cell locations (that contains the correct data) to derive your answer.

Write a Review

Corporate Finance Questions & Answers

  1 in late 2000 lucent announced that revenues would be

1. in late 2000 lucent announced that revenues would be adjusted downwards by 679 million as a result of revenue

  How does your list compare to the other groups lists

Make a list of all the suggestions, and then share your list with the other groups.- How does your list compare to the other groups' lists?

  Prepare a simple balance sheet of assets and liabilities

Prepare a simple balance sheet of assets and liabilities for Banc One immediately after the deposit is received. What will be the system's money supply?

  Examine the benefits of using sensitivity analysis

Examine the benefits of using sensitivity analysis in evaluating the projects for Johnson Controls and how this approach can provide a competitive advantage for the company.

  Overheads efficiency ratio cost reduction target - multiple

overheads efficiency ratio cost reduction target - multiple choice1.nbsp tayla industries has total budgeted fixed over

  Find the expected return of the stock

Global Pistons has common stocks with a market value of $200 million and debt with a value of $100 million. Investors expect 15 percent return on the stock and 6% return on the debt.

  Calculate your total percentage return

Calculate your total dollar return and calculate your total percentage return - Estimate the expected return on stocks and explain how and why you arrived at your answer.

  1 ethical standardsa can a multinational firm adopt varying

1. ethical standardsa. can a multinational firm adopt varying ethical standards such as with regard to product safety

  Propose overall strategy to build effective business model

FIN510- Propose one overall strategy to build an effective business model in order to both monitor / control changes in business process and predict future business performance for your company.

  Construct firms pro forma income statement and balance sheet

Based on the historical statements and the additional information provided, construct the firm's pro forma income statement and balance sheet for 2014.

  What is the address of the companys corporate headquarters

What is the address of the company's corporate headquarters? What is the address of the company's Web site? List other countries in which the company operates: What were the company's revenues for the most recent fiscal year?

  What trading strategy in the stock and the bond today

Consider a European put option which expires in one year and has a strike price of X = 48. What trading strategy in the stock and the bond today

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd