Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill in blank using the following information : BIG CITY COURIER STATEMENT OF CHANGES IN FINANCIAL POSITION For the Months of: January February March Operating
Fill in blank using the following information :
BIG CITY COURIER | |||
STATEMENT OF CHANGES IN FINANCIAL POSITION | |||
For the Months of: | |||
January | February | March | |
Operating Activities | |||
Net Income | |||
(Increase)/Decrease in Accounts Receivable | |||
Decrease in Deposits Paid | |||
Increase/(Decrease) in Accounts Payable | |||
Increase in Sales Tax Payable | |||
Cash Used in Operations | |||
Financing Activities | |||
Drawings | |||
Cash Used in Financing | |||
Investing Activities | |||
Changes in Fixed Assets | |||
Cash Used in Investing | |||
Net Increase/(Decrease) in Cash | |||
Cash Balance Previous Month End | |||
Cash Balance Current Month End | |||
Net change in Cash for the Month |
Financial Ratios | January | February | March |
Current Ratio | |||
Cash Ratio | |||
Accounts Receivable Turnover | |||
Accounts Receivable Turnover in Days | |||
Net Profit Margin |
Exhibit 1 BIG CITY COURIER BALANCE SHEET as at December 31 1996 1995 Current Assets Accounts Receivable Deposits Paid Total Current Assets 47,526 1,213 48,739 18,493 900 19,393 Fixed Assets Total Assets 4,258 52,997 3,947 23,340 9,688 Liabilities Overdraft Accounts Payable Sales Tax Payable Total Liabilities 7,044 274 3,509 10,827 22,386 32,074 Equity Capital Retained Earnings Total Equity 11,876 9,047 20,923 30,302 (17,789) 12,513 Total Liabilities and Equity 52,997 23,340 Exhibit 2 BIG CITY COURIER INCOME STATEMENTS for the period ended December 31 (one year) (8 months) 1996 1995 303,474 76,633 Sales Business Expenses Net Profit 276,638 26,836 94,422 (17,789) Exhibit 3 BIG CITY COURIER BALANCE SHEET as at 31-Jan-97 28-Feb-97 31-Mar-97 Current Assets Accounts Receivable Deposits Paid Total Current Assets 45,592 900 46,492 52,789 900 53,689 62,053 900 62,953 Fixed Assets Total Assets 4,258 50,750 4,435 58,124 4,435 67,388 Liabilities Overdraft Accounts Payable Sales Tax Payable Total Liabilities 9,231 411 23,967 33,609 11,580 271 26,212 38,063 13,217 1,100 28,265 42,582 Equity Capital Retained Earnings Total Equity 10,544 6,597 17,141 9,057 11,004 20,061 7,476 17,330 24,806 Total Liabilities and Equity 50,750 58,124 67,388 Exhibit 5 BANK ACCOUNT FOR BIG CITY COURIER, JANUARY 1, 1997 TO MARCH 31, 1997 Debit Credit 5,837 700 4,573 5,798 870 5.476 1,150 1.111 9,094 2.262 595 501 7.118 1,332 998 5,350 1,150 1,111 211 7.634 Transaction Date 01-Jan-97 02-Jan-97 02-Jan-97 03-Jan-97 09-Jan-97 13-Jan-97 17-Jan-97 17-Jan-97 17-Jan-97 22-Jan-97 22-Jan-97 23-Jan-97 24-Jan-97 27-Jan-97 28-Jan-97 29-Jan-97 31-Jan-97 31-Jan-97 31-Jan-97 31-Jan-97 03-Feb-97 03-Feb-97 07-Feb-97 14-Feb-97 14-Feb-97 14-Feb-97 18-Feb-97 20-Feb-97 20-Feb-97 21-Feb-97 24-Feb-97 25-Feb-97 26-Feb-97 26-Feb-97 28-Feb-97 28-Feb-97 28-Feb-97 28-Feb-97 03-Mar-97 04-Mar-97 07-Mar-97 07-Mar-97 14-Mar-97 14-Mar-97 14-Mar-97 19-Mar-97 19-Mar-97 21-Mar-97 24-Mar-97 28-Mar-97 28-Mar-97 28-Mar-97 28-Mar-97 Balance (9,688) (3,851) (4,551) (9,124) (3,326) (4,196) (9,672) (10,822) (11.933) (2,839) (5,101) (5,696) (6,197) 921 (411) (1,409) (6,759) (7.909) (9.020) (9,231) (1,597) (2,297) (2,792) (12,768) (13,918) (15,029) (4,295) (4.472) (4,966) (5,881) (6,268) (6,949) (8,436) 2,778 700 495 9.976 1,150 1.111 Description Balance Accounts Receivable Rent Drivers' Commissions Accounts Receivable Radio (Lease, Airtime, Repairs) Drivers' Commissions Salaries & Wages Marketing & Advertising Accounts Receivable Automobile Repairs & Expenses Miscellaneous Expenses Utilities Accounts Receivable Drawings Miscellaneous Expenses Drivers' Commissions Salaries & Wages Marketing & Advertising Overdraft Interest Bank Charges Accounts Receivable Rent Miscellaneous Expenses Drivers' Commissions Salaries & Wages Marketing & Advertising Accounts Receivable Radio Equipment Utilities Radio (Lease, Airtime, Repairs) Automobile Repairs & Expenses Miscellaneous Expenses Drawings Accounts Receivable Drivers' Commissions Salaries & Wages Marketing & Advertising Overdraft Interest & Bank Charges Rent Accounts Receivable Automobile Repairs & Expenses Miscellaneous Expenses Drivers' Commissions Salaries & Wages Marketing & Advertising Utilities Accounts Receivable Radio (Lease, Airtime, Repairs) Drawings Drivers' Commissions Salaries & Wages Marketing & Advertising Overdraft Interest Bank Charges 10,734 177 494 915 387 681 1,487 11,214 (9,104) 11.882 1.150 1,111 215 700 13,675 33 309 12,954 1,150 1,111 497 (10,254) (11,365) (11,580) (12,280) 1.395 1,362 1,053 (11,901) (13,051) (14,162) (14,659) 3,569 2,652 1,071 (10,733) (11,883) (12,994) (13,217) 18,228 917 1,581 11.804 1,150 1,111 223 Exhibit 4 BIG CITY COURIER INCOME STATEMENTS for the months ended 31-Jan-97 24,330 28-Feb-97 34,534 31-Mar-97 39,114 Year-to-Date 97,978 Sales (Net of Sales Tax) Expenses Drivers' Commissions Salaries & Wages Marketing & Advertising Radio (Lease, Airtime, Repairs) Rent Utilities Overdraft Interest & Bank Charges Automobile Repairs & Expenses Other Expenses Total Expenses Net Profit 15,399 2,300 2,221 870 700 501 211 2,673 1,906 26,781 (2,451) 21,858 2,300 2,221 915 700 494 215 247 1,176 30,126 4,408 24,759 2,300 2,221 917 700 497 223 333 838 32,788 6,326 62,016 6,900 6,663 2,702 2,100 1,492 649 3,253 3,920 89,695 8,284
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started