{"id":185601,"date":"2025-01-22T18:26:45","date_gmt":"2025-01-22T18:26:45","guid":{"rendered":"https:\/\/learnexams.com\/blog\/?p=185601"},"modified":"2025-01-22T18:26:47","modified_gmt":"2025-01-22T18:26:47","slug":"income-taxation-assessment","status":"publish","type":"post","link":"https:\/\/www.learnexams.com\/blog\/2025\/01\/22\/income-taxation-assessment\/","title":{"rendered":"Income Taxation Assessment"},"content":{"rendered":"\n<p>Income Taxation Assessment<br>Read through the requirements below, and then complete all parts of the assessment. Save your work as an EXCEL (.xlsx) file and click on the Assessment Submission link within this course. Upload your completed assessment to your tutor for marking.<\/p>\n\n\n\n<p>What you need to do before you start?<br>\u00b7 Revise taxation material for:<\/p>\n\n\n\n<p>o Calculating Tax \u2013 Worked Example \u2013 Sam\u2019s Trucking Ltd<\/p>\n\n\n\n<p>o Income Tax Return Preparation for IR10\/IR4<\/p>\n\n\n\n<p>o Company Taxation \u2013 Imputation Credit Accounts\/IR4J<\/p>\n\n\n\n<p>o FBT \u2013 Motor Vehicles, Loans, FBT on Goods<\/p>\n\n\n\n<p>Highly Recommend:basic Microsoft Excel skills is required for this assessment; you will be expected to use basic formulas as it will also assist with future submission (if required). Without these formulas, tutors are unable to provide detailed feedback to your calculations.<\/p>\n\n\n\n<p>Chloe\u2019s Model Trains<\/p>\n\n\n\n<p>Chloe Winston operates a small company that buy, restores and sells model trains. She has given the latest financial statements for her business activities during the past year.<\/p>\n\n\n\n<p>Your job will be completing the end of year returns for the year ended 31 March 20X3.<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Read all the information covered in the \u2018Chloe\u2019s Model Trains\u2019 tab.<\/li>\n\n\n\n<li>Using the Income Statement and Additional information sections you are required to complete the Tax Calculation Sheet for Chloe\u2019s Model Trains.<\/li>\n\n\n\n<li>Refer back to the Income Statementand the Tax Calculation Sheet to complete extracts of the IR10 andfill in the IR4.<\/li>\n\n\n\n<li>Complete the tax calculation AND provisional tax extract of the IR4.<\/li>\n\n\n\n<li>Complete the shareholder information for Chloe and state the amount of income you will enter in the IR3 to declare on Chloe\u2019s Tax Return.<\/li>\n\n\n\n<li>Using the additional transaction on the \u2018ICA\u2019 tab, prepare the workings to the ICA for Chloe\u2019s Model Trains. Then fill in the imputation credit return.<\/li>\n\n\n\n<li>Using the additional Information on the \u2018FBT\u2019 tab, complete the FBT workings (showing all explanations and calculations) and the what would appear for the Inland Revenue Remember: Chloe is files on an annual basis and she is on the single rate FBT Rate of 49.25%.<\/li>\n<\/ol>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-ast-global-color-6-color\">The correct answer and explanation is:<\/mark><\/strong><\/p>\n\n\n\n<p>To assist you in completing this assessment, I will guide you through each requirement. Here&#8217;s how you can systematically approach the task. Once you\u2019ve gathered all necessary financial and additional information, you can proceed to complete the assessment in Excel. Below is an explanation and breakdown for each requirement:<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step-by-Step Guidance<\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\">1. <strong>Review Information in \u2018Chloe\u2019s Model Trains\u2019 Tab<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Familiarize yourself with the financial statements and additional information provided.<\/li>\n\n\n\n<li>Identify revenue, expenses, and other relevant tax data such as deductible\/non-deductible items.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">2. <strong>Tax Calculation Sheet<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the Income Statement to calculate taxable income:\n<ul class=\"wp-block-list\">\n<li>Adjust the net profit by adding back non-deductible expenses (e.g., entertainment costs, fines).<\/li>\n\n\n\n<li>Deduct non-taxable income (e.g., capital gains).<\/li>\n\n\n\n<li>Account for any tax losses carried forward.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Apply the corporate tax rate to determine the tax liability.<\/li>\n\n\n\n<li>Show all calculations clearly using formulas in Excel.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">3. <strong>Extracts of IR10 and IR4<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use data from the Income Statement and Tax Calculation Sheet to populate:\n<ul class=\"wp-block-list\">\n<li>IR10: Summarize income, expenses, assets, liabilities, and equity.<\/li>\n\n\n\n<li>IR4: Include taxable income, deductions, and tax payable.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Ensure accuracy in transferring values and applying adjustments.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">4. <strong>Provisional Tax<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Calculate the provisional tax based on the prior year\u2019s tax liability or current year\u2019s estimate.<\/li>\n\n\n\n<li>Show workings for each installment due.<\/li>\n\n\n\n<li>Record the provisional tax paid in the IR4 extract.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">5. <strong>Shareholder Information<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Calculate the shareholder\u2019s income (e.g., dividends declared or shareholder salary).<\/li>\n\n\n\n<li>Determine the amount to be reported in Chloe\u2019s IR3.<\/li>\n\n\n\n<li>Ensure consistency with company tax figures.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">6. <strong>Imputation Credit Account (ICA)<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Start with the opening balance of the ICA.<\/li>\n\n\n\n<li>Adjust for:\n<ul class=\"wp-block-list\">\n<li>Tax paid.<\/li>\n\n\n\n<li>Credits attached to dividends distributed.<\/li>\n\n\n\n<li>Refunds or any other transactions affecting the ICA.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Complete the ICA return based on these workings.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h4 class=\"wp-block-heading\">7. <strong>FBT Workings<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Identify benefits subject to FBT (e.g., motor vehicles, loans, goods).<\/li>\n\n\n\n<li>Calculate the FBT payable using the single rate of <strong>49.25%<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Include the gross-up formula for cash and non-cash benefits.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Provide detailed explanations of calculations and assumptions.<\/li>\n\n\n\n<li>Record the FBT liability in the FBT return.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Excel Spreadsheet Setup<\/strong><\/h3>\n\n\n\n<p>Your spreadsheet should include the following tabs:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Income Statement<\/strong>: Copy and adjust Chloe\u2019s financial data for tax purposes.<\/li>\n\n\n\n<li><strong>Tax Calculation<\/strong>: Detailed workings for taxable income and tax liability.<\/li>\n\n\n\n<li><strong>IR10 Extract<\/strong>: Summarized financial details.<\/li>\n\n\n\n<li><strong>IR4 Extract<\/strong>: Tax and provisional tax calculations.<\/li>\n\n\n\n<li><strong>Shareholder Info<\/strong>: Chloe\u2019s personal income and tax details.<\/li>\n\n\n\n<li><strong>ICA Workings<\/strong>: Adjustments and return summary.<\/li>\n\n\n\n<li><strong>FBT Workings<\/strong>: Calculations and Inland Revenue summary.<\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Explanation<\/strong><\/h3>\n\n\n\n<p>The 300-word explanation should summarize:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Adjustments made to the income statement for tax purposes.<\/li>\n\n\n\n<li>Key figures reported in the IR10 and IR4.<\/li>\n\n\n\n<li>The calculation method for taxable income, provisional tax, and FBT.<\/li>\n\n\n\n<li>How shareholder income was determined.<\/li>\n\n\n\n<li>The purpose of the ICA and how it tracks tax credits.<\/li>\n\n\n\n<li>Compliance with tax laws and use of Excel formulas for accuracy.<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>Would you like me to create a draft Excel structure or provide a detailed explanation template for your written summary?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Income Taxation AssessmentRead through the requirements below, and then complete all parts of the assessment. Save your work as an EXCEL (.xlsx) file and click on the Assessment Submission link within this course. Upload your completed assessment to your tutor for marking. What you need to do before you start?\u00b7 Revise taxation material for: o [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[25],"tags":[],"class_list":["post-185601","post","type-post","status-publish","format-standard","hentry","category-exams-certification"],"_links":{"self":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts\/185601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/comments?post=185601"}],"version-history":[{"count":0,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/posts\/185601\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/media?parent=185601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/categories?post=185601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.learnexams.com\/blog\/wp-json\/wp\/v2\/tags?post=185601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}