Given | |||||
8000 | Monthly Average Revenue | 6000 | |||
0.31 | Jan, Feb and Dec | ||||
0.62 | Mar | ||||
0.99 | April & Nov | ||||
1.24 | May & June | ||||
1.49 | July through October | ||||
0.2 | Wages | ||||
0.25 | Misc | ||||
150 | Truck rent | ||||
25000 | Loan for 7 years @ 6.5% | ||||
420.26 | Monthly Payment (calculated using repayment schedule for 6 years) |
Calculations
Average Monthly Sales | 8000 | ||||||
Revenue | Wages | Rent | Repayment (monthly payment) | Misc Expen | Total Expenses | Profit | |
Jan | 2480 | 496 | 150 | 420.26 | 620 | 1686.26 | 793.74 |
Feb | 2480 | 496 | 150 | 420.26 | 620 | 1686.26 | 793.74 |
Mar | 4960 | 992 | 150 | 420.26 | 1240 | 2802.26 | 2157.74 |
April | 7920 | 1584 | 150 | 420.26 | 1980 | 4134.26 | 3785.74 |
May | 9920 | 1984 | 150 | 420.26 | 2480 | 5034.26 | 4885.74 |
June | 9920 | 1984 | 150 | 420.26 | 2480 | 5034.26 | 4885.74 |
July | 11920 | 2384 | 150 | 420.26 | 2980 | 5934.26 | 5985.74 |
August | 11920 | 2384 | 150 | 420.26 | 2980 | 5934.26 | 5985.74 |
Sept | 11920 | 2384 | 150 | 420.26 | 2980 | 5934.26 | 5985.74 |
Oct | 11920 | 2384 | 150 | 420.26 | 2980 | 5934.26 | 5985.74 |
Nov | 7920 | 1584 | 150 | 420.26 | 1980 | 4134.26 | 3785.74 |
Dec | 2480 | 496 | 150 | 420.26 | 620 | 1686.26 | 793.74 |
Total | 95760 | 19152 | 1800 | 5043.12 | 23940 | 49935.12 | 45824.88 |
A. | ||
Yes | ||
Annual profit | 45824.88 | |
Average Monthly Profit | 3818.74 |
B | ||||
Profits of the company will decrease by decreasing the average monthly sales to 6000 | ||||
Annual profit | 32657.88 | |||
Average Monthly Profit | 2721.49 | |||
Change in Profit by changing the average Sales from 8000 to 6000 | ||||
Annual profit | 13167 | |||
Monthly | 1097.25 |
Open the “Budget” tab and create the following monthly cash-flow budget: Revenues: Caveman Cooking plans to sell, on...
CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...