Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Old MathJax webview Old MathJax webview The answer I just got from you does not match the questions? I'm not sure where I can comment

Old MathJax webview

Old MathJax webview

The answer I just got from you does not match the questions?

I'm not sure where I can comment on the last question it is not allowing me to comment on the chapter 3 question..

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Miller-Nobles (12e) - Using Excel Ch01v3 Project Description: Steps to Perform: Step Instructions Points Possible 0 1 Download and open the excel spreadsheet, Miller-Nobles_12e-Using Excel_Ch01_Start.xlsx This spreadsheet includes 6 tabs, you will enter all answers on the tabs from the second to the sixth ones, ENTERANSWERS1-ENTERANSWERS5. (All answers should be entered in the blue highlighted cells.) 28 2. Echo Lake Company started operations on November 1, 2018. Nine transactions occurred during November. Financial statements are prepared at the end of the month. Use Excel to prepare a transaction analysis of the nine transactions. Use the blue shaded areas for inputs. (28 pts) a For each transaction, record the amount (either an increase or decrease) under the correct account. Enter only non-zero amounts. If an account is not affected by the transaction leave the amount blank. Be sure to use a minus sign (-) if the amount is a decrease. Enter dividends and expenses as negative amounts. Do not use an equal sign () when entering a numeric value b The row totals will be calculated automatically c. The accounting equation (Assets = Liabilities + Equity) should remain in balance after each transaction. The accounting equation is calculated automatically to the right of the transaction table. value. b. The row totals will be calculated automatically. The accounting equation (Assets = Liabilities + Equity) should remain in balance after each transaction. The accounting equation is calculated automatically to the right of the transaction table. 11 3 Prepare the income statement. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the ENTERANSWERS1 tab. (11 pts) (Always use cell references and formulas where appropriate to receive full credit.) 13 4 Prepare the statement of owner's equity. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the ENTERANSWERS1 and the ENTERANSWERS2 tabs. (13 pts) (Always use cell references and formulas where appropriate to receive full credit.) 15 5 Prepare the balance sheet. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the ENTERANSWERS1 and the ENTERANSWERS3 tabs. (16 pts) (Always use cell references and formulas where appropriate to receive full credit.) 22 6 Prepare the statement of cash flows. Fill in the blue shaded areas using a formula that references the changes in the account balances due to the corresponding transaction in the ENTERANSWERS1 tab. Do not use an equal sign (-) when entering a numeric value. Enter value in all answer boxes, even if answer is 0. (22 pts) (Always use cell references and formulas where appropriate to receive full credit.) M N P Accounting and the Business Environment Using Excel to Prepare Transaction Analysis Echo Lake Company started operations on November 1, 2018. Nine transactions occurred during November. Financial statements are prepared at the end of the month Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. Copy/pasting values will NOT earn full points. Possible Points 28 Requirements D 1 Use Excel to prepare a transaction analysis of the nine transactions. Use the blue shaded areas for inputs. a. For each transaction, record the amount (either an increase or decrease) under the correct account. Enter only non-zero amounts. If an account is not affected by the transaction, leave the amount blank. Be sure to use a minus sign (-) if the amount is a decrease. Enter withdrawals and expenses 1 as negative amounts. Do not use an equal sign () when entering a numeric value. 12 b. The row totals will be calculated automatically. The accounting equation (Assets = Liabilities +Equity) should remain in balance after each transaction. The accounting equation is calculated 13 automatically to the right of the transaction table. 2 Prepare the income statement (11 pts), statement of owner's equity (13 pts), balance sheet (16 pts), and statement of cash flows (22 pts) for the company. Each financial statement appears on separate worksheet tab. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the ENTERANSWERS1 tab. C 75 16 17 Excel Skills 18 1 Enter numbers into cells. Enter text into cells. 19 2 Use Excel to prepare the income statement, statement of retained earnings, balance sheet and statement of cash flows. 20 Instructions ENTERANSWERS ENTERANSWERS ENTERANSWERS ENTERANSWERS4 ENTERANSWERSS M xcel to prepare a transaction analysis of the nine transactions. Use the blue shaded areas for inputs. or each transaction, record the amount (either an increase or decrease) under the correct account. Enter only non-zero amounts. If an account is not affected by the transaction, leave the amount blank. e sure to use a minus sign (-) if the amount is a decrease. Enter withdrawals and expenses as negative amounts. not use an equal sign (=) when entering a numeric value. ne row totals will be calculated automatically. e accounting equation (Assets = Liabilities - Equity) should remain in balance after each transaction. The accounting equation is calculated automatically to the right of the transaction table. Description Assets Liabilities Owner's Equity Total Accounts Office Receivable Supplies A= Accounts Payable Stefanni, Capital Stefanni, Withdrawals Service Rent Salaries Revenue Expense Expense Total Owner's Equity Total Liabilities Cash Land Assets L+ OE 0 0 0 0 0 0 0 0 0 0 0 0 0 TRUE ol 0 0 0 0 0 0 0 0 0 0 0 0 TRUE Received $50,000 cash from the owner, Luigi Stefanni. Balance Purchased land for $23,000 cash. Balance Purchased $300 of office supplies on account. Balance Received $7,500 cash for services performed. Balance Performed services on account, $2,000. 0 0 0 0 0 0 0 0 0 0 0 0 TRUE 0 o 0 0 0 0 0 0 0 0 0 0 0 0 0 TRUE al CALLE Arnar A B D E F G H 1 K L M N O P B 0 O 0 O 0 0 0 0 0 0 0 0 0 0 TRUE 0 0 0 0 0 0 0 0 0 0 0 O 0 TRUE 0 O 0 O 0 0 0 0 0 o 0 te O TRUE RUE 0 0 0 0 0 0 0 0 0 0 0 0 0 TRUE 0 O 0 0 0 0 0 0 0 0 0 0 TRUE Received $50,000 cash from the 2 1 owner, Luigi Stefanni. 3 Balance 2 Purchased land for $23,000 cash. 15 Balance Purchased $300 of office supplies 36 3 on account. 17 Balance Received $7,500 cash for services 18 4 performed. 19 Balance Performed services on account, 20 5 $2,000. 21 Balance Paid in cash: $1,500 for rent & 22 6 $1,100 for employees' salaries 23 Balance 24 7 7 Paid $250 to creditor on account. Balance Collected $1,600 from customers 26 8 on account 27 Balance Stefanni withdrew $4,000 cash 28 9 from the business. 29 Balance 30 31 Instructions ENTERANSWERS1 0 0 0 0 0 0 0 0 0 0 0 0 TRUE 0 0 O 0 0 0 0 0 0 0 0 0 25 TRUE 0 0 0 0 ol 0 0 0 0 0 O 0 0 TRUE + 0 D 0 0 0 0 0 0 0 0 TRUE 0 ENTERANSWERS2 ENTERANSWERS ENTERANSWERS4 ENTERANSWERSS A B D G H Prepare the income statement. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in 1 the ENTERANSWERS1 tab. 2 (Always use cell references and formulas where appropriate to receive full credit.) 3 5 Income Statement 6 7. 8 Revenues 9 Expenses 10 11 12 13 14 Total Expenses $ 15 16 18 19 HINTS 20 Cell Hint D12:013 | Expenses should be entered as positive numbers in the income statement, 21 Add a negative sign in front of each formula for expense on the income statement to reverse the sign 22 AA B D E G H 1 K L Prepare the statement of retained earnings. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the 1 ENTERANSWERS1 and the ENTERANSWERS2 tabs. 2 (Always use cell references and formulas where appropriate to receive full credit.) 3 4 Statement of Owner's Equity 5 6 7 8 $ 0 9 10 11 12 13 $ - 14 15 16 17 18 19 20 21 22 23 24 25 26 ENTERANSWERS2 ENTERANSWERS ENTERANSWERS4 Instructions ENTERANSWERS1 ENTERANSWERSS Ready TOVI M N @ D E F G H 1 K Prepare the balance sheet. Fill in the blue shaded areas using a formula that references the account balances at the end of the month in the ENTERANSWERS1 and the ENTERANSWERS3 tabs. 2 (Always use cell references and formulas where appropriate to receive full credit.) Balance Sheet 5 6 7 - 8 Assets 9 10 11 12 13 14 Total Assets $ Liabilities 15 16 17 18 19 20 Owner's Equity $ Total Liabilities and Owner's Equity 21 22 23 24 25 26 ENTERANSWERS ENTERANSWERS4 ENTERANSWERS ENTERANSWERS Instructions ENTERANSWERS1 A1 fx Prepare the statement of cash flows. Fill in the blue shaded areas using a formula that references the changes in the account balances due B D E G Prepare the statement of cash flows. Fill in the blue shaded areas using a formula that references the changes in the account balances due to the corresponding transaction 1 in the ENTERANSWERS1 tab. Be sure that the amount is entered as a negative number if it is an outflow. 2. Do not use an equal sign (=) when entering a numeric value. Enter value in all answer boxes, even if answer is 0. 3 (Always use cell references and formulas where appropriate to receive full credit.) 4 5 Statement of Cash Flows 6 7 8 9 Cash Flows from operating activities: Receipts: 10 11 12 Payments: 13 15 16 Total Payments Net cash provided by operating activities 17 18 19 Cash flows from investing activities: Net cash used by investing activities Cash flows from financing activities: 20 21 22 23 24 25 26 Net cash provided by financing activities ENTERANSWERS4 ENTERANSWERS ENTERANSWERS ENTERANSWERS3 Instructions ENTERANSWERS1 Ready vo

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Auditing SAP S 4HANA

Authors: Steve Biskie

1st Edition

1493222643, 978-1493222643

More Books

Students also viewed these Accounting questions