spreadsheet id : 9684

p21 of 40: Transaction #1 K P DE Auverts Liabilities Shareholder's Equity Accounts Common Retained Besche Ubies Stock Lernings M Profit & Loss Net Cash Revenue ExpensesIncome Flow ab 1 Account Name TRUE TRUE THUE ME THUE Your turn Transaction 1 Nunya Business started operations on July 1, 2019 with an initial sue of common stock. The amount of this investment is your spreadsheet ID multiplied by 10. Thus if your spreadsheet DA 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 formulareturns then revitit Sup1 where you were instructed to enter your spreadsheet in 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 retum TRUE takes selection from column to indicate the transactions impact on cash flow. If any. Choose an account nume from column Rippropriate Students > We houden FS F6 FZ F8 F9 F10 F11 F32 Serik PASE Syste Pa % 5 6 7 a ces Presenter Info Step 23 of 40: Transaction #2 D M N Arts Q 5 G H Les Shareholder's Edity Common Refine U och + Canines Account ble K o P Prolit Loss Net Nexus come Cash Account 2 Your tum Transaction 12 Check TRUE TRUE THUE TRUE TRUE Nunya Business performed services for one month on account (The annount of this revenue is your spreadsheet multiplied by 100. divided by 12, and rounded to the nearest $1,000.) Use a formula within the corresponding worksheet calls to calculate this amount Even though no cash was received revenue must be recorded since the revenue recognition rules have been mat it has been earned and it is reasonable to expect payment Ar you record this transaction: The amounts will be based on forms in the worksheet cells as opposed to numbers that you ve calculated outside of Excel and the manual input The check for should return TRUE section to column toledicate the transactions impact on cash flow, if any Choose an accountametro con propriate Students Wow.com 16 F10 F11 112 Solk Pasc. Spills VaR & Break 9 0 Butik 2000 des sources Presenter Info Side 225 Step 24 of 40: Transaction # 3 A D 5 C Assets A. teche Shareholder's Bouty Common Retained Lite Stock Caring K L M Profit a loss Net Neve Income Cash 2. Ono 3 1 A Name Ched TRUE THUE 5 5 4 5 THUE TRUE THUE 10 Your turn: Transaction 3 34 Nunya Business has received 25% of the amount you recorded in Transaction # 2 as partial payment of 15 its accounts receivable 22 After you record this transaction: 19 30 22 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 Rit appropriate son Statement 30 Students We're here to help Email us at supportstudiants excel.com PEV NEXT > O acer