Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Put in excel format please. C D E F G 1730000 B 1 ACCOUNTING 3190 EXCEL ASSIGNMENT NO. 1 - DUE 10/19/2021 2 At 12/31

image text in transcribed

Put in excel format please.

C D E F G 1730000 B 1 ACCOUNTING 3190 EXCEL ASSIGNMENT NO. 1 - DUE 10/19/2021 2 At 12/31 - Butch Co. had the following Stockholder's Equity 3 components that would be part of would be part of the balance sheet: 4 5 (1) Numers after a 100% (2) Numbers after a 2 for 1 (3) Numbers after a $5000 6 Stockerholders Equity At 12/31/2020 Stock Dividend Stock Splint Cash Dividend 7 No. of Commn shares outstanding 5000 8 Par value per common share 1 9 Common Stock, at Par $5,000 10 Additional Paid-in Capital $745,000 11 Total Contributed Capital 750,000 12 Retained Earnings 980,000 13 Total Stockholder's Equity 14 15 Butch Company is considering 3 alternative distributions subsequent to 12/31/2020. For this assignment, considereach alternative 16 totally independent of the others. For cells C7 to E13, use cell formulas and cell references so that your spreadsheet will 17 automatically update all numbers displayed in coluns C-E when I change the number in cell B7. B7 is the only celll will manipulate for this assign. 18 EG: If I change cell B7 to 8000, your spreadsheet should be programmed to automatically display 16000 in cell C7, and in D8, 8000 in E7. 19 20 This revised assignment is due in the iLearn Assessments/Assign/Assessments folder = 10/19/2021 AT 11:55 pm 21 Be sure to submit a fully automatic excel spreadsheet/Not a word document where you show just one set of numbers 22 23 24 25 26 27 28 29

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

Modern Advanced Accounting In Canada

Authors: Hilton Murray, Herauf Darrell

7th Edition

1259066487, 978-1259066481

More Books

Students also viewed these Accounting questions

Question

=+ What are alternatives?

Answered: 1 week ago