Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill in the following : Financial Ratios January February March Current Ratio Cash Ratio Accounts Receivable Turnover Accounts Receivable Turnover in Days Net Profit Margin

Fill in the following :

Financial Ratios January February March
Current Ratio
Cash Ratio
Accounts Receivable Turnover
Accounts Receivable Turnover in Days
Net Profit Margin

BIG CITY COURIER
STATEMENT OF CHANGES IN FINANCIAL POSITION
For the months of January, February and March
January February March
Operating Activities:
Net Income -2450 4407 6326
(Increase)/ Decrease in Accounts Receivable 1934 -7197 -9264
Decrease in Deposits Paid 313 0 0
Increase/ (Decrease) in Accounts Payable 411 -140 829
Increase in Sales Tax Payable 1581 2245 2053
Cash Used in Operations 1789 -685 -56
Financing Activities:
Drawings -1332 -1487 -1581
Cash Used in Financing -1332 -1487 -1581
Investing Activities:
Changes in Fixed Assets 0 -177 0
Cash used in Investing 0 -177 0
Net Increase/ (Decrease) in Cash 457 -2349 -1637
Cash Balance Previous Month End -9688 -9231 -11580
Cash Balance Current Month End -9231 -11580 -13217
Net Change in Cash For the Month 457 -2349 -1637

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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 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 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

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

Bank Management Text And Cases

Authors: George H. Hempel, Alan B. Coleman, Donald G. Simonson

3rd Edition

0471621781, 978-0471621782

More Books

Students also viewed these Accounting questions

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago