Assume that you have $10,000,000 in your bank account. You wish to withdraw $400,000 per year, at the end of each year, for the next 5 years, after which you wish to have $11,000,000 in the bank. What is the balance in your account after the 2nd year (after the withdrawal)? Hint: you will need first to solve for rate in Excel given all other parameters. Watch signs. Select one: a. $10,366,644 b. $10,600,000 c. $9,600,000 d. $10,488,912

Assume that you have $10,000,000 in your bank account. You wish to withdraw $400,000 per year, at the end of each year, for the next 5 years, after which you wish to have $11,000,000 in the bank. What is the balance in your account after the 2nd year (after the withdrawal)? Hint: you will need first to solve for rate in Excel given all other parameters. Watch signs. Select one: a. $10,366,644 b. $10,600,000 c. $9,600,000 d. $10,488,912

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 3PA: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
You plan to deposit $700 in a bank account now and $200 at the end of one year. If the account earns 3% interest per year, what will the balance be in the account right after you make the second deposit? There will be $ in the account right after the second deposit. (Type an integer or a decimal.) w an example .... Get more help. Save Clear all In
You open an account where you deposit $500 today. Further, you deposit $800 at the beginning of next year, withdraw $250 at the beginning of year two and deposit $450 at the beginning of year 3. The return for year 1 is 6%, for year 2 it is -8%, for year 3 it is 4.5% and for year 4 it is -2%. What is your dollar-weighted or money-weighted return (in percent) for the four-year period? Answer to two decimals. O -1.45 -6.95 -11.92
For the following economic calculations, write the factors (multipliers) that should be used,in (i) using the parameter values, and in (ii) calculate the result by showing your computations. Write the results you find in the spaces left. (Use factors for your calculations.)EXAMPLE: If you deposit $ 100 to a bank account that earns 8% annual interest, how much money will you have in this account after five years?(i)(F/P, 8%, 5) (ii)146.93100 * (F/P, 8%, 5) = 100 * 1.4693 = 146.93 TLa. You plan to take a credit with $1500 installment size per year with an annual interest rate of 8% over six years from a bank. What is the amount of your current credit?(i) (ii)b. A bank is required to deposit money for four years with an interest rate 10%. The money deposited at the end of the first year is 6000 TL and the amount of money deposited in the next three years will be reduced by 500 TL every year. How much money will be in the bank at the end of the fourth year?(i) (ii)
Please provide the steps to solving this problem using a financial calculator: You just opened a brokerage account, depositing $3,500. You expect the account to earn an interest rate of 9.652%. You also plan on depositing $4,500 at the end of years 5 through 10. What will be the value of the account at the end of 20 years, assuming you earn your expected rate of return?
There is an investor stating they will pay out $84,000 at the end of 4 years. In order to invest into the opportunity, you'll need to make a deposit of $10,000 to thier indicated bank account. What is the average annaul return rate. Use excel functions to indicate your steps.
One can solve for payments (PMT), periods (N), and interest rates (1) for annuities. The easiest way to solve for these variables is with a financial calculator or a spreadsheet. Quantitative Problem 1: You plan to deposit $2,100 per year for 4 years into a money market account with an annual return of 3%. You plan to make your first deposit one year from today. a. What amount will be in your account at the end of 4 years? Do not round intermediate calculations. Round your answer to the nearest cent. $ b. Assume that your deposits will begin today. What amount will be in your account after 4 years? Do not round intermediate calculations. Round your answer to the nearest cent. $ Quantitative Problem 2: You and your wife are making plans for retirement. You plan on living 25 years after you retire and would like to have $95,000 annually on which to live. Your first withdrawal will be made one year after you retire and you anticipate that your retirement account will earn 12% annually. a.…
You are currently investing your money in a bank account which has a nominal annual rate of 7 percent, compounded monthly. How many years will it take for you to double your money? m Nper (or N) =n*m Rate (or I/Y)=i/m PV PMT FV Must identify variables and use excel
Do the relevant calculations so you can indicate which you prefer: a bank account that pays 5.8% per year (EAR) for 3 years or a. an account that pays 2.6% every 6 months for 3 years? b. an account that pays 7.6% every 18 months for 3 years? c. an account that pays 0.58% per month for 3 years? (Note: Compare your current bank EAR with each of the three alternative accounts. Be careful not to round any intermediate steps less than six decimal places.) If you deposit $1 into a bank account that pays 5.8% per year for three years, the amount you will receive after three years is $ (Round to five decimal places.)
4. How much should you deposit in an account so that you can withdraw $5300 every year for the next 18 years. Interest rate is 6%. Please do not use excel. Also, include cashflow diagram if possible.
You are currently investing your money in a bank account which has a nominal annual rate of 7 percent, compounded monthly. How many years will it take for you to double your money? m Nper (or N) =n*m Rate (or I/Y)=i/m PV PMT FV Identify variables and use excel
Please indicate what you entered into your calculator to solve these problems. 1. You graduated with $28,000 in school loans. You will make annual payments of $4,000 at the beginning of each year for the next 10 years. What annual rate of interest are you being charged on your school loans? 2. You bought equipment for $23,000 and agreed to make monthly payments at the end of each quarter for 5 years. Assuming you are being charged 9% interest compounded QUARTERLY, how much will your QUARTERLY payments be? 3. You currently have $750,000 in your building fund. If you start depositing an additional $20,000 per year into this account at the beginning of each year, how much will be in the account after 6 years assuming 5.5% interest compounded annually? 4. You want to start saving for a new car and have decided to put S$90 per month at the beginning of each month into an account which earns 6% compounded monthly. You would like to be able to buy a car for $25,000. (a) How many deposits will…