Need the formulas

ct FIN Ch. 1-3 i Saved Help Maple Moving Company has provided you its list of accounts and unadjusted balances as of December 31, Year 2, along with selected year-end data. The Controller has asked you to prepare an income statement and balance sheet for the year ended December 31, Year 2. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. In the Excel Simulation below, if "-83" is entered in a blank cell, the formula outputs the result from cell B3, which is $62,500 in this example. Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add). - (minus sign to subtract). (asterisk sign to multiply), and/ (forward slash to divide). In the Excel Simulation below, if"-B3+84" is entered in a blank cell, the formula adds the values from those cells and outputs the result. which is 229,660 in this example. If using the other math symbols, the result is an appropriate answer for the function. . SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. In the Excel Simulation below, if "SUM(B3,B4,B5)" is entered in a blank cell, the formula outputs the result of adding those three separate cells, which is 297,260 in this example. Similarly, if-SUM(B3:85)" is entered in a blank cell, the formula outputs the same result of adding those cells even though they are expressed as a range in the formula, so the result is 297,260 in this example. Save & Exit Submit Excel Project FIN Ch. 1-30 10 3 Wood Book References Paste Opd Al Cate BIU Cash 4 Accounts Receivable > Supplies 6 Prepaid Rent 7 Accounts Payable Interest Payable Wages Payable 10 Uncarsed Revenue 11 Notes Payable C D On December 31, Year 2, Maple Moving Company had the following balances before year and adjustme 2. 12 Common Stock 13 Retained Earnings AA 14 Service Revenue 15 Wages Expense 16 Supplies Expense 17 Kent Expense 18 Interest Expense Algement Number Conditional Format as Call Formatting le Styles Style & On December 31. Year 2, Maple Moving Company had the following balances S 62,500 167,160 67,000 42.240 31.500 6,000 100,000 66.000 23,400 167,000 61,000 fdting 19 20 Required: 21 Use the unadjusted account balances above and the following year-end data to 22 determine adjusted account balances and prepare an income statement and balance sheet. BYG F Help Save & Exit Submit 3 10 points Sapped Pri References Paste Clipboard Al Cab RIU EE 19 30 Required: 21 Use the unadjusted account balances above and the following year-end data to 25 Interest owed but not yet paid: 26 Supplies on hand 27 Rent expense 11 31 32 33 34 35 Service Revenue 36 Expenses 37 Wages Expense 38 Supplies Expense 39 Rent Expense 41 Net Income 42 22 determine adjusted account balances and prepare an income statement and balance sheet. 23 Note: If nothing belongs in a cell, leave it blank. 24 28 Unpaid wages camed by employees 29 Unearned revenue that has been earned: 30 Interest Expense KA Mignment Number Conditional Format as Cell Coll Editing Formatting Table Styles Style On December 31, Year 2, Maple Moving Company had the following balances Sheet1 MAPLE MOVING COMPANY Income statement at December 31, Year 2 D 10,800 15,000 35.200 3.500 2,000 E F 0 W 3 10 points Skup ellook References Pate Opbed A1 STU W 44 45 46 47 48 Assets Cash 38 59 50 Accounts Receivable 51 Supplies 52 Prepaid Rent 51 Total Assets 54 55 Liabilities 36 Accounts Payable 37 Interest Payable Wages Payable Unearned Revenue 60 Notes Payable 61 Total Liabilities 62 63 Stockholders' Equity 64 Common Stock READY Tost MAPLE MOVING COMPANY Balance Sheet 4 December 31, Your 2 Alignment Number Conditional format C Formatting Table Styles Styles k On December 31, Year 2, Maple Moving Company had the following balances 65 Retained Earnings 66 Total Stockholders' Equity 67 Total Liabilities and Stockholders Equity Sheet1 B Year 2 D Cassing E F 0 100% ct FIN Ch. 1-3 i Saved Help Maple Moving Company has provided you its list of accounts and unadjusted balances as of December 31, Year 2, along with selected year-end data. The Controller has asked you to prepare an income statement and balance sheet for the year ended December 31, Year 2. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. . Cell Reference: Allows you to refer to data from another cell in the worksheet. In the Excel Simulation below, if "-83" is entered in a blank cell, the formula outputs the result from cell B3, which is $62,500 in this example. Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: + (plus sign to add). - (minus sign to subtract). (asterisk sign to multiply), and/ (forward slash to divide). In the Excel Simulation below, if"-B3+84" is entered in a blank cell, the formula adds the values from those cells and outputs the result. which is 229,660 in this example. If using the other math symbols, the result is an appropriate answer for the function. . SUM function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges to utilize this function. In the Excel Simulation below, if "SUM(B3,B4,B5)" is entered in a blank cell, the formula outputs the result of adding those three separate cells, which is 297,260 in this example. Similarly, if-SUM(B3:85)" is entered in a blank cell, the formula outputs the same result of adding those cells even though they are expressed as a range in the formula, so the result is 297,260 in this example. Save & Exit Submit Excel Project FIN Ch. 1-30 10 3 Wood Book References Paste Opd Al Cate BIU Cash 4 Accounts Receivable > Supplies 6 Prepaid Rent 7 Accounts Payable Interest Payable Wages Payable 10 Uncarsed Revenue 11 Notes Payable C D On December 31, Year 2, Maple Moving Company had the following balances before year and adjustme 2. 12 Common Stock 13 Retained Earnings AA 14 Service Revenue 15 Wages Expense 16 Supplies Expense 17 Kent Expense 18 Interest Expense Algement Number Conditional Format as Call Formatting le Styles Style & On December 31. Year 2, Maple Moving Company had the following balances S 62,500 167,160 67,000 42.240 31.500 6,000 100,000 66.000 23,400 167,000 61,000 fdting 19 20 Required: 21 Use the unadjusted account balances above and the following year-end data to 22 determine adjusted account balances and prepare an income statement and balance sheet. BYG F Help Save & Exit Submit 3 10 points Sapped Pri References Paste Clipboard Al Cab RIU EE 19 30 Required: 21 Use the unadjusted account balances above and the following year-end data to 25 Interest owed but not yet paid: 26 Supplies on hand 27 Rent expense 11 31 32 33 34 35 Service Revenue 36 Expenses 37 Wages Expense 38 Supplies Expense 39 Rent Expense 41 Net Income 42 22 determine adjusted account balances and prepare an income statement and balance sheet. 23 Note: If nothing belongs in a cell, leave it blank. 24 28 Unpaid wages camed by employees 29 Unearned revenue that has been earned: 30 Interest Expense KA Mignment Number Conditional Format as Cell Coll Editing Formatting Table Styles Style On December 31, Year 2, Maple Moving Company had the following balances Sheet1 MAPLE MOVING COMPANY Income statement at December 31, Year 2 D 10,800 15,000 35.200 3.500 2,000 E F 0 W 3 10 points Skup ellook References Pate Opbed A1 STU W 44 45 46 47 48 Assets Cash 38 59 50 Accounts Receivable 51 Supplies 52 Prepaid Rent 51 Total Assets 54 55 Liabilities 36 Accounts Payable 37 Interest Payable Wages Payable Unearned Revenue 60 Notes Payable 61 Total Liabilities 62 63 Stockholders' Equity 64 Common Stock READY Tost MAPLE MOVING COMPANY Balance Sheet 4 December 31, Your 2 Alignment Number Conditional format C Formatting Table Styles Styles k On December 31, Year 2, Maple Moving Company had the following balances 65 Retained Earnings 66 Total Stockholders' Equity 67 Total Liabilities and Stockholders Equity Sheet1 B Year 2 D Cassing E F 0 100%