Purchase Solution

Creating an income statement and balance sheet

Not what you're looking for?

Ask Custom Question

Create an income statement and a balance sheet for years Y1 through Y5. You must use the accrual basis of accounting and apply GAAP accounting principles. Include the following five items on a separate sheet in the same EXCEL worksheet file: balance sheet; income statement; calculation of cost of goods sold, purchases, and ending inventory; calculation of ending cash balance; cash collections of accounts receivable and cash payments of other current liabilities.

Please see the attached documents for the full description of the assignment.

Attachments
Purchase this Solution
Solution Summary

You will see all formulas and relevant links inside the calculated fields. If you change the figures in the assumptions or/and in the statements of Y0, all subsequent years' amounts will change automatically.

Solution Preview

Attached is a dynamic Excel file with the suggested solution. You ...

Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

View More Free Quizzes
Related BrainMass Solutions

  • Financial Statements

    Have a great day, JP Detailed information on creating the income statement and balance sheet

  • Financial Management: Creating Pro Forma Statements

    548390 Financial Management: Creating Pro Forma Statements Consider the following simplified financial statements for the Fire Corporation (assuming no income taxes): Income Statement Balance Sheet Sales $ 46,900 Assets $ 22,700

  • Preparing financial statements with trial balances

    And since you subtracted withdrawals, when you were creating your owner's statement of equity, in your balance sheet, you will need to add it to owner's equity (capital) Now when you look at your trial balance you will see an item called unearned service

  • Proforma Financial Statements for Stevens Textiles

    70615 Pro forma Balance Sheet This problem requires creating a pro-forma balance sheet to come up with the answers.

  • Inventory loss, damaged goods, theft

    514124 Display loss, damaged goods, and stolen inventory on a financial statement I am attempting to display on a financial statement (balance sheet, income statement, and retained earnings) the recording of an inventory loss, damaged goods, and theft

  • Creating Financial Statements, and Closing Entries

    Prepare the income statement, the statement of retained earnings, and the classified balance sheet in account format. 3. Prepare closing journal entries from the worksheet. 4. Did the company have a good or a bad year during 2012?

  • Costa Company, Pickett Company,effect of the errors, profits

    $89,100 I need prepare an income statement and a balance sheet in good format after adjusting for the two errors below.

  • Write a memo explaning the financial statements

    Income Statement: The Income Statement (sometimes referred to as the "Profit and Loss" Statement) contains every account not considered on the Balance Sheet. These three types of accounts are Revenues, Cost-of-Goods-Sold and Expenses.

  • Projected Financial Analysis Identified

    Identify at least one problem that may result from an incorrect projection. A projected financial analysis contains the forecasted income statement and balance sheet.

View More Related Solutions