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

Answer rating: 100% (QA)

semi annual rate s 475 annual interest rate r 1snn1 where n no o... View the full answer