accounting information for business decisions.

Big Rock Candy Mountain Mining Co. Income Statements For the Years 2019 and 2020 A Big Rock Candy Mowhtain Mining Co. Balance Sheet For the Year Ended December 31, 2020 16 Liabilities \& Owner's Equity \begin{tabular}{l|rrr} 17 & Accounts Payable & $37,752 & $36,819 \\ 18 & Accrued Expenses & 3,183 & 3,085 \\ 19 & Total Current Liabilities & 40,935 & 39,904 \\ 20 & Long-term Debt & 170,562 & 178,581 \\ \cline { 3 - 4 } 21 & Total Liabilities & 211,497 & 218,485 \\ 22 & Common Stock ($1.00 par ) & 58,664 & 58,664 \end{tabular} a. Calculate the firm's expected ending cash balance for each month. b. Assuming that the firm must maintain an ending cash balance of at least $12,000, how much must they borrow during each month? c. If the firm must pay 5% annual interest on its short-term borrowing, what are the ending cash balances for each month? d. What are the ending cash balances if the firm uses any cash in excess of the minimuin to pay off its short-term borrowing in each month? week 2 Assignment: Chapter 3 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 3 Problem \#1, complete parts "a" through "d" (skip part "e") using the provided Excel template below Chapter 3 Problem \#1 Student Name Template XIs Graded Activity: 1. Read Chapters 3 and 4 of your text. 2. Review the PowerPoint for Chapters 3 and 4 and any related videos provided for the week. 3. Complete Week 2 Assignment: Chapter 3 Problem \#1. Please click on the title link above labeled "Week 2 Assignment: Chapter 3 Problem \#1" to enter and submit your work. Table 3-2 Functions Introduced in this Chapter PROBLEMS Big Rock Candy Mountain Mining Co. Income Statements For the Years 2019 and 2020 A Big Rock Candy Mowhtain Mining Co. Balance Sheet For the Year Ended December 31, 2020 16 Liabilities \& Owner's Equity \begin{tabular}{l|rrr} 17 & Accounts Payable & $37,752 & $36,819 \\ 18 & Accrued Expenses & 3,183 & 3,085 \\ 19 & Total Current Liabilities & 40,935 & 39,904 \\ 20 & Long-term Debt & 170,562 & 178,581 \\ \cline { 3 - 4 } 21 & Total Liabilities & 211,497 & 218,485 \\ 22 & Common Stock ($1.00 par ) & 58,664 & 58,664 \end{tabular} a. Calculate the firm's expected ending cash balance for each month. b. Assuming that the firm must maintain an ending cash balance of at least $12,000, how much must they borrow during each month? c. If the firm must pay 5% annual interest on its short-term borrowing, what are the ending cash balances for each month? d. What are the ending cash balances if the firm uses any cash in excess of the minimuin to pay off its short-term borrowing in each month? week 2 Assignment: Chapter 3 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 3 Problem \#1, complete parts "a" through "d" (skip part "e") using the provided Excel template below Chapter 3 Problem \#1 Student Name Template XIs Graded Activity: 1. Read Chapters 3 and 4 of your text. 2. Review the PowerPoint for Chapters 3 and 4 and any related videos provided for the week. 3. Complete Week 2 Assignment: Chapter 3 Problem \#1. Please click on the title link above labeled "Week 2 Assignment: Chapter 3 Problem \#1" to enter and submit your work. Table 3-2 Functions Introduced in this Chapter PROBLEMS