AC202/ACC2004 Financial Accounting Standards and Corporate Reporting Excel Assignment – 15%

Farhmahouse Ltd reported sales revenue of $16 million for the year ended 30 June 2013. In preparing the financial statements the following matters were considered:

(a) Income tax expense for the year ended 30 June 2013 was $218 640.

(b) Financial restructuring has resulted in the disposal of land, bought in 2002 for future expansion, for a profit of $200 000.

(c) A dividend of $26 000 has been received from a subsidiary company.

(d) Other expenses incurred:

Interest $480,000
Wages and salaries 5,492,000
Selling expenses 2,500,000
Administration expenses 100,000
Bad debts 200,000
Other expenses 440,667
Electricity/water 480,000
Cost of sales 5,000,000

 

 

(e) On 10 October 2012, plant with a carrying amount of $320 000 was destroyed by an earthquake.

 (f) During the period, non-current assets were revalued upwards by a net $120 000.

(g) The foreign currency translation reserve fell by $60 000 as a result of translating the financial statements of a foreign operation.

(h) Balance of retained earnings as at 1 July 2012 was $567 040.

 

Required Prepare a statement of comprehensive income with relevant notes in accordance with the requirements of AASB 101. You are required to prepare this assignment on excel using formulas.

Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.


If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.