Accounting 202 You decide to earn some money to finance your education by starti
ID: 2583507 • Letter: A
Question
Accounting 202
You decide to earn some money to finance your education by starting a business that designs Web pages. You will begin business on January 1, 2017, and run the business for the next 12 months. On your Excel spreadsheet, calculate the number of budgeted hours you will work for clients during the year by adding the last three digits of your student ID numbers of you and your partner, if working with a partner. Use only the last three digits of this sum. If working alone, just use the last three digits of your student ID number. If the number is less than 500, add 500 to the number. (If the last three digits of your ID number happen to be 000, use the first three digits of your ID number instead.) This number will be the expected number of billable hours to be worked in the coming budget year. You are going to prepare a budgeted income statement, cash budget, and budgeted balance sheet for the coming year based on the assumptions listed below.
MY ID NUMBER IS 600
BUDGET ASSUMPTIONS FOR THE COMING YEAR:
1. Before the business begins, you will take $5,000 cash from your savings account to invest in the business. You will protect yourself by organizing as a corporation, with yourself as the only stockholder.
2. Before the business begins, it will buy a computer, printer, and software package that together cost $5,200. Your parents have agreed to lend the business $5,200 cash so that the business can pay for the equipment and software. The business plans to repay your parents on January 31, 2018. Your parents do not expect any interest but require you to sign a promissory note.
The beginning balance sheet for your business is presented on the following page:
Arachne, Inc.
Balance Sheet
January 1, 2017
Assets
Current Assets
Cash
$5,000
Long-term Assets
Equipment
5,200
Less Accumulated Depreciation
0
5,200
Total Assets
$10,200
Liabilities and Stockholder’s Equity
Current Liabilities
$0
Long-term Liabilities
Note Payable
5,200
Total Liabilities
$5,200
Stockholder’s Equity
Common Stock
$5,000
Retained Earnings
0
Total Liabilities
$5,000
Total Liabilities and Stockholder’s Equity
$10,200
3. Starting January 1, 2017, the business will charge $40 per hour for design work and bill clients as each job is completed. You expect that by December 31, 2017, the end of the fiscal year, 70% of clients will have paid the business in cash. You expect that the rest will pay by January 31, 2018.
4. The business will hire an assistant to help with general office work. The assistant will earn $15 per hour and will work exactly the same hours that you work. The assistant will be paid for each month's work on the fifth day of the month following the month when the work is done. For the sake of simplicity, treat the assistant as an independent contractor rather than an employee. This means that you do not have to worry about withholding or matching payroll taxes. Assume that hours worked in December, 2017 are expected to total 10% (round to nearest whole hour) of the total hours for the year.
5. The business will purchase office supplies for cash of $1,800 in January, 2017
6. On March 1, the business will pay cash of $1,500 for a one-year liability insurance policy.
7. Since this is a new business, you think that it is important to advertise. The business will buy $500 of newspaper advertising each month. All payments for advertising costs will be made in the following month. (For example, January advertising expense will be paid for in February).
8. A dividend of $2,500 will be declared and paid before year end.
Record SUMMARY budgeted transactions for the entire year based on the above assumptions in the T-Accounts below. Round all amounts to the nearest whole dollar. The T-Accounts will not be turned in, but should be completed to assist you in completing the budgeted financial statements.
A1) It is expected that the equipment and software will be used for four years, after which time they will be worthless. The business uses the straight-line method of depreciation.
A2) It is expected that office supplies will be used up at the rate at the rate of $1.00 per hour worked, with the remaining amount still on hand at year-end.
A3) Record the insurance that has been used up during the year.
Arachne, Inc.
Balance Sheet
January 1, 2017
Assets
Current Assets
Cash
$5,000
Long-term Assets
Equipment
5,200
Less Accumulated Depreciation
0
5,200
Total Assets
$10,200
Liabilities and Stockholder’s Equity
Current Liabilities
$0
Long-term Liabilities
Note Payable
5,200
Total Liabilities
$5,200
Stockholder’s Equity
Common Stock
$5,000
Retained Earnings
0
Total Liabilities
$5,000
Total Liabilities and Stockholder’s Equity
$10,200
ASSETS LIABILITIES STOCKHOLDER'S EQUITY Record the expected adjusting entries in the T-Accounts for the following: Cash Accounts Payable Common Stock Sales 5000 5000 Wages Expense Retained Accounts Receivable Wages Payable Earnings Insurance Expense Advertising Expense Office Supplies Notes Payable 5200 Dividends Supplies Expense Prepaid Insurance Depreciation Expense Equipment 5200 Accumulated DepreciationExplanation / Answer
CASH A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
Common stock
5000
equipment
5200
Notes payable
5200
WAGES
8250
Sales revenue
16800
OFFICE SUPPLIES
1800
(40*600*70%)
DIVIDEND
2500
ADVERTISING
6000
INSURANCE
1500
BALANCE C/D
1750
TOTAL
27000
TOTAL
27000
EQUIPMENT A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH A/C
5200
DEPRECIATION
1300
BALANCE C/D
3900
TOTAL
5200
TOTAL
5200
COMMON STOCK A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH
5000
BALANCE C/D
5000
TOTAL
5000
TOTAL
5000
ACCOUNTS RECEIVABLE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
FEB 28
SALES A/C
7200
BALANCE C/D
7200
BALANCE C/D
7200
TOTAL
7200
TOTAL
7200
SALES A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH
16800
RECEIVABLES
7200
BALANCE C/D
24000
TOTAL
24000
TOTAL
24000
WAGES EXPENSE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
FEB 15
CASH A/C
8250
WAGES PAYABLE
750
BALANCE C/D
9000
TOTAL
9000
TOTAL
9000
OFFICE SUPPLIES A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH
1800
OFFICE SUPPKIES EXPENSE A/C
600
BALANCE C/D
1200
TOTAL
1800
TOTAL
1800
DEPRECIATION A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
EQUIPMENT
1300
BALANCE C/D
1300
TOTAL
1300
TOTAL
1300
OFFICE SUPPLIES EXPENSE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
OFFICE SUPPLIES A/C
600
BALANCE C/D
600
TOTAL
600
TOTAL
600
INSURANCE EXPENSE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH
1500
PREPAID INSURANCE
250
BALANCE C/D
1250
TOTAL
1500
TOTAL
1500
PREPAID ISURANCE A/C EXPENSE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
INSURANCE EXPENSE
250
BALANCE C/D
250
TOTAL
250
TOTAL
250
ADVERTAISING EXPENSE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH A/C
5500
PAYABLES
500
BALANCE C/D
6000
TOTAL
6000
TOTAL
6000
ACCOUNTS PAYABLE A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
ADVERATISING EXPENSE
500
BALANCE C/D
500
TOTAL
500
TOTAL
500
DIVIDEND A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
CASH A/C
2500
BALANCE C/D
2500
TOTAL
2500
TOTAL
2500
RETAINED EARNINGS A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
DIVIDEND
2500
INCOME STATEMENT
5850
BALANCE C/D
3350
TOTAL
5850
TOTAL
5850
CASH A/C
DATE
PARTICULARS
AMOUNT
DATE
PARTICULARS
AMOUNT
Common stock
5000
equipment
5200
Notes payable
5200
WAGES
8250
Sales revenue
16800
OFFICE SUPPLIES
1800
(40*600*70%)
DIVIDEND
2500
ADVERTISING
6000
INSURANCE
1500
BALANCE C/D
1750
TOTAL
27000
TOTAL
27000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.