Preparing multistep income statement and calculating profit

Reference no: EM13597772

Preparing multistep income statement and calculating profit percentage.Assume that you have been hired by Big Sky corporation as a summer intern . The company is in the process of preparing their annual financial statement. To help this process , you are asked to prepare an income statement for internal reporting purposes and an income statement for external reporting purposes. Your boss has also requested that you determine the company's gross profit percentage based on statement that you are to prepare. The following adjusted trial balance was created from the general ledger accounts on May 31,2010.

Accounts titel Debit credit
cash 57000
account receivable 67000
inventory 103000
property and equipment 252000
Accumulated depreciation 103000
liabilities 75000
Owner's equity,june 1,2009 265900
sales revenue 369000
sales returns and allowances 9500
sales discounts 14000
cost of goods sold 248000
selling expenses 19000
Administrative expense 23000
General expenses 5000
income tax expense 15400
Totals $812900 $812900

your boss wants you to create the spreadsheet in a way that automatically recalculates net sales and any other related amounts whenever changes are made to the contra-revenue accounts. To do this, you know that you will have to use formulas throughout the worksheets and even import or link cells from one worksheet to another.

Reference no: EM13597772

Questions Cloud

Becton labs inc produces various chemical compounds for : becton labs inc. produces various chemical compounds for industrial use. one compound called fludex is prepared using

Aziz corporation produces and sells a single product data : aziz corporation produces and sells a single product. data concerning that product appear below. selling price per unit

Recently a sales rep from waste radar company told the city : ignore income taxes in this problem. five years ago the city of paranoya spent 30000 to purchase a computerized radar

Operating expenses other than depreciation for the year : operating expenses other than depreciation for the year were 416818. prepaid expenses increased by 24003 and accrued

Preparing multistep income statement and calculating profit : preparing multistep income statement and calculating profit percentage.assume that you have been hired by big sky

A company had net income of 219632 depreciation expense is : a company had net income of 219632. depreciation expense is 26812. during the year accounts receivable and inventory

Analysis of the bank data reveals that the credits consist : videosoft company maintains a checking account at the intelex bank. at july 31 selected data from the general ledger

As of december 31 2009 there are three outstanding loans : as of december 31 2009 there are three outstanding loans with capitalized loan fees that are being amortized over the

Food bear grocery store purchased a new u-scan machine at a : food bear grocery store purchased a new u-scan machine at a cost of 100000. annual operating cash inflows are expected

User Account

All Pages