Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

To complete this exercise, download the starting exercise file named EA2_A1_FinancialStatements-eStart that is attached to this assignment. Then follow the EA2-A1 instructions in your Labyrinth

To complete this exercise, download the starting exercise file named EA2_A1_FinancialStatements-eStart that is attached to this assignment. Then follow the EA2-A1 instructions in your Labyrinth Learning textbook.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Apply Your Skills If your classroom is using eLab with Project Grader ("PG"), download and use the eStart file on the Assignments page and submit as directed. If you don't use the estart file, your work cannot be automatically graded. If you are not using Project Grader, open the indicated file from your chapter folder. EA2-A1 Create Financial Statements for Titan Industries PG In this exercise, you will create a monthly income statement, statement of owner's equity, and balance sheet in Excel for Titan Industries. Access the proper file. (Your starting file is intentionally blank.) - Using Project Grader: Download EA2-A1-FinanclalStatemento-eStart. - Not using Project Grader. Open EA2-A1-FinancialStatements. With the exception of the William Buffalo, Capital, account (the balance of which is from 11/1/2026), the company had the following account balances as of 11/30/2026 : Set Up the Workbook Throughout this course, the "appropriate" approach is the one described in the chapter and used in preceding exercise sections. If you aren't given the exact text to entec, setting to make, or other detail, turn back to the chapter for a refresher. - Three tabs, one named for each financial statement and arranged in the order of completion (Hint. For the statement name that won't fit, use the abbreviation ' OEE ' as part of the tab name).) (PG-1) - Range A1:A3 (on each tab): - Enter the appropriate three-line header for the statement (1. company name, 2 financial statement name, 3. date expressed in proper form). (PG-2o) - Bold formatting and this fill color: (PG-2b) - Merge and center the header rows across columns A-D (income Statement) ot columns A-C (Statement of OE., Balance Sheet). (PG-2c) Income Statement Formatting - Cells C11, D12, and D13; Apply the appropriate border (PG-4a) - Cell A15: Enter the text office Expense was the largest expense for the nonth. and apply 10-degree orientation. (PG-4b) - Row 15: Hide it. (PG-4c) - Columns A-D widths: 5, 16, 8, and 9, respectively (PG-4d) - All amounts: Accounting number format, zero decimals (PG-4e) Statement of Owner's Equity Formatting: - Cells C6, C8, and C9: Apply the appropriate border. (PG-6a) - Cells A5 and A9: Wrap the text to display the account names. (PG-6b) - Columns A-C widths: 25,2 and 9, respectively (PG-6c) - Set a height of 29 for the two rows requiring adjustment. (PG-6d) Balance Sheet Remember to add the appropriate borders to cells C10 and C11 (PG-7d), and to insert a line break where needed in the account name in cell A7. (PG-7e) Hint. In this instance, the order of liabilities from short to long-term is also the order from smallest to largest. Formatting: - Cells A19 and A21 (account names): Use Wrap Text. (PG-9a) - Cells C15,C19, and C21: Apply the appropriate border. (PG-9b) - Ranges A6:A10 and A14:A15: Indent the account names one time. (PG-9c) - Columns A-C widths: 18,10 , and 11, respectively (PG-9d) - Set a height of 29 for the three rows requiring adjustment. (PG-9e) - All amounts: Accounting number format, zero decimals (PG-9f) Save and close the file. Using Project Grader: Save the file as EA2-A1-Financialstatements-eSubmisslon and attach it to the assignment you submit for grading. Not using Project Grader: Submit the file per your instructor's guidelines

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started