Question: I need help with the excel template I have attached the template and the information and instructions. E 4-17 Page 208 Instructions: 1. Prepare the

I need help with the excel template I have attached the template and the information and instructions.

E 4-17 Page 208 Instructions: 1. Prepare the income statement as of August 31. 2. Prepare the retained earnings statement as of August 31. 3. Prepare the classified balance sheet as of August 31. **I have filled in some random spots for you. Note: Enter into the YELLOW cells only! Worth: 50 points *Be sure to answer the question below each statement as they make up 50% of your grade. Points Earned: Step 1 Step 2 AMIT COMPANY INCOME STATEMENT FOR THE YEAR ENDED AUGUST 31, 2012 Revenues: Service Revenue SPRING 2014 $ 34,600 Total Revenues Step 3 AMIT COMPANY RETAINED EARNINGS STATEMENT FOR THE YEAR ENDED AUGUST 31, 2012 $ Current Assets: Cash Retained Earnings, 9/1/2011 Add: Net Income $ 10,900 34,600 Less: Dividends Retained Earnings, 8/31/2012 Expenses: 0 HINT: Total = $16,800 Depreciation Expense AMIT COMPANY BALANCE SHEET FOR THE YEAR ENDED AUGUST 31, 2012 Total Current Assets Less: Accum. Depreciation-Equipment 4,800 Total Assets Current Liabilities 1,200 Total Expenses 6,100

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

search for data of company AMD of 4-5 years and do cash flow statements and ratios only read the requirements for cash flow statements and ratios 21F241_Group Project-2 (Protected View) - Word...

Project 1. Pected Ves Excel Sign in Home Insert Page Layout Formukas Data Review View Help Search Shade p comer Suve 00 H PROTECTED VIEW Be careful files from the Internet can contain vie. Unless you...

Tax return information You own a t-shirt screen printing company called Back the Pack. Back the Pack operates as a regular Corporation under Subchapter C of the Internal Revenue Code. Back the Pack...

I have completed the spreadsheet portion of this assignment, but need help with the written aspects of it. SUBDOMAIN 319.1 - ACCOUNTING & FINANCE SUBDOMAIN 319.2 - INFORMATION TOOLS Competency...

Enable Editing PROTECTED VIEW Be careful files from the internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View i SUBSCRIPTION EXPIRED Most of the features of...

Need assistance solving so I can check my answers for these 5 problems. Formulas (on a separate sheet) would be helpful. Thank you _x000D_ Accounting and Microsoft Excel_x0 -> data creation_x -> data...

Hello, I am pleased with an question you just completed. I have another spreadsheet that I am prepping for test, Will you please complete the tabs P10-3A, p11-2A, P13-7A, P14-3 and P14-9 in its...

QPR 21-4B Cash budget Obj. 5 The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:...

1. On January 10, sold merchandise on account to Rayms $9,000 and Fischer $8,600. Terms 2/10, n/30, F.O.B. shipping point. 2. On January 12, purchased merchandise on account from Zapfel $3,200 and...

Create a personal secenario that exemplifies the time value of money that includes the opportunity cost involved

Find the radiation power developed by a non-relativistic particle with charge e and mass m, moving along a circular orbit of radius R in the field of a stationary point charge q.

What is considered a demand factor that wilt impact the demand curve for a product? Multule Choice movketing metrics competitors' pricing corporate tax rate profit soles volume

Target is using analytics. A) predictive B) Forecasting C) prescriptive D) descriptive

The facts rule: We have a tendency to have more confidence in information that is documented with figures than information that isnt.

The permanence rule: We tend to have more confidence in information that is of a more permanent nature than information that is of a temporary nature.

The official stamp rule: We tend to have more confidence in information that is exempt from the Freedom of Information Act than if the same information was made readily available.