£20,672.50VAT 20%CT 25%£8,502.64£12,165.55£32,444.11=B7*0.2CT 25%=B7*0.2YE 31/03£29,877.0531 JAN£19,807.69£41,333.71£12,570£75,768.81£13,670.70=B7*0.2£90,000×1.2NI 8%NI 8%£33,461.23Δ +8.4%£40,254.67£45,920.93
£80,717.09£55,704.2131 JAN×1.2£88,484.09=B2-B3£46,798.76£60,695.08Q3£87,951.08£92,845.39NI 8%£51,466.85£61,415.45£16,247.63£38,574.16YE 31/03£65,978.10£53,544.70£18,847.55Q3P&LYE 31/0331 JAN£20,730.29=SUM(B2:B13)
£78,117.23£1,436.18£49,298.7831 JAN=ROUND(D9,2)=B7*0.2£90,104.71£53,194.50£84,037.51£9,727.26£15,308.43CT 25%£20,726.68£48,559.78£28,156.78£84,053.32P&L£16,019.62NI 8%£41,775.10£45,809.94£91,609.20=IF(C4>90000,"VAT","")=ROUND(D9,2)£91,348.69=ROUND(D9,2)
£85,168.11Q3£12,570£30,101.68=ROUND(D9,2)£30,134.78=IF(C4>90000,"VAT","")YE 31/03Δ +8.4%£65,489.45=SUM(B2:B13)£90,000£91,670.77NI 8%P&LP&L£14,289.29£45,167.26£80,888.00£86,487.44VAT 20%CT 25%=IF(C4>90000,"VAT","")£24,299.55=B2-B3£52,783.59
£12,030.92£17,551.03£61,894.83£79,001.60P&L£72,764.16£86,054.1331 JAN£26,433.27£28,789.37=B2-B3£55,820.16£47,271.58=ROUND(D9,2)£66,652.16=ROUND(D9,2)NI 8%=SUM(B2:B13)31 JAN£62,961.79£1,048.00£90,334.66£90,000CT 25%=B7*0.2£37,196.05
=ROUND(D9,2)£4,552.97VAT 20%£81,185.64=IF(C4>90000,"VAT","")NI 8%£90,000Δ +8.4%Q3=IF(C4>90000,"VAT","")31 JAN£52,327.56£88,869.30£28,777.85£16,936.99£94,763.8231 JAN£18,890.59£13,237.50£12,570Δ +8.4%£57,460.65£56,117.25£12,984.92£45,199.70£93,063.02
£68,721.79£9,326.14Δ +8.4%CT 25%£36,541.05£12,570£17,881.54Q3£71,233.65=B2-B3£8,440.88£10,391.34VAT 20%VAT 20%Δ +8.4%£16,848.58£73,391.53Q3=B7*0.2Δ +8.4%£12,570£24,643.25MTD=IF(C4>90000,"VAT","")£66,447.86£46,382.02
=B7*0.2£67,177.70=ROUND(D9,2)£59,496.13×1.2£1,048.00YE 31/03MTDΔ +8.4%£93,531.93YE 31/03=B7*0.2=SUM(B2:B13)£34,401.55£11,973.85=ROUND(D9,2)MTDMTD£25,194.20£1,374.33£44,013.70£5,415.39£24,880.00£11,895.60£86,885.25£1,548.11
