You plan to spend $400 to buy a new IPAD at the beginning of year3 and $1,000 to buy a new phone at the End of year 6. By using excel, please calculate how much you need to save in each year? Suppose you deposit in the beginning of each year. Suppose your last deposit is at the beginning of year 6. Interest rate is 8%. Answers should be rounded to the 2nd decimal place.

You plan to spend $400 to buy a new IPAD at the beginning of year3 and $1,000 to buy a new phone at the End of year 6. By using excel, please calculate how much you need to save in each year? Suppose you deposit in the beginning of each year. Suppose your last deposit is at the beginning of year 6. Interest rate is 8%. Answers should be rounded to the 2nd decimal place.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

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

See similar textbooks

Similar questions

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
Suppose you want to have $400,000 for retirement in 10 years. Your account earns 9% interest. Feel free to use the Online Basic Financial Calculator a) How much would you need to deposit in the account each month? S b) How much interest will you earn? S
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…
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 put $250 in the bank for 5 years at 12% a. if interest is added at the end of the year, how much will you have in the bank after one year? Calculate the amount you will have in the bank at the end of year two and continue to calculate all the way to the end of the fifth year. b. use the future value of $1 table in the textbook to verify that your answer is correct. (https://cnx.org/contents/kg0cimBs@14.13:vq8rrTZQ@6/Time-Value-of-Money)
After learning about the time value of money, you decided to open a retirement account. You will invest $475 each month. It earns an annual interest rate of 10.8% per year. Your first deposit will be made one month from now. What is the value of your account in 33 years? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Retirement account value
A local bank will pay you $135 a year for your lifetime if you deposit $3,000 in the bank today. If you plan to live forever, what interest rate is the bank paying? Note: Enter your answer as a percent rounded to 2 decimal places. Interest rate %
You want to be able to withdraw $5000 from an account at the end of each year for the next 12 years. How much money should you invest now into an account earning 5.5% interest per year, compounded annually, in order to fund the desired withdrawals? Assume the account is empty after the last withdrawal is made. Give the answer to 2 decimal places, and do not use the $ sign in the answer box. The amount to invest now is Blank 1. Calculate the answer by read surrounding text. dollars.
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?
Suppose you borrow money from your parents for college tuition on January 1, 2019. Your parents require four annual payments of $30,000 each, with the first payment due on January 1, 2023. They are charging you 5% annual interest. What is the cost of college tuition? (Use spreadsheet software or a financial calculator to calculate your answer. Round intermediary calculations to two decimal places and round your final answer to the nearest dollar.) Question content area bottom Part 1 A$91,894 B.$111,697 C.$120,000 D.$88,475
You would like to put some money into an account so that you will have $6000 in the account 13 years from now. If the account earns 3.5% interest per year, compounded quarterly, how much should you invest now in order to reach your goal? Give the answer correctly to 2 decimal places. dollars Do NOT use the dollar sign in the answer box. ns
You want to be able to withdraw $50,000 each year for 30 years. Your account earns 6% interest. a) How much do you need in your account at the beginning? b) How much total money will you pull out of the account? c) How much of that money is interest? Question Help: Video