example Assignment - Excel

Document Sample
example  Assignment  - Excel Powered By Docstoc
					IDA-O ASSIGNMENT 3

                                                                    Horizontal Statement Model
                                                                                                             Stk. Equity          Income Statement
                                                                       Type                                Com.          Ret.                     Net   Cash
                                                                        of
     Event                                                             Event       Assets = Liab + Stock + Earn.                Rev.   - Exp. = Inc.    Flows
                                                                                              .
a. Purchased land for cash                                               AE          I/D         NA         NA           NA       NA      NA      NA    D   IA

b. Acquired cash from the issue of common stock                          AS

c. Collected cash from accounts receivable                               AE

d. Paid cash for operating expenses                                      AU

e. Recorded accrued salaries                                             CE

f. Paid cash to purchase office equipment                                AE

g. Performed services on account                                         AS

h. Paid cash advance for rent on office space.
                          AE

i.   Recorded depreciation expense on office equipment                   AU

j.   Performed services for cash                                         AS

k. Purchased a building with cash and issued a note payable            AE/AS

l.   Paid cash for salaries accrued at the end of a prior period         AU

m. Paid a cash dividend to the stockholders                              AU

n. Adjusted books to reflect the amount of prepaid rent expired          AU
   during the period
o. Incurred operating expenses on account                                CE

p. Paid cash on accounts payable                                         AU

q. Received cash advance for services to be provided in the              AS
   future.




     In this Assignment, we must identify Transactions type and effect on Financial Statements



     Identify whether each of the following transactions is an asset source (AS), asset use (AU), asset exchange (AE), or claims exchange (CE).



     In the tan and blue columns:

     Indicate whether the event increases (I), decreases (D), or does not affect (NA) each element of the financial statements.



     In the green column:

     

Designate the cash flows as operating activities (OA), investing activities (IA), or financing activities (FA).



     A few transactions have been recorded as examples.





                                                                                                                                                                 9

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:19
posted:9/3/2011
language:English
pages:1