Foundations Of Finance
10th Edition
ISBN: 9780134897264
Author: KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher: Pearson,
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 35SP
Summary Introduction
To determine: The rate to be compounded annually
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
You want to save up enough money to purchase a new computer, which costs $4,500. You currently have $4,000 in your bank account. If you can earn 8% per year by investing this money, how long will it take before you have enough money in your bank account to buy the new computer? _______years (keep at least two decimal places)
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?
. Suppose you want to buy a home after 3 years and you will need $15,000 for that. You open a savings account and deposit a lump sum amount of $2,000. You want to make a monthly payment at an interest rate of 4.5%. What should be the constant monthly payment you should make to reach the goal of $15,000 after 3 years? Explain in excel
Chapter 5 Solutions
Foundations Of 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 - Prob. 5SP
Ch. 5 - (Compound value) Stanford Simmons, who recently...Ch. 5 - (Future value) Sarah Wiggum would like to make a...Ch. 5 - Prob. 8SPCh. 5 - (Future value) Giancarlo Stanton hit 59 home runs...Ch. 5 - Prob. 10SPCh. 5 - Prob. 11SPCh. 5 - Prob. 12SPCh. 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 - Prob. 24SPCh. 5 - (Solving for PMT of an annuity) To pay for your...Ch. 5 - Prob. 26SPCh. 5 - Prob. 27SPCh. 5 - (Loan amortization) On December 31, Beth Klemkosky...Ch. 5 - (Solving for r of an annuity) You lend a friend...Ch. 5 - Prob. 30SPCh. 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. 34SPCh. 5 - Prob. 35SPCh. 5 - Prob. 36SPCh. 5 - Prob. 37SPCh. 5 - Prob. 38SPCh. 5 - (Compound interest uith nonannnal periods) a....Ch. 5 - (Compound interest with nonannual periods) After...Ch. 5 - Prob. 41SPCh. 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. 46SPCh. 5 - (Nonannual compounding using a calculator) Dennis...Ch. 5 - Prob. 48SPCh. 5 - (Calculating the effective annual rate) Youve just...Ch. 5 - Prob. 50SPCh. 5 - Prob. 51SPCh. 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. 56SPCh. 5 - Prob. 57SPCh. 5 - Prob. 58SPCh. 5 - Prob. 59SPCh. 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 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.52arrow_forwardYou need to save $200 000 by making monthly deposit of 100 for 6 years. How much interest must you earn in order to achieve this goal ? Could use excel to solve this and show the step ?arrow_forward7. 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
- The website is: http://www.moneychimp.com/calculator/calculator.htmarrow_forwardSolve each of the following questions using both pricing formulas and Excel. 3. You plan to retire in 35 years. At the end of each year, you plan on saving $15,000, and your bank pays you 2% annual interest. How much will you have saved by the time you retire?arrow_forwardYou 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_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 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_forward(Use Calculator or Formula Approach) Suppose you need $15,000 in 3 years . If you can earn 6% annually, how much do you need to invest today? If you could invest the money at 8%, would you have to invest more or less than at 6%? How much?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_forwardGeneral Accountingarrow_forwardYou estimate that you can save $3,900 by selling your home yourself rather than using a real estate agent. What would be the future value of that amount if invested for seven years at 5 percent? Use Exhibit 1-A. (Round FV factor to 3 decimal places to 2 decimal places.). Better if you use your calculator. and final answer Future valuearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Pfin (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