Need help creating a monthly cash budget (hwk)

posted by .

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?

Respond to this Question

First Name
School Subject
Your Answer

Similar Questions

  1. Government

    Has the Supreme Court acted legitimately in creating and interpreting the right of privacy?
  2. Question about Cash Flow Statement

    I had to work on the income statement, the balance sheet and the statement of Owner's equity. Now I am on the statement of cash flow. The first thing I have to imput is Cash flows from Operating activities. Where I need to input is …
  3. government

    the office of management and budget helps in the budget process by a. providing congress with financial information b. keeping the government runnin if congress fails to pass appropriations c. helping the president produce the budget …
  4. Algebra HELP

    I am resubmitting this in hopes that someone may point me in the right direction...... When managing a business, it is important to take inventory of where your money is spent. You have a monthly budget of $5,000. Refer to the table …
  5. Math

    suzanne has collected 44 carpet squares she would like to place them side y side going down the hallway,creating two columns of carpet. Will the columns each have the same number of carpet squares
  6. HCS 320

    describe the national incident command structure i am supposed to do this on a disaster planning presentation and i need help ive been just so busy and this is due today i just need a little help or push in the right direction to get …
  7. Personal Finance Management

    Jenny has a part time job and her net take-home income is $2000 per month. She needs to allocate her funds to reflect a balanced monthly budget. Jenny's main categories of expenses include rent, utilities, and groceries. How would …
  8. Math

    You need to put carpet in a rectangular room that measures 12 feet by 17 feet at a cost of $27.50 per square yard. Assuming that you can buy precisely the amount of carpet you need, how much will the carpet for the room cost?
  9. Math

    Suppose you want to install carpet in a hexagon room whose sides are all 15 ft long. Carpet costs $48 per sq yd and comes in rectangular rolls that are 12 ft by 90 ft. (Sold by the whole sq yd) How will you lay the carpet?
  10. grammar

    Could you check my sentences. Thank you very much 1. You are supposed to unplug the light before you change the bulb. You could get a shock. 2. Everyone in the house is supposed to deal with their own mess. I'm not going to do all …

More Similar Questions