Nunya business Transaction #1-#8, please use 1153 as the Spreadsheet ID for these equations. Please fill out the financial statement.
Step 21 of 40: Transaction #1 B L M O P CDF Amets Ubies Shareholder's Equity Accounts Common Retained tech Profit & Loss OUT! Det Netincem com Account Nam Sea 3 2 Check TRUE TRUE TRUE TRUE TRUE 9 10 11 Your turn Transaction #1 14 15 Nunya Business started operations on July 1, 2019 with an initial issue of common stock. The amount of this investment is your spreadsheet ID multiplied by 10. Thus if your spreadsheet ID is 1234 then the initial Investment to record is 1234 x 10 - 12,340.Enter this formula into the corresponding cells: -Chart of Accounts'A0000 10 where 0000 is your 4 digit spreadsheet ID. If your formula returns 0 then revisit Step 1 where you were instructed to enter your spreadsheet in on the Chart of Accounts worksheet 10 19 20 21 22 23 After you record this transaction: 25 26 The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually input The check formula should return TRUE Make a selection from column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate. Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts + 29 Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 24/43 00:01 /02:46 N o D E Asset Accounts Profit & Loss Liabilities + Shareholder's Equity Common Retained Stech Camino Entert Bewe Net Income Account Name TRUE 2 TRUE TRUE TRUE Your tum Transaction #2 10 11 12 Nunya Business performed services for one month on account. (The amount of this revenue is your spreadsheet ID multiplied by 100, divided by 12, and rounded to the nearest $1,000.) Use a formula within the correponding worksheet cells to calculate this amount 14 17 Even though no cash was received revenue must be recorded since the revenue recognition rules have been met (it has been "earned" and it is reasonable to expect payment.) After you record this transaction: 20 21 22 23 24 25 26 27 20 The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually input The check formula should return TRUE. Make a selection from column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts Students www.studentsexcel.com Need help? Email: support@studentsexcel.cc 00:02 / 00:49 33/43 00:04 / 00:36 Step 31 of 40: Transaction #8 B 1 M o Profit & Los O 1 DF Arts Liabilities. Shareholders Accents Common Receable laws Stes Retained 12 BE Netcome while TRUE TRUE 5 7 TRUE TRUE TRUE TRUE TRUE TRUE 12 13 14 15 16 Your turn: Transaction #B Record an adjusting entry to recognize 25% of the prepayment from transaction #7 as revenue 10 19 After you record this transaction: 20 21 22 23 24 25 26 You'll have added a new row for your transaction. The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually input. The check figure should return TRUE. Make a selection from column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rif appropriate. 28 22 Honzontal Financial Statement + Balance Sheet Income Statement Chart of Account Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 34/43 00:01/00:23 Step 21 of 40: Transaction #1 B L M O P CDF Amets Ubies Shareholder's Equity Accounts Common Retained tech Profit & Loss OUT! Det Netincem com Account Nam Sea 3 2 Check TRUE TRUE TRUE TRUE TRUE 9 10 11 Your turn Transaction #1 14 15 Nunya Business started operations on July 1, 2019 with an initial issue of common stock. The amount of this investment is your spreadsheet ID multiplied by 10. Thus if your spreadsheet ID is 1234 then the initial Investment to record is 1234 x 10 - 12,340.Enter this formula into the corresponding cells: -Chart of Accounts'A0000 10 where 0000 is your 4 digit spreadsheet ID. If your formula returns 0 then revisit Step 1 where you were instructed to enter your spreadsheet in on the Chart of Accounts worksheet 10 19 20 21 22 23 After you record this transaction: 25 26 The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually input The check formula should return TRUE Make a selection from column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate. Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts + 29 Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 24/43 00:01 /02:46 N o D E Asset Accounts Profit & Loss Liabilities + Shareholder's Equity Common Retained Stech Camino Entert Bewe Net Income Account Name TRUE 2 TRUE TRUE TRUE Your tum Transaction #2 10 11 12 Nunya Business performed services for one month on account. (The amount of this revenue is your spreadsheet ID multiplied by 100, divided by 12, and rounded to the nearest $1,000.) Use a formula within the correponding worksheet cells to calculate this amount 14 17 Even though no cash was received revenue must be recorded since the revenue recognition rules have been met (it has been "earned" and it is reasonable to expect payment.) After you record this transaction: 20 21 22 23 24 25 26 27 20 The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually input The check formula should return TRUE. Make a selection from column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts Students www.studentsexcel.com Need help? Email: support@studentsexcel.cc 00:02 / 00:49 33/43 00:04 / 00:36 Step 31 of 40: Transaction #8 B 1 M o Profit & Los O 1 DF Arts Liabilities. Shareholders Accents Common Receable laws Stes Retained 12 BE Netcome while TRUE TRUE 5 7 TRUE TRUE TRUE TRUE TRUE TRUE 12 13 14 15 16 Your turn: Transaction #B Record an adjusting entry to recognize 25% of the prepayment from transaction #7 as revenue 10 19 After you record this transaction: 20 21 22 23 24 25 26 You'll have added a new row for your transaction. The amounts will be based on formulas in the worksheet cells, as opposed to numbers that you've calculated outside of Excel and then manually input. The check figure should return TRUE. Make a selection from column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rif appropriate. 28 22 Honzontal Financial Statement + Balance Sheet Income Statement Chart of Account Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 34/43 00:01/00:23
