Categories
HCS 380 Week 2 WileyPLUS Excel Assignment (Ex 4-12, Ex 4-13, Ex 4-16, Ex P4-1A)
$12.00

HCS 380 Week 2 WileyPLUS Excel Assignment (Ex 4-12, Ex 4-13, Ex 4-16, Ex P4-1A)

This Tutorial was purchased 10 times & rated A by student like you.

 

This Tutorial contains following Attachments

  • HCS 380 Week 2 WileyPLUS Excel Assignment (Ex 4-12, Ex 4-13, Ex 4-16, Ex P4-1A).xlsx

Complete the assigned exercises in WileyPLUS.

 

You should see the following assignments that are due for a grade:

·          

  • Chapter 4 - Excel assignment

NOTE:  Assignment must be completed by Due Date.  Automatic deduction of 50% of points if received after due date.  No points awarded if completed after 4 days from Due Date.

 

Excel Exercise 4-12

http://edugen.wiley.com/edugen/art2/common/pixel.gif

Excel Exercise 4-13

http://edugen.wiley.com/edugen/art2/common/pixel.gif

Excel Exercise 4-16

http://edugen.wiley.com/edugen/art2/common/pixel.gif

Excel Problem 4-1A

 

 

E4-12  Prepare a correct income statement                                                                                                                            

The income statement of Garska Co. for the month of July shows net income of $2,000                                                                                                                            

based on Service Revenue $5,500; Salaries and Wages $2,100; Supplies Expense $900;                                                                                                                            

and Utilities Expense $500.  In reviewing the statement, you discover the following:                                                                                                                                

1.         Insurance expired during July of $350 was omitted.                                                                                                            

2.         Supplies expense includes $200 of supplies that are still on hand at July 31.                                                                                                                       

3.         Depreciation on equipment of $150 was omitted.                                                                                                                 

4.         Accrued but unpaid wages at July 31 of $360 were not included,                                                                                                               

5.         Services performed but unrecorded totaled $700.                                                                                                                

                                                                                                                                   

Instructions                                                                                                                            

Prepare a correct income statement for July 2014.                                                                                                                            

NOTE:  Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .                                                                                                                        

                                                                                                                                   

E4-13  Analyze adjusted data                                                                                                           

This is a partial adjusted trial balance of Barone Company                                                                                                   

                                                                                                           

                                    BARONE COMPANY                                                                     

            Adjusted Trial Balance                                                                                              

            January 31, 2014                                                                                            

                                                                                                           

                                                Debit   Credit                                     

            Supplies                                   $700                                                   

            Prepaid Insurance                               1,560                                                  

            Salaries and Wages Payable                                        $1,060                                                

            Unearned Service Revenue                                         750                                         

            Supplies Expense                                950                                                     

            Insurance Expense                              520                                                     

            Salaries and Wages  Expense                          1,800                                                  

            Service Revenue                                             4,000                                      

                                                                                                           

Instructions                                                                                                    

Answer these questions, assuming the year begins January 1.                                                                                                          

(a)        If the amount in Supplies Expense is the January 31 adjusting entry, and                                                                                       

            $300 of supplies was purchased in January, what was the balance in Supplies                                                                                            

            on January 1?                                                                                     

(b)        If the amount in Insurance Expense is the January 31 adjusting entry, and the                                                                                           

            original insurance premium was for 1 year, what was the total premium and                                                                                               

            when was the policy purchased?                                                                                           

(c )       If $2,500 of salaries was paid in January, what was the balance in Salaries and                                                                                          

            Wages Payable at December 31, 2013?                                                                                             

(d)       If $1,800 was received in January for services performed in January, what was                                                                                          

            the balance in Unearned Service Revenue at December 31, 2013?                                                                                       

NOTE:  Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .                                                                                                

 

E4-16  Prepare adjusting entries from analysis of trial balance                                                                                                         

The trial balance shown below are before and after adjustment for Bere Company at the end of its fiscal year.                                                                                                    

                                                                                                           

BERE OMPANY                                                                                                      

Trial Balance                                                                                                  

August 31, 2014                                                                                                        

                                                                                                           

           

                                                                                                           

Instructions                                                                                                    

Prepare the adjusting entries that were made                                                                                                

NOTE:  Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?" .                                                                                                

                                                                                                           

P4-1A  Record transactions on accrual basis; convert revenue to cash receipts   

Write a review

Order Id


Order Id will be kept Confidential
Your Name:


Your Review:
Rating:   A   B   C   D   F  

Enter the code in the box below:



Related Tutorials
$15.00

This Tutorial was purchased 6 times & rated A by student like you.

This Tutorial contains Excel Sheet which can be used to solve All Wiley Problem for any numbers/values     Complete the assigned exercises in WileyPLUS   Excel Problem 10-8A Excel Problem 10-8B Excel Problem 10-10A     ..
$12.00

This Tutorial was purchased 5 times & rated A+ by student like you.

This Tutorial contains Excel Sheet which can be used to solve below mentioned Problem for any numbers/values     Complete the assigned exercises in WileyPLUS.   Chapter 7 - Excel Assignment (E7-8); Chapter 7 - Excel Assignment (E7-14: Cash Budget)..
$10.00

This Tutorial was purchased 4 times & rated A+ by student like you.

This Tutorial contains Excel Sheet which can be used to solve below mentioned Problem for any numbers/values       Complete the assigned exercises in WileyPLUS. Exercise 13-9   Exercise 13-13   Exercise 13-9 ..
$12.00

This Tutorial was purchased 10 times & rated A by student like you.

Complete the assigned exercises in WileyPLUS.   You should see the following assignments that are due for a grade: ·           Chapter 4 - Excel assignment NOTE:  Assignment must be completed by Due Date.  ..
$12.00

This Tutorial was purchased 3 times & rated A by student like you.

This Tutorial contains Excel Sheet which can be used to solve below mentioned Problem for any numbers/values     Complete the assigned exercises in WileyPLUS.    Excel Exercise 1-15   Excel Problem 1-3A   Exercise 2-1 &nbs..
$7.00

This Tutorial was purchased 4 times & rated A+ by student like you.

Just enter the value and get the answer, this excel file will work for any value     The condensed financial statements of Elliott Company for the years 2013 and 2014 are presented below.   ELLIOTT COMPANY Balance Sheets December 31 (in thousands) 20..
$7.00

This Tutorial was purchased 3 times & rated A by student like you.

Just enter the value and get the answer, this excel file will work for any value     Kinder Company has these comparative balance sheet data:   KINDER COMPANY Balance Sheets December 31 2014    2013 Cash    $ 34,290&..
$9.00

This Tutorial was purchased 9 times & rated A+ by student like you.

This Tutorial contains 2 Papers     Signature Assignment: Cash Control Instructions: Write a 750- to 1,050-word paper in which you: • Explain the principles of internal control. • Explain the use of cash and internal controls to prevent fraud. • Explain w..
$8.00

This Tutorial was purchased 11 times & rated A by student like you.

This Tutorial contains 2 Papers     HCS 380 Week 5 Team Assignment Business Proposal   Business Proposal Instructions: For this assignment, you will use the consolidated financial statements you chose in Week Four. As a team, analyze your chosen cons..
$8.00

This Tutorial was purchased 18 times & rated A+ by student like you.

This Tutorial contains 2 Papers     Signature Assignment: Financial Statement Instructions: The community college instructor has asked for your help again. This time, he has asked for you to personally create a document he could give to his students. Writ..
$6.00

This Tutorial was purchased 8 times & rated A by student like you.

This Tutorial contains 2 Papers   HCS 380 Week 3 Individual Assignment Accounting Comparison   Accounting Comparison Instructions: Create a diagram comparing accrual and cash accounting. Also include a 350- to 700-word summary of the differentiation and uses ..
$8.00

This Tutorial was purchased 6 times & rated A by student like you.

This Tutorial contains 2 PPT     HCS 380 Week 2 Team Assignment Financial Statement Components   Financial Statement Components Instructions: Your team has been asked by a local community college instructor to speak to a class about health care accou..
$6.00

This Tutorial was purchased 14 times & rated A by student like you.

Reference Chart Instructions: Create a chart detailing the three different forms of business organizations (proprietorships, partnerships, and corporations). Also include key users of financial information and briefly explain their roles. Cite 3 peer-reviewed, scholarly, or si..