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

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

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