Instruction: All the solutions must be completed by the Microsoft Excel program and all the calculations should be performed by excel functions. All the solutions will be in a single excel file in separate sheets. A hand-written pdf copy is also necessary to submit along with the excel file.

The Balance Sheet of Swan Ltd, as on 313.2018 was as follows: Balance Sheet of Swan Ltd. as at 31st March, 2018 Notes to Accounts : (1) Share Capital The following scheme of reconstruction was adopted : (a) The preference shares be reduced to an equal number of fully paid shares of 50 each. (b) The equity shares be reduced to 25% of their present values. (c) The amount available be used to write-off 30,800 from leasehold premises, 15,000 from stock, 20\% off plant and machinery and sundry debtors. The balance available will be utilised in writing-off patents after the remaining intangible assets are written-off in full. Joumalise the transactions in the books of the Company and prepare the Balance Sheet after the reconstruction