Nunya Transaction Business questions #1-#8, please use 6679 as the ID number and please complete the financial statement.

Step 21 of 40: Transaction #1 B KL P M O Profit & Los CDF Aneta abilities. Shareholder's Equity Account Come on Retained Rese: Stech OUTL Netincem cflew Account 2 Tete 3 Sea 2 Check TRUE TRUE TRUE TRUE TRUE 5 L! 9 10 11 Your turn Transaction #1 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 14 15 10 17 10 19 20 21 22 23 24 25 26 After you record this 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 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 Rif appropriate. Horizontal Financial Statement Balance Sheet Income Statement Chart Accounts + 28 29 Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 24/43 00:01 / 02:46 N Profit & Loss D Asset Liabilities + Shareholder's Equity Accounts Commen Retained Receivable abilities Stech Chines Rev Errent Neincome Chile Account Name 2 OM TRUE TRUE 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 15 16 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.) 18 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 to indicate the transaction's impact on cash flow, if any. - Choose an account name from column R if appropriate Horizontal Financial Statement Balance She Income Statement Chart of Accounts Students www.studentsexcel.com Need help? Email: support@studentsexcel.cc 00:02 / 00:49 29/43 00:01 / 00:21 Step 29 of 40: Transaction #6 A K L P Q M N Profile & Low 1 DF Amets Liabilities + Shareholder's Equity Account Commen Retained Receivable Liabilities Stock Retu Netincome Account Name 2 2 Ento 3 4 5 6 2 TRUT TRUE TRUE TRUE TRUE TRUE Your tum: Transaction #6 10 11 12 13 14 15 16 17 10 19 20 21 22 23 Record the payment of the telephone bill. This amount is 1% of the amount that you calculated in Transaction #2 After you record this 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 formula should return TRUE. Make a selection from column to indicate the transaction's impact on cash flow. If any. Choose an account name from column Rif appropriate. 24 26 27 28 29 Horizontal Financial Statement Balance Sheet In Statement Chant of Accounts Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 32 / 43 00:01/00:14 Step 30 of 40: Transaction #7 P . 5 K L M N 0 Profilow OUTLINE 1 Awets Accevets Libilities Shareholder's guilty Common Retained . Canh Net Income when Search 2 tot 3 1 4 2 5 3 6 4 7 8 Chech TRUE TRUE TRUE TRUE THUE TRUE TRUE 11 12 13 14 15 Your turn: Transaction #7 Record a cash prepayment from a second customer. This amount will be your spreadsheet ID multiplied by 100, divided by 60, rounded to the nearest 1,000. 17 10 19 20 21 After you record this entry 23 24 25 26 27 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 formula should return TRUE Make a selection from column to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate Balance Sheet income Statement Horizontal Financial Statement Chart of Accounts Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 33/43 00:04 / 00:36 Step 31 of 40: Transaction #8 o Profit & Los O 1 DF Arts Liabilities: Shareholder's Equity Accounts Commen Retained Recebal Stock Eretince Cashflow Account Nam 2 Entry 3 4 Check TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE 7 Your turn: Transaction #B Record an adjusting entry to recognize 25% of the prepayment from transaction #7 as revenue After you record this transaction: 12 13 14 15 16 17 10 19 20 21 22 23 24 25 26 27 28 29 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 to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate. + Honzontal Financial Statement Balance Sheet Income Statement Chat of Account Students www.studentsexcel.com Need help? Email: support@studentsexcel.com 34/43 00:01/00:23