Question: ( 1 ) You plan the following deposits into your bank account: $ 5 0 0 next year, $ 1 , 0 0 0 the

(1) You plan the following deposits into your bank account: $500 next year, $1,000 the following year and $2,000 the year after that. If you can earn an annual rate of return of 8%, what one-time deposit would you need to support the indicated withdrawals? Enter the rate, the cash flows and the answer in the indicated cells in column B. Be sure that all dollar figures in column B are displayed as positive values.
(2) If the withdrawals in Question 1 were deposits instead and you could earn 8% per year, what would your balance be immediately after your last deposit? Be sure that your answer is displayed as a positive value.
TVM MULTPLE UNEVEN value.
(4) If you wanted to make annual withdrawals of $100 over the next 15 years, earning 10% per year, what one-time deposit would you need to make today? Use the inputs from column B from question #3 and set this up so that your answer is displayed as a positive value.
TVM ANNUITY
PMT
YEARS
RATE
FVA
PVA
(Please solve these steps using excel because i need to enter in the correct formulas in the yellow boxes. Thank you so much)
(1) You plan the following deposits into your bank account: $500

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!

Q:

Procedure calculate(N): let ct = 0 for i in 1 .. N: a = random() # returns a uniform random number between 0 and 1 b = random() # returns a uniform random number between 0 and 1 if a*a + b b < 1: ct...

Q:

PROBLEM ( 1 - 4 ) ( 1 ) You plan the following deposits into your bank account : $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can 4 earn an annual...

Q:

PROBLEM ( 1 - 4 ) ( 1 ) You plan the following deposits into your bank account : $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can 4 earn an annual...

Q:

( 1 ) You plan the following deposits into your bank account: $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If 4 you can earn an annual rate of return of 8 %...

Q:

- ) You plan the following deposits into your bank account : $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can arn an annual rate of return of 8 % ,...

Q:

ROBLEM ( 1 - 4 ) You plan the following deposits into your bank account: $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can earn in annual rate of...

Q:

ROBLEM ( 1 - 4 ) You plan the following deposits into your bank account: $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can earn in annual rate of...

Q:

ROBLEM ( 1 - 4 ) You plan the following deposits into your bank account: $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can earn in annual rate of...

Q:

1 . You plan the following withdrawals from your bank account : $ 5 0 0 next year, $ 1 , 0 0 0 the following year and $ 2 , 0 0 0 the year after that. If you can earn an annual rate of return of 8 %...

Q:

Vincent makes the following deposits into his bank account: $1,500 in one year and $2,500 in 3 years. He also makes the following withdraws: $1,000 in 2 years and $2,000 in 4 years? How much is left...

Q:

Activity 2 . 1 D Equations of value Vincent makes the following deposits into his bank account: $ 1 , 5 0 0 in one year and $ 2 , 5 0 0 in 3 years. He also makes the following withdraws: $ 1 , 0 0 0...

Q:

Day 'n Nite currently has 25,000 shares of stock outstanding and no debt. The price per share is $20. The firm is considering borrowing funds at 8 percent interest and using the proceeds to...

Q:

Hamlet.com has requested that you prepare a partial balance sheet on December 31, 2012, from the following: Cash, $114,000; Petty Cash, $69; Accounts Receivable, $69,000; Bad Debts Expense, $50,000;...

Q:

Reflection strategies suggesting strategies for programme manager to improve the management of the resources in the South African public sector?. Provide 3 - 5 applicable strategies.

Q:

It is NOT important for NFP organizations to prepare cash budgets. True / False Product budgets and program budgets that present data differently and in some detail help to complement the operating...

Q:

The treasurer is the personal responsible for coordinating the preparation of the operating budgets. True / False Typical operating budgets include investment budgets, cash budgets and pro-forma...

Q:

The treasurer is the personal responsible for coordinating the preparation of the operating budgets. True / False Typical operating budgets include investment budgets, cash budgets and pro-forma...

Q:

A uniform magnetic field H oriented in Z-direction and an AC electric field E(t) = E(o)e perpendicular to H are applied on Cu metal. a- Write down the momentum equation. iot b- Suppose that E(o)=...

Q:

DBMS (database management system) Database management system, also known as DBMS (database management system), provides users with access to all data in an organization that can minimize problems....

Q:

English argues that we should NOT require labeling of genetically modified foods. Which of the following is his fundamental argument?

Q:

To what extent are you interested in, and able to contribute to social media-based interactions such as blogs, social networking sites, podcasts and so on that may provide information and ideas for...

Q:

What level of skills would you need to generate specific queries and reports from information management systems? How might you develop the skills you need? Who would be the best person to help with...

Q:

What information search skills do you need to identify and select appropriate documentary sources? How might you develop these?