Hyrule Motors Worksheet For the Year Ended December 31, 2020 Adjusted TrialBalance Credit Income Statement Debit Balance Sheet Debit P240,000 425.000 50,000 90 000 500,000 240,000 400.000 Tral Balance Debit Adjustments Debit Account Title 110 Ca 120 Accounts Receivable 130 Office Supoles 140 Prepaid Rent 150 Machinenes 160 Computer Equipment 170 Funtuare and Fodure 210 Accounts Payable 220 UMes Payable 230 Uneamed Revenue 310 Unk Capital 410 Service Revenue 510 Ues Expense 520 Rent Expense Debit P240.000 425.000 50,000 90 000 500 000 240 000 400.000 No. Credit Credit Credit Credit P240.000 400,000 50,000 360 000 500 000 240,000 400,000 P25.000 P270 000 P200.000 50,000 45,000 1,000.000 1,070,000 P200.000 50,000 45,000 1.000,000 P200.000 50,000 90,000 1.000,000 1,000,000 45,000 70,000 P1.070.000 100 000 50.000 150,000 270 000 P390,000 P2,365,000 P2365,000 P150,000 270,000 P420,000 P1,070,000 P1,945,000 P1,295,000 650.000 P1070.000 P1,070.000 P1.945.000 | P1.945.000 270.000 P390,000 P2,790,000 P2,790,000 Profit 650.000

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

Submit in excel form the financial statements report for Hyrule as presented in the worksheet 

Hyrule Motors, a motorcycle repairs and maintenance services provider, had the following transaction during 2020, its first month of operations:
January 1. The owner, Link, invested P1,000,000 cash to start the business.
January 1. Hyrule Motors bought computer equipment totaling P240,000 using cash.
January 1. Bought furmiture and fixtures using cash, P400,000.
January 1. Bought machineries totaling P500,000 on account.
January 3. Bought office supplies amounting 50,000 cash.
January 7. Rendered services amounting to P800,000, on account.
January 8. Rendered services amounting to P200,000 cash.
January 13. Paid 300,000 for the machineries bought on January 1.
January 27. Received P400,000 cash as payment for the services rendered on
January 31. January 31. Paid P100,000 for the month's utilities.
Transcribed Image Text:Hyrule Motors, a motorcycle repairs and maintenance services provider, had the following transaction during 2020, its first month of operations: January 1. The owner, Link, invested P1,000,000 cash to start the business. January 1. Hyrule Motors bought computer equipment totaling P240,000 using cash. January 1. Bought furmiture and fixtures using cash, P400,000. January 1. Bought machineries totaling P500,000 on account. January 3. Bought office supplies amounting 50,000 cash. January 7. Rendered services amounting to P800,000, on account. January 8. Rendered services amounting to P200,000 cash. January 13. Paid 300,000 for the machineries bought on January 1. January 27. Received P400,000 cash as payment for the services rendered on January 31. January 31. Paid P100,000 for the month's utilities.
Hyrule Motors
Worksheet
For the Year Ended December 31, 2020
Trial Balance
Debit
F240,000
400.000
50,000
360.000
500.000
240.000
Adjusted Trial Balance
Debit
P240,000
425,000
50,000
90,000
500,000
240,000
400,000
Adjustments
Debit
Income Statement
Debit
Balance Sheet
Credit
Debit
P240,000
425,000
50,000
90.000
500,000
240,000
No.
Account Title
Credit
Credit
Credit
Credit
110 | Cash
120 Accounts Receivable
130 Ofice Supplies
140
P25,000
Prepaid Rent
150 Machinenes
160 Computer Equipment
170 | Furniture and Fixtures
210
220
P270.000
400,000
400,000
P200,000
Accounts Payable
Utilities Payable
230 Uneamed Revenue
310 Link, Capital
410 Service Revenue
510 Utities Expense
520 | Rent Expense
P200,000
50,000
45,000
1,000,000
1,070,000
P200,000
50.000
45,000
1,000,000
50,000
90,000
1,000,000
1,000,000
45,000
70,000
P1,070.000
100,000
50,000
270,000
150,000
270,000
P390,000 P2,365,000 P2,365,000
P150.000
270,000
P2,290,000 P2,290,000
P420,000 P1,070,000 P1,945,000 P1,295,000
650,000
P1,070,000 | P1,070,000 | P1,945,000 | P1,945,000
P390,000
Profit
650.000
Transcribed Image Text:Hyrule Motors Worksheet For the Year Ended December 31, 2020 Trial Balance Debit F240,000 400.000 50,000 360.000 500.000 240.000 Adjusted Trial Balance Debit P240,000 425,000 50,000 90,000 500,000 240,000 400,000 Adjustments Debit Income Statement Debit Balance Sheet Credit Debit P240,000 425,000 50,000 90.000 500,000 240,000 No. Account Title Credit Credit Credit Credit 110 | Cash 120 Accounts Receivable 130 Ofice Supplies 140 P25,000 Prepaid Rent 150 Machinenes 160 Computer Equipment 170 | Furniture and Fixtures 210 220 P270.000 400,000 400,000 P200,000 Accounts Payable Utilities Payable 230 Uneamed Revenue 310 Link, Capital 410 Service Revenue 510 Utities Expense 520 | Rent Expense P200,000 50,000 45,000 1,000,000 1,070,000 P200,000 50.000 45,000 1,000,000 50,000 90,000 1,000,000 1,000,000 45,000 70,000 P1,070.000 100,000 50,000 270,000 150,000 270,000 P390,000 P2,365,000 P2,365,000 P150.000 270,000 P2,290,000 P2,290,000 P420,000 P1,070,000 P1,945,000 P1,295,000 650,000 P1,070,000 | P1,070,000 | P1,945,000 | P1,945,000 P390,000 Profit 650.000
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cash Flow Statement Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
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