Determine how long it will take to accumulate at least $20,000 in a bank account if you deposit $250 initially, $1200 at the end of each year and the account pays 5% annual interest. Highlight the year that this takes place and final amount in your account at that time in yellow and create an XY graph identical to the one shown. You must use formulas and absolute and relative referencing to complete this problem. Make your EXCEL sheet look identical to this one
show formula please, thank you!
hi, I have attached the pic with the formula.. Let me know if you need any details...
Determine how long it will take to accumulate at least $20,000 in a bank account if...
Use a loop in Matlab to determine how long it will take to accumulate at least $2,000,000 in a bank account if you deposit $10,000 initially and $10,000 at the end of each year; the account pays 8% annual interest distributed at the end of each year. Tabulate the amount in your bank account at the end of each year in an easy to read manner. Round it off to the nearest whole dollar amount in the balance. If you...
How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? What is the balance in an account at the end of 10 years if $6,500 is deposited today and the account earns 3% interest compounded annually? If you wish to accumulate $50,000 in 10 years, how much must you deposit today in an account that pays annual interest rate of 8%, with semi-annual compounding...
How much money should be deposited today in an account that earns 5% compounded semiannually so that it will accumulate to $8000 in three years? The amount of money that should be deposited is $ (Round up to the nearest cent.) You deposit $14,000 in an account that pays 5% interest compounded quarterly A. Find the future value after one year B. Use the future value formula for simple interest to determine the effective annual yield. A. The future value...
11) Suppose you wish to accumulate $20,000 by the year 2035 (18 years from now). How much must you set aside every month in a savings account that pays 12% interest, compounded monthly?. A) $226.39 B) $358.75 9 $2331.38 D) $26.39 12) Peking Duct Tape Company has an outstanding issue of $1000-face-value zero-coupon bond with 3 years remaining until final maturity. Assuming 16 percent required rate of return and semiannual compounding, what should be the value of this bond? A)...
3. You want to buy a car, and a local bank will lend you $20,000. The loan would be fully amortized over 3 years (36 months), and the nominal interest rate would be 12%, with interest paid monthly. What is the monthly loan payment? Round your answer to the nearest cent. $ What is the loan's EFF%? Round your answer to two decimal places. % 4. Find the present values of the following cash flow streams. The appropriate interest rate...
1) How long will it take for $12,000 to become $24,000, if it is in an account paying 3% every six months? 2) A department store charges its customers 1.75% per month for their credit purchases. What nominal interest rate are customers charged? What is the effective rate? 3) You deposit $2,000 in a bank that pays 3% compounded continuously. How much are you going to have at the end of 4 years? 4) A car can be purchased with...
Is an avid reader and buys only mystery novels. Janet deposits $3,000 in a bank account that pays an annual nominal interest rate of 5%. Assume this interest rate is fixed-that is, it won't change over time. At the time or her deposit, a mystery Initially, the purchasing power of Janet's $3,000 deposit smystery novels For each of the annual inflation rates given in the following table, first determine the new price of a mystery novel, assuming it rises at...
Instructions: Using Financial Formulas in Excel, answer the following time value of money problems in a single Excel worksheet. You can round to the nearest dollar. You must turn in your answers in an Excel document. 1. How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? 2. What is the balance in an account at the end of 10 years if $6,500 is...
Instructions: Using Financial Formulas in Excel, answer the following time value of money problems in a single Excel worksheet. You can round to the nearest dollar. You must turn in your answers in an Excel document. 1. How much interest is earned in an account by the end of 5 years if $30,000 is deposited and interest is 4% per year, compounded semi-annually? 2. What is the balance in an account at the end of 10 years if $6,500 is...