ACCT220 Portfolio Project - Shelley Final Submission

.xlsx

School

Bryant & Stratton College *

*We aren’t endorsed by this school

Course

220

Subject

Accounting

Date

Jan 9, 2024

Type

xlsx

Pages

5

Uploaded by BailiffCheetahPerson1003

Report
BRYANT & STRATTON COLLEGE ACCT220 - FINANCIAL ANALYSIS PORTFOLIO PROJECT Introduction Page Click Below to Access the spreadsheet you are looking for: This spreadsheet will give you the account balances for Module 4. The Ratios to calculate in Module 5. The management assumptions to use to complete the Pro Forma income sta Module 4 Module 5 Module 6
atement in Module 6.
BRYANT & STRATTON COLLEGE ACCT220 FINANCIAL ANALYSIS PORTFOLIO PROJECT Module 4 ARRANGE THE FOLLOWING FINANCIAL INFORMATION INTO THE FOLLOWING: 1) Comparative Balance Sheets for 2020 vs. 2021. 2) Comparative Income Statements for 2020 vs. 2021. 3) Construct the 2021 Statement of Cash Flows using items 1 and 2. 2020 BALANCE 2021 BALANCE Selling and Administrative Expenses 650,000 600,000 Interest Expense 54,000 52,000 Accounts Receivable (net) 350,000 425,000 Taxes 91,000 58,000 Notes Payable 200,000 175,000 Capital paid in excess of par 500,000 500,000 Cost of Goods Sold 2,300,000 2,250,000 Cash 120,000 95,000 Common Stock, $1 par value 250,000 250,000 Sales 3,600,000 3,300,000 Plant and Equipment 2,500,000 2,800,000 Accumulated Depreciation 850,000 950,000 Depreciation Expense 90,000 100,000 Retained Earnings 665,000 905,000 Bonds Payable, 2016 700,000 700,000 Accounts Payable 375,000 475,000 Operating Income 560,000 350,000 Accrued Expenses 80,000 60,000 Investments 150,000 100,000 Inventory 450,000 550,000 Prepaid Expenses 50,000 45,000 Click here to get back to the Introduction Page
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help