Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A. Record the journal entries for the December transactions.**Must show formulas in cells. B. Record the adjusting journal entries for 12/31/18.**Must show formulas in cells.

A. Record the journal entries for the December transactions.**Must show formulas in cells. B. Record the adjusting journal entries for 12/31/18.**Must show formulas in cells. C. Set up a worksheet using Excel to: Prepare the Unadjusted Trial Balance as of December 31, by making the December adjustments (separate columns). **Must link cells to journal entries. Enter the adjusting journal entries into worksheet (separate columns). **Must link cells to journal entries. Prepare the Adjusted Trial Balance as of December 31. **Use formulas. Complete the Income Statement and Balance Sheet columns of the worksheet. **Use formulas. D. Prepare a multiple step income statement including calculation of weighted average shares and earnings per share. **Must link to worksheet. E. Prepare a retained earnings statement. **Must link to worksheet. F. Prepare a balance sheet (both years presented). **Must link to worksheet. G. Prepare a cash flows statement. **Must link to comparative balance sheets and income statements. H. Compute the following (**Must link to income statement and/or balance sheet): Current ratio Acid test ratio Debt to Equity Inventory Turnover Accounts Receivable Turnover At least 5 other ratios of your choosing Using the memo format located in Microsoft Word, compile a memo incorporating the following information: Based on the financial statements and ratios, describe the financial health of this company. Would you invest in this company? Why or why not? What would your advice be to the president of the company? Memo must include what other information would be helpful in making your decision. Memo will be graded based on content, correct grammar & spelling and the students ability to summarize financial data in a logical manner indicating the students general understanding of the financial data. See Rubric for additional details. Answer question J

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions

Question

Prepare an ID card of the continent Antarctica?

Answered: 1 week ago

Question

What do you understand by Mendeleev's periodic table

Answered: 1 week ago