FIN621 Financial Statement Analysis Assignment No. 01 Solution Fall 2014

[education-2014]

FIN621 Financial Statement Analysis Assignment No. 01 Discussion and Solution Fall 2014 Last Date 1st December 2014





Question # 1:



Life insurance agency was organized on September 01, 2013. Assume that the accounts are closed and financial statements prepared each month. The company occupies rented office space but owns office equipment estimated to have a useful life of 5 years from date of acquisition, September 01, 2013. The trial balance for Life insurance agency at November 30, 2013 is shown below.



LIFE INSURANCE AGENCY

TRIAL BALANCE


[B]NOVEMBER 30, 2013
[TABLE]
[TR]
[TD][B]Particulars[/B]
[/TD]
[TD="width: 104"]

[B]Debit[/B]

[/TD]
[TD="width: 72"]

[B]Credit[/B]

[/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"]

[B]Rs.[/B]

[/TD]
[TD="width: 72"]

[B]Rs.[/B]

[/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Cash
[/TD]
[TD="width: 104"]

6,565

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Account receivable
[/TD]
[TD="width: 104"]

17,050

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Office supplies
[/TD]
[TD="width: 104"]

500

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Office equipment
[/TD]
[TD="width: 104"]

18,000

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Accumulated Depreciation: Office equipment
[/TD]
[TD="width: 104"][/TD]
[TD="width: 72"]

600

[/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[/TABLE]
[/B]
[TABLE]
[TR]
[TD][B]Accounts payable
[/TD]
[TD="width: 104"][/TD]
[TD="width: 72"]

1,260

[/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Capital
[/TD]
[TD="width: 104"][/TD]
[TD="width: 72"]

35,000

[/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Drawing
[/TD]
[TD="width: 104"]

2,500

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Commission earned
[/TD]
[TD="width: 104"][/TD]
[TD="width: 72"]

15,555

[/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Advertising expense
[/TD]
[TD="width: 104"]

1,400

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Salaries expense
[/TD]
[TD="width: 104"]

2,600

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"]Rent expense
[/TD]
[TD="width: 104"]

3,800

[/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][/TD]
[TD="width: 104"][/TD]
[TD="width: 72"][/TD]
[/TR]
[TR]
[TD="width: 317"][B]Total[/B]
[/TD]
[TD="width: 104"]

[B]52,415[/B]

[/TD]
[TD="width: 72"]

[B]52,415[/B]

[/TD]
[/TR]
[TR]
[TD="width: 317"]Life Insurance Agency estimated that only about Rs.300 worth of office supplies remained on hand at November 30, 2013.



You are required to:



a. Prepare adjusting entries at November 30, 2013 to reflect the office supplies used in



November and depreciation expense for the month. (2 Marks)



b. Prepare an adjusted trial balance at November 30, 2013. (2 Marks)



c. Prepare Income Statement and balance sheet at November 30, 2013. (3 + 2 Marks)



Question: 2



What is purpose of making period-end adjusting entries? (1 Marks)
NOTE:



Complete calculations are required for every part of the problem. Incomplete calculations will result in loss of marks.



IMPORTANT:



24 hours extra / grace period after the due date is usually available to overcome uploading difficulties. This extra time should only be used to meet the emergencies and above mentioned due dates should always be treated as final to avoid any inconvenience.



OTHER IMPORTANT INSTRUCTIONS:



DEADLINE:



Make sure to upload the solution file before the due date on VULMS.


Any submission made via email after the due date will not be accepted.


FORMATTING GUIDELINES:



Use the font style “Times New Roman” or “Arial” and font size “12”.


It is advised to compose your document in MS-Word format.


You may also compose your assignment in Open Office format.


Use black and blue font colors only.
[/TD]
[TD="width: 104"][/TD]
[TD="width: 72"]
[/TD]
[/TR]
[/TABLE]
[/B]

[Vuhelper]

please share with me your balance sheet total.any one of you done this?