The debit credit values on the journal entry format

Assignment Help Financial Accounting

Reference no: EM134963

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: EM134963

Questions Cloud

Simple capital structure : Assuming that Susan has a marginal tax rate of 30%, the net effect of her having this hobby will be to increase her total tax liability by:

Evaluate the total tax liability : Assuming that Susan has a marginal tax rate of 30%, the net effect of her having this hobby will be to increase her total tax liability by:

Create journal entries for each situation : Limon Company uses the chart of accounts shown below. Use the numbers preceding each title to create journal entries for each situation.

How would vickis assets be recorded for tax purposes : How would Vicki's assets be recorded for tax purposes by Palm Corporation? What is the amortization amount for each intangible asset in the current year?

The debit credit values on the journal entry format : We need transactions like that. And Excel spreadsheet should have different input boxes for different values. The input should be reflected in the solution.

Give the appropriate journal entries for lester company : Give the appropriate journal entries for Lester Company through 31 st December, 2009. Based on the above lease contract, answer the following:-Item(s) and related amount(s) in years 2008 and 2009 reported on:1. Income Statement 2. Balance Sheet 3. S..

Determine the contribution margin at the break-even point : Calculate the break-even point in (1) dollars and (2) number of fares. Without calculations, determine the contribution margin at the break-even point.

Evaluate genmets net income for fiscal year 2013 : Evaluate GenMet's net income for fiscal year 2013. Round your calculations and answer to one decimal place. Enter the amount in millions.

How much loss can eric and denise recognize : The loan is secured by property with a $230,000 fmv. ed has a $200,000 ordinary loss during the current year. How much loss can eric and denise recognize?

User Account

All Pages