Question
Will rate!

You are planning to withdraw $100 in Year 1, $150 in Year 3, and $200 in Year 5. How much should you invest today, at an interest rate of 5%? Draw a cash flow diagram for your understanding You need not submit the cash flow diagram Choose the most appropriate model using functional notations that will answer the question ap-100(P/F, 5% 1) +150P/F 5%, 2).200 pyp.5%3)
What is the correctly calculated value for how much you should invest today. at an interest rate of 5% from the previous problem? Enter your answer as 1.23. Do NOT include the comma separator or the dollar (S) symbol.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

1.

Amount required to invest today is equal to present value of future cash inflows at interest rate. Present value can be calculated with following formula -

P = C1(P/F,i%,1) + C2(P/F,i%,2) + .............. Cn(P/F,i%,n)

Thus, to answer question use following model

P = 100(P/F,5%,1) + 150(P/F,5%,3) + 200(P/F,5%,5)

2.

Computation of Amount required to invest today.

E6 丘 :SUM(E3:E5) | cash flow | 1 Year PVF(5%) 100 0.95238095 150 0.8638376 200 0.78352617 95.24 129.58 156.71 381.52 4 Total Present Value

Formula reference -

E6 cash flovw PVF(5% 1/(1+0.05)AB3 1/(1+0.05)AB4 1/(1+0.05)AB5 Year PV -C3*D3 100 150 200 4 -C5*D5 -SUM(E3:E5) Total Present Value

Thus, Amount required to invest today is 381.52

Add a comment
Know the answer?
Add Answer to:
Will rate! You are planning to withdraw $100 in Year 1, $150 in Year 3, and...
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