The question is 'Assume tax is paid one year after the year of income'. Is this first year of cashflows or to account for this, create a year 11?

An as per example below, I have an after tax terminal cash flow from the sale of the building $69 500 ($19500 tax shield and $50000 loss on disposal), where does this get inserted into the spreadsheet example below?

Salvage value of asset After tax value $305 000.00 30 500.00 $335 500.00 Sale of Fixed Asset - Building Land ($500 000 00-39%) Building ($50 000.00-39%) Total Salvage Value Accumulation Depreciation ($200 000/20 10) $100 000.00 Loss on dispoal Tax Shield After tax cash flow $50 000.00 $50 000.00 |$19 500 00 $69 500.00 $50000"39% Calculation of Depreciation Amount Farm building ($200 000.00/20 years) Farm equipment ($400 000.00/10 years) $40 000.00 Total depreciation $10 000.00 $50 000.00 TYPE/YEARS YEAR 10 YEAR O YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 YEAR 6 YEAR 7 YEAR 8 YEAR 9 Investment in land Investment in farm buildings Investment in farming equipment Net Working Capital investment Annual Cash Sales Less Annual Operating costs Operating Income/Profit Less Depreciation Costs Earnings Before Tax Less Taxation (39%) Net Income Add Depreciation Salvage value of assets after tax Net Working Capital Net Annual Cash Flows 1,000,000.00 200,000.00 -400,000.00 250,000.00 3,000,000.003,000,000.00 3,000,000.00 2,200,000.002,200,000.00-2,200,000.00 800,000.00 800,000.00 800,000.00 50,000.00 750,000.00750,000.00 750,000.00 292,500.00292,500.00 292,500.00 457,500.00 457,500.00 457,500.00 50,000.00 3,000,000.00 3,000,000.003,000,000.003,000,000.003,000,000.003,00O,000.00 3,000,000.00 2,200,000.002,200,000.00-2,200,000.00-2,200,000.00 -2,200,000.002,200,000.00-2,200,000.00 800,000.00 800,000.00 800,000.0O 800,000.00800,000.00800,000.00 800,000.00 50,000.0050,000.0 50,000.0050,000.0050,000.00 750,000.00 750,000.00 750,000.00 750,000.00 750,000.00750,000.0750,000.00 292,500.00 292,500.00292,500.00 292,500.00292,500.00292,500.0029,500.00 457,500.00 457,500.00 457,500.00 457,500.00 457,500.00457,500.0 457,500.00 50,000.00 335,500.00 250,000.00 50,000.00 50,000.00 50,000.00 -50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 50,000.00 1,850,000.00 507,500.00507,500.00 507,500.00 507,500.00 507,500.00507,500.00507,500.00 507,500.00 507,500.00 1,093,000.00