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.

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.


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.