Question
Is this correct
Suppose that you have $100,000 in cash today. You want to find a bank account that offers an interest rate that will allow you to make withdrawals to pay your monthly expenses of $1,250, beginning one month from today, for 10 years before exhausting the account. Assume that any savings account we consider pays interest monthly (i.e monthly compounding). What APR must the account offer in order for you to achieve your goal? .7.45% 8.69% 9:16% 110.43%
0 0
Add a comment Improve this question Transcribed image text
Answer #1

YES, it is correct.

Please refer to below spreadsheet for calculations

C7 XRATE(C5,C4,-C3,,0) Deposit Amount Monthly withdraw No. of Period $ 100,000.00 1,250.00 120 4 Interest rate (monthly) APR

Formula reference -

C7 Deposit Amount Monthly withdraw No. of Period 100000 1250 4 10*12 RATE(C5,C4,-C3,,0) Interest rate (monthly) APR -C7 12

Add a comment
Know the answer?
Add Answer to:
Is this correct Suppose that you have $100,000 in cash today. You want to find a...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT