Financial Tools problesm set

User Generated

synzrvfonpx

Business Finance

Description

Details:

Complete the following problems from Chapter 5 in Principles of Managerial Finance: Time Value of Money: P5-3; P5-5; P5-12; P5-13; P5-20; P5-24; P5-30; P5-36; P5-43; P5-48.

need to complete the problem-set assignment in this topic.MUST BE IN EXCEL, WITH FORMULA AND STEPS,PROBLEMS ATTACHED

Please show all work for each problem.

Unformatted Attachment Preview

P5–3 Future value You have $100 to invest. If you can earn 12% interest, about how long does it take for your $100 investment to grow to $200? Suppose that the interest rate is just half that, at 6%. At half the interest rate, does it take twice as long to double your money? Why or why not? How long does it take? P5–5 Time value You have $1,500 to invest today at 7% interest compounded annually. a. Find how much you will have accumulated in the account at the end of (1) 3 years, (2) 6 years, and (3) 9 years. b. Use your findings in part a to calculate the amount of interest earned in (1) the first 3 years (years 1 to 3), (2) the second 3 years (years 4 to 6), and (3) the third 3 years (years 7 to 9). c. Compare and contrast your findings in part b. Explain why the amount of interest earned increases in each succeeding 3-year period. P5–12 Present value concept Answer each of the following questions. a. What single investment made today, earning 12% annual interest, will be worth $6,000 at the end of 6 years? b. What is the present value of $6,000 to be received at the end of 6 years if the discount rate is 12%? c. What is the most you would pay today for a promise to repay you $6,000 at the end of 6 years if your opportunity cost is 12%? d. Compare, contrast, and discuss your findings in parts a through c. P5–13 Time value Jim Nance has been offered an investment that will pay him $500 three years from today. a. If his opportunity cost is 7% compounded annually, what value should he place on this opportunity today? b. What is the most he should pay to purchase this payment today? c. If Jim can purchase this investment for less than the amount calculated in part a, what does that imply about the rate of return that he will earn on the investment? P5–24 Funding your retirement You plan to retire in exactly 20 years. Your goal is to create a fund that will allow you to receive $20,000 at the end of each year for the 30 years between retirement and death (a psychic told you that you would die exactly 30 years after you retire). You know that you will be able to earn 11% per year during the 30-year retirement period. a. How large a fund will you need when you retire in 20 years to provide the 30-year, $20,000 retirement annuity? b. How much will you need today as a single amount to provide the fund calculated in part a if you earn only 9% per year during the 20 years preceding retirement? c. What effect would an increase in the rate you can earn both during and prior to retirement have on the values found in parts a and b? Explain. d. Now assume that you will earn 10% from now through the end of your retirement. You want to make 20 end-of-year deposits into your retirement account that will fund the 30-year stream of $20,000 annual annuity payments. How large do your annual deposits have to be? P5–36 Changing compounding frequency Using annual, semiannual, and quarterly compounding periods for each of the following, (1) calculate the future value if $5,000 is deposited initially, and (2) determine the effective annual rate (EAR). a. At 12% annual interest for 5 years. b. At 16% annual interest for 6 years. c. At 20% annual interest for 10 years. P5–43 Creating a retirement fund To supplement your planned retirement in exactly 42 years, you estimate that you need to accumulate $220,000 by the end of 42 years from today. You plan to make equal, annual, end-of-year deposits into an account paying 8% annual interest. a. How large must the annual deposits be to create the $220,000 fund by the end of 42 years? b. If you can afford to deposit only $600 per year into the account, how much will you have accumulated by the end of the forty-second year? P5–48 Loan amortization schedule Joan Messineo borrowed $15,000 at a 14% annual rate of interest to be repaid over 3 years. The loan is amortized into three equal, annual, end-of-year payments. a. Calculate the annual, end-of-year loan payment. b. Prepare a loan amortization schedule showing the interest and principal breakdown of each of the three loan payments. c. Explain why the interest portion of each payment declines with the passage of time.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hi there :)Please find the solutions attached.If you have any questions, please do not hesitate to ask; if all is clear, please review and rate the solutionAll the best

PV
FV

$100
$200

a)
Interest
Numer of Years

12%
6.12

Years

b)
Interest
Numer of Years

6%
11.90

Years

c)
Yes, it almost takes twice as long to double the money. This is
because under option b, you need more compounding periods so as
to be able to double the mooney.

PV
Interest

$1,500
7%

a)
1)
Periods
FV

3
$1,837.56

2)
Periods
FV

6
$2,251.10

3)
Periods
FV

9
$2,757.69

b)
Year
1
2
3
4
5
6
7
8
9

PV
$1,500
$1,605
$1,717
$1,838
$1,966
$2,104
$2,251
$2,409
$2,577

Interest
$105
$112
$120
$129
$138
$147
$158
$169
$180

Ending
$1,605.00
$1,717.35
$1,837.56
$1,966.19
$2,103.83
$2,251.10
$2,408.67
$2,577.28
$2,757.69

c)
Amount of interest increases because ...


Anonymous
I was struggling with this subject, and this helped me a ton!

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Content

Related Tags