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.

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

ChapterA3: Time Value Of Money

Section: Chapter Questions

Problem 7CE

See similar textbooks

Similar questions

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
Suppose you want to have $400,000 for retirement in 25 years. Your account earns 5% interest. Feel free to use the Online Basic Financial Calculator a) How much would you need to deposit in the account each month? es b) How much interest will you earn? $
You plan to deposit $700 in a bank account now and $900 at the end of one year. If the account earns 2% 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.)
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)
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.
Answer the given question with a proper explanation and step-by-step solution. Please provide the answer using the math tool otherwise I give the downvote.
You plan to deposit S500 in a bank account now and S400 at the end of the year. If the account earns 4% interest per year, what will the balance be in theaccount right after you make the second deposit?
How much money (to the nearest dollar) will you need to deposit in an account now in order to have $35,000 in the account after 5 years if the account earns 1.2% interest compounded weekly? Summarize the information provided, stating the interest rate in a decimal form. PN = r = N = k = Solve the problem and give your answer here:
Suppose you take out a car loan that requires you to pay $7,000 now, $4,000 at the end of year 1, and $6,000 at the end of year 2. The interest rate is 5% now and increases to 10% in the next year. What is the present value of the payments? Enter your response below rounded to 2 decimal places. Number
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
Suppose you deposit $10 every week into an account that earns 4% interest compounded weekly. How much money (to the nearest cent) will you have in the account after 5 years? Summarize the information provided, stating the interest rate in a decimal form. d = r = N = k = Solve the problem and give your answer here