I need excel sheet please

AP $13-7($Comprehensive Corporate Income Tax Payable$)$

Falko Ltd$.$ is a CCPC with a calendar$-$based taxation year end. For its $2023$ taxation year ending

December $31,2023,$ its accounting net income before income tax, as determined using generally

accepted accounting principles $($ASPE$),$ was $$1,029,700.$ Relevant information for the $2023$ taxa$-$tion year necessary to make the appropriate reconciliation adjustments to net income for income

tax purposes, taxable income, and federal income tax payable is as follows:

$1.$ Falko$$s amortization expense was $$494,500.$ Maximum deductible CCA for the year was

$$713,000.$ Company policy has always been to claim the maximum available CCA.

$2.$ The company$$s revenues included foreign source investment income of C$$44,000.$ The amount

received, however, was only C$$36,080$ as a result of foreign withholding income tax of $18\%,$ or

$$7,920.$ The company only recorded the amount received as revenue.

$3.$ Falko sold one of its buildings that required costly renovations in favour of leasing a building. The

total sales price was $$1,725,000$ with $$500,000$ allocated to the land and $$1,225,000$ to the build$-$ing. The original cost of the land and therefore its ACB was $$650,000.$ The capital cost and ACB

of the building was $$1,000,000$ and its UCC at the time of sale was $$885,000.$ For accounting

purposes the carrying value of the building was $$710,000.$ The company records accounting gains

and accounting losses based on the carrying value for the buildi

$$

$9.$ At December $31,2022,$ Falko had an eligible RDTOH balance of $$19,446,$ a non$-$eligible RDTOH

balance of $$73,670,$ and a GRIP account balance of $$24,000.$ In $2022,$ Falko paid taxable divi$-$dends of $$118,800,$ $$18,800$ of which were designated as eligible. As a result of paying the

dividends, Falko received a dividend refund of $$45,540[(381/3\%)($$$118,800)]$; $$7,207$ of the

dividend refund $[($$$18,800)(381/3\%)]$ was attributable to the eligible RDTOH and the remainder

of $$38,333[($$$100,000)(381/3\%)]$ was attributable to its non$-$eligible RDTOH.

$10.$ The combined AAII for the two associated corporations for the $2022$ taxation year is $$47,190$

and will be $$62,770$ for $2023.$ The TCEC of the two associated corporations totals $$6,445,000$

for the $2022$ taxation year and will equal $$10,960,000$ for $2023.$

$11.$ Falko has a $2019$ non$-$capital loss balance of $$112,000$ and a $2021$ net capital loss balance

of $$16,930.$ Falko$$s management has indicated that they wish to deduct the maximum

amount of these losses possible for the $2023$ taxation year.

$12.$ Falko and its wholly owned subsidiary Lands have agreed to split the annual small business

limit $50-50$ for the $2023$ taxation year.

Required:$$ Show all of the calculations used to provide the following required information, includ$-$ing those for which the result is nil.

$$

A$.$ Calculate Falko$$s minimum $2023$ net income and taxable income.

B$.$ Assume the foreign non$-$business tax credit is equal to the foreign tax withheld. Calculate Falko$$s

Part I tax payable for the $2023$ taxation year. As the corporation carries on manufacturing in a

province that has a reduced rate for M&P activity, a separate calculation of the federal M&P

deduction is required.

C$.$ Calculate the refundable portion of Falko$$s Part I tax payable for $2023.$

D$.$ Calculate Falko$$s $2023$ Part IV tax.

E$.$ Determine the December $31,2023,$ balance in Falko$$s GRIP account.

F$.$ Determine the December $31,2023,$ balances in Falko$$s eligible RDTOH and the non$-$eligible RDTOH.

G$.$ Calculate Falko$$s dividend refund for the $2023$ taxation year, showing separately the amount

attributable to eligible dividends and the amount attributable to non$-$eligible dividends.