Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I seek the formula for manual calculation of the payment of an ordinary annuity when the interest is not compounded at the same frequency as

I seek the formula for manual calculation of the payment of an ordinary annuity when the interest is not compounded at the same frequency as the deposits (e.g. compound daily with monthly payments). This is an annuity that I buy now, the present value is large, I receive monthly payments, the future value is zero. TI-83 can do this, but I need the formula for manual calculation, and I haven't yet found it anywhere. The only formula that I have includes only future value. Don't I need a formula that includes both present value and future value? This is the formula that I have:

A & = & \mbox{ accumulated balance after t years} \\ & = & FV \\ & = & \mbox{ future value of the annuity} \\ PMT & = & \mbox{ periodic payment} \\ & = & \mbox{ need to find this} \\ r & = & \mbox{ APR written as a decimal} \\ m & = & \mbox{ compounding frequency} \\ i & = & \mbox{ periodic interest rate} \\ & = & \frac { r } { m } \\ n & = & \mbox{ number of payments per year} \\ t & = & \mbox{ number of years} \\ A & = & FV \\ & = & PMT \frac { \left [ \left ( 1 + i ight )^{\frac { m } { n }} ight ]^{(nt)} - 1} { ( 1 + i )^{\frac { m } { n }} - 1 } \\ & = & PMT \frac { \left [ \left ( 1 + \frac { r } { m } ight )^{\frac { m } { n }} ight ]^{(nt)} - 1} { ( 1 + \frac { r } { m } )^{\frac { m } { n }} - 1 }

Here is the specific question: Suppose that you have just received an inheritance of \$300,000. You use the money to set up an annuity to fund a stream of monthly payments to yourself over the next 20 years; at the end of the 20-year period, the account will be completely depleted. Assuming that you can earn 6\% interest compounded daily on this investment, what will be your monthly payments? Here is the TI-83 solution:

N & = & 240 \quad \mbox{12 payments per year for 20 years } \\ I\% & = & 6 \quad \mbox{Given interest rate} \\ PV & = & 300,000 \quad \mbox{The given present value} \\ PMT & = & ?? \quad \mbox{Again, solving for the payment} \\ FV & = & 0 \quad \mbox{At the end, the account is depleted} \\ P/Y & = & 12 \quad \mbox{payments are on a monthly basis} \\ C/Y & = & 12 \quad \mbox{compounding is on a monthly basis} \\ PMT & : & END

Solving for the unknown, we get

PMT = -2149.29

In other words, this investment will give us monthly payments of \$2149.29 over the next 20 years.

Thank you.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Health Care Finance Basic Tools For Nonfinancial Managers

Authors: Judith Baker

2nd Edition

0763726605, 9780763726607

More Books

Students also viewed these Finance questions