ZuoTi.Pro
Question
what formula you should use to get answers for these columns?
Team View Help Review Data Formulas Page Layout Draw General Wrap Text Conditional Fona $ - % 9 8 Formatting Ta E EMerge & Ce

these are the answers for the columns but i want to know what are the formulas that person used to get the answers in excel
image.png
business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The formula used is: Debit amount in january entry-credit amount in january entry+debit amount in opening balance entry-credit amount in opening entry.then if the final answer you received by applying the given formula is a positive figure it will go to debit column of the unadjusted trialbalance andif it is negative figure it will go to credit side of the unadjusted trial balance.

0 0
Add a comment
Know the answer?
Add Answer to:
what formula you should use to get answers for these columns? these are the answers for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • $ . % Merge & Center - .000 Formatting Table SIU. . . A. Number Styles...

    $ . % Merge & Center - .000 Formatting Table SIU. . . A. Number Styles Alignment Font Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for...

  • please give answers to the blue part in these one and it will be helpful if...

    please give answers to the blue part in these one and it will be helpful if you could provide formula to the answers. At the end of January, the following additional information is available to help determine what adjustments are needed: Amount Amount 43 31-Jan One month of the prepaid rent has been used up 14 31-Jan One month of the services for Stanley Inc. has been performed (see above) 45 31-Jan Supplies were counted at month end 48 31-Jan...

  • E1-8 the following items and amounts were taken from Lonyear You have been hired as an...

    E1-8 the following items and amounts were taken from Lonyear You have been hired as an accountant for AugFig Consulting Inc. This business was created when some friends decided to make use of their newly minted college degrees and go into business together. The business was created on January 1, 2019. The company will have a fiscal year end of December 31. The initial formation transactions and early purchases for AugFig Consulting Inc. resulted in the balances that are included...

  • Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings,...

    Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet ). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY completed for the 3 statements. Prepare closing entries for the end of the period Prepare financial statements for the...

  • i need help with the financial statement, balance sheet, statement of retained earnings. here are the...

    i need help with the financial statement, balance sheet, statement of retained earnings. here are the numbers used. formulas displayed. Prepare financial statements for the month ending January 31, 2019. (Income Statement, Statement of Retained Earnings, Classified Balance Sheet). Formatting is important and will be graded so be sure you use dollar signs and underlines as appropriate. Also be sure you have headings and proper column usage for all statements. There is a tab for these statements. Heading are PARTIALLY...

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

  • JUST NEED THE COMPLETE BALANCE SHEET FOR THIS FIXING THE ERRORS I MADE BEGINNING NUMBERS ADJUSTMENTS...

    JUST NEED THE COMPLETE BALANCE SHEET FOR THIS FIXING THE ERRORS I MADE BEGINNING NUMBERS ADJUSTMENTS Worksheet - AugFig Consulting Inc UNADJUSTED TRIAL JANUARY ENTRIES BALANCE 8,100 8,100 28,000 42.800 Prepaid Rent 675 ADJUSTED TRIAL BALANCE 7,425 28,000 42,800 Land 28,000 42,800 Computer Equipment Accumulated Depreciation, Comp Equip 185 185 11,260 11,260 11,260 135 8,650 8,650 6850 6,850 135 6,850 1,750 1,750 65 65 Office Furniture Accumulated Depreciation, Off Furn Accounts Payable Salaries Payable Interest Payable Unearned Revenue Long-term Notes...

  • Fill out the pink part of the journal entry and then fill out the worksheet entry...

    Fill out the pink part of the journal entry and then fill out the worksheet entry Date Amount During January, the first mouth of operations, the following transactions occurred: Event 2-Jan Paid for 12 months rent on office space 5-Jan Purchased office furniture Borrowed cash from the bank for operating expenses. The note charges simple interest and is to be paid back in 5 Amount 9,000 8.950 5-m years 0.02 interest rate 11500 on account 30,000 loan am 12,500 paid...

  • I need submission 2 and submission 3 completed please, thank you!!! Submission 1 - due Friday...

    I need submission 2 and submission 3 completed please, thank you!!! 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 file correctly will result in a 1 point deduction Submission...

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

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