Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please solve tasks 1, 2, & 3 written on sheet 1 (tab 1) at the bottom. There are three 3 sheets and all must be

image text in transcribed

Please solve tasks 1, 2, & 3 written on sheet 1 (tab 1) at the bottom. There are three 3 sheets and all must be done. I've done #1 but need confirmation if done correctly and i'm definitely stuck on 2 & 3. The highlighted part is what needed to be solved. Thank you!

image text in transcribed Deferred Revenue & Expense Schedule Sales Month Jan-13 Jan-13 Jan-13 Jan-13 Account Name Website Set-up Fees Social Set-up Fees Maps Set-up Fees Other Revenue Account Type Sales Amount Revenue $ 190,425.00 Revenue $ 23,531.00 Revenue $ 37,802.00 Revenue $ 6,672.00 Deferral Term 39 1 12 39 Jan-13 4,882.69 23,531.00 3,150.17 171.08 Feb-13 4,882.69 Mar-13 4,882.69 Apr-13 4,882.69 May-13 ### Jun-13 4,882.69 Jul-13 4,882.69 Aug-13 4,882.69 Sep-13 4,882.69 Oct-13 4,882.69 Nov-13 4,882.69 Dec-13 4,882.69 Jan-14 4,882.69 Feb-14 4,882.69 Mar-14 4,882.69 Apr-14 4,882.69 3,150.17 171.08 3,150.17 171.08 3,150.17 171.08 ### ### 3,150.17 171.08 3,150.17 171.08 3,150.17 171.08 3,150.17 171.08 3,150.17 171.08 3,150.17 171.08 3,150.17 171.08 171.08 171.08 171.08 171.08 (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) ### ### (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) (342.66) (330.22) (342.66) (342.66) (342.66) (342.66) Jan-13 Jan-13 Royalty Expense - Web Sites Map Directory Listing Expense Expense Expense $ $ (13,363.85) (3,962.60) 39 12 Feb-13 Feb-13 Feb-13 Feb-13 Website Set-up Fees Social Set-up Fees Maps Set-up Fees Other Revenue Revenue Revenue Revenue Revenue $ $ $ $ 178,392.00 24,853.00 34,129.00 7,287.00 39 1 12 39 4,574.15 24,853.00 2,844.08 186.85 4,574.15 4,574.15 ### 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 2,844.08 186.85 2,844.08 186.85 ### ### 2,844.08 186.85 2,844.08 186.85 2,844.08 186.85 2,844.08 186.85 2,844.08 186.85 2,844.08 186.85 2,844.08 186.85 2,844.08 186.85 186.85 186.85 186.85 Feb-13 Feb-13 Royalty Expense - Web Sites Map Directory Listing Expense Expense Expense $ $ (12,734.40) (3,545.25) 39 12 (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) ### ### (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) (326.52) (295.44) (326.52) (326.52) (326.52) Mar-13 Mar-13 Mar-13 Mar-13 Website Set-up Fees Social Set-up Fees Maps Set-up Fees Other Revenue Revenue Revenue Revenue Revenue 183,602.00 39 1 12 39 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 3,512.75 189.94 189.94 189.94 189.94 189.94 Mar-13 Mar-13 Royalty Expense - Web Sites Map Directory Listing Expense Expense Expense 39 12 (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) Sales Month Account Name Total 2013 Website Set-up Fees - Custom Total 2013 Social Set-up Fees Total 2013 Maps Set-up Fees Total 2013 Other Revenue Sales Month Account Name Royalty Expense - Web Sites Map Directory Listing Expense 42,153.00 7,407.52 (19,248.52) (12,540.00) Account Type Sales Amount Deferral Term 552,419.00 39 Revenue 76,761.00 1 Revenue 114,084.00 12 Revenue Revenue TOTAL Total 2013 Total 2013 28,377.00 21,366.52 764,630.52 39 Account Type Sales Amount Deferral Term (45,346.77) 39 Expense Expense TOTAL (20,047.85) (65,394.62) 12 28,377.00 Jan-13 Feb-13 Mar-13 4,882.69 23,531.00 3,150.17 171.08 31,734.94 9,456.85 24,853.00 5,994.25 357.92 40,662.02 14,164.59 76,761.00 9,507.00 547.86 Jan-13 Feb-13 Mar-13 (669.19) (625.65) (1,294.84) (1,162.74) (1,670.65) (342.66) (330.22) (672.88) Balance @ 3/31/13 Account # 28,504.13 4000 125,145.00 4001 18,651.42 4002 1,076.86 4005 173,377.40 Deferred Revenue Balance @ 3/31/13 Account # (2,174.59) 6314 (2,626.53) 5389 (4,801.11) Deferred Expenses Tasks 1. Using the Unadjusted March 2013 Income Statement, complete the Deferred Revenue & Expense Schedule for the deferred revenue and expenses for March 2013 2. Based upon the results of the Deferred Revenue & Expense Schedule, prepare the journal entry required for March 2013 to defer the related revenues and expenses from the Deferred Revenue & Expense Schedule 3. Use the journal entry to post the adjustments in the March Income Statement and March Balance Sheet to come up with the "Adjusted" Income Statement and "Adjusted" Balance Sheet May-14 4,882.69 Jun-14 4,882.69 Jul-14 4,882.69 Aug-14 4,882.69 Sep-14 4,882.69 Oct-14 4,882.69 Nov-14 4,882.69 Dec-14 4,882.69 Jan-15 4,882.69 Feb-15 4,882.69 Mar-15 4,882.69 Apr-15 4,882.69 May-15 4,882.69 Jun-15 4,882.69 Jul-15 4,882.69 Aug-15 4,882.69 Sep-15 4,882.69 Oct-15 4,882.69 Nov-15 4,882.69 Dec-15 4,882.69 Jan-16 4,882.69 Feb-16 4,882.69 Mar-16 4,882.69 Apr-16 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 171.08 (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) (342.66) 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 4,574.15 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 186.85 (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) (326.52) 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 4,707.74 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 189.94 (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) (493.55) (1,045.00) May-16 4,707.74 189.94 (493.55) (1,045.00) Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 One Month Income Statement Unadjusted Mar 13 Ordinary Income/Expense Income 4000 Website Set-up Fees 183,602.00 4001 Social Set-up Fees 28,377.00 4002 Maps Set-up Fees 42,153.00 4003 Monthly Hosting Revenue 65,178.00 4004 Monthly Maintenance Revenue 94,775.00 4005 Other Revenue Total Revenues 7,407.52 421,492.52 Cost of Goods Sold 5300 Hosting Costs 5320 Domain Registration 5389 Map Directory Listing Expense 5393 Social Expenses 56,225.80 4,100.00 12,540.00 637.00 5395 Print Marketing 2,007.45 Total Cost of Goods Sold 75,510.25 GROSS PROFIT 345,982.27 Salaries and Related Benefits 5412 Salaries 41,773.53 5415 Payroll Taxes 2,723.76 5418 Benefits 4,240.60 Total Salaries and Related Benefits 48,737.89 Other Expenses 6220 Marketing 60,765.04 6260 Direct Mail - Existing Clients 5,724.13 6290 Miscellaneous Marketing 2,687.75 6314 Royalty Expense - Web Sites 6648 Vacation 19,248.52 2,092.23 6665 Professional Development 968.50 6680 Dues and subscriptions 225.00 6700 Meals and entertainment 6770 Bad Debt Expense 1,134.16 500.00 6790 Office supplies 1,861.53 6800 Computer / Phone Supplies 2,793.69 6805 IT consulting services 2,400.00 6840 Equipment and furniture rental 6890 Telephone 6895 Miscellaneous general expense 128.30 3,558.52 249.57 7040 Credit card and bank fees 36,249.94 6910 Rent 12,974.80 6920 Utilities Total Other Expenses Total Expense Net Ordinary Income 982.77 154,544.45 203,282.34 142,699.93 Other Income/Expense 6401 Depreciation & Amortization Expense Total Depreciation and Amortization Net Income 21,124.15 21,124.15 121,575.78 Adjusted Adjustments Mar 13 Balance Sheet Unadjusted 3/31/13 ASSETS Current Assets 1000 Cash and Cash Equivalents 455,734.06 1200 Accounts Receivable, Net 539,589.75 1330 Prepaid Advertising 13,687.51 1410 Prepaid Misc. General Expense 16,897.82 1450 Prepaid Print Marketing 1460 Prepaid Rent Total Current Assets 2,911.29 12,884.85 1,041,705.28 Fixed Assets 1500 Furniture and fixtures 82,996.65 1520 Computer equipment 176,980.59 1540 Software 288,076.64 1560 Conference booth and equipment 6,494.37 1570 Leasehold Improvements 126,149.11 1675 Accumulated Depreciation (150,412.99) Total Fixed Assets 530,284.37 Other Assets 1715 Deferred Expenses 1999 Other Assets 1800 Secuity Deposits Total Other Assets TOTAL ASSETS 31,638.38 7,362.62 25,014.82 64,015.82 1,636,005.47 LIABILITIES & EQUITY Current Liabilities 2000 Accounts payable 287,692.26 2051 Customer deposits 55,545.00 2140 Misc. Accrued expenses 81,327.49 2155 Accrued Vacation 75,195.14 2190 Deferred rent 2196 Accrued Referral Fees Total Current Liabilities 2,229.36 77,632.22 579,621.47 Total Other Long Term Liabilities 2055 Deferred Revenue 430,694.04 2211 Other Liabilities 301,023.68 Total Other Long Term Liabilities Total Liabilities 731,717.72 1,311,339.19 EQUITY 3000 Equity 3300 Retained Earnings 3500 Net Income Total Equity TOTAL LIABILITIES & EQUITY 1,000.00 39,985.83 283,680.45 324,666.28 1,636,005.47 Adjusted Adjustments 3/31/13

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial & Managerial Accounting

Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac

13th edition

9781133607618, 978-1285868776

More Books

Students also viewed these Accounting questions

Question

Why is transformation important for dynamic programming problems?

Answered: 1 week ago

Question

2. Value-oriented information and

Answered: 1 week ago

Question

1. Empirical or factual information,

Answered: 1 week ago

Question

1. To take in the necessary information,

Answered: 1 week ago