Xenn Ltd. is a large, profitable CCPC with a December 31 year-end. On incorporation of Xenn Ltd. in 2012, 1000 common shares were issued to Anne Xenn for $1,000. At the beginning of 2013, 800 common shares of Xenn Ltd. were issued to Bill Xenn for $8,000, the fair market value of the shares on that date. At the end of 2014, 500 Class A preferred shares of Xenn Ltd. were issued to Carl Xenn for $7,000, the fair market value of the preference shares on that date. There has been no new issuances, purchases, sales or redemptions of shares since 2014.

From a review of the prior years tax files, the following transactions involve Xenn Ltd.s capital dividend account:

In 2017, they sold a non-depreciable capital asset with an adjusted cost base of $12,693 for cash of $22,266.

In 2018, they sold a non-depreciable capital asset with an adjusted cost base of $8,529 for cash of $2,991.

On July 1, 2021, they sold goodwill for proceeds of $43,276. The goodwill had been internally developed and was not reflected in the Company's records. On July 1, 2021, there was a nil balance in the Company's Class 14.1 UCC.

On October 31, 2022, the Company paid an ITA 83(2) capital dividend of $5,045. The appropriate election was made.

Required: Prepare an excel spreadsheet calculation for the partner, Janet Abbott, that answers the following questions. Be sure to show all of your work for your calculations and state any relevant assumptions.

(a) The total and per share PUC of the common shares and the preference shares of Xenn Ltd.

(b) The total and per share PUC and ACB of the shares of Xenn Ltd. owned by each of Anne, Bill and Carl.

(c) Calculate the Capital Dividend Account (CDA) balance as of December 31, 2022. How much of a tax-free dividend can the corporation pay next year?