I'm stuck on a question. Okay, the PRE-adjustment trial balance as at 30 June 2013 says the Prepaid Rent Expense is 9000. Reports are prepared on a quarterly basis. The Prepaid Rent Expense was paid 12months in advance on 1 January 2013, Calculate the Prepaid Rent Expense balance as at 30 June 2013.
So the answer is 6000 but I dont know how they got that because in my eyes,
9000 represents 12 months so thats 750 per month and 2250 per quarter and after one quarter (Jan to March) the Prepaid Rent Expense would be 6750 so then after another quarter (Apr-June) it should be 6750-2250 which is 4500. What am I doing wrong? :/
Its from a PES Exam btw.
Yes the balance is 6000.
You gotta work backwards with this question, and it helps to draw up a timeline.
Okay, so with this Question, the first thing to note, is that Reports are prepared quarterly, and since we have been told that we are now on Balance Day at June 30 2013, it means that this Reporting Period is April-June. Why? Quarterly is three months, so counting backwards from June three months is April 1. It might help if I said these are the Reporting Periods:
* Jan, Feb, March
* April, May, June
* July, August, September
* October, November, December
Sometimes they may trick you and it won't be as simple as that for quarterly Reporting Periods, which is why you gotta work backwards from the date given.
So from this timeline, where are we?
* Jan, Feb, March
* April, May,
June <----- HERE! We're on Balance Day for the end of the Reporting Period, so June 30.
* July, August, September
* October, November, December
Now look back at the Balance of the Prepaid Rent Expense and it was $9000. This was as at April 1, 2013 because the Reporting Period is April to June. Then, look at when the Prepaid Rent Expense was paid, and for how long. So we can see that it was paid on January 1 2013 for 12 months (annual). So, January, February and March have already been accounted for, and the Expense was allocated in the previous Reporting Period as at March 31, so cross them out:
*
Jan, Feb, March* April, May,
June <----- HERE! We're on Balance Day for the end of the Reporting Period, so June 30.
* July, August, September
* October, November, December
After the last Reporting Period concluded, how many months were left on the Prepaid Rent Expense? 12 minus 3 (Jan, Feb, March) = 9. So as at April 1, 9 Months are left. So now, the balance was 9000, and divide this by 9 months remaining = $1000 per month is the Expense, so for a Reporting Period, its 3x$1000=$3000
So now, the question is asking, whats the balance as at June 30 2013. So now we need to take off another 3 months (April, May, June) because we have already consumed them.
*
Jan, Feb, March*
April, May, June <----- HERE! We're on Balance Day for the end of the Reporting Period, so June 30.
* July, August, September
* October, November, December
How many months left on the Prepaid Rent Expense? 6 months. And just before, we calculated the amount for each month is $1000 per month. So 6 x $1000 = $6000 remaining for the Prepaid Rent Expense, as at June 30 2013.
Hope this helps! I tried to break it down as much as I could, but if you still don't get one of the steps, let me know.
The mistake you made was thinking that the whole Prepaid Rent Expense paid on January 1 2013, was $9,000, and missed the Balance Day date on March 31 2013, when the Expense for January to March was already accounted for and recognised as an Expense in the previous Reporting Period.