Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please i need help with 1 and 2 using excel and know what formulas to use for those problems so that im able to see
please i need help with 1 and 2 using excel and know what formulas to use for those problems so that im able to see hos you got the answers i am stuck! please show work 1. Stock Pricing (20 points) Copper Communications has just paid a dividend of 52.97 and is projected to pay a dividend of $3.11 in the upcoming year. a. Determine the annual rate of growth in dividends between year 0 and year 1 b. Suppose you can earn 13% on alternative investments with similar risk. If the company's dividend grows at this rate indefinitely, what is the most you would be willing to pay per share for this company...? c. If the firm's dividends were expected to grow at previous rates for three years, and then be the same for the indefinite future lie, zero growth) what is the most you would be willing to pay per share? Assume the same discount rate. 2. Retirement Sayings 120 points) You plan to retire in exactly 22 years a. Suppose you save $500 per month. Assume that your account earns interest monthly at an annual rate, compounded monthly. How much will you have in 22 years...? Round to nearest dollar b. You goal is to create a fund that will allow you to receive $7.000 at the end of each month for 25 years after retirement. You believe you will be able to earn 5% per year, compounded monthly during the 25-year retirement period. How large a fund will you need when you retire to provide the 25-year, 57,000 per month retirement annuity?(round to nearest dollar) c. How much is $7,000 received 22 years from now worth in today's dollars if inflation is 2% per year (round to nearest dollar)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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