Given company nike sportsset up 8 different scenarios word

Assignment Help Financial Accounting

Reference no: EM13350950

Given Company: Nike Sports

Set up 8 different scenarios (Word Problems) that will result in basic journal entries such as putting money into the business. Design an EXCEL SPREADSHEET to have the student input the values for the journal entries.

Also prepare an EXCEL SOLUTION for this section.

For example : Transaction 1: Purchases office supplies on Jan 4 costing $76000 on credit.

Journal Entry Will be:

Date Transaction Debit Credit

Jan 4 Office Supplies 76000

Accounts Payable 76000

We need 8 transactions like that. And Excel spreadsheet should have different input boxes for different values. The input should be reflected in the solution.

Sheet1: Excel sheet must have input tabs for the values for different transactions. It should be user friendly.

Sheet 2: Another sheet can be named as "Solution JE", should reflect the debit credit values on the Journal Entry Format. Debit and Credit End Amounts (Total) must be same as every transaction has debit and credit effect.

Reference no: EM13350950

Questions Cloud

Eps simple capital structureon 1st january 2012 bailey : eps simple capital structureon 1st january 2012 bailey industries had stock outstanding as follows.6 cumulative

Susan rents an apartment in 2012 she worked full-time as a : susan rents an apartment. in 2012 she worked full-time as a nurse and earned w-2 wages of 50000. each year she claims

Limon company uses the chart of accounts shown below use : limon company uses the chart of accounts shown below. use the numbers preceding each title to create journal entries

Q1 on january 1 of the existing year palm corporation : q1. on january 1 of the existing year palm corporation purchases the net assets of vickis unincorporated business for

Given company nike sportsset up 8 different scenarios word : given company nike sportsset up 8 different scenarios word problems that will result in basic journal entries such as

Hayes company signs a five-year non-cancelable lease with : hayes company signs a five-year non-cancelable lease with lester company on january 1 2008 when the lease begins. the

Comfi airways inc a small two-plane passenger airline has : comfi airways inc. a small two-plane passenger airline has asked for your help in some basic analysis of its

The following data relate to genmet a us based consumer : the following data relate to genmet a u.s. based consumer goods manufacturing firm for the fiscal year ending 31st

Denise and eric are partners in ed partnership eric owns 60 : denise and eric are partners in ed partnership. eric owns 60 capital profits and loss interest. eds only liabilities

User Account

All Pages