a.
To calculate: the future value of lump sum of (a).
Concept Introduction:
b.
To calculate: the future value of lump sum of (b).
Concept Introduction: Time value of money is the concept of finance which calculates the effect of time over the value of money. As per this concept, the present value of a future amount is lower than the future value. The present value/ future value of an amount are calculated using the interest rate as discount rate.
c.
To calculate: the future value of lump sum of (c).
Concept Introduction: Time value of money is the concept of finance which calculates the effect of time over the value of money. As per this concept, the present value of a future amount is lower than the future value. The present value/ future value of an amount are calculated using the interest rate as discount rate.
Want to see the full answer?
Check out a sample textbook solutionChapter 1 Solutions
Personal Finance (MindTap Course List)
- Which is more valuable to you today--receiving $5,000 for each of the next 3 years OR receiving $15,000 in 3 years from now? Explain. (Be sure to discuss the concept of the "time value of money" when providing your explanation)arrow_forwardYou are a financial adviser working with a client who wants to retire in eight years. The client has a savings account with a local bank that pays 7 percent annual interest. The client wants to deposit an amount that will provide her with $1,001,000 when she retires. Currently, she has $300,400 in the account. (FV of $1, PV of $1, FVA of $1, and PVA of $1) Note: Use the appropriate factor(s) from the tables provided. Required: How much additional money should she deposit now to provide her with $1,001,000 when she retires? Note: Round your intermediate calculations and final answer to nearest whole dollar.arrow_forwardFind the required value for each problem. Show the formula used and the counts for each problem.1. Jane Morrison is planning to invest $ 25,000 today in a mutual fund that provides a yield of 8% compounded annually. What will the investment be worth in ten years? 2. Ramón Rivera is investing $ 7,500 in a CD from a bank that pays 6% interest compounded annually. How much will he have earned at the end of five years? 3. María Lebrón is considering an investment that pays 7.6% interest compounded annually. How much would she have to invest today if she expects this investment to bring her $ 25,000 in six years? 4. Elizabeth Terrier wants to accumulate $ 12,000 after 12 years. If the annual compound interest rate paid by her savings account is 9.25%, how much money would he have to deposit in her account today to reach her goal? 5. Carolina Carlo needs to decide whether she accepts a $ 17,000 bond today or waits two years and receives $ 20,100. The CAGR she could invest in is 6%. What…arrow_forward
- Hi There! I solved the problem below, but can you answer the question and put everything on an excel spreadsheet and show the formulas please for the questions below. 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 expect to receive two cash flows: $41,000 paid in 5 years and $61,500 paid in 10 years. You'll put the money into a savings account with an annual interest rate of 8%. What is the future value of the combined cash flows, in 15 years? Please Introduction and explanation without plagiarism please and use math tools plZarrow_forwardMelannie Bayless has purchased a business building for $331,000. She expects to receive the following cash flows over a 10-year period: Year 1: $43,000 Year 2: $58,500 Year 3-10: $89,000 What is the payback period for Melannie? Round your answer to one decimal place.fill in the blank What is the accounting rate of return? Enter your answer as a whole percentage value (for example, 16% should be entered as "16" in the answer box).fill in the blankarrow_forward
- PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS 1.-FUTURE VALUE. Miss Ruth Encarnación Plateros y Del Valle, has to pay off a debt at the end of year 6. Ruth Encarnación will receive a flow of 35,000.00 per year, at the end of each period. She wants to know the amount equivalent to the future value of this series of 6 flows, considering a capitalization rate of 9%.arrow_forwardPlease 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_forwardSolve the following problems. You must show all your solutions -Draw the cash flow diagram for each problem -use interest rate with five decimal places. -Box your final answer and upload the picture of your complete solution. 1. A woman is considering giving a quarterly endowment to a university in order to provide payments of P5,000 and decreasing by 4% at the end of each quarter during a year. If the interest rate is 10% compounded monthly, what is the capitalized equivalent that must be deposited now so that the bimonthly payment can be repeated forever?arrow_forward
- For each requirement, change the values of the given information as shown and keep all other original data the same. Then enter your updated final answers for each scenario. Scenario A: Future value to be received $ 10,000 Future date received 3 years Discount Rate 6% 10% 16% Scenario B: Annual Cash Receipt $ 5,000 Number of Years 6 years Discount Rate 6% 10% 16% Scenario C: Discount Rate 8% Investment Project Cash Flow Initial Investment $ (6,500) Year 1 $ 700 Year 2 $ 800 Year 3 $ 1,400 Year 4 $ 3,600 Year 5 $ 6,800 Required: a. A company is expecting to receive a lump sum of money at a future date from now. Using the PV formula in Excel, what is the Present Value of that money at three different rates? (Round your answers to 2 decimal places.)arrow_forwardJuliana is considering an investment proposal with the following cash flows: Initial investment-depreciable assets $55,000 Net cash inflows from operations (per year for 10 years) 11,000 Disinvestment 0 a. Determine the payback period. Round your answer to one decimal place; for example, enter 1.4 for 1.44 or 1.5 for 1.45. Answer years For parts b. and c., round your answers to three decimal places if applicable. For example, enter 0.084 for 0.0844 or 0.085 for 0.0845. b. Determine the accounting rate of return on initial investment. Answer c. Determine the accounting rate of return on average investment.arrow_forwardAlan Kaminski just received a signing bonus of $ 1,600,000. His plan is to invest this payment in a fund that will earn 10%, compounded annually. (For calculation purposes, use 5 decimal places as displayed in the factor table provided.)Click here to view the factor table. https://education.wiley.com/content/Kieso_Intermediate_Accounting_17e/media/simulations/interest_rate_tables.pdfarrow_forward
- Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning