- Please Use Excel And Show Functions Used 1 (38.22 KiB) Viewed 33 times
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
PLEASE USE EXCEL AND SHOW FUNCTIONS USED!
1. (20 points) A widow received $100,000 from an insurance company after her husband's death. She wants to deposit this amount in a savings account that earns interest at a rate of 3% compounding monthly. She would like to make 48 equal monthly withdrawals over four years, so that this savings account will have a zero balance with the last withdrawal. Show her account's monthly balance in a cash balance table. a) What is the monthly effective interest rate? b) How much would she withdraw each month?
1. (20 points) A widow received $100,000 from an insurance company after her husband's death. She wants to deposit this amount in a savings account that earns interest at a rate of 3% compounding monthly. She would like to make 48 equal monthly withdrawals over four years, so that this savings account will have a zero balance with the last withdrawal. Show her account's monthly balance in a cash balance table. a) What is the monthly effective interest rate? b) How much would she withdraw each month?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!