hello this sachinn i need help in accounting cycle program

ACC 296

ACCOUNTING CYCLE PROBLEM

SUMMER , 201 9

Please read all directions before starting this assignment.

GENERAL INSTRUCTIONS:

1) With the exception of posting to T -accounts or the ledger, either of which can be handwritten, all other

answers for this assignment are required to be typed using either spreadsheet and/or word processing

so ftware (e.g., Excel, Word, or similar). I recommend using Excel. This means that you cannot use accounting

software such as QuickBooks or similar to process your tr ansactions.

2) Do NOT abbreviate any account titles in your journals, T -accounts (or ledger accounts) or financial

statements. Also, make sure your journal entries are prepared using proper form throughout. In

addition, be sure to include the word ‘ exp ense ’ in the title of any expense account --- and be sure to do so

in your journal entries, T -accounts (or ledger accounts) and financial statements. Likewise, do not use the

word ‘expense’ in the account title if the account is not an expense. Also, you c an omit explanations in all

of your journal entries (unless you want to include them).

3) This assignment is DUE by the start of class on WEDNES DAY , MA Y 29 TH , and is worth points. Unlike

the assigned homework, your grade for this assignment will be bas ed on the correctness of your answers .

Significant points will be deducted for turning in this assignment late. Submissions that are excessively tardy, as

determined by the instructor, will not be accepted and a ‘0’ will be assigned for the assignment. In addition,

failure to complete this assignment will result in a 10 -point penalty in determining your final course grade (i.e.,

in addition to receiving a ‘0’ for the assignment). Submissions by email will not be permitted. Finally, do not

under -estimate the amount of time it will take to complete this assignment!

4) Available Help: This project must be done INDIVIDUALLY and NOT with the assistance of anyone

else . (Please refer to the syllabus related to potential penalties for cheatin g.) Since having a correct solution

stems from having correct journal entries, I will permit each student to verify with me the correctness of up to

three journal entries in total (i.e., from the regular transactional entries and adjusting entries, but no t from the

closing entries). If you type the three entries of your choice and send them to me in an email, I will respond to

you indicating if any of those entries are incorrect. I will not tell you the correct entry, only if yours is not

correct. Please d o not send me attachments or financial statements, only journal entries typed into (or cut

and pasted into) an email. This help is available only through 5:00 p.m. on Tuesday , Ma y 28 th as I cannot

assist you at the last minute (and please remember to use p rofessional email etiquette as I discussed the

first day of class). Of course, you are certainly encouraged to inquire of me if you have questions regarding

your understanding of general concepts related to this assignment. Otherwise, you should not be see king the

help of anyone else to complete the assignment, as it is essentially a take -home portion of the first exam.

SPECIFIC REQUIREMENTS:

1) Provided on the next page is the trial balance of the Ridgewood Golf Club, Inc. as of December 31, 201 8.

They prepare adjusting entries and close their books annually on December 31 st. Create T -accounts (or

general ledger accounts) for each account listed in the trial balance, and enter the balances from the trial balance

into your T -accounts (or general ledger a ccounts) --- and allow a few lines per account. (FYI: I recommend

using T -accounts due to their simplicity, but the choice is yours.) In order to save paper, you can place multiple

T-accounts (or ledger accounts) on a page. For ledger accounts you can u se the standard account format as

illustrated on page 88 or the T -account format illustrated on page 89 (and elsewhere). Note that you must create ONE (and only one ) T -account (or general ledger account) for each and every account (i.e., do not

create mor e than one Cash T -account, more than one Retained Earnings T -account, etc.). (You will use the

same T -accounts for posting regular transactional entries, adjusting entries, and closing entries.) Also, to the

extent possible, organize your T -accounts (or general ledger accounts) so that Assets are together, Liabilities are

together, etc. (Please note that the assumption in this problem is that the ‘regular’ (transactional) entries have

ALREADY been recorded and posted to the T -accounts (or general ledger ), and the trial balance below reflects

that fact. (Therefore, you do not have to record the original journal entries that resulted in the balances shown in

the trial balance --- and in fact, there is no way that you would be able to figure out what those journal entries

were just by looking at the trial balance, anyway.)

Ridgewood Golf Club, Inc.

Trial Balance

December 31, 201 8

Debit Credit

Cash $ 238,000

Accounts Receivable 80,000

Allowance for Doubtful A ccounts $ 1,000

Prepaid Insurance 36 ,000

Land 200,000

Buildings 800,000

Accumulated Depreciation of Buildings 250,000

Equipment 300,000

Accumulated Depreci ation of Equipment 50,000

Common Stock 550,000

Retained Earnings 440 ,000

Dues Revenue 400,000

Greens Fee Revenue 838 ,000

Rent Revenue 275 ,000

Advertising Expe nse

Utilities Expense

50,000

100,000

Salaries and Wages Expense 600,000

Maintenance Expense 400,000

$ 2,8 04,0 00 $ 2,8 04,000

2) Assume the regular transactional entries for the year have already been recorded leading to the account

balances in the trial balance above. However, assume that the following transactions were overlooked and not

previousl y recorded by the company during the year. (These are regular transactional entries, not adjusting

entries). Record the journal entries for these transactions and then post them to your T -accounts (or ledger).

a) On February 1, the company paid cash to purchase supplies for $1 4,000. The company’s policy is to

record the purchase of supplies in an expense account at the time of purchase.

b) On April 1 , an additional building was purchased for $40 0,000 and additional equipment was

purchased for $ 10 0,0 00. The company made a 10% down payment of the total purchase price, and

signed a 1 -year, 4% note payable for the remaining balance. Make one compound entry.

c) On December 1, dividends of $ 12 ,000 we re declared. ( Note: Payment of the dividends will be ma de at a

later date the following year. Hint: Be precise with the account name that is credited.)

3) Record the adjusting journal entries listed below (see letters ‘a -j’) and then post those adjusting

entries to T -accounts (or the ledger). Create new ac counts, as needed. (Again, the company prepares

adjusting entries at year -end only.) Be sure to SHOW YOUR CALCULATION S for each adjusting entry that

requires a calculation (i.e., any adjusting entry for which you add, subtract, multiply, or divide numbers ).

There will be a deduction for each calculation that is missing. Those calculations can appear beneath or next

to the entry or on a separate page. [ Note: Adjusting entries should always be made in journal form first , and

then , only after the journal entr ies have been prepared , should they be posted to T -accounts (ledger accounts).

When your posting is complete, be sure to show ending balances in each T-account (ledger account) .]

a) The amount for prepaid insurance relates to a payment for one year of i nsurance coverage that was

paid for on June 1st of the current year. The insurance coverage began on that date.

b) It is estimated that 5% of the accounts r eceivable will be uncollectible.

c) The rent revenue represents the amount received for 11 m onths for dining facilities. The same

monthly amount is owed from customers for December, but that rent has not yet been received.

(Note: Be specific/descriptive in the account name for the account debited in this entry.)

d) The company paid $ 50,000 in October for several months of television and radio ads and recorded that

amount as Advertising Expense at that time. As of December 31 st, $ 10,000 of those ads have yet to run.

e) Of the $4 00,000 of Dues Revenue on the trial balance, 5% of that amount is considered to be ‘received

in advance’ (i.e., services have not been performed for that portion, yet).

f) Property taxes incurred but not yet paid amount to $ 60,000. (Be specific in both account names here.)

g) Of the supplies purchased in 2a ) above, $ 3,000 worth were u nu sed as of December 31 st

h) The building referred to in 2b) above has an estimated useful life of 30 years and an estimated salvage

value of $40,000. Use the straight -line method to record depreciation for 201 8. (Note: A ssume for

simplicity that depreciation was already recorded for all other buildings; you only have to record

depreciation for this new building.)

i) The equipment referred to in 2b) above has an estimated salvage value of $0 and is depreciated at

a ra te of 20% per year. Record depreciation for 201 8. (Note: Assume depreciation was already recorded

for all other equipment ; you only have to record depreciation for this new equipment. )

j) Record the accrued interest on the note from the April 1st tra nsaction from 2b) above.

4) Using your updated balances in your T -accounts (or ledger) prepare the year -end income statement,

statement of retained earnings, and balance sheet for 201 8. Be sure to use proper form in preparing your

financial statements, including proper headings and dating of the financials . Page 161 (Single -Step Income

Statement), p. 111 (Statement of Retained Earnings), and p. 112 (Balance Sheet) provide good examples to

follow for this requirement (but obviously, you will have some di fferent account names than the examples

provided in the text). For your balance sheet, be sure to use your updated retained earnings balance from your

statement of retained earnings since you have not prepared closing entries, yet. For your income statemen t, be

sure to list each revenue and expense account, but do not worry about computing income tax expense.

5) Prepare closing entries (using compound entries where appropriate) and post them to your T -accounts

(or ledger). Put these journal entries on a separate page from your adjusting journal entries and label them ,

‘Closing Entries .’ (When posting, be sure to create a T -account or ledger account for Income Summary.)

6) Place your name at the top right corner of every page and make sure that each pa rt is clearly and

precisely identified . Your submission should be neatly prepared and free of spelling mistakes, and please

note that points can be deducted for unprofessional / non -neat work and/or for multiple spelling

mistakes. Arrange all your work in the following order (and please note that points will be deducted if

items are not submitted in this order): 1) The three additional ‘regular’ transactional entries, 2) Adjusting

entries, 3) Income statement, 4) Statement of retained earnings, 5) Bal ance sheet, 6) Closing entries, and 7)

T-accounts or general ledger accounts. [Note: You can combine more than one financial statement on one page,

if you wish --- assuming they ‘fit’ on one page and it is clearly readable and not too small.] Do not use a report

cover; simply staple once in the upper left hand corner.