Question

Use a single worksheet for each question. Set up the answer with the dates in columns...

Use a single worksheet for each question. Set up the answer with the dates in columns and the income statement or balance sheet items in rows. On the balance sheet, the assets and liabilities should be in the same column. Use links between worksheets so the system works even if you change earlier numbers.

Assume you have started a new company on the first day of the year. You raise $100,000 from family and friends, and borrow $40,000 from the bank on a ten-year, 8% note, with 10% of the original principle due each year (on the morning of Dec. 31.) Your company sells only for cash, and holds no inventory. All labor and materials are paid for at delivery. Properly label all accounts.

1. Show the balance sheet for Jan. 1, 2002.

2. On Jan 2, 2002 you buy a machine for $75,000. It has a five-year life, and is depreciated straight-line. Show the balance sheet for Jan. 2, 2002.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Assuming that the date of starting the company is January 1st, 2002.

No transactions occurred during the year were given except the purchase of equipment

on Jenn on Jan 2 Assets 1. Non current Assts A: plant, properly Begipornest 2. Current Assets A cash 15poo , A 140 poo 6Spoo

Note :

1. There are no income statement transactions given in question

2. Only the required headings and accounts are mentioned in the balance sheet.

3. 10% of the long term liability is current portion of long term debt. i.e., 10% of 40,000 = 4,000 (as it is to be repaid within 12 months)

4. Instead of using "Long term bank loan", we can use "Long term Note payable from bank" account and similarly instead of "current portion of long term liability", we can use "current portion of long term note payable from bank"

(No interest accrual entry for one day on 8% note is accounted as January 2nd 2002 is not a year end date)

Add a comment
Know the answer?
Add Answer to:
Use a single worksheet for each question. Set up the answer with the dates in columns...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Do the following quiz in Excel. Use a single worksheet for each question. Set up the...

    Do the following quiz in Excel. Use a single worksheet for each question. Set up the answer with the dates in columns and the income statement or balance sheet items in rows. On the balance sheet the assets and liabilities should be in the same column. Use links between worksheets so the system works even if you change earlier numbers. Assume you have started a new company on the first day of the year. You raise $100,000 from family and...

  • This project will be submitted in 3 parts. The submission dates and required parts to be...

    This project will be submitted in 3 parts. The submission dates and required parts to be completed for each submission are: Submission 1 - due Friday January 17 before 5pm - You must submit your completed Journal entries, the Worksheet complete through the Trial Balance (with totals for all columns), and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure to name your...

  • Please answer question C. Problem 4-02A a-e (Part Level Submission) The adjusted trial balance columns of...

    Please answer question C. Problem 4-02A a-e (Part Level Submission) The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. . 130 157 Ayayai Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,000 112 Accounts Receivable 10,500 126 Supplies 1,200 Prepaid Insurance 1,800 Equipment 26,500 158 Accumulated Depreciation-Equipment 5,000 200 Notes Payable 12,000 201 Accounts Payable 5,800 212 Salaries and Wages Payable 2,100 Interest...

  • YOU MUST USE FORMULAS AND CELL REFERENCES FOR INPUTS IN THE WORKSHEETS AND FINANCIAL STATEMENTS FOR...

    YOU MUST USE FORMULAS AND CELL REFERENCES FOR INPUTS IN THE WORKSHEETS AND FINANCIAL STATEMENTS FOR YOUR PROJECT TO BE CONSIDERED FOR FULL CREDIT Submission 1 - due Friday January 17 before 5pm - You must submit your completed Journal entries, the Worksheet complete through the Trial Balance (with totals for all columns), and the worksheet formulas tab complete through the Trial Balance. Your file must be named correctly - "Your name (first and last) Project 1 part 1. Failure...

  • The question I need help/answer with is the 3rd photo. The first two photos just aid...

    The question I need help/answer with is the 3rd photo. The first two photos just aid the 3rd Comprehensive Properties All work must be completed using this Excel spreadsheet Al journal entries francial statements, et must be prepared in dean, proper form. Reference your textbook and past courses for examples or templates to model Uue the current year for din purpose This project is W ed 120 points. The grading rubricis valable on the last sheet labeled "Grading brie Wformation...

  • Please answer question E only. i attach prior work for reference. Thank you so much Problem...

    Please answer question E only. i attach prior work for reference. Thank you so much Problem 4-02A a-e (Part Level Submission) The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. . 130 157 Ayayai Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,000 112 Accounts Receivable 10,500 126 Supplies 1,200 Prepaid Insurance 1,800 Equipment 26,500 158 Accumulated Depreciation-Equipment 5,000 200 Notes Payable 12,000...

  • this question was previously answered wrong. can you please help me find the correct answer. can...

    this question was previously answered wrong. can you please help me find the correct answer. can you please give explanations as to how you arrived at the numbers. thanks so much. You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year...

  • Please answer question D, the last 3 unanswered pictures. thank you so much Problem 4-02A a-e...

    Please answer question D, the last 3 unanswered pictures. thank you so much Problem 4-02A a-e (Part Level Submission) The adjusted trial balance columns of the worksheet for Ayayai Company are as follows. . 130 157 Ayayai Company Worksheet For the Year Ended December 31, 2019 Adjusted Trial Balance Account No. Account Titles Dr. Cr. 101 Cash 5,000 112 Accounts Receivable 10,500 126 Supplies 1,200 Prepaid Insurance 1,800 Equipment 26,500 158 Accumulated Depreciation-Equipment 5,000 200 Notes Payable 12,000 201 Accounts...

  • Heavy Equipment and Machinery Inc. Trial Balance At December 31, 2019

    What is the answer to these tables? here is all the information that had been given to me and my answers to the question that I think needs to be answered to complete the two tablesYou have been hired as a Financial Consultant by Heavy Equipment and Machinery Inc. (HEMI).  HEMI is a private corporation that has finished its first year of operations. HEMI's owners plan to list the business on the Toronto Stock Exchange  (TSE) in the next 5 years; accordingly,...

  • LO 10-6, 10 10-36 Based on an assessment of audit risk, the auditors are concerned with...

    LO 10-6, 10 10-36 Based on an assessment of audit risk, the auditors are concerned with the following two risks: 1. The risk that that the client might be making duplicate payments to vendors. 2. The risk that the client's accounting clerk might be making unauthorized payments to himself. a. Assuming that the client has a manual accounting system, describe how the auditors can design a test to identify the duplicate payments and unauthorized payments. b. Assuming that the client...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT