please kindly help me with this questions, the rest of the questions are on the comments. please avoid the part where I have to use excel to calculate the answers

PART A: QUESTION 1 Peanut Limited is a South African company that sells an assortment of peanuts to retail outlets throughout South Africa. Peanut Limited operates out of their premises in the Mankweng area. Peanut Limited buy their peanuts in bulk lots where after they sorts, spice, roast and packages the peanuts into smaller packets. The peanuts are then distributed to their customers across South Africa. Peanut Limited has a 30 June financial reporting period end. The following information relates to Peanut Limited: 1 . The following is a list of balances that was extracted from Peanut Limited's pre- adjustment trial balance on 30 June 2018: R Stated capital 1 000 Retained earnings 4 022 000 Bank (debit balance) 525 600 Trade receivable 5 068 000 Allowance for credit losses 608 700 Inventory 4 222 800 Plant @ cost 6 900 000 Plant - accumulated depreciation 2 587 500 Equipment @ cost 4 380 000 Equipment - accumulated depreciation 1 533 000 Vehicles @ cost 3 960 000 Vehicles - accumulated depreciation 1 806 000 Trade payables 3 866 000 Mortgage loan 4 288 702 Income tax payable/receivable (debit balance) 1 600 000 2 Net profit before tax of R7 943 498 was determined BEFORE taking into account the following information: (1) Inventory on hand on 30 June 2018 was valued as follows: Raw material R 975 000 WIP R 325 000 Finished goods R3 800 000 Peanut limited uses the periodic inventory system to account for their inventory. The amount for inventory as reflected in the list of balances is in relation to the inventory that was on hand at 1 July 2017. (i) On 29 June 2018 one of Peanut Limited's customers paid R453 000 in advance for a large order of peanuts. The peanuts were only ready for delivery on 10 July 2018. (ii) Rent for July 2018 of R120 000, had been paid in advance. (iv) An annual insurance premium of R180 000 was paid for the period 1 April 2018 to 31 March 2019. (v) The water and electricity account for June 2018 was only received from the municipality on 15 July 2018. The amount for June 2018 with regards to their water 5 CACCO 12 - Semester Assignment 2020 (vi) The Chief Financial Officer discovered that the loss on disposal of a vehicle as per the trial balance has been incorrectly calculated, as the bookkeeper failed to account for the trade-in value of the old vehicle that was received from the dealer of R250 000 on 30 April 2018 that was utilised on the new vehicle purchased. The cash amount paid for the new vehicle amounted to R360 000. This error also affects the balance of the new vehicle in the asset account as well as the depreciation that was calculated on the new vehicle. At the date of purchase, the new vehicle had an estimated useful life of 8 years and a residual value equal to 20% of the vehicles total cost. The company calculated depreciation on vehicles using the straight-line method. (vii) The income tax amounts to R2 248 500 for the 2018 tax period