Question: 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

CLOSING ARGUMENTS A Closing Argument should: 1. Repeat your theory and theme of the case 2. Summarize the evidence that preceded it 3. Relate the evidence to the law and the legal issues (i.e....

Opening Statement for Defense The 1948 U.S. Presidential election was a hard fight for Harry Truman. No one thought he had a shot and the folks at the Chicago Daily Tribune didn't think so either. At...

5, Putting Together an Evaluation Matrix An evaluation plan is a written document that describes the cWill/mat\Questions to ask yourself when putting together an evaluation matrix: Evaluation...

i just need to complete the worksheet but i suck at excel and dont know what formulas to use. X Cut . General Copy Wrap Text Merge & Center - Paste Geneva - 9AA BIU.E. A. Font Format Painter = $ - %...

Week 11: Discussion Board 3 This Discussion Board builds on applying two key concepts of diversification: correlation of asset returns and risk reduction. In Chapter 11 last week we developed the...

PLEASE DO QUESTION NUMBER 2 """ALWAYS FRESH NEW ANSWERS Please look at below business operations question #2 and answer it. You are encouraged to use an excel spreadsheet to produce the final result...

PART 3 - PRELIMINARY CONCLUSIONS, NEXT STEPS & RECOMMENDATIONS (i) In this part of your work make a preliminary conclusion - based on your results, is it feasible to implement the idea you had? It...

please help with all parts of questions 1-8 from creating the balance sheet and income statement... to calculating the ratios, interpreting those ratios , and whether or not she can achieve her...

When companies decide to shift from private to public financing by making an initial public offering for their stock, they are likely to face increased costs of investor communications. Given this...

Emma Louise Company had net sales of $2,225,500,000 and cost of goods sold of $1,557,850,000. Emma had the following balances: Required: Round answers to two decimal places. 1. Calculate the average...

List the elements of the auditor's report with an unmodified opinion and explain the meaning of each part. Question content area bottom Part 1 ( List the elements in correct order and assign the...

McDonald's incorporated many unique strategies to turn the restaurant around. Which of the following is part of a different restaurant's corporate strategy? Question 6 options: focusing on healthy...

OUTCOME 4 Describe the different group techniques and types of work schedules used to broaden a firms job functions and maximize employee contributions.

OUTCOME 3 Provide examples illustrating the various factors that must be taken into account in designing a job, including what motivates employees.

OUTCOME 1 Discuss the relationship between job requirements and HRM functions.