Need help creating a monthly cash budget (hwk)
posted by Claire .
I started, but don't know if I'm going in the right direction:
Here is the information on the sheet:
Your carpet cleaning entrepreneurship:
Supposed that your hometown is Petoskey, Michigan. After college graduation you decided to go into business for yourself because you couldn't find a job that you liked in Petoskey and you desired to stay in the area. You decide to start a new type of cleaning business in Traverse City.
During the month of December, you borrow $20,000 from your father and agreed to pay him back $4,000 per year, beginning in year two with no interest. You also have received a girft of $5,000 from your grandfather's family trust and you decide to use it to start your business. Further, your have convinced your dad to allow you to start this business out of his garage. You want to draw a salary of $1,500 per month for the first year.
During December, you spend $18,000 for a new panel truck. In addition, you spend $1,250 for a steam cleaning, $800 for a heavy-duty commercial vacuum cleaner, and $100 for special brushed and attachments. The panel truck will be depreciated over a 5 year life, based on a straight-line method of depreciation. The steam cleaner, vacuum cleaner and brushes and attachments will be depreciated over a 3 year life, based on straight-line method of depreciation.
You also figured that you would have several monthly expenses when you start your business, beginning on January 1st.: $100 of cleaning solvents per month, $200 for insurance per month, $160 for fuel per month, and $500 per month for advertising in the local paper and on radio.
From your work experience while in college, you realized that you would be able to gross about $1,200 per month, except for May through August. During May through August, you would be able to gross $250 per day, working 6 days per week, or about $6,000 for each of these four months.
Can someone help me create it?
See if you can find any ideas here and don't forget the months when Bayview is closed!