I am stuck on this problem and need to put into excel with formulas. Please help.  You want to buy SuperTech Inc. stock. They pay quarterly dividends, with the next dividend of $0.40 per share being paid later today.  You believe that, during the next 6 years, their quarterly dividends will grow by 20% APR, compounded annually.  But after 6 years, their quarterly dividends will grow more slowly… only at 4% APR, compounded annually.  If the discount rate on this stock is 12% APR, compounded annually, then what would be a fair price for this stock right now?

Question

I am stuck on this problem and need to put into excel with formulas. Please help. 

  1. You want to buy SuperTech Inc. stock. They pay quarterly dividends, with the next dividend of $0.40 per share being paid later today.  You believe that, during the next 6 years, their quarterly dividends will grow by 20% APR, compounded annually.  But after 6 years, their quarterly dividends will grow more slowly… only at 4% APR, compounded annually.  If the discount rate on this stock is 12% APR, compounded annually, then what would be a fair price for this stock right now?

Expert Answer

Want to see the step-by-step answer?

Check out a sample Q&A here.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times may vary by subject and question complexity. Median response time is 34 minutes for paid subscribers and may be longer for promotional offers.
Tagged in
Business
Finance

Related Finance Q&A

Find answers to questions asked by students like you.

Q: 3. Your client has a 2-year old child whose college education they plan to fund when the child turns...

A: First calculate the lump sum amount needed at the start of college. This lump sum can be calculated ...

Q: (1)If compounding monthly, how would I find percent and intrest of a problem? (2) How do I compute i...

A: We’ll answer the first question since the exact one wasn’t specified. Please submit a new question s...

Q: How much will I need to deposit into an account to have $6,500,000 in 10 years earning 5 % compounde...

A: Present value can be defined as the amount which is to be set aside in order to have a pre-defined s...

Q: Executives at XYZ Corporation realize that they have too much liquid assets. They want to use this c...

A: Calculate the expected return and standard deviation as follows:

Q: What will the total amount of an account be where I deposited $1000 per year earning 4 % annually fo...

A: The accumulated value of a series of payment can defined as the sum of future value of all cash flow...

Q: Which one of the following terms applies to a bond that can be exchanged for the issuing company's c...

A: Convertible bond or convertible debt is a type of bond that the bond holder can convert the bond int...

Q: NikkiG’s Corporation’s 10-year bonds are currently yielding a return of 6.80 percent. The expected i...

A: Current Yield = 6.80%Expected Inflation Premium (EIP) = 1.20%Risk-free Rate (RFR) = 2.10%Liquidity R...

Q: Part 1: The CFO of Cruz, inc. is considering Projects A and B which are considered equally risky; th...

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for y...

Q: Q2)   Suppose the current one-year euro swap rate y0[0, 1] is 1.74%, and the two-yearand three-year ...

A: Meaning of Euro swap rate:A swap rate is the fixed rate that a receiver demands, in exchange for unc...

Q: Suppose that 10 years ago you bought a home for $150,000, paying 10% as a down payment, and financin...

A: Calculation of Interest Paid over the New Loan:The interest paid over the new loan is $137,184.85.Ex...

Q: A five-year project has an initial fixed asset investment of $280,000, an initial NWC investment of ...

A: Equivalent Annual Cost (EAC) is the cost of owning an asset. It is used as an important tool for eva...

Q: Is there an easily identifiable debt-equity ratio that will maximize the value of a firm? Why or why...

A: The value of the firm is dependent upon the future cash flows and the discount rate. In the absence ...

Q: You buy stock for $30 per share and sell it for $33 per share after holding it for slightly after a ...

A: Since the stock is held for more than a year, both income and capital gains will be taxed differentl...

Q: What is Internal Rate of Return - Monthly Fixed Cash Flows with Reversions?  Please provide examples...

A: The internal rate of return is the one of the discounted techniques of capital budgeting which is us...

Q: Calculate how much you will have to save each month between now and then to have $300,000 in your re...

A: Calculate the monthly saved amount as follows:

Q: Could you please do a step by step solving process for this question?

A: PVIFA refers to present value interest factor of an annuity. It is used to determine the present val...

Q: Executives at Microsoft are interested to get into the drone delivery business.They decide to acquir...

A: Option 1: The present value is $40 million.Option 2: Calculate the present value as follows:

Q: XYZ company has just paid a dividend of $1.15. The required rate of return on the stock is 13.4%, an...

A: 1.Calculation of Current Stock Value:The current stock value is $21.30.

Q: Please show all equations and work as needed. Make the correct answer clear. If possible, please typ...

A: Answer:The firm will raise $0 and will own ownership of 30.8% in firm.The firm will get nothing in t...

Q: need help with all

A: Risk free rate, Rf = 4%CAPM = E(R) = Rf + Beta x (Rm - Rf) where Rm is the expected return from mark...

Q: Assume the following ratios are constant:             Total asset turnover   2.6     Prof...

A: The maximum growth which a firm can achieve by using internal resources and fund is known as sustain...

Q: A yield curve is a graphical representation of the relationship between the yields and the maturitie...

A: The yield curve displays the upward path- this yield curve is termed as normal yield curve.The rates...

Q: I am currently working on some practice problems for my finance class and am unsure how to set up an...

A: As per the rule, I will do the first three parts. Since 1a is done will do 1b, 2 a and b.1b) Standar...

Q: XYZ company has the following expected cash flows for three scenarios that could occur:            ...

A: In an levered firm, there is no debt amount therefore no interest amount is payable that is 0. The E...

Q: Protective covenants protect:   Group of answer choices A. the investor from interest rate risk. ...

A: A protective convenant is a part of a bond indenture (legal contract or loan agreement). The scope a...

Q: A trasury security in which periodoc coupon interest payments can be seperate from eachother ad from...

A: The appropriate answer is option (a).The Treasury STRIPS is known as Separate Trading of Registered ...

Q: Currently working on finance practice problems and need help with setting up the problem, calculatin...

A: Hey, since there are multiple questions posted, we will answer first question. Kindly, post the othe...

Q: Consider the following bond: Face value = 1000; coupon rate = 8%; maturity = 5 years; ytm = 7% A) Wh...

A: A)The formula to calculate price of bond is given below,

Q: You lent $290 to a friend for one year at a nominal rate of interest of 3 percent. Inflation during ...

A: Real interest rate is the real return earned on the amount lent which can be calculated by using fis...

Q: Paul and Sandy Moede signed an $8000 note at Citizen's Bank. Citizen's charges a 6.50% discount rate...

A: Computation of effective rate of interest:Hence, the effective rate of interest is 6.87%.

Q: The next dividend payment by Grenier, Inc., will be $1.64 per share. The dividends are anticipated t...

A: Calculation of Dividend Yield and Capital Gains Yield:

Q: You deposit $3000 in an account that pays 88​% interest compounded semiannually. After 33 ​years, th...

A: Amount deposited, P = $ 3,000Future value of P deposited in an account offering annual interest rate...

Q: Calculate the value of x for the cash flows below such that the equivalent total value in year 8 is ...

A: Equivalent value of a cash flow, Ct occurring at time t, at the end of year n = Ct x (1 + r)n - t wh...

Q: Prepare an amortization schedule for a five-year loan of $59,000. The interest rate is 7 percent per...

A: Amortization schedule is prepared as follows, formulas for each cell is given in the next screen sho...

Q: The newspaper reported last week that Tisch Enterprises earned $34.17 million this year. The report ...

A: Calculation of Earnings Growth and Next Year’s Earnings:The earnings growth is 13.50%.

Q: Suppose you have two options for buying total 500 stocks.      A:   You can buy 1 stock from each of...

A: Diversification can be described as a way of investing in such a manner that reduces overall risk fo...

Q: A 4.40 percent coupon municipal bond has 16 years left to maturity and has a price quote of 105.50. ...

A: “Hi, as per our policy we will answer the first three parts of the question. Kindly repost the remai...

Q: Executives at Microsoft are interested to get into the drone delivery business. Since it would take ...

A: (a) Calculation of present values of two options:Answer:Net present values of both options are $40 m...

Q: Atlantic Corporation is the largest logging company in the north eastern part of the United States. ...

A: Dividend can be described as the amount received by shareholders from the company periodically.It is...

Q: At age 18, Marcia started depositing $2000 per year at the end of each year into an account earning ...

A: Annuity, A = $ 2,000Rate of interest = r = 12%number of annuities, n = 8

Q: (Solving for i of an annuity) You lend a friend $30,000, which your friend will repay in five equal ...

A: We can solve the rate of return using the Financial calculator or excel. I will demonstrate both the...

Q: How much should chuck invest semiannually in his ira to have $250,000 in it when he retires in 25 ye...

A: Semi-annual compound interest is the interest which is added to the principal amount twice in a year...

Q: Hello, It is a three part question. However, I would like to know how the amount of 122, 265, was ca...

A: 3.Calculate the net present value as follows:

Q: Thank you for answering question 3. I need the answers to 4 and 5 as well because the cash flows are...

A: 4.Computation of NPV:

Q: Tony Ring wants to attend Northeast College. He will need $66,000, 4 years from today. Assume Tony's...

A: Future Amount required (fv) = $66,000Interest Rate = 12%Type of Interest Compounded = SemiannuallyNu...

Q: Debbie invests $5,500 in her IRA account each year for 40 years.  If she earns 7% return annually on...

A: We need to use the concept of time value of money to solve the question. According to the concept of...

Q: Ba short position in a fulures coedracd Csold a forward coetract D. purchased a forwand contracd E. ...

A: Option is a derivative instrument which gives the buyer the right to buy or sell an asset at a prede...

Q: Your company is currently considering two investment projects. Each project requires an upfront expe...

A: Payback period can be defined as the time length required by the project to recover the total cash o...

Q: 9. A passbook savings account has a rate of 6%. Find the effective annual yie if the interest is com...

A: I am solving the first question, that is Q - 9.

Q: Why are credits and debits different for banks compared for personal finance usage?

A: In personal account, all expenses, assets, and losses will be debited. All incomes, liabilities, and...