Question

In: Accounting

A: Prepare a balance sheet at May 31. (List Assets in order of liquidity. List Property,...

A: Prepare a balance sheet at May 31. (List Assets in order of liquidity. List Property, plant and equipment in order of land, buildings and equipment. Round answers to 0 decimal places, e.g. 5,275.)

B: Prepare an income statement for the month of May 31. (Round answers to 0 decimal places, e.g. 5,275.)

The Skyline Motel opened for business on May 1, 2017. Its trial balance before adjustment on May 31 is as follows.

SKYLINE MOTEL
Trial Balance
May 31, 2017

Account Number Debit Credit
101 Cash $ 3,600
126 Supplies 2,050
130 Prepaid Insurance 3,000
140 Land 12,000
141 Buildings 62,400
149 Equipment 15,400
201 Accounts Payable $ 11,700
208 Unearned Rent Revenue 3,000
275 Mortgage Payable 40,000
311 Common Stock 36,000
429 Rent Revenue 12,500
610 Advertising Expense 600
726 Salaries and Wages Expense 3,300
732 Utilities Expense 850
$103,200 $103,200


In addition to those accounts listed on the trial balance, the chart of accounts for Skyline Motel also contains the following accounts and account numbers: No. 142 Accumulated Depreciation—Buildings, No. 150 Accumulated Depreciation—Equipment, No. 212 Salaries and Wages Payable, No. 230 Interest Payable, No. 619 Depreciation Expense, No. 631 Supplies Expense, No. 718 Interest Expense, and No. 722 Insurance Expense.

Other data:

1. Prepaid insurance is a 1-year policy starting May 1, 2017.
2. A count of supplies shows $800 of unused supplies on May 31.
3. Annual depreciation is $3,120 on the buildings and $1,536 on equipment.
4. The mortgage interest rate is 12%. (The mortgage was taken out on May 1.)
5. Two-thirds of the unearned rent revenue has been earned.
6. Salaries of $800 are accrued and unpaid at May 31.

Solutions

Expert Solution

Working
No. Date Account Titles and Explanation Debit Credit
1 31-May Insurance Expense 250
Prepaid Insurance (3000/12) 250
(To expired insurance)
2 31-May Supplies expenses (2050-800) 1,250
Supplies 1,250
(To record supplies used)
3 31-May Depreciation Expense 4,656
Accumulated Depreciation—Buildings, 3,120
Accumulated Depreciation—Equipment 1536
4 31-May Interest Expense (40000*12%*1/12) 400
Interest Payable 400
(To record interest accrued on the note)
5 31-May Unearned Rent Revenue 2,000
Rent Revenue (3000*2/3) 2,000
(To record service revenue earned)
6 31-May Salaries and Wages Expense 800
Salaries and Wages Payable 800
(To record accrued wages)
ans Income Statement
For the year ended May 31 2017
Rent Revenue 14,500
Less: Operating expenses
Salaries and Wages Expense 4,100
Insurance Expense 250
Depreciation Expense 4,656
Supplies Expense 1,250
Advertising expenses 600
Utilities expenses 850
Total operating expenses 11,706
Net Operating Income 2,794
Interest Expense 400
Net Income 2,394
ans Balance Sheet
For the year ended May 31 2017
Assets
Current Assets
Cash $3,600
Supplies $800
Prepaid Insurance $2,750
Total current assets $7,150
Property Plant & Equipment
Land 12000
Building 62,400
Accumulated Depreciation-Building $3,120 $59,280
Equipment 15,400
Accumulated Depreciation-Equipment $1,536 $13,864
Total Property Plant & Equipment $85,144
Total Assets $92,294
Liabilities & Stockholder Equity
Current Liabilities
Accounts Payable 11,700
Interest Payable 400
Unearned Service Revenue 1,000
Salaries and Wages Payable 800
Total Current Liabilities 13,900
Mortgage Payable 40,000
Total Liabilities 53,900
Stockholder Equity
Common Stock 36000
Retained Earnings 2,394
Total Stockholder Equity 38,394
Total Liabilities & Stockholder Equity 92,294

Related Solutions

A: Prepare a balance sheet at May 31. (List Assets in order of liquidity. List Property,...
A: Prepare a balance sheet at May 31. (List Assets in order of liquidity. List Property, plant and equipment in order of land, buildings and equipment. Round answers to 0 decimal places, e.g. 5,275.) B: Prepare an income statement for the month of May 31. (Round answers to 0 decimal places, e.g. 5,275.) The Skyline Motel opened for business on May 1, 2017. Its trial balance before adjustment on May 31 is as follows. SKYLINE MOTEL Trial Balance May 31,...
Prepare a balance sheet at May 31. he Blossom Company opened for business on May 1,...
Prepare a balance sheet at May 31. he Blossom Company opened for business on May 1, 2019. Its trial balance before adjustment on May 31 is as follows. Blossom Company Trial Balance May 31, 2019 Account Number Debit Credit 101 Cash $ 3,500 126 Supplies 2,050 130 Prepaid Insurance 1,800 140 Land 14,000 141 Buildings 60,500 149 Equipment 15,500 201 Accounts Payable $ 11,500 208 Unearned Rent Revenue 3,200 275 Mortgage Payable 40,000 311 Common Stock 35,300 429 Rent Revenue...
1.) Based on the following information, prepare a balance sheet. Current Assets = $15,000; Property, Plant...
1.) Based on the following information, prepare a balance sheet. Current Assets = $15,000; Property, Plant & Equipment = $25,000; Accumulated Depreciation = $5,000; Accounts Payable = $5,000; Notes Payable = $5,000; Total Liabilities = $25,000
Prepare a 12/31/18 balance sheet.
The following account balances were taken from the 2018 post-closing trial balance of the Bowler Corporation:cash, $5,000accounts receivable, $10,000inventory, $16,000equipment, $100,000accumulated depreciation—equipment, $40,000accounts payable, $20,000 salaries payable, $12,000retained earnings, $9,000 and common stock, $50,000.Prepare a 12/31/18 balance sheet
METLOCK, INC. Condensed Balance Sheet May 31 ($ in millions) 2017 2016 Assets Current Assets $9,800...
METLOCK, INC. Condensed Balance Sheet May 31 ($ in millions) 2017 2016 Assets Current Assets $9,800 $8,760 Property, plant, and equipment (net) 1,970 1,800 Other assets 1,550 1,770 Total assets $13,320 $12,330 Liabilities and Stockholders' Equity Current Liabilities $3,230 $3,320 Long-term liabilities 1,310 1,350 Stockholders’ equity 8,780 7,660 Total liabilities and stockholders' equity $13,320 $12,330 (a) Prepare a horizontal analysis of the balance sheet data for Metlock, using 2016 as a base. (If amount and percentage are a decrease show...
Prepare a balance sheet as of December 31, 2019. BUSINESS SOLUTIONS Balance Sheet December 31, 2019...
Prepare a balance sheet as of December 31, 2019. BUSINESS SOLUTIONS Balance Sheet December 31, 2019 Assets Cash Accounts receivable Prepaid insurance Prepaid insurance Prepaid rent Office equipment Accumulated depreciation—Office equipment 0 Accumulated depreciation—Computer equipment Computer equipment 0 Total Assets 0 Liabilities Accounts payable Wages payable Unearned computer services revenue Total Liabilities 0 Equity Retained earnings Common stock Total equity $0 Total Liabilities and Equity $0 After the success of the company’s first two months, Santana Rey continues to operate...
Prepare a balance sheet in report form as of December 31, 2016. * Balance sheet data:...
Prepare a balance sheet in report form as of December 31, 2016. * Balance sheet data: Accounts payable $ 194,300 Accounts receivable 545,000 Accumulated depreciation—office buildings and equipment 1,580,000 Accumulated depreciation—store buildings and equipment 4,126,000 Allowance for doubtful accounts 8,450 Available-for-sale investments (at cost) 260,130 Bonds payable, 5%, due 2024 500,000 Cash 246,000 Common stock, $20 par (400,000 shares authorized; 100,000 shares issued, 94,600 outstanding) 2,000,000 Dividends: Cash dividends for common stock 155,120 Cash dividends for preferred stock 100,000 Goodwill...
what order should assets appear on the balance sheet?
what order should assets appear on the balance sheet?
Liquidity management can be practiced on either side of the balance sheet. How are assets and...
Liquidity management can be practiced on either side of the balance sheet. How are assets and liability management similar and how do they differ? Why smaller banks have limited access to liability management?
Instructions: Prepare a classified balance sheet for Baxter Incorporated, at December 31, 2018. The balance sheet...
Instructions: Prepare a classified balance sheet for Baxter Incorporated, at December 31, 2018. The balance sheet should be prepared in good form in excel. Be sure to use proper spacing, references, and formulas. Baxter Incorporated was started by John Ross early in 2018. Initial capital was acquired by issuing shares of commons stock to various investors and by obtaining a bank loan. The company operates a retail store that sells records, tapes, and compact discs. Business was so good during...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT