Nunya Business questions 1-8. please us the ID number 6799 to complete the financial statment.

B E K Q R D Assets Accounts Receivable G H Liabilities + Shareholder's Equity Common Retained Liabilities Stock Earnings L M N o P Profit & Loss Net Revenue Expenses Income try. Cash 1 Cash Flow Account Name N Chec TRU TRUE TRUE TRUE TRUE 3 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: F'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 ID on the Chart of Accounts worksheet 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 columna 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 Chan OF ACCOUNT TRUE TRUE TRUE TRUE TRUE Your tum Transaction 2 9 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 corresponding worksheet cells to calculate this amount 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) 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 of Accounts 10 Your tum: Transaction 3 Nunya Business has received 25% of the amount you recorded in Transaction #2 as partial payment of Its accounts receivable 2 13 14 15 16 1 18 19 20 21 22 23 Are 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 Bancsheet Income statement chant of Accounts Your turn: Transaction #4 Nunya Business paid 10% of the amount you recorded in Transaction # 2 as salary expense. 20 11 12 13 14 15 16 17 18 19 20 21 22 23 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. Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts Your turn: Transaction #5 Nunya Business paid 5% of the amount you recorded in Transaction #2 as rent expense. 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 transactions impact on cash flow, if any. Choose an account name from column Rif appropriate. Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts 8 TRUE Your turn: Transaction #6 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: 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 Huu wal TRUE Your tum: Transaction #7 9 au 11 12 13 14 15 16 17 18 19 20 21 22 23 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 After you record this entry: 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 Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rif appropriate. Horizontal Financial Statement ENCE SHEET com surement chant or Account 24 TRU TRU Your turn: Transaction #8 Record an adjusting entry to recognize 25% of the prepayment from transaction #7 as revenue. After you record this transaction: 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 acco name from column Rif appropriate. WONTONCAT Financial Statement wandeneet Income statement CNBLOT ACCOUMS