Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Note: can you answer this question in excel format Kathy Myers frequently purchases stocks and bonds, but she is uncertain how to determine the rate
Note: can you answer this question in excel format
Kathy Myers frequently purchases stocks and bonds, but she is uncertain how to determine the rate of return that she is eaming. For example, three years ago she paid $22,000 for 960 shares of Malti Company's common stock. She received a $787 cash dividend on the stock at the ond of each year for three years. At the end of three years, she sold the stock for $20,000. Kathy would Eke to earn a returm of at least 13% on all of her investments. She is not sure whether the Malti Company stock provided a 13% retum and would like some help with the necessary computations. (Ignore income taxes.) Required: a. Enter the Excel inputs below to be used to calculate the present value of the cash inflows from the investment. itern Amount RATE NPER PMT FV Calculate the present value of the cash inflows from the investment and the net present value of the investment. (Any cash outflows should be indicated by a minus sign. Use Microsoft Excel to calculate present values and do not round intermediate calculations.) b. item Amount Present Value of Infiows Less initial Investment Net Present Value of Investment C. Did Kathy Myers eam at least a 13% return on her investment? O Yes d. Enter the Excel formula inputs and calculate the Internal Rate of Return for Kathy's investment Item Amount NPER PMT FV PV Rate of Return References eBook & ResourcesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started