Question: How can I model this on excel? With the cash flow for each year You have $10,000 in savings. Assume you earn 2.5% compounded quarterly

How can I model this on excel? With the cash flow for each year

You have $10,000 in savings. Assume you earn 2.5% compounded quarterly on it for three years, then you earn 5% annually for the next two years, then you withdraw $1,000 to buy a new phone, then you earn 7% per year on the remaining balance for 10 more years.

a. How much savings will you have at the end of the entire time?

b. How much would you have had if you had not purchased the phone?

By hand, I've found for the first part the FV=21,405 and for the second part FV=23,372.

How can I display the FV for each year though?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Complete the following statements by fining in the blanks with either mora1 or "OOlllllOral" (e.g .. factual, scientific, legal): a. Whether or not dumping should be permitted is a ___ question. b....

1. Excel-finish the buy tab 2. Write-up- add recommendations, graphs, edit, and include NPV table. Case # 7 AMG, Inc. & Forsythe Solutions: Leave vs. Buy Decisions Case Study Recommendations Finance...

Hello please refer to part 4 from the question paper I have attached the past student work for your reference just have to follow the format if you feel comfortable with I have attached the necessary...

(1)Your firm has identified three potential investment projects. The projects and their cash flows are shown here (Project Cash Flow Today ($) Cash Flow in One Year ($)) A -10- 20 B 5 -5 C 20 -10...

1- Given the following cash flow payments: End of year KD 0 0 1 500 2 0 3 200 4 200 5 200 6 0 7 400 Assume that interest rate is effective per year and varies as follows: from 0 to 2, i = 10%, from 2...

( LN-2 concepts - part I) "You have been notified that you will be receiving an amount of $2,000 semi-annually for the next 2 years (end of period cash flows), which the first cash flow occurring 6...

You are a member of the investment committee for a large manufacturing company that two years ago licensed a new technology from a small start-up firm. Based largely on that technology, engineers in...

12. You have $10,000 in savings. Assume you earn 2.5% compounded quarterly on it for three years, then you earn 5% annually for the next two years, then you withdraw $1,000 to buy a new phone, then...

The risk free rate is 5%. Aquarius Corporation, Arizona-based manufac- turer of healing power crystals, has existing assets generating certain cash a?ows of $231 million next year. A new exciting...

A loader is being considered to tram material from a stockpile. The cost of the machine is estimated at $1,400,000 with an estimated salvage value of $425,000 at the end of year seven. Operating...

What type of database I/O operations will likely be used by the query?

4. What will the code in Figure 5-28 assign to the dblRate variable when the dblSales variable contains the number 1000? a. 0 b. 0.05 c. 0.1 d. 0.15

This question is related to a data called gapminder. This data is a part of a R package called "gapminder". To access the data install the library in your console, call the library and have a look...

62. The inverse supply equation for clay pots is P = 0.5Qs + 1; the inverse demand equation is P=-2Qp + 15. Quantity is in thousands of units. %3D What are the normal supply equation and the normal...

60. SCENARIO 3.2: Mustard and mayonnaise are substitutes. Mustard and relish are complements. Mustard is a normal good. During the summer, about 50% of all mustard was recalled by manufacturers and...

58. If the price per pizza is $6, there is a(n): excess demand of 300 units. O excess demand of 200 units. excess supply of 700 units excess supply of 1,000 units.

57. The figure above shows the demand for fruit snacks. Which movement reflects an increase in the price of a complement for fruit snacks? from point a point d O from point a to point e O from point...

REVIEW THE INFORMATION ABOUT LEAPFROG HOSPITAL SAFETY GRADES. CHOOSE TWO HOSPITALS TO COMPARE A VERY EFFECTIVE ONE AND ONE WHICH IS NOT EFFECTIVE. WHAT SEPARATES THE TWO? HOW CAN THE A HOSPITAL USE...

3. Imagine a real event that brought joy to your past. What images, sounds, emo-tions, smells and tastes appear? Try to imagine a movie clip of this incident, as it could unfold if the circumstances...

7. Imagine yourself in a future situation that you know you do not thrive in. Try to bring with you that feeling of satisfaction from task 6 in the future uncomfortable situation. a. Highlight three...

1. Maintain my own perspective and my opinions