Question: Part B: (7 marks) RRSP contributions $5,000, remaining (March - December) of year from RBC Mary has made a RRSP contribution this year to reduce

Part B: (7 marks) RRSP contributions $5,000, remaining (March - December) of year from RBC Mary has made a RRSP contribution this year to reduce her taxes, her current available room is $36,000. Required: Prepare a sensitivity analysis in $1,000 increments beginning with $5,000 up to $10,000 in total contributions for Mary's RRSP contribution to determine how much more/less would she have to contribute to owe zero taxes after instalment payments are applied? Prepare a table and graph detailing your analysis to be submitted to the Week 11 Case Study 2b drop box. Ensure that you show and label your work. (hint: use Excel) Part B: (7 marks) RRSP contributions $5,000, remaining (March - December) of year from RBC Mary has made a RRSP contribution this year to reduce her taxes, her current available room is $36,000. Required: Prepare a sensitivity analysis in $1,000 increments beginning with $5,000 up to $10,000 in total contributions for Mary's RRSP contribution to determine how much more/less would she have to contribute to owe zero taxes after instalment payments are applied? Prepare a table and graph detailing your analysis to be submitted to the Week 11 Case Study 2b drop box. Ensure that you show and label your work. (hint: use Excel)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
