Retirement Contribution Matching: Christopher works as a Consultant at a private firm and his plan offers pre-tax contribution for every dollar ahe puts in her Keogh Plan. He earns $800,000 salary and $185,000 in bonunes is considering his options between 1%,2%,3%,4%,5%, and 6% contributions for 2019 . Calculate the percentages and calculations using hints and comments below. Use absolute cell locking and relative cell locking to drag your formulas across bike cellin to sove time and be efficient. Ceristegheric Contribution (N) Amount of Baie Salary Amount of Bonus Amount of Grous income Alluwed Contribusin is Kench Dias Tasable incorses Marconal teifiate of 338 Afer Tar income (Disposal inceme) Keogh Plans Ony; it someone is selt-employed, and the Keogh account is their only retirement plan, their contribution limit is $55,000 or 100% of eliglole compensation, whichever is less for the tax year 2018. In 2019, the contribution increases to $56,000. 347,2013