TVM with Excel Assignment: There are two major goals for this assignment: (1) to demonstrate your...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
TVM with Excel Assignment: There are two major goals for this assignment: (1) to demonstrate your understanding and the correct application of Time Value of Money concepts in a financial problem solving situation, and (2) to demonstrate your ability to use the TVM functions of Excel. This is intended to be a short assignment - solving the problem shouldn't take more than 30-45 minutes, plus a little more perhaps to make it look nice. When Yvonne was twelve, her grandfather gave her $5,000 to be used for college. Yvonne was a good student and dreamed of going to a good school so she invested the gift in a 10-year bank CD earning 7%. She received a generous scholarship and never needed to use the money from her grandfather. After graduating from college at age 22, she began working at a great job. Knowing the value of early investing, she began saving for retirement right away. When the CD matured she put it into an investment account earning 6%% and made an additional annual investment of $1,500 every January 1st. She also opened an IRA account and put $2,000 into it every year on January 1st and over the years it earned a steady 7%. Now Yvonne is 45 and thinking she'd like to retire early at age 55. At age 65 she'll get an extremely generous corporate pension, which along with Social Security payments will allow her to live very well indeed. She believes that with clever investing strategies both of her accounts will be able to earn 8%. She plans to continue making the same annual contributions to her accounts until retirement. What Yvonne wants to know is whether her retirement savings will be able to provide enough income each year to allow her to live comfortably until age 65 when the pension kicks in. 1. How much was the CD worth when she transferred it into that investment account? 2. How much is the investment account worth now? 3. How much is the IRA account worth now? 4. How much will she have accumulated when she takes early retirement? 5. How much will she be able to withdraw each January 1st if she takes early retirement? Guidelines: 1. Number and briefly explain each of your steps 2. Show your inputs for each step using the TVM functions of Excel, not the financial calculator 3. Laying out your solution using a timeline may help you visualize the cash flows better 4. Follow the facts as given in the narrative, but list any additional assumptions you make 5. Complete the solution using Excel (.xls or .xlsx) - no other software/file format is acceptable 6. Upload your solution file through the assignment link 7. I must be able to easily follow and replicate your work-points off if I have to struggle with it TVM with Excel Assignment: There are two major goals for this assignment: (1) to demonstrate your understanding and the correct application of Time Value of Money concepts in a financial problem solving situation, and (2) to demonstrate your ability to use the TVM functions of Excel. This is intended to be a short assignment - solving the problem shouldn't take more than 30-45 minutes, plus a little more perhaps to make it look nice. When Yvonne was twelve, her grandfather gave her $5,000 to be used for college. Yvonne was a good student and dreamed of going to a good school so she invested the gift in a 10-year bank CD earning 7%. She received a generous scholarship and never needed to use the money from her grandfather. After graduating from college at age 22, she began working at a great job. Knowing the value of early investing, she began saving for retirement right away. When the CD matured she put it into an investment account earning 6%% and made an additional annual investment of $1,500 every January 1st. She also opened an IRA account and put $2,000 into it every year on January 1st and over the years it earned a steady 7%. Now Yvonne is 45 and thinking she'd like to retire early at age 55. At age 65 she'll get an extremely generous corporate pension, which along with Social Security payments will allow her to live very well indeed. She believes that with clever investing strategies both of her accounts will be able to earn 8%. She plans to continue making the same annual contributions to her accounts until retirement. What Yvonne wants to know is whether her retirement savings will be able to provide enough income each year to allow her to live comfortably until age 65 when the pension kicks in. 1. How much was the CD worth when she transferred it into that investment account? 2. How much is the investment account worth now? 3. How much is the IRA account worth now? 4. How much will she have accumulated when she takes early retirement? 5. How much will she be able to withdraw each January 1st if she takes early retirement? Guidelines: 1. Number and briefly explain each of your steps 2. Show your inputs for each step using the TVM functions of Excel, not the financial calculator 3. Laying out your solution using a timeline may help you visualize the cash flows better 4. Follow the facts as given in the narrative, but list any additional assumptions you make 5. Complete the solution using Excel (.xls or .xlsx) - no other software/file format is acceptable 6. Upload your solution file through the assignment link 7. I must be able to easily follow and replicate your work-points off if I have to struggle with it
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Can you provide an example of when you led a previous organization through a major operational change? Did you encounter any obstacles and how did you motivate and guide your team through these...
-
Repeat Problem 11.9 for an m-step backward predictor.
-
Devise a graph in which at some step the maximal flow algorithm will reduce the flow along a reverse edge.
-
Northeast Servotech Corporation, which offers services to the computer industry, has expanded rapidly in recent years. Because of its profitability, the company has been able to grow without...
-
With this case, a comparison is made between three firms in different industries using net profit margin, total asset turnover, and current ratio. 1. Apple Fiscal Year Ended September 26, 2009 The...
-
A private not - for - profit entity is working to create a cure for a deadly disease. The charity starts the year with one asset, cash of $ 7 0 0 , 0 0 0 . Net assets without donor restrictions are $...
-
13. Southern Manufacturing makes snow blowing Equipment for residential and professional use. The CEO has asked you to evaluate the performance of each product line. Data for the past year is as...
-
The two sides of a V-shaped water trough are hinged to each other at the bottom where they meet, as shown in the figure, making an angle of 45 with the ground from both sides. Each side is 0.35 m...
-
Given the functions, f(x) = x-6 x-8 and g(x) = x - 3, find the following domains. Use interval notation. help (intervals) Domain of f(g(x)) Domain of g(f(x))
-
6. Beam AB supports two different shape of loading as shown in fig. below. The following equations have been derived from moment calculation. M=wl.x-x 0 x 1 Mwix-wix +(x-15x521 If 1-3m and w=5kN/m,...
-
Near the Normandy coast of northern France, the village of Bayeux houses a remarkable treasure. The Bayeux Tapestry may be found in its own museum in the former Great Seminary of Bayeux. Also known...
-
2. Which of the four rectangular barges having dimensions of length, width, and height is the most economical to use for ferrying cargoes with a total mass of 5,000 kg? a. 4mx2mx 1.2m b. 4mx2mx1m c....
-
subject is Combinations and Permutations 1. A middle school basketball team plays 20 games during the season. In how many ways can it end the season with ten wins, nine loses and one tie? 2. If 9...
-
In the series connection below, what are the respective power consumptions of R, R2, and R3? R R www 4 V=6V P1-3 W; P2=3W; and P3= 3 W OP10.5 W; P2-1 W; and P3= 1.5 W P1=1.5 W; P2=1 W; and P3= 0.5 W...
-
(NPV and IRR) You are offered the following project: a. What is the NPV of the project at a discount rate r = 6%? b. Do you want to invest in the project at r = 6%? c. Would you change your mind if r...
-
Accounting for Notes Receivable-Honoured and Dishonoured} Yarnell Electronics sells computer systems to small businesses and has a December 31 year-end. Yarnell engaged in the following activities...
-
(NPV and IRR) You are considering a project whose cash flows are given below: a. Calculate the present value of the future cash flows of the project. b. Calculate the projects net present value. c....
Study smarter with the SolutionInn App