Using the data presented below: Big Rock Candy Mountain Mining Co. Income Statements For the Years 2019 and 2020 2020 Sales Cost of Goods Gross Profit Depreciation Selling & Admin. Expense Other Operating Expense Net Operating Income Interest Expense Earnings Before Taxes Taxes Net Income Notes: Tax Rate Shares Earnings per Share 25.00% 52,100 $0.40 25.00% 52,100 $0.28 $412,500 318,786 93,714 29,800 26,250 1,210 36,454 8,582 27,872 6,968 20,904 2019 $398,600 315,300 83,300 29,652 24,550 1,245 27,853 8,457 19,396 4,849 14,547 Big Rock Candy Mountain Mining Co. Balance Sheet For the Year Ended December 31, 2020 2020 Assets Cash Marketable Securities Accounts Receivable Inventory Total Current Assets Gross Fixed Assets Accumulated Depreciation 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) Additional Paid-in-Capital Retained Earnings Total Owner's Equity Total Liab. & Owner's Equity $16,435 3,656 45,896 52,397 118,384 436,573 87,450 349,123 467,507 $37,752 3,183 40,935 170,562 211,497 58,664 136,807 60,539 256,010 467,507 2019 $11,596 619 47,404 54,599 114,218 397,023 57,650 339,373 453,591 $36,819 3,085 39,904 178,581 218,485 58,664 136,807 39,635 235,106 453,591

a. Recreate the income statement and balance sheet using formulas wherever possible. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly. b. On another worksheet, create a statement of cash flows for 2020. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous worksheets. c. Using Excels outlining feature, create an outline on the statement of cash flows that, when collapsed, shows only the subtotals for each section. d. Suppose that sales were $425,000 in 2020 rather than $412,500. What is the 2020 net income and retained earnings?