Question

Julia sold her business for $550,000 today which she then invests in the following: 25% in...

Julia sold her business for $550,000 today which she then invests in the following:

25% in Stock, for which she receives a 4% dividend each year (so, 4% of the total value of her stock holdings she receives as income)

35% in Bonds, for which she receives a 6% annual coupon payment (every six months - or 3% every six months)

20% in Healthcare Group, which pays out $10,000 in Year 1, growing 4% each year

20% in a Farm, which pays out $40,000 in Year 10.

Over the next 15 years, calculate the NPV and IRR of the combined projects?

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

We first chalk out the cash flows and then calculate the NPV and IRR using NPV and IRR function in excel

Assuming discount rate of 5% in NPV

A B C D E F G H 1 Total investment 550000 N 3 Year Net cash flow -550000 4 0 5 1 6 2 27050 27450 27866 28298.64 7 3 8 4 9 5 2

Add a comment
Know the answer?
Add Answer to:
Julia sold her business for $550,000 today which she then invests in the following: 25% in...
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