If the market value of a telecommunications share is $287.95, calculate the year-end dividends that it should
Fantastic news! We've Found the answer you've been seeking!
Question:
If the market value of a telecommunications share is $287.95, calculate the year-end dividends that it should be able to pay in perpetuity if money is worth 4.75% compounded semi-annually.
Transcribed Image Text:
Hired before Hired before Hired before 1/1/2010 6% 1/1/2012 4% 1/1/2013 2% Hired after 1/1/2013 no bonus 套 Y IFS function New City Salary salary LastName Department Rank State Date Hired Year Hired Gender Chin Accounting Fll Austin Техas 10/4/2012 9.4 M $ 63.531 Rothenberger Human Resources Full Austin Техas 7/14/2010 11.7 M $ 66,031 Nelson 10/9/2012 Accounting Accounting Instructor Austin Техas 9.4 M $ 58.828 Anderson Instructor Austin Texas 10/14/2011 10.4 F $ 47,405 Young Human Resources Instructor Austin Техas 7/22/2010 11.6 M $ 47,763 Neumann Finance Instructor Dallas Техas 4/3/2013 8.9 M 39,631 4. Insert the IFS function to the calculate the employee's new salary, display the new salary plus the bonus, format your answer with no decimals as currency. marks) o If the employee was hired on or after 1/1/2010, the employee is entitled to a 6% increase o If the employee was hired on or after 1/1/2012, the employee is entitled to a 4% increase o If the employee was hired on or after 1/1/2013, the employee is entitled to a 2% increase o If the employee was hired after 2013, show the existing salary Hired before Hired before Hired before 1/1/2010 6% 1/1/2012 4% 1/1/2013 2% Hired after 1/1/2013 no bonus 套 Y IFS function New City Salary salary LastName Department Rank State Date Hired Year Hired Gender Chin Accounting Fll Austin Техas 10/4/2012 9.4 M $ 63.531 Rothenberger Human Resources Full Austin Техas 7/14/2010 11.7 M $ 66,031 Nelson 10/9/2012 Accounting Accounting Instructor Austin Техas 9.4 M $ 58.828 Anderson Instructor Austin Texas 10/14/2011 10.4 F $ 47,405 Young Human Resources Instructor Austin Техas 7/22/2010 11.6 M $ 47,763 Neumann Finance Instructor Dallas Техas 4/3/2013 8.9 M 39,631 4. Insert the IFS function to the calculate the employee's new salary, display the new salary plus the bonus, format your answer with no decimals as currency. marks) o If the employee was hired on or after 1/1/2010, the employee is entitled to a 6% increase o If the employee was hired on or after 1/1/2012, the employee is entitled to a 4% increase o If the employee was hired on or after 1/1/2013, the employee is entitled to a 2% increase o If the employee was hired after 2013, show the existing salary
Expert Answer:
Answer rating: 100% (QA)
semi annual rate s 475 annual interest rate r 1snn1 where n no o... View the full answer
Related Book For
Financial management theory and practice
ISBN: 978-1439078099
13th edition
Authors: Eugene F. Brigham and Michael C. Ehrhardt
Posted Date:
Students also viewed these accounting questions
-
Max Corporation purchased its products from a manufacturer & sells them at a retail level. The product costs $5,230 each from the manufacturer & it is sold to customers at an average of...
-
The Human Resource Department at Neumann University would like to examine the relationship between a faculty members performance rating (measured on a scale of 1 20) and his or her annual salary...
-
Accounting Q4 Question completion Status: 3 4 SB 6 7 9 10 QUESTION 3 The following information relates to Questions 3:8. Suppose a research USLOMAS 20 3 4 54 6 7 8 9 10 10 TReport your answer as a...
-
Assume that the average talk time on an Apple iPhone is 20 hours and that this time follows the exponential probability distribution. What is the probability that a randomly selected iPhone will...
-
On January 1, 2011, Delphin Ltd. acquired all the share capital of Telescon Ltd. when Telescons equity consisted of: 100,000 common shares issued at $0.75 each... $75,000 Retained earnings...
-
a) How many nonisomorphic unrooted trees are there with three vertices? b) How many nonisomorphic rooted trees are there with three vertices (using isomorphism for directed graphs)?
-
Imagine you are working for a company that sells teleconferencing equipment. Draft a value proposition for selling your equipment to a sales manager who has ten salespeople traveling two weeks a...
-
A locking C-clamp is used to clamp two pieces of 1/4-in. steel plate. Determine the magnitude of the gripping forces produced when two 30-lb forces are applied as shown. -L9 in-13 tn.- -26 in. 0.55...
-
What strategies do you employ to optimize temporal resource allocation amidst multifaceted commitments and obligations ? Explain
-
Code Churn is a common metric used to measure the efficiency and productivity of software engineers and computer programmers. It?s usually measured as the percentage of a programmer?s code that must...
-
Assume that you recently made a purchase on Amazon.com. The next time you go to purchase this item, lets say you find out that the price has increased by X dollars. How would you respond to this...
-
You manage a software company that requires internet bandwidth to produce output. Currently your company is using 79% of its capacity, but is considering an expansion to utilize the additional...
-
Digi - Flow Inc. issued a bond with a coupon rate of 9 % , payable quarterly. The bond matures in 1 5 years. It has a face value of $ 1 , 0 0 0 and a yield to maturity of 7 % . What is the price of...
-
how to calculate college contribution for the following clients Clients information Martin & Kathleen Martin's Age 58, plans to retire at age 68 Salary $150,000 with expected 4% raise per year...
-
Calculate the PV of a one - time $ 7 5 , 0 0 0 payment to be received in 8 years when the required rate of return ( discount rate ) is 5 % .
-
Your client Idris Elba has come back to you after you sent the email explaining how bridging finance works. He is a little concerned if he does not sell his property in the next 6-12 months he will...
-
4.Write a CSS for the following program to get that desired output: A B C D A B C D
-
The slopes of the tangents at the points where the curve y = x2 - 4x intersects the X-axis is 1) 1 2) +2 3) +3 4) +4
-
Companies U and L are identical in every respect except that U is unlevered while L has $10 million of 5% bonds outstanding. Assume that (1) there arc no corporate or personal taxes, (2) all of the...
-
Suppose a firm estimates its overall cost of capital for the coming year to be 10%. What might be reasonable costs of capital for average-risk, high-risk projects?
-
Assuming the same information as for Problem 21-2, suppose Hastings will increase Vandells level of debt at the end of Year 3 to $30.6 million so that the target capital structure is now 45% debt....
-
Using what you learned in this chapter of Dessler Human Resource Management, build on the companys new system by recommending two more specific career development activities the hotel should...
-
Many hotel jobs are inherently dead end; for example, maids, laundry workers, and valets, either have no great aspirations to move up, or are just using these jobs temporarily, for instance, to help...
-
Should other employees (cleaner/spotters, counter people) be put on a similar plan? Why or why not? If so, how exactly?
Study smarter with the SolutionInn App