pls write clear. spread sheet id 3479
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'1A0000 10 whore 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 After you record this transaction: 1 22 23 24 The amounts will he had Your turn: Transaction #2 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 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: Your turn: Transaction #3 12 11 14 15 16 12 Nunya Business has received 25% of the amount you recorded in Transaction #2 as partial payment of its accounts receivable 19 20 21 After you record this transaction: Your turn: Transaction #4 12 13 1 15 16 17 Nunya Business paid 10% of the amount you recorded in Transaction #2 as salary expense. 15 20 21 After you record this transaction: Your turn: Transaction # 5 . 15 16 17 Nunya Business paid 5% of the amount you recorded in Transaction # 2 as rent expense. 49 20 23 After you record this transaction: Your turn: Transaction #6 12 13 30 15 16 17 18 19 20 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: 1 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. 10 17 11 19 20 After you record this entry: Your tum: 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 oun naken TDIIC