Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

pls write clear. spread sheet id 3479
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Accounting Volume 23

Authors: Philip M J Reckers

1st Edition

0762314257, 9780762314256

More Books

Students also viewed these Accounting questions

Question

Outline the three steps in time management and in money management.

Answered: 1 week ago

Question

=+which it operates?

Answered: 1 week ago

Question

=+How should we organize a book to maximize learning and interest

Answered: 1 week ago