Create a simple monthly cash budget

Assignment Help Financial Management

Reference no: EM13941165

Step I: Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be approximately 60% of sales. You anticipate about 20% of your sales will be cash and 80% collected the following month. Your supplier has agreed to extend credit for 70 days at no cost (i.e. you will pay your bills on a two month lag). Your monthly expenses for rent, wages, utilities, and so forth will be approximately $3,500 per month. You have deposited $15,000 in a checking account to begin your operations and would like to maintain a minimum balance of $5,000 in that account.

Step II: Create a simple monthly cash budget. Create a spreadsheet file that contains a simple monthly cash budget for the next year for the business described in the above scenario.

Step III: Answer questions.

-Explain the purpose of creating budgets.

-Will you need additional funds at some point? Justify your answer

Reference no: EM13941165

Questions Cloud

How strictly adhering to investment strategy of dollar cost : Discuss how strictly adhering to an investment strategy of dollar cost averaging over time should always result in a lower average cost to the investor than if a share averaging strategy was followed. Describe the market environment when the investme..

A company manufactures two products : A company manufactures two products, X & Y. It uses three materials in its manufacture, A, B and C and both unskilled and skilled labour are used. The standard costs for both products for next year are as follows:

Sales for the first quarter of the year : Purchases are equal to 50% of the following quarter's sales. The sales for the first quarter of the following year are estimated at $2,100. The accounts receivable period is 30 days and the accounts payable period is 45 days. The firm will purchase _..

How to print out the matrices. : How to call the input matrice files and implement them in the functions. Or to convert the txt file into a matrice?

Create a simple monthly cash budget : Step I: Assume you are thinking about starting a business and would like to forecast your cash needs for the next six months. You expect sales to be approximately $30,000 per month for the first 12 months and your purchases to support sales will be a..

The firms cost of capital for the preferred stock : (Cost of preferred stock) Your firm is planning to issue preferred stock. The stock is expected to sell for $98.64 a share and will have a $100 par value on which the firm will pay a 13.6 percent dividend. What is the cost of capital to the firm for ..

What is the nature of the universe : What is ultimate reality? What is the nature of the universe? What is human nature? What is knowledge?

Preferred stock valuation : (Preferred stock valuation) Pioneer's preferred stock is selling for $45 in the market and pays a $2.70 annual dividend. If the market's required yield is 7 percent, what is the value of the stock for that investor? The value of the stock for the in..

Example of short-run exposure to exchange rate risk : Which of the following is (are) an example of short-run exposure to exchange rate risk:

User Account

All Pages