Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started