The Douxe Droppe Inn, a sole proprietorship, has several accounts as follows: Room sales Land Cash Accounts payable Inventories Accounts receivable Bonds payable (long-term) Hugh Wake, Capital (1/1/20X4) Accrued expenses Prepaid expenses Temporary investments Building Equipment and furnishings Franchise fees (deferred) Accumulated depreciation Income tax payable Interest expense Other information is as follows: $ 1,050,000 8,500 25,000 32,500 27,500 85,000 350,000 300,000 15,500 9,500 22,500 550,000 250,000 15,000 (160,000) 25,000 33,000 The Douxe Droppe Inn's net income for 20X4 was $300,000, and Hugh Wake withdrew $220,000 for personal use during 20X4.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Do not give answer in image 

Problem 3:
The Douxe Droppe Inn, a sole proprietorship, has several accounts as follows:
Room sales
Land
Cash
Accounts payable
Inventories
Accounts receivable
Bonds payable (long-term)
Hugh Wake, Capital (1/1/20X4)
Accrued expenses
Prepaid expenses
Temporary investments
Building
Equipment and furnishings
Franchise fees (deferred)
Accumulated depreciation
Income tax payable
Interest expense
Other information is as follows:
$ 1,050,000
8,500
25,000
32,500
27,500
85,000
350,000
300,000
15,500
9,500
22,500
550,000
250,000
15,000
(160,000)
25,000
33,000
The Douxe Droppe Inn's net income for 20X4 was $300,000, and Hugh Wake withdrew
$220,000 for personal use during 20X4.
Required:
1. Prepare a classified balance sheet in standard format using the Problem 3 tab in Excel.
2. Make certain you are using Excel formulas to calculate the subtotals and totals.
Transcribed Image Text:Problem 3: The Douxe Droppe Inn, a sole proprietorship, has several accounts as follows: Room sales Land Cash Accounts payable Inventories Accounts receivable Bonds payable (long-term) Hugh Wake, Capital (1/1/20X4) Accrued expenses Prepaid expenses Temporary investments Building Equipment and furnishings Franchise fees (deferred) Accumulated depreciation Income tax payable Interest expense Other information is as follows: $ 1,050,000 8,500 25,000 32,500 27,500 85,000 350,000 300,000 15,500 9,500 22,500 550,000 250,000 15,000 (160,000) 25,000 33,000 The Douxe Droppe Inn's net income for 20X4 was $300,000, and Hugh Wake withdrew $220,000 for personal use during 20X4. Required: 1. Prepare a classified balance sheet in standard format using the Problem 3 tab in Excel. 2. Make certain you are using Excel formulas to calculate the subtotals and totals.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education