Allen wants to open a savings account. He will transfer $40,000 from another account to the...

Allen wants to open a savings account. He will transfer $40,000 from another account to the savings account today. After that, he will deposit $1,000 every month to the savings account. If the annual interest rate is 3.2%, what will be the account balance in his savings account after 5 years?

	a.	$112,653.52
	b.	$123,877.44
	c.	$123,877.23
	d.	$111,903.31

how would this be solved using finance functions in excel?

Expert Solution

CELL REFERENCE ALSO PROVIDED FOR EASY UNDERSTANDING

jeff jeffy answered 3 weeks ago

Lila Gibbons decides to open a retirement savings account today and she wants to make equal...

Lila Gibbons decides to open a retirement savings account today and she wants to make equal payments every month for the next 9 years. She anticipates she can earn 5.20% on the account which compounds monthly and would like to have $110,000 at the end of the 9 years. To achieve her goals, the payments should be closest to: A. $800.87. B. $797.42. C. $824.50.

Jacob decides to open a savings account while he is in college. His bank offers him...

Jacob decides to open a savings account while he is in college. His bank offers him an account that earns 1.10% APR compounded monthly. If he opens the account with $600 and deposits $150 every month until he graduates in four years, how much money will he have in his account? $8,370.08 $7,984.28 $29,585.95 $7,800 5 points QUESTION 12 Lauren is purchasing a house for $175,000. Her bank gives her a 30 year loan with an APR of 4.25%....

1. John has started a new job and wants to open a retirement account. He is...

1. John has started a new job and wants to open a retirement account. He is now 26 years old and plans to retire if he is over 65. For this, he is considering depositing $ 2815 retirement accounts annually. Annual interest yield is 2%. a. How much money will he save when he retires? Calculate by drawing a cash flow diagram. b. If John wanted to save $ 150,000, how much money would he have to deposit into his...

Jason and Sarah Allen invested $7,200 in a savings account paying 6% annual interest when their...

Jason and Sarah Allen invested $7,200 in a savings account paying 6% annual interest when their daughter, Angela, was born. They also deposited $1,100 on each of her birthdays until she was 16 (including her 16th birthday). Click here to view the factor table 1. Table 2 Table 3 Table 4 How much was in the savings account on her 16th birthday (after the last deposit)? (For calculation purposes, use 5 decimal places as displayed in the factor table provided,...

Charlie wants to retire in 15 years, and he wants to have an annuity of $40,000...

Charlie wants to retire in 15 years, and he wants to have an annuity of $40,000 a year for 20 years after retirement. Charlie wants to receive the first annuity payment at the end of the year during his retirement period. Using an interest rate of 5% for both savings and retirement periods, how much must Charlie invest today in order to have his retirement annuity? (Round your answer to the nearest dollar).

Mr Allen is selling 5 sets of western food in restaurant. He wants to build a...

Mr Allen is selling 5 sets of western food in restaurant. He wants to build a food ordering system. So if the system has added 5 sets of western food inside the text file, how to use search function to search the foods from the text file by using(( JAVA )) and display it ?

Suppose you open today (year 0) a savings account with $5,000; the account earns an interest...

Suppose you open today (year 0) a savings account with $5,000; the account earns an interest of 3% APR annually. At the end of year 2 you deposit an additional $5,000 in the savings account, and then at the end of year 7 you deposit another $5,000 in the account. There is a total of 3 deposits made so far. If you did not make any withdrawals or additional deposits, then approximately what is the balance (FV) in the account...

Harry has inherited $50,000 from his parents, and he wants to open a business with that....

Harry has inherited $50,000 from his parents, and he wants to open a business with that. Which form of business organization would you recommend? What are the consequences for Harry if the business fails? a) He wants to open a small restaurant. It needs $100,000 investment, and Harry can borrow $50,000 from a local bank. b) He wants to open a restaurant. It needs $200,000 investment, and Harry can borrow only $50,000. His brother, Ryan, is interested in investing in...

ABC wants to have $20,000 in a savings account four years from now. What amount must...

ABC wants to have $20,000 in a savings account four years from now. What amount must ABC deposit into an account today if the account will earn 10% interest, and interest is compounded semiannually? Present Value of $1 Periods 5% 6% 8% 10% 4 0.823 0.792 0.735 0.683 5 0.784 0.747 0.681 0.621 6 0.746 0.705 0.630 0.564 7 0.711 0.665 0.583 0.513 8 0.677 0.627 0.540 0.467 9 0.645 0.592 0.500 0.424 10 0.614 0.558 0.463 0.386 Present Value...

Demarcus wants to retire with 1 million in savings by the time he turns 65 he...

Demarcus wants to retire with 1 million in savings by the time he turns 65 he is currently 18 years old how much will he need to save each year assuming that he can get 12% annual return on his investment

Question