Foundations of Finance (9th Edition) (Pearson Series in Finance)
9th Edition
ISBN: 9780134083285
Author: Arthur J. Keown, John D. Martin, J. William Petty
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 34SP
Summary Introduction
To determine: The rate to be compounded annually
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
USE EXCEL TO SOLVE THE PROBLEM AND SHOW THE EXCEL FORMULA AS WELL!
You are hoping to buy a house in the future and recently received an inheritance of $20,000. You intend to use your inheritance as a down payment on your house.
a. If you put your inheritance in an account that earns a 7 percent interest rate compounded annually, how many years will it be before your inheritance grows to $30,000?
b. If you let your money grow for 10.25 years at 7 percent, how much will you have?
c. How long will it take your money to grow to $30,000 if you move it into an account that pays 3 percent compounded annually? How long will it take your money to grow to $30,000 if you move it into an account that pays 11 percent?
d. What does all of this tell you about the relationship among interest rates, time, and future sums?
Please put the solution in an excel spreadsheet to get the correct answer and please explain the steps for each formula in excel
You are offered the opportunity to put some money away for retirement. You will receive 10 annual payments of $5,000 each beginning in 26 years. If you desire an annual interest rate of 12% compounded monthly, answer the following two questions:
How much would you be willing to invest today?
How much would the money (that you will be willing to invest today) be worth at the end of your last payment (i.e., in year 35)?
Amount that you would be willing to invest today =
PV = $5,000/(1.01)26*12 + $5,000/(1.101)27*12 + $5,000/(1.01)28*12 + $5,000/(1.01)29*12 + $5,000/(1.01)30*12 + $5,000/(1.01)31*12 + $5,000/(1.01)32*12 + $5,000/(1.01)33*12 + $5,000/(1.01)34*12 + $5,000/(1.01)35*12
= $1,388.638
Amount that would the money worth at the end of your last payment =
FV = $1388.64 * (1+ 0.01)35*12
= $90691.52
Use a financial calculator or computer software program to answer the following questions:
Melanie is trying to save money for retirement and has a future goal of $750,000 at the end of 20 years. Determine the present value of her goal using a discount rate of 11%.
How would the present value change if the $750,000 is to be received at the end of 15 years instead? Explain the impact and show your work?
FV= PV(1+)^n
Chapter 5 Solutions
Foundations of Finance (9th Edition) (Pearson Series in Finance)
Ch. 5 - Prob. 1RQCh. 5 - The processes of discounting and compounding are...Ch. 5 - Prob. 3RQCh. 5 - Prob. 4RQCh. 5 - Prob. 5RQCh. 5 - Prob. 1SPCh. 5 - Prob. 2SPCh. 5 - Prob. 3SPCh. 5 - Prob. 4SPCh. 5 - (Compound value) Stanford Simmons, who recently...
Ch. 5 - (Future value) Sarah Wiggum would like to make a...Ch. 5 - Prob. 7SPCh. 5 - Prob. 8SPCh. 5 - Prob. 9SPCh. 5 - Prob. 10SPCh. 5 - Prob. 11SPCh. 5 - Prob. 13SPCh. 5 - Prob. 14SPCh. 5 - Prob. 15SPCh. 5 - Prob. 16SPCh. 5 - Prob. 17SPCh. 5 - Prob. 18SPCh. 5 - Prob. 19SPCh. 5 - Prob. 20SPCh. 5 - Prob. 21SPCh. 5 - Prob. 22SPCh. 5 - Prob. 23SPCh. 5 - (Solving for PMT of an annuity) To pay for your...Ch. 5 - Prob. 25SPCh. 5 - Prob. 26SPCh. 5 - (Loan amortization) On December 31, Beth Klemkosky...Ch. 5 - (Solving for r of an annuity) You lend a friend...Ch. 5 - Prob. 29SPCh. 5 - (Compound annuity) You plan on buying some...Ch. 5 - (Loan amortization) On December 31, Son-Nan Chen...Ch. 5 - (Loan amortization) To buy a new house you must...Ch. 5 - Prob. 33SPCh. 5 - Prob. 34SPCh. 5 - Prob. 35SPCh. 5 - Prob. 36SPCh. 5 - Prob. 37SPCh. 5 - (Compound interest uith nonannnal periods) a....Ch. 5 - (Compound interest with nonannual periods) After...Ch. 5 - Prob. 40SPCh. 5 - (Spreadsheet problem) To buy a new house you take...Ch. 5 - (Nonannual compounding using a calculator) Jesse...Ch. 5 - (Nonannual compounding using a calculator)...Ch. 5 - (Nonannual compounding using a calculator) Fords...Ch. 5 - Prob. 45SPCh. 5 - (Nonannual compounding using a calculator) Dennis...Ch. 5 - Prob. 47SPCh. 5 - (Calculating the effective annual rate) Youve just...Ch. 5 - Prob. 49SPCh. 5 - Prob. 50SPCh. 5 - (Present value) The Kumar Corporation is planning...Ch. 5 - (Perpetuities) What is the present value of the...Ch. 5 - (Complex present value) How much do you have to...Ch. 5 - (Complex present value) You would like to have...Ch. 5 - Prob. 55SPCh. 5 - Prob. 56SPCh. 5 - Prob. 57SPCh. 5 - Prob. 58SPCh. 5 - (Present value of a complex stream) Don Draper has...Ch. 5 - (Present value of a complex stream) Don Draper has...Ch. 5 - (Complex stream of cash flows) Roger Sterling has...Ch. 5 - (Future and present value using a calculator) In...Ch. 5 - Prob. 1MCCh. 5 - Prob. 2MCCh. 5 - Prob. 3MCCh. 5 - Prob. 4MCCh. 5 - Prob. 5MCCh. 5 - Prob. 6MCCh. 5 - Prob. 7MCCh. 5 - Prob. 8MCCh. 5 - Prob. 9MCCh. 5 - Prob. 10MCCh. 5 - Prob. 11MC
Knowledge Booster
Similar questions
- Please use question 3 and 4 to answer question 5. 3. It’s time to get a new laptop. The laptop is $2500. You decide to put money aside for it each month for one year. If you put the money in an account that earns 5%, how much will you have to save each month? 4. Instead of saving up, you decide to finance the laptop. What will your monthly payments be if you finance $2500 at 7% for 3 years? 5. What are the acquisition costs for questions 3 and 4? In other words, how much out of pocket will you pay to pay for the laptop?arrow_forwardSuppose you have three goals in your financial planning for saving money.First, you would like to be able to retire 25 years from now with a retirement income of $10,000 (today's dollar) per month for 20 years. Second, you would like to purchase a vacation home in Sedona in 10 years at an estimated cost of $500,000 (today's dollars). Third, assuming that you will live until your life expectancy, say 20 years after your retirement, you would like to leave a cash contribution to your college in the amount of $1,000,000 (actual dollars). You can afford to save $2,000 (actual dollars) per month for the next 10 years. Assume that the general inflation rate is 4% and the property value in Sedona increases at an annual rate of 5%. Your first retirement withdrawal will be made 25 years and 1 month from now. Before retirement, you would be able to invest your money at an annual rate of 10%. But after retirement, you will invest your assets in more conservative financial assets at an annual rate…arrow_forwardSuppose you have three goals in your financial planning for saving money. First, you would like lo be able to retire 25 years from now with a retirement income of $10,000 (today's dollar) per month for 20 years. Second, you would like to purchase a vacation home in Sedona in 10 years at an estimated cost of $500,000 (today's dollars). Third, assuming that you will live until your life expectancy, say 20 years after your retirement, you would like to leave a cash contribution to your college in the amount of $1,000,000 (actual dollars). You can afford to save $2,000 (actual dollars) per month for the next 10 years. Assume that the general inflation rate is 4% and the property value in Sedona increases at an annual rate of 5%. Your first retirement withdrawal will be made 25 years and 1 month from now. Before retirement, you would be able to invest your money at an annual rate of 10%. But after retirement, you will invest your assets in more conservative financial assets at an annual…arrow_forward
- 7. You plan to save every year and accumulate $150,000 in 6 years to make the down payment for your house. To achieve your financial goal, you plan to make a deposit of $20,000 per year into a bank account paying 6% annual interest. The first deposit will be made a year from today. a. Draw a timeline to visualize the problem. b. Can you achieve your financial goal? (Show your work to answer this question) c. If not, what is the minimum deposit you need to make per year in order to achive your goal? 8. You are pursuing a Bachelor's in Finance at a business school, and you will need $20,000 per year for the next 4 years to cover your college expenses. That is, you plan to withdraw $20,000 at the end each of the next 4 years, starting one year from today. To support your college education, your parents decide to make a deposit today into a bank account paying an 8% annual interest. This deposit should be sufficient to cover the four $20,000 withdrawals you will make over the next 4 years.…arrow_forward(Use Calculator or Formula Approach) Suppose you need $10,000 in one year for the down payment on a new car. If you can earn 7% annually, how much do you need to invest today?arrow_forwardYou estimate that you can save $9,000 by selling your home yourself rather than using a real estate agent. What would be the future value of that amount if invested for five years at 6 percent? I need help to use appropriate factor(s) from the tables provided when it comes to rounding the time value factor to 3 decimal places and final answer to 2 decimal places. Future value= ???arrow_forward
- You want to retire in 20 years. You currently have $200,000, and think you will need $1.5 million at retirement. What annual interest rate must you earn to reach your goal, assuming you don’t save any additional funds? What annual interest rate must you earn if you can contribute an additional $5,000 per year? What annual interest rate must you earn if you can contribute an additional $15,000 per year? You want to retire in 30 years. You currently have $500,000, and think you will need $2.5 million at retirement. What annual interest rate must you earn to reach your goal, assuming you don’t save any additional funds? What annual interest rate must you earn if you can contribute an additional $7,500 per year? What annual interest rate must you earn if you can contribute an additional $13,000 per year?arrow_forwardYou decide to make monthly payments into a retirement fund earning 4.75% compounded monthly. Note: Payments are made at the end of each period.arrow_forwardUse a financial calculator or computer software program to answer the following questions: Melanie is trying to save money for retirement and has a future goal of $750,000 at the end of 20 years. Determine the present value of her goal using a discount rate of 11%. How would the present value change if the $750,000 is to be received at the end of 15 years instead? Explain the impact and show your work?arrow_forward
- 1. You are 25, recently graduated, and have a job paying you $40000 a year. a) You want to take a trip to Rome next summer and want to save $4000 between now (January 1) and June 1 of next year (18 months). You have an account that will earn 6% annually. How much will you need to save every month to get to the desired amount? b) You think it might be a good time to buy a condo instead of renting. You want to borrow $140,000 at 3.7% for 30 years. What will your monthly payments be? c) You plan to take off two years of work starting in five years to complete your master's degree. If you want to have $37000 in an account that you can live off, how much do you have to put aside monthly now in an account paying 5% per year? d) You want to retire in 45 years with $1 million in the bank. You think you can get an average of 5.2% annually in an investment account. How much will you have to save every year to get to $1 million? e) If your million dollar account continues to earn 5.2% a year, how…arrow_forward3. It’s time to get a new laptop. The laptop is $2500. You decide to put money aside for it each month for one year. If you put the money in an account that earns 5%, how much will you have to save each month?arrow_forwardYou are saving for a new house. You place $40,000 into an investment account each year for five years. How much will you have after five years if the account earns (a) 3%, (b) 6%, or (c) 9% compounded annually? Note: Use tables, Excel, or a financial calculator. Round your answers to 2 decimal places. (FV of $1, PV of $1, FVA of $1, and PVA of $1)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegePfin (with Mindtap, 1 Term Printed Access Card) (...FinanceISBN:9780357033609Author:Randall Billingsley, Lawrence J. Gitman, Michael D. JoehnkPublisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Pfin (with Mindtap, 1 Term Printed Access Card) (...
Finance
ISBN:9780357033609
Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:Cengage Learning