Question: 03 (INDEX NUMBERS) Below is the RPI index data for U.K. from 2011 to date. MAR 232.5 DEC 239.4 2011 2012 2013 2014 246.8 253.4

03 (INDEX NUMBERS) Below is the RPI index data for U.K.

03 (INDEX NUMBERS) Below is the RPI index data for U.K. from 2011 to date. MAR 232.5 DEC 239.4 2011 2012 2013 2014 246.8 253.4 257.5 JAN FEB 229.0 231.3 238.0 239.9 245.8247.6 252.6 254.2 255.4 | 256.7 258.8 260.0 265.5 268.4 276.0 278.1 283.0 | 285.0 290.6 292.0 294.6 296.0 240.8 248.7 254.8 257.1 261.1 269.3 2015 2016 2017 APR MAY JUN JUL AUG 234.4 235.2 235.2 234.7 | 236.1 242.5 242.4 241.8242.1 243.0 249.5 250.0 249.7 249.7 251.0 255.7 255.9 256.3 256.0 257.0 258.0 258.5 258.9 258.6259.8 261.4 262.1 263.1 263.4 264.4 270.6 | 271.7 272.3 272.9 274.7 279.7 280.7 281.5 281.7 284.2 288.2 289.2 289.5 291.7 292.6 292.2 292.7 294.2 293.3 301.1 301.9 304.0 305.5 | 307.4 SEP OCT NOV 237.9 238.0 238.5 244.2 245.6 245.6 251.9 251.9 252.1 257.6 257.7 257.1 259.6 259.5 259.8 264.9 264.8 265.5 275.1 275.3 275.8 284.1 284.5 284.6 291.0 290.4 291.0 294.3 294.3 293.5 308.6 260.6 267.1 278.1 289.6 2018 2019 2020 2021 278.3 285.1 292.6 296.9 285.6 291.9 295.4 Your annual salary in 2011 is 23,500. To take care of inflations, your employer been increasing your salary by 2% p.a. up to 2020. NOTE: Please comment on each answers and solution that you provide (a) Determine the yearly RPI for each year by taking the average (mean) of the monthly data. Using this yearly RPI data, index your salary to 2012, and determine for each year if you are earning more or less in real earning. (b) By what percentage increase should your salary be in 2020 to bring your salary in line with inflation? What should be your salary in 2020? (c) Using a simple linear regression and the first three quarter RPI, estimate the monthly RPI for the last quarter of 2021. Hint: use the months Jan - Dec (1 12) as the independent variable and the RPIs as the dependent variable. (d) What percentage increase should your employer offer in 2021 to bring your salary in line with inflation and what is this salary? 03 (INDEX NUMBERS) Below is the RPI index data for U.K. from 2011 to date. MAR 232.5 DEC 239.4 2011 2012 2013 2014 246.8 253.4 257.5 JAN FEB 229.0 231.3 238.0 239.9 245.8247.6 252.6 254.2 255.4 | 256.7 258.8 260.0 265.5 268.4 276.0 278.1 283.0 | 285.0 290.6 292.0 294.6 296.0 240.8 248.7 254.8 257.1 261.1 269.3 2015 2016 2017 APR MAY JUN JUL AUG 234.4 235.2 235.2 234.7 | 236.1 242.5 242.4 241.8242.1 243.0 249.5 250.0 249.7 249.7 251.0 255.7 255.9 256.3 256.0 257.0 258.0 258.5 258.9 258.6259.8 261.4 262.1 263.1 263.4 264.4 270.6 | 271.7 272.3 272.9 274.7 279.7 280.7 281.5 281.7 284.2 288.2 289.2 289.5 291.7 292.6 292.2 292.7 294.2 293.3 301.1 301.9 304.0 305.5 | 307.4 SEP OCT NOV 237.9 238.0 238.5 244.2 245.6 245.6 251.9 251.9 252.1 257.6 257.7 257.1 259.6 259.5 259.8 264.9 264.8 265.5 275.1 275.3 275.8 284.1 284.5 284.6 291.0 290.4 291.0 294.3 294.3 293.5 308.6 260.6 267.1 278.1 289.6 2018 2019 2020 2021 278.3 285.1 292.6 296.9 285.6 291.9 295.4 Your annual salary in 2011 is 23,500. To take care of inflations, your employer been increasing your salary by 2% p.a. up to 2020. NOTE: Please comment on each answers and solution that you provide (a) Determine the yearly RPI for each year by taking the average (mean) of the monthly data. Using this yearly RPI data, index your salary to 2012, and determine for each year if you are earning more or less in real earning. (b) By what percentage increase should your salary be in 2020 to bring your salary in line with inflation? What should be your salary in 2020? (c) Using a simple linear regression and the first three quarter RPI, estimate the monthly RPI for the last quarter of 2021. Hint: use the months Jan - Dec (1 12) as the independent variable and the RPIs as the dependent variable. (d) What percentage increase should your employer offer in 2021 to bring your salary in line with inflation and what is this salary

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!

American Greeting Case Study Question: 2) Figure out the implied enterprise value based on the industry average EBITDA multiple (Exhibit 45.6) and the implied share price. CASE 45 American Greetings...

American Greeting Case Study Question: 3) Figure out the weighted average cost of capital (WACC) based on Exhibits 45.6 and 45.9. CASE 45 American Greetings This year American Greetings is...

(extra information added) Question 1 Barton Ltd manufactures and sells garden ornaments. It prepares accounts to 31 December The income statement for the year ended 31 December 2020 is as follows:...

can someone help me solve this? the data and informatiin is there for JP Morgan Chase with all the instructions. I sent the images in parts. it should be more clear now. unless you want me to email...

An Investment Analysis Case Study This case is a group project that is due on April 1, before class at 10.30. Stating the obvious: Each group will turn in one report (sounds obvious, but might as...

ITM 309: Business Information Technology and Systems Spring 2016 Watson and the new era of cognitive systems Jerry Haan IBM Cloud Ecosystem Development January 27, 2016 2013 International Business...

yes its based on uk tax system Prestbury pic (Prestbury) prepares accounts to 30 September. During the year ended 30 September 2021 x made the following disposals In April 2021 Prestbury sold a...

4. Rachel and Irina have been in partnership since 1 March 2003, preparing accounts to 31 October. Fran was admitted as a partner on 1 August 2018 and Rachel left the partnership on 31 May 2019. The...

Calibri WI 29 Wrap Text Paste ID Copy Format Painter BIU V A Merge & Cen Clipboard Font Alignment 0114 fax 649 A F G H 1 B D E Consumer Price Index - All Urban Consumers 2 Original Data Value K M...

C4) Alfonso runs a sole-trade business with an accounting period ended 31 December. On 1st January 2020, Alfonso purchased a piece of land. On 1st April 2020 he signed a contract with a builder to...

The Grayson Company uses standard costs to account for its production of a specialty cleaning product called Green Clean. The standard cost of materials and direct labour to produce one bottle of...

The Batson Corporation issued $800,000 of 12% face value bonds for $851,705.70. The bonds were dated and issued on April 1, 2007, are due March 31, 2011, and pay interest semiannually on September 30...

Which of the following metals was unknown prior to the discovery of electricity? (a) calcium (b) copper (c) iron (d) tin

SQL Query Question: This is using the PVFC database, so if you have it, please use it. Provide a list of raw materials and quantities required to produce one cherry end table and one oak computer...

1. Assess the simulators sensitivity to parameters that define the Overall Goal Attainment node within the rural resident group IDs. Do this by running the sensitivity analysis option of id and...

2 image from (say) http://emap-int.com and, using the method of Laliberte and Ripple (2003), count the number of horses in this image.

2. Say that there are 2000 cheetahs in all of Tanzania. After looking up the area of this country, find all values of C and C for which the areal detection fraction estimator gives this value...