Question

You are expecting to receive monthly payments of $280 for 36 months with the first payment...

You are expecting to receive monthly payments of $280 for 36 months with the first payment occurring exactly two years from now. What is the value of these payments to you today? Assume an APR of 6.5%. Round your answer to two decimal places. Hint: The first payment occurs exactly two years from now, so the annuity actually begins one month prior to that.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프· ー· 鱼, Δ. : rーー 遑锂函Merge & Center. $, % , 弼,8 Conditional Format eCell Insert Delete Formsat Sort &Find & Format Painter Formatting as Table Styles2 Clear Clipboard Alignment Number Cells Edting LL88 LM LN LO LP LQ LR LS LT LU LV LW LX LY LZ 76 78 79 80 81 82 83 84 85 86 87 FIRST WE WE WILL CALCULATE PRESENT VALUE OF ANNUITY OF 36 MONTHS PMT PERIOD MONTHS APR PERIODS IN A YEAR 280 36 6.50% 12 PVAD= $ 9,135.70 PV(LP83/LP84,LP82,-LP81) NOW WE HAVE TO FIND PRESENT VALUE OF PVAD 89 90 91 92 93 94 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity i CAP STRU VALUE NO OF MONTHS PRESENT VALUE$ 8,068.30 [EXCE; -PV(LP83/LP84,LP90,,-LP86)] AS FIRST PAYMENT OCCURS ONE MONTH PRIOR, WE HAVE TO CALCULATE PRESENT VALUE FOR 23 MONTHS LOCK BOXDILUTION DOLLAR COST AVG MORTGAGE EXPO Sheet1 Sheet2 Shel rences: x261 02:57 27-01-2019Home nert Page Layout Formulas Data Review View dd-Ins s Cut ta copy. Σ AutoSum ー E ゴWrap Text General в 1 프· ー· 鱼, Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting, as Table w styles. ▼ ㆆ ▼ Sort &Find & 2 ClearFe Select Edting Format Painter Clipboard Font Alignment Number Styles Cells LL112 LM LN LO LP LQ LR LS LT LU LV LW LX LY LZ 94 95 96 97 98 WE CAN PRESENT SAME SUM IN THE FORM OF ANNUITY DUE AS WELL FIRST WE WE WILL CALCULATE PRESENT VALUE OF ANNUITY OF 36 MONTHS PMT PERIOD MONTHS APR PERIODS IN A YEAR 280 36 6.50% 12 100 101 102 103 104 105 106 107 108 109 110 PVAD= $ 9,185.18 PV(LP83/LP84,LP82,-LP81,,1) NOW WE HAVE TO FIND PRESENT VALUE OF PVAD NO OF MONTHS PRESENT VALUE = $ 8,068.30 [EXCE; -PV(LP83/LP84,LP90,,-LP86)] SEE, BOTH METHODS GIVE SAME ANSWER 112 BOX DILUTION DOLLAR COST AVGMORTGAGE EXPO Sheeti Sheet2 Shel 福 130% 11 1 トーCALCULATOR ( LOAN OPTIONS | pv, fv, annuity 1 CAP STRU VALUE rences: x261 02:57 27-01-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut Σ AutoSum ー E ゴWrap Text aCopy в 1 프· ー· 鱼, Δ. :r-ㄧ 逻锂函Merge & Center. $, % , 弼,8 C Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard AT219 AM Alignment Number Cells Edting Formula Bar AN AP AR AS AT AU AV AW AX AY AZ BA 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 STEP 1 COMPOUNDED MONTHLY PMT -280 432 36 12 6.5 12 12 RATE C/N PV 9135.70 STEP 2 FV 9135.70 0 23 6.5 12 12 8068.30 PMT RATE C/N ANSWER PV | CALCULATOR AN OPTIONS fv. ann CAP STRU VALUE LOCK BOXDILUTION DOLLAR COST AVGMORTGAGE PO SheetiSheet2She 福 130% 02:55 27-01-2019

Add a comment
Know the answer?
Add Answer to:
You are expecting to receive monthly payments of $280 for 36 months with the first payment...
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