Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am in desperate need of help with this project. Apparently my answers are all wrong. 3:02 PM Thu Feb 27 4796% AC 321 Intl

I am in desperate need of help with this project. Apparently my answers are all wrong. image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

3:02 PM Thu Feb 27 4796% AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review View 8 Q o Calibri (Body) 12 B U Home B ^ A = 1 EE tx 19 2 3 4 All work must be completed using this Excel spreadsheet. All journal extries, financial statements, etc. must be prepared in clean, proper form. Reference your textbook and past courses for examples or templates to model. Use the current year for dating purposes. This project is valued at 120 points. The grading rubric is available on the last sheet labeled "Grading Rubric." Information on using Excel can be found in the Excel Notes section below. Please be aware, points are allocated for the use of Excel (see rubric). Click on the tabs at the bottom of the bottom to familiarize yourself with the project. Check figures are provided for 3 key items to help ensure you are on the correct track 6 7 & 10 EXCEL NOTES: *Use Excel to link all of your journal entries and financial statements. This will be great practice and it reduces the likelihood of errors. There is a video available in Blackboard to guide you on using Excel and navigating the project. * Also be sure to take advantage of Excel by using formulas to calculate/sum groups of numbers. * DO NOT force any cells to match check figures given. Any adjustments in the T-Accounts or financial statements not supported by legitimate adjusting or closing entries will be considered financial statement misrepresentation, sufficient to result in a failing grade. *Use the format button to add dollar signs, underlining and double underlining when appropriate. DO NOT put dollar signs on every line as it will cost you points. REQUIREMENTS: Part 1 Post the Unadjusted Trial Balance totals to the T-Accounts on the sheet labeled "T-Accounts." These numbers will represent your beginning balances. 22 Part 2 Record the adjusting journal entries required for items AND post them to the T-accounts. Add or extend lines on any T-Accounts if necessary. 24 Part 3 Prepare an Adjusted Trial Balance for Gatsby, Inc. using the updated T Accounts Adjusted TB check figure: $1,279,200 26 Part 4 Prepare, in good form, financial statements on each specified sheet in the following order: a Multi-Step Income Statement and prepare a bar or ple chart for a visual representation of expenses. b Statement of Stockholders' Equity Classified Balance Sheet Total Assets check figure: $850,750 31 Part 5 Using the financial statements, calculate the 5 following ratios on the specified sheet and briefly ( 2 or 3 sentences) interpret the ratios for Gatsby, Inc. a Working Capital b Current Ratio C Quick Ratio (Acid Test d Debt to Equity e Times Interest Earned 29 Part 6 Record closing journal entries AND post them to the T-accounts. Part 7 Prepare a Post-Closing Trial Balance using the updated T-accounts. 40 Total debit check figure: $924,750 Project Instructions Unadjusted Trial Bal... Adjusting Journal En.. T-Accounts Adjusted Trial Balance Income Statement Statement Shar + 3:02 PM Thu Feb 27 4796% 8 Q o Home UB AC 321 Intl - FA19 - Comprehensive Project Insert Draw Formulas Data Review A = 1 View A Calibri (Body) 11 B tz a m ] Y ES D E F G H I J K L M N O Credit 40,000 8,000 160,500 B C Gatsby, Inc. Unadjusted Trial Balance 12/31/XX Debit 5 Cash 121,550 6 Accounts Receivable 236,000 7 Prepaid Insurance 24,000 & Supplies 4,500 9 Inventory 85,000 10 Land 75,000 11 Building 200,000 12 Accumlated Depreciation Building 13 Equipment 160,000 14 Accumlated Depreciation- Equipment 15 Accounts Payable 16 Interest Payable 17 Wages Payable 18 Unearned Revenue - Alarm Systems 19 Long-Term Bank Note Payable zo Common Stock 21 Retained Earnings 22 Dividends 7,000 23 Revenue 24 Cost of the Goods Sold 132,500 25 Depreciation Expense 26 Insurance Expense 15,000 27 Interest Expense 28 Rent Expense 24,000 29 Supplies Expense 30 Utilities Expense 9,700 31 Wage Expense 125,000 32 Totals $1.219.250 45,000 150,000 310,000 124,750 381,000 $1.219.250 34 Project Instructions Unadjusted Trial Bal... Adjusting Journal En... T-Accounts Adjusted Trial Balance income Statement Statement Share + 96% 3:03 PM Thu Feb 27

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

Content Audits And Inventories A Handbook

Authors: Paula Ladenburg Land

1st Edition

1937434389, 978-1937434380

More Books

Students also viewed these Accounting questions

Question

Find the minimal polynomial of this matrix 010 100 001

Answered: 1 week ago

Question

=+why not go to Ask.com and enter the question,

Answered: 1 week ago