Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2020 20202019 Assets 6 Cash 7 Marketable Securities 8 Accounts Receivable Inventory Total Current Assets Gross Fixed Assets 12 Accumulated Depreciation 13 Net Plant \& Equipment Total Assets Liabilities \& Owner's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ( $1.00 par) 23 Additional Paid-in-Capital 24 Retained Earnings 25 Total Owner's Equity Total Liab. \& Owner's Equity Income Statement Balance Sheet Statement of Cash Flows Big Rock Candy Mountain Mining Co. Statement of Cash Flows For the Year Ended December 31, 2020 Cash Flows from Operations Net Income Depreciation Expense Change in Marketable Securities Change in Accounts Receivable Change in Inventory Change in Accounts Payable Change in Accrued Expenses Total Cash Flows from Operations Cash Flows from Investing Change in Gross Fixed Assets Total Cash Flows from Investing Cash Flows from Financing Change in Long-term Debt Change in Common Stock (\$2 par) Change in Additional Paid-in-Capital Total Cash Flows from Financing Net Change in Cash Balance A B C D E Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Earnings per Share Notes: Tin Rate Shares Eaminqs per Slare = Week 1 Assignment: Chapter 2 Problem \#1 Requirement: You will complete most of your weekly assignments using Excel. These assignments will reference the concepts learned from your text, from your chapter PowerPoints, and other videos provided for you to view. Please be sure to review the chapter PowerPoints before beginning your assignments. Topic: Using the information provided in Chapter 2 Problem \#1, complete parts "a" through " e " using the provided Excel template below. Graded Activity: 1. Read Chapters 1 and 2 of your text. 2. Review the PowerPoint for Chapters 1 and 2 and any related videos provided for the week 3. Complete Week 1 Assignment: Chapter 2 Problem \#1. Please click on the title link above labeled "Week 1 Assignment: Chapter 2 Problem \#1" to enter and submit your work. Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2020 20202019 Assets 6 Cash 7 Marketable Securities 8 Accounts Receivable Inventory Total Current Assets Gross Fixed Assets 12 Accumulated Depreciation 13 Net Plant \& Equipment Total Assets Liabilities \& Owner's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ( $1.00 par) 23 Additional Paid-in-Capital 24 Retained Earnings 25 Total Owner's Equity Total Liab. \& Owner's Equity Income Statement Balance Sheet Statement of Cash Flows Big Rock Candy Mountain Mining Co. Statement of Cash Flows For the Year Ended December 31, 2020 Cash Flows from Operations Net Income Depreciation Expense Change in Marketable Securities Change in Accounts Receivable Change in Inventory Change in Accounts Payable Change in Accrued Expenses Total Cash Flows from Operations Cash Flows from Investing Change in Gross Fixed Assets Total Cash Flows from Investing Cash Flows from Financing Change in Long-term Debt Change in Common Stock (\$2 par) Change in Additional Paid-in-Capital Total Cash Flows from Financing Net Change in Cash Balance A B C D E Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Earnings per Share Notes: Tin Rate Shares Eaminqs per Slare = Week 1 Assignment: Chapter 2 Problem \#1 Requirement: You will complete most of your weekly assignments using Excel. These assignments will reference the concepts learned from your text, from your chapter PowerPoints, and other videos provided for you to view. Please be sure to review the chapter PowerPoints before beginning your assignments. Topic: Using the information provided in Chapter 2 Problem \#1, complete parts "a" through " e " using the provided Excel template below. Graded Activity: 1. Read Chapters 1 and 2 of your text. 2. Review the PowerPoint for Chapters 1 and 2 and any related videos provided for the week 3. Complete Week 1 Assignment: Chapter 2 Problem \#1. Please click on the title link above labeled "Week 1 Assignment: Chapter 2 Problem \#1" to enter and submit your work