Cash Budget Information COGS Purchases 60% paid in month 40% paid next month Sales 90% cash, 10% on account and collected the next month Fixed Asset Purchases a. Service truck = $20,000 (Purchased in January) b. Laptop Computer = $1,000 (Purchased in January) c. LaserJet Printer = $500 (Purchased in October) d. 3 Mechanic Tool Sets = $500 each (1 in January, 1 in March, 1 in April) - . Owner invested $20,000 in the company on the first day. Beginning Cash Balance = 0 Minimum Cash Balance = $1,000 Interest = 1% per month on the balance. Prepare a 12 month Cash budget based on this data. Cash Budget Information COGS Purchases 60% paid in month 40% paid next month Sales 90% cash, 10% on account and collected the next month Fixed Asset Purchases a. Service truck = $20,000 (Purchased in January) b. Laptop Computer = $1,000 (Purchased in January) c. LaserJet Printer = $500 (Purchased in October) d. 3 Mechanic Tool Sets = $500 each (1 in January, 1 in March, 1 in April) . Owner invested $20,000 in the company on the first day. Beginning Cash Balance = 0 Minimum Cash Balance = $1,000 Interest = 1% per month on the balance. Cash Budget Information COGS Purchases 60% paid in month 40% paid next month Sales 90% cash, 10% on account and collected the next month Fixed Asset Purchases a. Service truck = $20,000 (Purchased in January) b. Laptop Computer = $1,000 (Purchased in January) c. LaserJet Printer = $500 (Purchased in October) d. 3 Mechanic Tool Sets = $500 each (1 in January, 1 in March, 1 in April) - . Owner invested $20,000 in the company on the first day. Beginning Cash Balance = 0 Minimum Cash Balance = $1,000 Interest = 1% per month on the balance. Prepare a 12 month Cash budget based on this data. Cash Budget Information COGS Purchases 60% paid in month 40% paid next month Sales 90% cash, 10% on account and collected the next month Fixed Asset Purchases a. Service truck = $20,000 (Purchased in January) b. Laptop Computer = $1,000 (Purchased in January) c. LaserJet Printer = $500 (Purchased in October) d. 3 Mechanic Tool Sets = $500 each (1 in January, 1 in March, 1 in April) . Owner invested $20,000 in the company on the first day. Beginning Cash Balance = 0 Minimum Cash Balance = $1,000 Interest = 1% per month on the balance