Angsaya_S40065765_FinancialMGT_as1.xlsx - Sales Cash Inflow Cash sales(60 Collection from last month(30 Collection from second to last month(10 Total

Angsaya_S40065765_FinancialMGT_as1.xlsx - Sales Cash Inflow...

This preview shows page 1 - 7 out of 10 pages.

Cash collection Schedule May Jun July August September October November December Sales 42,100 47,300 59,000 44,100 46,000 51,600 47,000 67,000 Cash Inflow: Cash sales (60%) #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Collection from last month (30%) - #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? Collection from second to last month (10%) - - #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? - - Total Cash Receipt #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Image of page 1
Jul Budget $ Variance % Variance Income Reimbursed expense 0 600 600 100% Sales 59,000 61,200 2,200 3.6% Service 0 0 0 0 Total Income 59,000 61,800 2,800 4.53% Expense Bank service charges 50 50 0 0% Books and publication 80 100 20 20% Dues and subscription 50 50 0 0% Expensed equipment 600 500 (100) -20% Advertising 2,000 2,000 0 0% Insurance 10,000 10,000 0 0% Finance charges 0 100 100 100% Loan interest 4,970 5,000 30 1% License & permits 1,100 700 (400) -57% Motor expense 9,900 9,000 (900) -10% Office supplies 30 150 120 80% Payroll expense 25,000 25,000 0 0% Postage & delivery 30 20 (10) -50% Printing & Reproduction 770 1,000 230 23% Accounting fees 0 0 0 0% Legal fees 0 0 0 0% Recruitment & Training 0 0 0 0% Rent 1,200 1,200 0 0% Repairs 250 300 50 17% Software expense 300 300 0 0% Stamp duty 70 100 30 30% Telephone 90 100 10 10% Travel & Ent 800 1,500 700 47% Utilities 247 250 3 1% Total Expense 57,537 57,420 (117) 0% Net Income 1,463 4,380 2,917 67% Opening Balance 51,200 51,200 0 0% Receipts 53,800 55,480 1,680 3% Payments 57,537 57,420 (117) 0% Closing Balance 47,463 49,260 1,797 3%
Image of page 2
Aug Budget $ Variance % Variance Sep Budget $ Variance 800 1,200 400 33% 1,200 2,000 800 44,100 42,000 (2,100) -5% 46,000 41,000 (5,000) 300 100 (200) -200% 100 400 300 45,200 43,300 (1,900) -4% 47,300 43,400 (3,900) 40 50 10 20% 50 50 0 200 100 (100) -100% 80 100 20 0 50 50 100% 60 50 (10) 450 500 50 10% 12,000 12,000 0 2,000 2,000 0 0% 500 500 0 300 1,000 700 70% 700 1,000 300 10 10 0 0% 10 10 0 3,300 3,300 0 0% 3,300 3,300 0 0 0 0 0% 0 0 0 3,100 2,570 (530) -21% 3,100 1,200 (1,900) 90 150 60 40% 150 150 0 25,000 25,000 0 0% 25,000 25,000 0 70 20 (50) -250% 50 20 (30) 500 350 (150) -43% 80 150 70 1,200 1,200 0 0% 0 0 0 500 0 (500) 0% 0 1,200 1,200 0 500 500 100% 0 0 0 3,500 3,500 0 0% 3,500 3,500 0 0 300 300 100% 0 0 0 60 60 0 0% 60 60 0 100 100 0 0% 100 100 0 300 100 (200) -200% 300 100 (200) 230 1,000 770 77% 200 100 (100) 250 250 0 0% 250 0 (250) 41,200 42,110 910 2% 49,490 48,590 (900) 4,000 1,190 (2,810) -236% (2,190) (5,190) (3,000) 47,463 49,260 1,797 4% 55,153 56,400 1,247 48,890 49,250 360 1% 46,730 45,210 (1,520) 41,200 42,110 910 2% 49,490 48,590 (900) 55,153 56,400 1,247 2% 52,393 53,020 627
Image of page 3
% Variance 1st Quarter Budget $ Variance % Variance Oct 40% 2,000 3,800 1,800 47% 0 -12% 149,100 144,200 (4,900) -3% 51,600 75% 400 500 100 20% 300 -9% 151,500 148,500 (3,000) -2% 51,900 0% 140 150 10 7% 50 20% 360 300 (60) -20% 30 -20% 110 150 40 27% 0 0% 13,050 13,000 (50) 0% 0 0% 4,500 4,500 0 0% 16,000 30% 11,000 12,000 1,000 8% 1,000 0% 20 120 100 83% 30 0% 11,570 11,600 30 0% 3,300 0% 1,100 700 (400) -57% 700 -158% 16,100 12,770 (3,330) -26% 3,200 0% 270 450 180 40% 400 0% 75,000 75,000 0 0% 25,000 -150% 150 60 (90) -150% 70 47% 1,350 1,500 150 10% 300 0% 1,200 1,200 0 0% 0 100% 500 1,200 700 58% 0 0% 0 500 500 100% 10,000 0% 8,200 8,200 0 0% 3,500 0% 250 600 350 58% 500 0% 420 420 0 0% 60 0% 270 300 30 10% 0 -200% 690 300 (390) -130% 300 -100% 1,230 2,600 1,370 53% 1,200 0% 747 500 (247) -49% 250 -2% 148,227 148,120 (107) 0% 65,890 0 0 58% 3,273 380 (2,893) -761% (13,990) 2% 52,393 -3% 49,170 -2% 65,890 1% 167,453
Image of page 4
Budget $ Variance % Variance Nov Budget $ Variance 0 0 0% 900 700 (200) 49,300 (2,300) -5% 47,000 41,000 (6,000) 0 (300) 0% 1,000 200 (800) 49,300 (2,600) -5% 48,900 41,900 (7,000) 50 0 0% 30 50 20 100 70 70% 80 100 20 50 50 100% 50 50 0 500 500 100% 400 500 100 16,000 0 0% 500 500 0 1,000 0 0% 1,300 1,000 (300) 10 (20) -200% 10 10 0 3,300 0 0% 3,300 3,300 0 700 0 0% 20,050 20,000 (50) 2,000 (1,200) -60% 2,200 2,570 370 150 (250) -167% 140 150 10 25,000 0 0% 32,500 32,500 0 20 (50) -250% 10 20 10 150 (150) -100% 900 1,000 100 0 0 0% 1,200 1,200 0 0 0 0% 300 0 (300) 10,000 0 0% 500 500 0 3,500 0 0% 3,200 3,500 300 300 (200) -67% 200 300 100 60 0 0% 60 60 0 100 100 100% 0 100 100 100 (200) -200% 200 100 (100) 1,500 300 20% 1,200 1,500 300 250 0 0% 250 250 0 64,840 (1,050) -653% 68,580 69,260 680 (15,540) (1,550) 648% (19,680) (27,360) (7,680) 53,020 627 1% 167,453 35,110 (132,343) 46,930 (2,240) -5% 48,280 44,270 (4,010) 64,840 (1,050) -2% 68,580 69,260 680 35,110 (132,343) -2% 284,313 10,120 (274,193)
Image of page 5
% Variance Dec Budget $ Variance % Variance 2nd Qrt -29% 400 500 100 20% 1,300 -15% 67,000 63,000 (4,000) -6% 165,600 -400% 200 0 (200) 0% 1,500 -17% 63,500 (4,100) -6% 100,800 40% 10 10 0 0% 90 20% 80 20
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 10 pages?

  • Three '18

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 You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes