MoustafaYoussef_1002519

.xlsx

School

Fanshawe College *

*We aren’t endorsed by this school

Course

1031

Subject

Accounting

Date

Apr 3, 2024

Type

xlsx

Pages

31

Uploaded by SuperHumanOstrichMaster911

Do the work IN THIS ORDER !!! Marks 1) Do income statements for 2021 6 2) Do Balance Sheets for 2021 6 3) Do a pro forma Income Statement for 2022 8 4) Do a pro forma Balance Sheet for 2022 8 5) Do Cash Flow Statement for 2021 10 6) Do ratios for 2020 2021 10 7) Do pro forma Ratios for 2022 5 8) Do a pro forma cash budget for 2022 18 9) Do breakeven questions for 2021 2022 8 10) Do the theory problem below 20 Total 99 Theory Problem Based on the ratios AND common size calculations compare how Fanshawe Furniture is doing compared to the benchmark. Is it doing better or worse ? Be specific. This is worth 20 marks which means you should be comparing 10 sets of numbers and explaining why the numbers are different and whether they are better or worse.
MoustafaYoussef1002519
2021 Data MoustafaYoussef1002519 2021 Accounts payable $ 1,030,085 Accounts receivable $ 483,637 Amortization expense $ 38,000 Beginning Inventory $ 760,000 Cash $ 196,837 Common stock $ 100,000 Ending Inventory $ 1,014,034 Freight In $ 39,660 Interest expense $ 63,401 GIC's $ 250,000 Mortgage payable $ 911,115 Net Purchases $ 2,993,557 Net Sales $ 5,253,140 Notes payable $ 150,000 Prepaid expenses $ 42,089 Plant and Equipment $ 3,900,000 Salaries $ 688,452 Utilities $ 2,883 Insurance $ 2,791 Transport $ 20,698 Repairs & Maintenance $ 9,589 Advertising $ 26,814 Misc. Expense $ 49,705 Direct Wages and Expenses $ 1,185,500 Comon Stock Dividends $ 50,000 1002519 2020 MoustafaYoussef1002519
Other Info 2021 2020 2022 Common Stock 400000 shares 400000 shares 400000 shares Notes Payable current Sales on Credit 90% percent of net sales Share Price 2020 $ 1.60 per share Share Prices based on accounting department's esti Share Price 2021 $ 2.75 per share The directors have decided that no new shares will be issued/sold in 2022 Tax rate 40% Of Net Income Taxes on the year's profits are paid in December Amortization Expense 4% declining balance
imates.
Accounts payable 1030085 Accounts receivable 483637.15 Amortization expense 38000 Beginning Inventory 760000 Cash 196837.15 Common stock 100000 Ending Inventory 1014034 Freight In 39660 Interest expense 63401 GIC's 250000 Mortgage payable 911115 Net Purchases 2993557 Net Sales 5253140 Notes payable 150000 Prepaid expenses 42089 Plant and Equipment 3900000 Salaries 688451.92 Utilities 2883.1 Insurance 2790.64 Transport 20698.36 Repairs & Maintenance 9588.55 Advertising 26814.34 Misc. Expense 49705.26 Direct Wages and Expenses 1185500 Comon Stock Dividends 50000 1002519 2020 MoustafaYoussef1002519
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