Nunya Business Transaction #1-8 please use 4563 as the spreadsheet id for these equations. please fill out financial statement.
DocuSign Perimeter Ulice esources Presenter Info Slide ID: 4422 Step 21 of 40: Transaction #1 R a A K E 1 D Assets Accounts + Receivable F G H Liabilities. Shareholder's Equity Common Retained Liabilities Stock Farnings L M P Profit & Loss Net. Revenue Expenses Income Cash Flow Account Name Cash 2 Entry 3 4 5 2 3 4 9 Your turn: Transaction #1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 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 column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rif appropriate. HOMEONEST FIN STETS Statement Balance Sheet come Statement CON ACCOUNT Students Excel We're here to help. Email us at support@studentsexcel, sources Presenter into Slide ID: 4424 Step 23 of 40: Transaction #2 R 5 2 D Assets Accounts Resells GHD Liabilities. Shareholder's Equity Common Retained Liabilities : Stock Earnings M O P Profit & Loss Net Revenue : Expenses : Income Cash Flow 2 Entry 3 Account. Nams 1 2 Check TRUE TRUE TRUE TRUE TRUE Your turn: Transaction #2 10 11 12 13 16 17 18 19 20 21 22 23 24 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) 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 Sign Perimeter Ohce arces Presenter Info He ID 4425 Step 24 of 40: Transaction # 3 K L Q D Assets Accounts Receivable E G Liabilities. Shareholder's Equity Common Retained ulabilit Stock : Earnings M N O Profit & Loss Net Expenses : Income Cash Flow Revenue : Account Name 2 Entry Cash 3 4 2 5 3 6 4 7 5 9 Your turn: Transaction #3 Nunya Business has received 25% of the amount you recorded in Transaction #2 as partial payment of Its accounts receivable. 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 DocuPrint Oce Resources Presenter Info Slide ID 4420 Step 25 of 40: Transaction #4 a R B 1 D Assets Accounts Recevable E G Liabilities + Shareholder's Equity Common Retained Liabilities Stock Earnings K M N 0 P Profit & Loss Net Revenue : Expenses : Income Cash Flow Account Name 2 Entry Cash 3 1 2 5 6 7 5 9 10 11 12 13 14 Your turn: Transaction 4 15 Nunya Business paid 10% of the amount you recorded in Transaction #2 as salary expense. 16 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 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 Studonta Horisontal Statem Dashboard Studentice.com x Main Donces/Chegg.com o students cel.com/horisontal/windows DocuSige Perimeter My LastPass Academic Calendar Lu Life University One Square Dashboard I Homettere Resources Presenter info Slide ID. 4427 Step 26 of 40: Transaction #5 a 8 1 C D Assets Accounts Receivable G H Liabilities. Shareholder's Equity Common Retained Liabilities - Stock Larnings M N p Profit & Loss Net Revenue : Expenses Income Cash Flow Account Name 2 Entry Cash 3 4 2 5 3 Ches TRUE TRUE TRUE TRUI TRU 6 10 Your turn: Transaction #5 13 15 16 Nunya Business paid 5% of the amount you recorded in Transaction #2 as rent expense. After you record this transaction: 19 20 21 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 transactions impact on cash flow, if any. Choose an account name from column R if appropriate. 23 24 Dashboard: StudentsExcel.com Horizontal Financial Statex vices | Chegg.com Home Mante Bentsexcel.com/honzontal/windows/ DocuSign e Perimeter Otice Pr. D Square Dashboard I Home Lite Univers My LastPass Vaut I Academic Calendar Life University Oni ources Presenter Info lide ID: 4430 Step 29 of 40: Transaction #6 B 1 D Assets Accounts Receivable E G H K Liabilities Shareholder's Equity Common Retained Liabilities - Stock Earnings M O P Profit & Loss Net Revenue Expenses e Income Cash How Account Name 2 Entry Cash 3 3 4 Check TRUE TRUE TRUE TRUE TRUE TRUE 5 6 7 8 3 4 5 6 10 11 2 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: 13 14 15 16 17 18 19 20 21 22 25 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 Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rifappropriate. Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts Students Excel Ute University cuSign Perimeter Office Pr DSquare Dashboard Ill Home Life Uniwers My LastPass Vault Academic Calendar rces Presenter Info e ID: 4431 tep 30 of 40: Transaction #7 Q 1 D Assets Accounts Receivable G H Liabilities + Shareholder's Equity Common Retained luabilities - Stock Earnings MNO P Profit & Loss Net Revenue : Expenses Income Cash Flow Account Name 2 Entry Cash 3 1 4 2 5 3 6 4 7 Ched TRUE TRUE TRUE TRUE TRUE TRUE TRUE 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, After you record this entry: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 Balance sheet Income Statement Chart or Accounts och My LastPass Vault Academic Calendar Lu Lile University On dentel.com/horizontal/windows/ Docu Permite Orice DSquare Dashboard Home Life Universe ources Presenter into Slide ID: 4432 Step 31 of 40: Transaction #8 a MANO Profit & Loss A Net. D Assets Accounts Receivable G H Liabilities. Shareholder's Equity Common Retained Liabilities - Stock + Earnings Cash Flow Account Name Revenue Expenses income 2 Entry 3 1 4 2 5 3 6 5 8 Check TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE 9 10 12 Your turn: Transaction 8 14 Record an adjusting entry to recognize 25% of the prepayment from transaction #7 as revenue. After you record this transaction: 15 16 17 18 19 20 21 22 23 24 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 R if appropriate. MOTTON TOMTOT Income Anet der ha A. TUK Bobce Short Income Out of Account 0 dan SUSASIS Potem Mam Balance Sheet CA HAITAM aroops thatal era | step terioris | Anet der ha A. TUK Bobce Short Income Out of Account 0 dan SUSASIS Potem Mam Balance Sheet CA HAITAM aroops thatal era | step terioris | DocuSign Perimeter Ulice esources Presenter Info Slide ID: 4422 Step 21 of 40: Transaction #1 R a A K E 1 D Assets Accounts + Receivable F G H Liabilities. Shareholder's Equity Common Retained Liabilities Stock Farnings L M P Profit & Loss Net. Revenue Expenses Income Cash Flow Account Name Cash 2 Entry 3 4 5 2 3 4 9 Your turn: Transaction #1 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 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 column Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rif appropriate. HOMEONEST FIN STETS Statement Balance Sheet come Statement CON ACCOUNT Students Excel We're here to help. Email us at support@studentsexcel, sources Presenter into Slide ID: 4424 Step 23 of 40: Transaction #2 R 5 2 D Assets Accounts Resells GHD Liabilities. Shareholder's Equity Common Retained Liabilities : Stock Earnings M O P Profit & Loss Net Revenue : Expenses : Income Cash Flow 2 Entry 3 Account. Nams 1 2 Check TRUE TRUE TRUE TRUE TRUE Your turn: Transaction #2 10 11 12 13 16 17 18 19 20 21 22 23 24 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) 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 Sign Perimeter Ohce arces Presenter Info He ID 4425 Step 24 of 40: Transaction # 3 K L Q D Assets Accounts Receivable E G Liabilities. Shareholder's Equity Common Retained ulabilit Stock : Earnings M N O Profit & Loss Net Expenses : Income Cash Flow Revenue : Account Name 2 Entry Cash 3 4 2 5 3 6 4 7 5 9 Your turn: Transaction #3 Nunya Business has received 25% of the amount you recorded in Transaction #2 as partial payment of Its accounts receivable. 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 DocuPrint Oce Resources Presenter Info Slide ID 4420 Step 25 of 40: Transaction #4 a R B 1 D Assets Accounts Recevable E G Liabilities + Shareholder's Equity Common Retained Liabilities Stock Earnings K M N 0 P Profit & Loss Net Revenue : Expenses : Income Cash Flow Account Name 2 Entry Cash 3 1 2 5 6 7 5 9 10 11 12 13 14 Your turn: Transaction 4 15 Nunya Business paid 10% of the amount you recorded in Transaction #2 as salary expense. 16 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 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 Studonta Horisontal Statem Dashboard Studentice.com x Main Donces/Chegg.com o students cel.com/horisontal/windows DocuSige Perimeter My LastPass Academic Calendar Lu Life University One Square Dashboard I Homettere Resources Presenter info Slide ID. 4427 Step 26 of 40: Transaction #5 a 8 1 C D Assets Accounts Receivable G H Liabilities. Shareholder's Equity Common Retained Liabilities - Stock Larnings M N p Profit & Loss Net Revenue : Expenses Income Cash Flow Account Name 2 Entry Cash 3 4 2 5 3 Ches TRUE TRUE TRUE TRUI TRU 6 10 Your turn: Transaction #5 13 15 16 Nunya Business paid 5% of the amount you recorded in Transaction #2 as rent expense. After you record this transaction: 19 20 21 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 transactions impact on cash flow, if any. Choose an account name from column R if appropriate. 23 24 Dashboard: StudentsExcel.com Horizontal Financial Statex vices | Chegg.com Home Mante Bentsexcel.com/honzontal/windows/ DocuSign e Perimeter Otice Pr. D Square Dashboard I Home Lite Univers My LastPass Vaut I Academic Calendar Life University Oni ources Presenter Info lide ID: 4430 Step 29 of 40: Transaction #6 B 1 D Assets Accounts Receivable E G H K Liabilities Shareholder's Equity Common Retained Liabilities - Stock Earnings M O P Profit & Loss Net Revenue Expenses e Income Cash How Account Name 2 Entry Cash 3 3 4 Check TRUE TRUE TRUE TRUE TRUE TRUE 5 6 7 8 3 4 5 6 10 11 2 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: 13 14 15 16 17 18 19 20 21 22 25 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 Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column Rifappropriate. Horizontal Financial Statement Balance Sheet Income Statement Chart of Accounts Students Excel Ute University cuSign Perimeter Office Pr DSquare Dashboard Ill Home Life Uniwers My LastPass Vault Academic Calendar rces Presenter Info e ID: 4431 tep 30 of 40: Transaction #7 Q 1 D Assets Accounts Receivable G H Liabilities + Shareholder's Equity Common Retained luabilities - Stock Earnings MNO P Profit & Loss Net Revenue : Expenses Income Cash Flow Account Name 2 Entry Cash 3 1 4 2 5 3 6 4 7 Ched TRUE TRUE TRUE TRUE TRUE TRUE TRUE 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, After you record this entry: 11 12 13 14 15 16 17 18 19 20 21 22 23 24 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 Balance sheet Income Statement Chart or Accounts och My LastPass Vault Academic Calendar Lu Lile University On dentel.com/horizontal/windows/ Docu Permite Orice DSquare Dashboard Home Life Universe ources Presenter into Slide ID: 4432 Step 31 of 40: Transaction #8 a MANO Profit & Loss A Net. D Assets Accounts Receivable G H Liabilities. Shareholder's Equity Common Retained Liabilities - Stock + Earnings Cash Flow Account Name Revenue Expenses income 2 Entry 3 1 4 2 5 3 6 5 8 Check TRUE TRUE TRUE TRUE TRUE TRUE TRUE TRUE 9 10 12 Your turn: Transaction 8 14 Record an adjusting entry to recognize 25% of the prepayment from transaction #7 as revenue. After you record this transaction: 15 16 17 18 19 20 21 22 23 24 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 R if appropriate. MOTTON TOMTOT Income Anet der ha A. TUK Bobce Short Income Out of Account 0 dan SUSASIS Potem Mam Balance Sheet CA HAITAM aroops thatal era | step terioris | Anet der ha A. TUK Bobce Short Income Out of Account 0 dan SUSASIS Potem Mam Balance Sheet CA HAITAM aroops thatal era | step terioris |
