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.
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

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)
Use a single worksheet for each question. Set up the answer with the dates in columns...
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 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...
Candy Company Worksheet For the Year Ended June 30, 2020 Adjusting Entries Adjusted Trial Balance DЬ. Cr. Ref DЬ. Cr. Income Statement Db. Cr. Balance Sheet . Cr. Ref Account Titles Cash Accounts Receivable Allowance for Doubtful Accounts Supplies Prepaid Insurance Prepaid Rent Land Buildings Accum. Depreciation-Bldgs. Equipment Accum. Depreciation-Equip. Goodwill Patents Accounts Payable Unearned Revenue Interest Payable Salaries and Wages Payable Mortgage Payable Common Stock ($1par) Paid in Capital in Excess of par-CS Dividends Retained Earnings Income Summary Sales...
Problem 4-03A a-d The completed financial statement columns of the worksheet for Bridgeport Company are as follows. Bridgeport Company Worksheet For the Year Ended December 31, 2019 Income Statement Balance Sheet Account No. Account Titles Dr. Cr. 101 Cash 112 9,100 11,000 2,800 23,800 130 157 201 212 4,700 8,800 2,400 10,400 9,000 311 320 332 400 Accounts Receivable Prepaid Insurance Equipment Accumulated Depreciation-Equip. Accounts Payable Salaries and Wages Payable Common Stock Retained Earnings Dividends Service Revenue Maintenance and Repairs...
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...
Please answer the following question and answer it in the
attached chart. Thanks!
1. Practice Makes Perfect Inc. was started on July 1 of the current year. Practice Makes Perfect provides piano lessons for students of all abilities. You are the founder, president, office manager, etc. You have not yet hired an accountant but your bank is asking for an income statement and balance sheet for the first month of operation. Using the following information, put each transaction into the...
I want you to answer question 2-19 with explanations
Chapter 2 Analyzing and Recording Transactions use the information in Exercise 2-16 to prepare an August statement of owner's equity for Help Today ind owners capital account balance at August I was $0, and the owner invested $102,000 cash in the company on August 2 Exercise 2-17 Preparing a statement owner's equity P3 Use the information in Exercise 2-16 to prepare an August 31 balance sheet for Help Today. Hint: Compute...
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...
I will give thumbs up for correct answers! Thank you!
Rantzow-Lear Company buys and sells debt securities expecting to earn profits on short-term differences in price, and holds these investments in its trading portfolio. The company's fiscal year ends on December 31. The following selected transactions relating to Rantzow-Lear's trading account occurred during December 2021 and the first week of 2022. 2021 Dec. 17 Purchased 200 Grocers' Supply Corporation bonds at par for $500,000. 28 Received interest of $6,000 from...
please help with step 3 and the answer the question.
Steps: Step #1 - Set up Chart of Accounts by en entering the accounts one by one. of Accounts by either importing the chart (Excel file on Canvas) or by Step #2 - Establish the beginning balances by er 1 as the date. in the beginning balances by entering the big journal entry below. Use January Cash 2 Accounts Receivable $ Raw Materials Inventory 4 Goods In Process Inventory 5...