If you need $40,000 five years from now, what is the minimum amount of money you need to deposit into a bank account that pays 4% annual interest, compounded (give your answers to the nearest cent): (a) annually? $ (b) monthly? $ (c) daily (assuming 365 days in a year)? $
Q: You need to have 59,173 dollars to buy a new car 5 years from now. How much do you need to save at…
A: An annuity is the sum total of all the periodic payments or investments made over the period of time…
Q: 1. How much money you must invest today in order to withdraw ? 1,000 per year for 10 years, if the…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: Suppose you wish to start up your coffee shop. You need to borrow $50,000 today. You intend to pay…
A: Using PMT function of the excel to calculate monthly withdrawals
Q: Imagine you want to earn $1000 in total after 3 years. The Bank A says that account earns 5%…
A: In simple interest, the rate of interest is applied on the principal amount only whereas in compound…
Q: Solve each of the following questions using both pricing formulas and Excel. 1. If you wish to…
A: Present value refers to the current value of money which is required to put for a certain amount in…
Q: 2. You have $42,180.53 in a brokerage account, and you plan to deposit an additional $5,000 at the…
A: We will make use of the excel function NPER to get this answer. This function returns the number of…
Q: You would like to have $600,000 when you retire in 40 years. How much should you invest each quarter…
A: Here, To Find: Part a). Amount of deposit each quarter =? Part b). Total money deposited into the…
Q: Starting next year, you will need $15,000 annually for 4 years to complete your education. (One year…
A: “Hey, since there are multiple questions posted, we will answer first question. If you want any…
Q: You expect to need $1500 in 3 years. Your bank offers 4% compounded semi-annually. How much money…
A: Solution:- When an amount is invested somewhere, it earns interest on it. The amount initially…
Q: You need to have 59,173 dollars to buy a new car 5 years from now. How much do you need to save at…
A: Annuity is a no. of payment which are equal in size and made in equal interval of time. Person…
Q: Mike Gioulis would like to have $23,000 in 4 years to pay off a balloon payment on his business…
A: In order to have sufficient money to accomplish future goals, individuals use various investment…
Q: 2. Upon graduating from college this year, you expect to earm $25,000 per year. If you get your BBA,…
A: Face value of loan is the value for which a borrower is going to take loan. The interest amount is…
Q: You have $35,009.41 in a brokerage account, and you plan to deposit an additional $5,000 at the end…
A: According to the time value rule, dollar money available today is worth more than the same dollar…
Q: You put 280,000 dollars in a bank which gives you 0.75% interest compounded daily. If you leave that…
A: The amount of interest earned can be computed with the help of future value function
Q: Suppose you want to have $300,000 in the bank when you retire in 45 years and the bank pays 3%…
A: given, rate = 3% no of years= 45 FV= 300,000
Q: 1. A man has a loan of 50,000 in a bank that gives 12% simple interest. How much is the interest if…
A: Since you have asked multiple questions, we will solve the first question for you. If you want any…
Q: You want to be able to withdraw $50,000 each year for 20 years. Your account earns 8% interest. a)…
A: a) Hence, the amount in the account at the beginning is $490,907.37 b) Hence, the total money pull…
Q: IF you deposit $300 each quarter into an account earning 3.2% compunded quarterly, how many years…
A: Given that;Quarterly deposit amount (pmt) is $300Future value of the amount is $15,000Interest rate…
Q: You want to be able to withdraw $45,000 each year for 25 years. Your account earns 6% interest. a)…
A: Given: Withdraw amount =$45000Interest rate annually =6%Time=25 years
Q: Mike Gioulis would like to have $22,000 in 3 years to pay off a balloon payment on his business…
A: Mike must put money in his account = $ 20,828 EXPLANATION:- Target amount(A) = $ 22,000…
Q: account with an interest rate of 7.5% per year compounded monthly. You want to withdraw all your…
A: interest rate =7.5% monthly interest =7.5/12=0.625 Future value =Present value (1+i)n
Q: Starting next year, you will need $10,000 annually for 4 years to complete your education. (One year…
A: Here, Annual withdrawal is $10,000 Time Period of Withdrawal is 4 years Interest Rate is 6%
Q: If you put $850 in a bank today that pays (a) 13% interest per year, how much money could be…
A: The concept of the time value of money states that the current worth of money is more than its value…
Q: A man can save 10,000 per month for 2years, If the bank offers 5% compounded monthly, what is n?
A: The present value is the value of the sum received at time 0 or the current period. It is the value…
Q: You plan to make a lump-sum deposit of $5000 now into an investment account that pays 6% per year,…
A: Lump Sum Deposit = 5000 Return % = 6% Annual End of year withdrawals = 1000 Time Period of…
Q: b. You have a $20,000 note payable which is due in three years. How much money must you put into a…
A: Solution d: N = 1 PV (Future value of at the end of 3 years) = $20,000 Interest rate (I) = 3%
Q: You have €42,180.53 in a brokerage account, and you plan to deposit an additional €5,000 at the end…
A: Working note:
Q: Having trouble, please help! You would like to have $1,000,000 when you retire in 35 years. How…
A: The concept of the time value of money states that the current worth of money is more than its value…
Q: Suppose you want to have $300,000.00 for retirement in 35 years. You plan to make regular monthly…
A: Future value is the value of the cash flows at the end of certain period. Future value of annuity is…
Q: You would like to have $550,000 when you retire in 40 years. How much should you invest each quarter…
A: Required Amount at retirement is $550,000 Time period is 40 years Interest rate is 6.4% Compounded…
Q: You want to be able to withdraw $4000 from an account at the end of each year for the next 19 years.…
A: In the given question we require to calculate the amount of money to be invest today to receive…
Q: You deposit GHS10,000 today into an account paying 6% annual interest and leave it on deposit for…
A: As per Bartleby answering guideline, we can answer only one question, if student post more than one…
Q: 5) You need $10,000 annually for 4 years to complete your education, starting next year. (One year…
A: Hi thanks for the question. This post has multiple questions. As per company guidelines expert can…
Q: nvestment promises to pay into an account that pays you 6 percent annually, $150 per month for the…
A: because you have posted multiple questions, we will answer the first question only, for the…
Q: You want to be able to withdraw $5000 from an account at the end of each year for the next 12 years.…
A: Information Provided: Payment = $5000 Term = 12 years Interest rate = 5.5% compounded annually
Q: You would like to have $650,000 when you retire in 40 years. How much should you invest each quarter…
A: a. GIVEN, future value (FVA) = $650,000 n = 40 m =4 rate of interest (r) = 3.6% applying the formula…
Q: You want to be able to withdraw $50,000 each year for 30 years. Your account earns 5% interest.…
A: This the question of present value of ANNUITY. Annuity is a equal stream of cashflow at equal…
Q: How much would be in your savings account in 8 years after depositing $300 today if the bank pays 8…
A: Present value = Future value/(1+required rate of return)^n. Use PV Function in excel Future value =…
Q: 2) You wish to save $150,000 for a new car. You are going to make $5000 deposits at the end of each…
A: A study that proves that the future worth of the money is lower than its current value due to…
Q: If you need $40,000 five years from now, what is the minimum amount of money you need to deposit…
A: Formulas:
Q: You would like to have $53,000 in 13 years. To accumulate this amount, you plan to deposit an…
A: Present value refers to the current valuation for a future sum. Investors determine the present…
Q: You need to accumulate $10,000. To do so, you plan to make deposits of $1,450 per year - with the…
A: Given: Interest rate = 7% = 0.07 Future value (FV) = $10000
Q: Say you barrowed $10,000 from a bank at 12% interest rate per year for a period of 10 years. How…
A: Borrowed amount is $10,000 Interest rate is 12% Time period is 10 years To Find: Amount after 10…
Q: . How long will it take to accumulate P5,000 to P7,000 if interest rate is 6% compounded quarterly?
A: Honor code: Since you have asked multiple questions, we will solve the first question for you. If…
Q: !
A: Compound Interest Compound interest refers to the interest that includes interest on principal as…
Q: You need to accumulate $10,000. To do so, you plan to make deposits of $1,450 per year - with the…
A: Future value of an annuity can be calculated as: = Annuity payment * FVAF (i%, n years)
Q: You want to be able to withdraw $25,000 each year for 20 years. Your account earns 10% interest.…
A: Part A-C:Calculation of Amount in the Account, Total Money in the Account and Total Interest:A) The…
Q) If you need $40,000 five years from now, what is the minimum amount of money you need to deposit into a bank account that pays 4% annual interest, compounded (give your answers to the nearest cent):
(a) annually? $
(b) monthly? $
(c) daily (assuming 365 days in a year)? $
Solve on the white paper.
Not solve in excel works.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
- You put $600 in the bank for 3 years at 15%. 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 third year. B. Use the future value of $1 table In Appendix B and verify that your answer is correct.You put $250 in the bank for S 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 Appendix B and verity that your answer is correct.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
- If you want to have $23,000 for a down payment for a house in six years, what amount would you need to deposit today? Assume that your money will earn 3 percent. Use the TVM keys on your calculator ... NOT the tables in the book Enter your answer as a negative value in the form: -$nn,nnn.nn Numeric Response 19,262.13 XYou 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. nsAssume 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
- 2. Suppose you have a bank account into which you make $100 deposits each month. You find a bank account paying r 100% (r is a decimal rate) per month. You would like to save up for a $2,000 car down payment, which you would like to have in 15 months. What must the bank account pay in order for this to be accomplished?PLEASE don't use excel for this. Show the solution with formula needed. SIMPLE INTEREST 1. You owe P120,000.00 from a friend that promise to pay 6% simple interest. How much will you pay at the end of 9 months? How about at the end of 1 year and 6 months? COMPOUND INTEREST 1. If the sum of P12,000.00 is deposited in an account earning interest rate of 9% compounded quarterly, what will it become after 1 year? And what is the effective rate? 2. An investment of P3,000,000.00 earns interest of 9% compounded continuously. What is the effective rate of interest?Tony Ring wants to attend Northeast College. He will need $75,000 4 years from today. Assume Tony's bank pays 12% interest compounded semiannually. What must Tony deposit today so he will have $75,000 in 4 years? (Use the Table 12.3 provided.) Note: Do not round intermediate calculations. Round your answer to the nearest dollar amount. X Answer is complete but not entirely correct. Amount to be deposited $ 47,056 X
- 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 decide to borrow $250,000 to build a new home. The bank charges an interest rate of 8% compounded monthly. If you pay back the loan over 30 years, what will your monthly payments be (rounded to the nearest dollar)? Select one: a.$1,123 b.$1,237 c.$1,687 d.$1,834 e.None of these solutions is correctGive only typing answer with explanation and conclusion You are considering investing in a bank account that pays a nominal annual rate of 7%, compounded monthly. If you invest $3,000 at the end of each month, how many months will it take for your account to grow to $325,000? Note that if the final answer is not a whole number, be sure to round it up to the nearest whole number. Select the correct answer. a. 83 b. 81 c. 85 d. 79 e. 89