80.2K

Verified Solution

Link Copied!

Nunya business Transaction #1-#8, please use 7584 as the Spreadsheet ID for these equations. Please fill out the finacial statement.

Step 21 of 40: Transaction #1 KL c D E F P M OUT Labilities Shareholder's Equlty Commen Stesh Profit & Lo Assets Betained Eanines Accounts t Becebable Mabilities Sheck TRUE Netincome Cablew Acceunt Nams BEVemue 2 Intry Cesh Sea TRUE 4 TRUE TRUE TRUE Your turn: Transaction # 1 10 11 12 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 13 14 15 16 17 18 19 20 After you record this transaction: 21 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 Q to indicate the transaction's impact on cash flow, if any. Choose an account name from column R if appropriate. 23 24 25 26 27 28 29 Chart of Accounts Income Statement Balance Sheet Horizontal Financial Statement Need help? Email: [email protected] Students Exre www.studentsexcel.com NEXT 00:01/00:14 32/43 Step 30 of 40: Transaction # 7 N D E F G H A OUTLINE Prot& Low Liabities Shareholder's Equity Commen Stesh Assts Retained nine ceunts t Becelable iabilities Chesh Acceunt Name es Net Income Cash Flow Cash Search 2 tntry TRUE 1 TRUE TRUE TRUE TRUE TRUE TRUE 11 12 Your turn: Transaction # 7 13 14 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. 15 16 17 18 After you record this entry 19 20 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 R if appropriate. 21 22 21 24 25 26 27 Chart of Accounts Income Statement Balance Shee Horizontal Financial Statement Students Need help? Email: [email protected] www.studentsexcel.com NEXT 00:01/00:23 34/43

Answer & Explanation Solved by verified expert

See Answer