Project #19958 - ACCounting using excel

 

 Problem 1   
 Cash   4,100
 Accounts Receivable   3,200
 Supplies   800
 Equipment   10,600
 Accumulated Depreciation - equip   1,350
 Accounts payable   2,100
 Salaries and wages payable   700
 Unearned Service Revenue   890
 Owner's Capital   12,900
 Service Revenue   5,450
 Salaries and Wages Expense   3,300
 Advertising Expense   600
 Miscellaneous Expense   290
 Utilities expense   500
   
 Received a check for services to be delivered in six months  $10,000 
 Service revenue of $25,000 was earned, but  not recorded 
 Supplies on hand $500   
 Depreciation Expense not recorded $500   
 Bad debt expense not recorded $750   
 Salaries and Wages for current period to be paid the 5th of next month  $1,200 
 Facility rent for this period will be paid the 5th of next month $2,000 
 Invoice for supplies purchase not recorded $1,200 
   
 1. Complete a Excel Worksheet and calculate the following (add accounts if needed) 
 Trial Balance   
 Adjustments   
 Adjusted Trial Balance   
 Income    
 Balance sheet   
   
 2. Do the journal entries for the adjustment above 
   
   
 Problem 2   
   
 Jan 1, purchased equipment for $150,000 
 Salvage value $30,000   
 Useful life 10 years   
 Units of production 100,000 units   
   
 Prepare deprecation schedules ( for 3 yrs.) using the following methods: 
 Straight-line method   
 Unites of activity method  (12,000, 18,000 & 25,000 units) 
 150% Declining Balance Method   

Subject Mathematics
Due By (Pacific Time) 12/16/2013 03:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy