Answer each of the following questions. Model each problem with input cells to allow for flexibility...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Answer each of the following questions. Model each problem with input cells to allow for flexibility in answering similar questions. Interest rates are stated as simple annual rates. 1. If you invest $1,000 in a bank account paying 1% interest (about what Ally pays right now), how much will you have in 5 years? a. What if interest is compounded quarterly instead of annually? b. What if interest is compounded monthly instead of annually? 2. If you invest $10,000 in the market and expect a 5% annual return, how long do you expect it to take for your account to grow to $25,000? 3. You want to withdrawal $10,000 per year for 10 years starting next year. How much do you need in your account today if you expect a 3% annual return? Assume you will end with $0 in your account. 4. You want to withdrawal $10,000 per year for 10 years starting in 11 years. How much do you need to have in your account today if you expect a 3% annual return? Assume you will end with $0 in your account. 5. You want to withdrawal $10,000 per year for 10 years starting in 11 years. You will start saving today, and will make deposits into your account for 9 more years (10 total deposits). At the start of the 11th year, you will take your first withdrawal. How much do you need to save each year if you expect a 3% annual return? Assume you will end with $0 in your account. Summary of Deliverables: 1. One-page, PDF print out of your Excel file answers to the questions. For each question, display your inputs and answers, and in a separate cell, display the formula used to calculate your answer. Use a single-quote (') in front of "=" to display the cell contents rather than the calculated answer. Provide your name and the date you printed the file in the header. Answer each of the following questions. Model each problem with input cells to allow for flexibility in answering similar questions. Interest rates are stated as simple annual rates. 1. If you invest $1,000 in a bank account paying 1% interest (about what Ally pays right now), how much will you have in 5 years? a. What if interest is compounded quarterly instead of annually? b. What if interest is compounded monthly instead of annually? 2. If you invest $10,000 in the market and expect a 5% annual return, how long do you expect it to take for your account to grow to $25,000? 3. You want to withdrawal $10,000 per year for 10 years starting next year. How much do you need in your account today if you expect a 3% annual return? Assume you will end with $0 in your account. 4. You want to withdrawal $10,000 per year for 10 years starting in 11 years. How much do you need to have in your account today if you expect a 3% annual return? Assume you will end with $0 in your account. 5. You want to withdrawal $10,000 per year for 10 years starting in 11 years. You will start saving today, and will make deposits into your account for 9 more years (10 total deposits). At the start of the 11th year, you will take your first withdrawal. How much do you need to save each year if you expect a 3% annual return? Assume you will end with $0 in your account. Summary of Deliverables: 1. One-page, PDF print out of your Excel file answers to the questions. For each question, display your inputs and answers, and in a separate cell, display the formula used to calculate your answer. Use a single-quote (') in front of "=" to display the cell contents rather than the calculated answer. Provide your name and the date you printed the file in the header.
Expert Answer:
Answer rating: 100% (QA)
Here are the answers to the investment questions with deeper stepbystep calculations shown inline 1 If you invest 1000 in a bank account paying 1 inte... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Queue class (15 marks) Implement the Queue class in the file queue.py. Your queue must be an array-based dynamic circular queue. You must use numpy arrays with object type elements for the underlying...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Calculate the following ratios for both 2021 and 2020 years: current ratio, quick ratio, debt to equity ratio, debt ratio, gross profit ratio, net profit ratio, return on equity, return on total...
-
As a second-year financial analyst for A.J. Straub Investments, you are performing an initial analysis on Fizer Pharmaceuticals. A difficulty you've encountered in making comparisons with its chief...
-
Colby Company, which uses the allowance method, has Accounts Receivable of $65,000 and an allowance for uncollectible accounts of $6,400 (credit). The company sold merchandise to Irma Hegerman for...
-
Farha Co. purchases a machine for $11,500, terms 2/10, n/60, FOB shipping point. The seller pre paid the $260 freight charges, adding the amount to the invoice and bringing its total to $11,760. The...
-
1. What barriers to effective communication do you detect in this case? 2. Is anyone wrong in this situation? By what other means could Randell have requested the information from Tom Ballard? What...
-
0 State what the shaded area represents. 0 1 0 O 0 1 0 O A. Total cost in dollars B. Rate of change of area OC. C. Total area in square feet D. Rate of change of price point(s) possible Cost (dollars...
-
Karen Samuels (Social Security number 123-45-6789) makes the following purchases and sales of stock: Assuming that Karen is unable to identify the particular lots that are sold with the original...
-
Explain who Justin Martyr was and what were his three main arguments regarding Greek philosophy and its relationship with Christianity (the theft/loan theory, the demon theory, and the logos theory)....
-
Jones Company, a reputable business entity, encounters a common accounting scenario involving accounts receivable and the allowance for bad debts. In this scenario, Jones initially wrote off $500 of...
-
Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. (PV of $1. FV of $1. PVA of $1, and EVA of...
-
A few years ago, Largo Industries implemented an inventory auditing system at an installed cost of $172,000. Since then, it has taken depreciation deductions totaling $122,120. What is the system's...
-
2. Write a program in Java to take an infix mathematical expression. The expression will contain single- or double-digit numbers, '+',"-", "*", ***, and operators, and parenthesis. First check the...
-
Consider a multiplicative binomial model with N = 3, r = 0, u = 1.2, d = 0.8 and S 0 = 100. At time t = 1 when S 1 = 120 a (european) call option with maturity at T = 3 and struck at 100 is quoted at...
-
FIRST ESSAY QUESTION: (20 points) You are the Vice President of Purchasing for Toys R Us. Perth Toys, Inc., a toy manufacturer from Perth, Australia with whom you have not had prior dealings sends...
-
The following processes constitute the air-standard Diesel cycle: 12: isentropic compression,23: constant-volume energy addition (T and P increase),34: constant-pressure energy addition (v...
-
Apple produces iMacs with a multiple production line. Identify and list some of its production processing steps and departments.
-
In December 2008, Dreamvision established its predetermined overhead rate for movies produced during year 2009 by using the following cost predictions: overhead costs, $1,700,000, and direct labor...
-
Explain how contribution margin analysis is useful for managerial decisions and performance evaluations.
-
How many months does it take to save $200,000.00 based on the information provided in this problem?---
-
What is the amount oi the credit to employee city income tax payable?
-
Milat is the total yearly gross pay for all employees?
Study smarter with the SolutionInn App