In: Finance
You plan to make five deposits of $1,000 each, one every 6 months, with the first payment being made in 6 months. You will then make no more deposits. If the bank pays 7% nominal interest, compounded semiannually, how much will be in your account after 3 years? Round your answer to the nearest cent. $ One year from today you must make a payment of $9,000. To prepare for this payment, you plan to make two equal quarterly deposits (at the end of Quarters 1 and 2) in a bank that pays 7% nominal interest compounded quarterly. How large must each of the two payments be? Round your answer to the nearest cent.
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.