Question

In: Finance

We would like to build an Excel model addressing the following situation: Kristy will open an...

We would like to build an Excel model addressing the following situation:

Kristy will open an investment account on September 1, 2020 at a bank. She plans on saving and depositing $300 into the account at the end of each month with first deposit on September 30, 2020. The account will earn 6 percent interest compounded monthly (i.e. she earns 6%/12=0.5% interest on deposits with the bank on any given month). Kristy is curious about how much would accumulate in her investment account after 20 years.

To help her with her financial planning you will prepare three graphs using the data table feature in Microsoft Excel:

  1. A graph showing how much would accumulate in the bank account after 1, 3, 5, 10, 20 (actual), or 30 years. Label the x-axis as time and y-axis of the graph as dollar amount accumulated in the bank account.
  2. A graph showing how much would accumulate in the bank account if annual interest rate were 4%, 6% (the actual), 8%, 10%, and 12% hypothetically. Label the x-axis of the graph as the interest rate and the y-axis as dollar amount accumulated in the bank account.
  3. A graph showing how much would accumulate in the bank account if deposits were to be $100, $200, $300 (actual), or $500 hypothetically.  Label the x-axis of the graph as the monthly deposit amount and the y-axis as dollar amount accumulated in the bank account.  

Solutions

Expert Solution


Related Solutions

1. We would like to obtain an estimator of β1 from the following regression model with...
1. We would like to obtain an estimator of β1 from the following regression model with only one independent regressor: yi =β0 +β1x1i +ui. (1) However, there is another variable x2i, which is missing from the model and poten- tially correlated with x1i. That is, the true model would be yi =β0 +β1x1i +β2x2i +vi (2) where vi is an observation error, which satisfies E (vi|x1i, x2i) = 0. (a) Show that the OLS estimator of β1 obtained from model...
A statistics professor would like to build a model relating student scores on the first test...
A statistics professor would like to build a model relating student scores on the first test to the scores on the second test. The test scores from a random sample of 2121 students who have previously taken the course are given in the table. Test Scores Student First Test Grade Second Test Grade 1 81 79 2 55 64 3 52 61 4 81 74 5 50 65 6 70 71 7 43 64 8 43 58 9 77 75...
A statistics professor would like to build a model relating student scores on the first test...
A statistics professor would like to build a model relating student scores on the first test to the scores on the second test. The test scores from a random sample of 2121 students who have previously taken the course are given in the table. Test Scores Student First Test Grade Second Test Grade 1 6767 7070 2 9797 8181 3 4242 6161 4 6969 7272 5 5656 6363 6 6666 7272 7 9999 9090 8 7979 7373 9 8888 7878...
We would like to have a simple model to describe how temperature changes with time in...
We would like to have a simple model to describe how temperature changes with time in your classroom during lecture in a typical day in Fall and Spring. You can consider two sets of average air temperature – one in October and other one in April for your analysis. Also, for simplicity, consider the entire room to be at one temperature T. Outside air (Ti,) comes in and reaches the temperature of the room through mixing, and this air leaves...
Complete the following table using the Excel functions like we did for homework: Hint: There is...
Complete the following table using the Excel functions like we did for homework: Hint: There is no function for calculating coupon payments. (Assume semi-annual coupon payments and the bond's par value is $1,000.) Bond Coupon Rate Yield to Maturity Periods to Maturity Annual Coupon Payment Current Bond Value Discount or Premium A 3.0% 5.0% 10 B 4.5% 4.0% 10 C 3.5% 6.0% 10 D 5.0% 5.0% 10 E 11.0% 10.0% 10
Build and present a menu to a user like the following and enclose it into a...
Build and present a menu to a user like the following and enclose it into a loop that ends when the Quit option is chosen. Scan the user's selection into an integer variable. 1. Enter user name. 2. Enter test scores. 3. Display average. 4. Display summary. 5. Quit. Selection: If the user selects Option #1, scan the user's name, and store it to a char array. Assume the user's name is under 20 characters. If the user selects Option...
Often we would like to make the user think we like him/her so we use a...
Often we would like to make the user think we like him/her so we use a friendly prompt to get them to decide if they want to continue a loop. One can make a sentinel using an integer value outside of the expected input range but a more delightful way is to ask politely if: System.out.println("Do you want to play again?); In order to do this we will need a scanner and a do-while loop. For the scanner sometimes the...
Provide an example of a logical excel function and describe a situation when we might use...
Provide an example of a logical excel function and describe a situation when we might use it in a spreadsheet. How can we work with spreadsheets that contain large numbers of rows and columns and not lose our place or get lost in what we’re looking at. Your main post should be at least 250-300 words long. -spreadsheet management.
Provide an example of a logical excel function and describe a situation when we might use...
Provide an example of a logical excel function and describe a situation when we might use it in a spreadsheet. How can we work with spreadsheets that contain large numbers of rows and columns and not lose our place or get lost in what we’re looking at. Your main post should be at least 250-300 words long. -spreadsheet management.
a. For your senior project, you would like to build a cyclotron that will accelerate protons...
a. For your senior project, you would like to build a cyclotron that will accelerate protons to 10% of the speed of light. The largest vacuum chamber you can find is 60 cm in diameter.What magnetic field strength will you need? b.What magnetic field strength will levitate the 2.0 g wire in the figure(Figure 1)? Assume that I = 1.9 A and d = 12 cm . c. The magnetic field strength at the north pole of a 2.0-cm-diameter, 8-cm-long...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT