Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is a multi-part question that builds upon the work/adjustmentsew information from the previous parts. There are three (3) sections to this particular question -

This is a multi-part question that builds upon the work/adjustmentsew information from the previous parts. There are three (3) sections to this particular question - 1-A, 1-B, and 1-C. Within each of these sections, there are various facts/events that will be needed to make the corrections/adjustments to the provided spreadsheets. Please include any mathematical equations or formulas used in your notes for each section.

1-A ) Make adjusting entries in the journal (rounding to the nearest dollar) using the information below (Include any formulas used in your work):

A-1) A physical count of inventory revealed $440,020.00 of inventory

A-2) A physical count of supplies revealed $7232.00 of supplies

A-3) Depreciation for the year was $24,005

A-4) The balance in prepaid rent represents an amount paid Dec. 1st for one year

A-5) Even though the notes receivable aren't due until April 30 2019 they will include 8% interest. The Dec. 31 balance represents a 6 month note originating on Nov. 1st 2018.

A-6) Dec. 31st is a Thursday and $11,000 of salaries for a five day workweek are paid every Friday.

1-B) On the designated pages, make an Adjusted Trial Balance and then Create Financial Statements for 2018

Additional information needed for cash flow statement (not adjusting entries):

Furniture was bought for cash and equipment was bought on credit. No assets were sold.

Cash dividends of $50,000 were paid during the year.

Use the indirect method for creating the Statement of Cash Flows

1-C) ANSWER THE FOLLOWING QUESTIONS. (record how much the assets, liabilities, and retained earnings would change and indicate the direction of change with a + or - so that a positive number would indicate it is too high by that amount and a negative number indicates it is too low by that amount.)

How would the financial statements be different if (each of these scenarios are independent):

C-1) We had missed counting incoming inventory of $1,700

C-2) We had forgotten to record depreciation

C-3) We had forgotten to count supplies

C-4) The bookkeeper had thought the $40,000 we received 12-1 was for past services instead of services to be performed in January

C-5) The bookkeeper wasn't aware that the note payable includes 8% interest to be paid at maturity (calculated on the average balance)

C-6) How would the financial statements be different if all of these scenarios happened in 2018?

INFORMATION AVAILABLE IN SPREADSHEET:

Instructions & Info:

image text in transcribed

1-1-18 Balance Sheet:

image text in transcribed

12-31-18 Unadjusted Trial Bal.:

image text in transcribed

Journal:

image text in transcribed

A B D E F G H J K L M N 0 P Q 1 2 3 4 5 6 7 8 9 10 11 1. Make adjusting entries in the journal (rounding to the nearest dollar) using the information below: A physical count of inventory revealed $440,020.00 of inventory A physical count of supplies revealed $7232.00 of supplies Depreciation for the year was $24,005 The balance in prepaid rent represents an amount paid Dec. 1st for one year Even though the notes receivable aren't due until April 30 2019 they will include 8% interest. The Dec. 31 balance represents a 6 month note originating on Nov. 1st 2018. Dec. 31st is a Thursday and $11,000 of salaries for a five day workweek are paid every Friday. 2. On the designated pages, make an Adjusted Trial Balance and then Create Financial Statements for 2018 Additional information needed for cash flow statement (not adjusting entries): Furniture was bought for cash and equipment was bought on credit. No assets were sold. Cash dividends of $50,000 were paid during the year. Use the indirect method for creating the Statement of Cash Flows 3. Answer these questions: a. How would the financial statements be different if (each of these scenerios are independent): assets liabilities retained earnings We had missed counting incoming inventory of $1,700 We had forgotten to record depreciation We had forgotten to count supplies The bookkeeper had thought the $40,000 we received 12-1 was for past services instead of services to be performed in January The bookkeper wasn't aware that the note payable includes 8% interest to be paid at maturity (calculated on the average balance) (record how much the assets, liabilities, and retained earnings would change and indicate the direction of change with a + or - so that a poitive number would indicate it is too high by that amount and a negative number indicates it is too low by that amount.) b. How would the financial statements be different if all of these scenerios happened in 2018? 12 13 14 15 16 17 18 19 20 21 22 23 24 25 B D 1 2 3 4 5 6 7 $45,559.00 $4,690.00 $4,258.00 $459,871.00 $2,000.00 $88,331.00 0 00 10 11 12 13 ABC Inc. Balance Sheet 1/1/2018 Current assets Cash Accounts receivable Office Supplies Inventory Pre-paid rent Notes Rec Fixed assets Building $252,845.00 (Less Accumulated Depreciation) -$157,000.00 Furniture Equipment Land Total assets Current liabilities Salaries Payable Accounts payable Long term liabilities Notes Payable Total Liabilities Capital Stock Retained Earnings Total Liabilities and Shareholder Equity 14 15 $95,845.00 $5,000.00 $56,000.00 $42,000.00 $803,554.00 16 17 18 19 $3,000.00 $88,437.00 20 21 22 23 24 $456,286.00 $547,723.00 $100,000.00 $155,831.00 $803,554.00 25 26 27 28 29 A B D E 1 2 3 4 5 6 7 8 9 10 11 ABC Inc UNADJUSTED UNTRIAL BALANCE 12/31/18 Cash Accounts receivable Office Supplies Inventory Pre-paid rent Building Accumulated Depreciation Furniture Equipment Notes Rec Land Salaries Payable Accounts payable Notes Payable Capital Stock Retained Earnings Sales Revenue COGS Salaries Expense Rent Expense 12 13 DR CR $7,255.00 $1,258.00 $11,487.00 $441,742.00 $4,000.00 $252,845.00 $157,000.00 $9,000.00 $62,000.00 $81,612.00 $42,000.00 $5,000.00 $83,125.00 $440,035.00 $100,000.00 $105,831.00 $163,208.00 $81,000.00 $42,000.00 $18,000.00 $1,054,199.00 $1,054,199.00 14 15 16 17 18 19 20 21 22 23 24 25 26 A B D E 1 Date Accounts Debits Credits 2 3 0 00 van A 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Using Accounting & Financial InformationAnalyzing, Forecasting, And Decision Making

Authors: Mark S. Bettner

2nd Edition

1947098683, 9781947098688

More Books

Students also viewed these Accounting questions

Question

What is ethnocentric bias?

Answered: 1 week ago