Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Beginning July August September October November December January February March April May June Total Cash on hand (beginning of month) 325,000 93,595 79,440 65,285
Beginning July August September October November December January February March April May June Total Cash on hand (beginning of month) 325,000 93,595 79,440 65,285 51,129 36,974 22,819 8,664 -5,491 -19,646 -33,802 -47,957 CASH RECEIPTS July August September October November December January February March April May June Total Cash sales 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 467,200 TOTAL CASH RECEIPTS Total cash available 0 38,933 363,933 38,933 132,528 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 38,933 467,200 118,373 104,218 90,063 75,908 61,752 47,597 33,442 19,287 5,132 -9,023 CASH PAID OUT Cost of Good Sold July 12,075 August September October November December January February March April May June Total 12,075 12,075 12,075 12,075 12,075 12,075 12,075 12,075 12,075 12,075 12,075 144,905 Rent 5,891 5,891 5,891 5,891 5,891 5,891 5,891 5,891 5,891 5,891 5,891 5,891 70,695 Wages 20,389 20,389 20,389 20,389 20,389 20,389 20,389 20,389 20,389 20,389 20,389 20,389 244,664 Employee benefit 3,494 3,494 3,494 3,494 3,494 3,494 3,494 3,494 3,494 3,494 3,494 3,494 41,933 Insurance 250 250 250 250 250 250 250 250 250 250 250 250 3,000 Internet 300 300 300 300 300 300 300 300 300 300 300 300 3,600 Utilities 1,964 1,964 1,964 1,964 1,964 1,964 1,964 1,964 1,964 1,964 1,964 1,964 23,565 Machine Maintenance 500 500 500 500 500 500 500 500 500 500 500 500 6,000 Interest expense 2,708 2,708 2,708 2,708 2,708 2,708 2,708 2,708 2,708 2,708 2,708 2,708 32,500 Miscellaneous 350 350 350 350 350 350 350 350 350 350 350 350 4,200 Marketing SUBTOTAL CASH PAID OUT Loan principal payment Capital purchases 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000 48,922 48,922 48,922 48,922 48,922 48,922 48,922 48,922 48,922 48,922 48,922 48,922 587,062 July August September October 4,167 4,167 4,167 4,167 November 4,167 December 4,167 January February March April May June Total 4,167 4,167 4,167 4,167 4,167 4,167 50,000 154,250 154,250 Other startup costs 63,000 63,000 TOTAL CASH PAID OUT 270,338 53,088 53,088 53,088 53,088 53,088 53,088 53,088 53,088 53,088 53,088 53,088 854,312 Cash on hand (end of month) 0 93,595 79,440 65,285 51,129 36,974 22,819 8,664 -5,491 -19,646 -33,802 -47,957 -62,112
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