60.1K

Verified Solution

Link Copied!

QUESTIONS ARE ASKED BETWEEN IMAGES! the shaded reen boxes are where I need help with the answers. Thank you! Instructions:

Complete the each of following seven tabs in this MS Excel Workbook using the information contained in them:

Post the Journal Entries (to record the transactions of FirstRate Company during the final week of its fiscal year ended [FYE]

Dec. 31, 20X5) to the consolidated Trial Balance of the company as of December 31, 20X5

Consolidated Balance Sheet of the company as of December 31, 20X5

Consolidated Income Statement, including comprehensive income, of the company for its FYE December 31, 20X5

Statement of Cash Flows (SCF) Support Schedule, which provides information useful for preparing the SCF

Consolidated Statement of Cash Flows (SCF) of the company for its FYE December 31, 20X5

Consolidated Statement of Changes in Shareholders' Equity of the company for its FYE December 31, 20X5

Complete the assignment by working "from left to right." That is, first, complete the Trial Balance, followed by the Balance Sheet, then the

Income Statemet tab, etc.

Below are images from excel: Image 1: General Journal - i dont know why image 1 is small so i typed it aout below Accounts Receivalbe: Debit $800 Sales revenue (gross): Credit $800 COGS-other $600 Inventory, at lower cost or market $600 Cash and cash equivalents: $700 Accounts receivable, gross: $200 Allowance for uncollectible accounts receivable: $200 Accounts receivable, gross: $200 Selling and administrative cost or market: $500 Cash and cash equiv.: $200 Inventory, at lower cost or market: $500 Accounts payable: $500 Total Debits: $3000 | Total Credits: $3000

Image 2: Balance Sheet- ***PLEASE FILL IN GREEN SHADED BOXES WITH INFO FROM IMAGE 1

Image 3: Income Statement- **PLEASE FILL IN GREEN SHADED BOXES WITH INFO FROM IMAGE 1&/OR 2

Image 4, 5, 6: Support Schedules- PLEASE FILL IN SHADED GREE NBOXES WITH INFOR FROM IMAGES 1, 2, &/OR 3

Image 7: Statement of Cash Flows- PLEASE FILL IN SHADED GREEN BOXES FROM IMAGES 1, 2, 3, 4, 5, &/OR 6

Image 8: Statement of Changes in Stockholders' Equity- PLEASE FILL IN SHADED GREEN BOXES WITH INFO FROM IMAGES 1, 2, 3, 4, 5, 6, &/OR 7

FirstRate Company and subsidiaries General Journal (US. dollars in thousands) mes company does NOT use special journals, such as sales journal, purchases journal, cash journal, or payroll journa) General ledger accounts Date Cred Dec. 31. 20X5 Accounts receivable, gross Sales revenue (gross) Explanation: To record credit sales for the last few days of 20X5 Dec. 31, 20X5 Cost of goods sold (COGS) other Inventory, at lower of cost or market Explanation: To record cost of sales for the last few days of 20X5 Dec. 31, 20X5 Cash and cash equivalents Accounts receivable, gross Explanation: To record collections of accounts receivables for the last week of 20X5 Dec. 31, 20X5 Allowance for uncollectible accounts receivable Accounts receivable, gross Explanation: To record write-off of AR outstanding more than 6 months as of Dec. 28, 20X5 Dec. 31, 20X5 Selling and administrative expenses other Cash and cash equivalents i Explanation: To record payment of employee 20X5 bonuses, declared by board on Dec. 28, 20X5 Dec. 31, 20X5 Inventory, at lower of cost or market Accounts payable Explanation: To record purchases of raw materials during last week of 20X5 on credit (terms net 30 days) Total debits and credits 3,000 Pos of each of th entr EFO work his WO (Cornplete all 6 tabs inthis workbook.) FirstRate Company and subsidiaries General Journal (US. dollars in thousands) mes company does NOT use special journals, such as sales journal, purchases journal, cash journal, or payroll journa) General ledger accounts Date Cred Dec. 31. 20X5 Accounts receivable, gross Sales revenue (gross) Explanation: To record credit sales for the last few days of 20X5 Dec. 31, 20X5 Cost of goods sold (COGS) other Inventory, at lower of cost or market Explanation: To record cost of sales for the last few days of 20X5 Dec. 31, 20X5 Cash and cash equivalents Accounts receivable, gross Explanation: To record collections of accounts receivables for the last week of 20X5 Dec. 31, 20X5 Allowance for uncollectible accounts receivable Accounts receivable, gross Explanation: To record write-off of AR outstanding more than 6 months as of Dec. 28, 20X5 Dec. 31, 20X5 Selling and administrative expenses other Cash and cash equivalents i Explanation: To record payment of employee 20X5 bonuses, declared by board on Dec. 28, 20X5 Dec. 31, 20X5 Inventory, at lower of cost or market Accounts payable Explanation: To record purchases of raw materials during last week of 20X5 on credit (terms net 30 days) Total debits and credits 3,000 Pos of each of th entr EFO work his WO (Cornplete all 6 tabs inthis workbook.)

Answer & Explanation Solved by verified expert

See Answer