Cash-budget - Index Expected Sales 20 for cash 50 on credit 2 months 30 on credit 3 months Total cash collection October November December January

Cash-budget - Index Expected Sales 20 for cash 50 on credit...

This preview shows page 1 - 2 out of 2 pages.

Index October November December January Expected Sales 770000 790000 1050000 750000 20% for cash 154000 158000 210000 150000 50% on credit 2 months 425000 390000 385000 395000 30% on credit 3 months 267000 255000 234000 231000 Total cash collection 846000 803000 829000 776000 Payments Expected purchases 610000 535000 290000 320000 30% on cash 183000 160500 87000 96000 20% in credit on 30 days 130000 122000 107000 58000 50% in credit on 60 days 240000 325000 305000 267500 Total payments for purchases 553000 607500 499000 421500 Interest Payment 8000 8000 8000 8000 Dividends 0 0 40000 0 Income Tax payment 0 0 0 0 Sales Tax, 5% 38500 39500 52500 37500 Wages, 19% 146300 150100 199500 142500 40% 58520 60040 79800 57000 60% 88920 87780 90060 119700 Wages payment 147440 147820 169860 176700 Selling payments, 17% 130900 134300 178500 127500 Total payments 877840 937120 947860 771200 Excess (deficiency) of cash available (C -31840 -134120 -118860 4800 Analysis of cash needs Prograssive total net cash flow -31840 -165960 -284820 -280020 Beginning balance cash 95000 70000 70000 70000 Excess (deficiency) of cash available -31840 -134120 -118860 4800 Ending balance cash
Image of page 1

Subscribe to view the full document.

Image of page 2

Unformatted text preview: 63160-64120-48860 74800 Cash requirement 70000 70000 70000 70000 Cash needs 6840 134120 118860 Payments 4800-6840-140960-259820-255020 615.6 Beginning balance cash 95000 63160-70960-189820 Excess (deficiency) of cash available-31840-134120-118860 4800 Ending balance cash 63160-70960-189820-185020 Cash requirement 70000 70000 70000 70000 Cash needs 6840 140960 259820 255020 688440 Interest payment 41306.4 February March Total 680000 720000 4760000 136000 144000 525000 375000 237000 315000 898000 834000 450000 480000 135000 144000 64000 90000 145000 160000 344000 394000 8000 8000 30000 34000 36000 129200 136800 51680 54720 85500 77520 137180 132240 115600 122400 668780 692640 229220 141360-50800 90560 70000 70000 229220 141360 299220 211360 70000 70000 229220 141360 259820-25800 115560 16094.4 14263.2 30973.2-185020 44200 229220 141360 44200 185560 70000 70000 25800...
View Full Document

  • Fall '14
  • Zalin
  • balance cash

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask bonus questions You can ask questions ( expire soon) You can ask questions (will expire )
Answers in as fast as 15 minutes