Creating budget-will you need additional funds at some point

Assignment Help Financial Management
Reference no: EM131194758

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 2: 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 3: Answer the questions.

Use the scenario information to help you answer these questions:

Explain the purpose of creating budgets.

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

Reference no: EM131194758

Questions Cloud

Types of incentives for providers for efficiency : Explain the three types of incentives for providers for efficiency in the delivery of healthcare services. Explain who bears the financial risk-the provider, the patient, or the managed care organization.
How many atoms are there per unit cell : A 3-D cubic unit cell contains four atoms whose centers are positioned halfway up along each of the vertical cell edges and one atom each centered in the middle of the top and bottom faces.
Explain the positive and negative aspects : Explain the positive and negative aspects, respectively, of managed care organization from the provider's point of view-a physician and a healthcare facility-and from a patient's point of view.
Returns and standard deviations for four investments : Here are returns and standard deviations for four investments. Return Standard Deviation Treasury bills 5.5% 0% Stock P 8.0 14 Stock Q 15.0 37 Stock R 23.0 22 Calculate the standard deviations of the following portfolios. a. 50% in Treasury bills, 50..
Creating budget-will you need additional funds at some point : 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 approxima..
Explain role of health education in health promotion program : Explain the role of health education in health promotion programs. Discuss the nature of communities that make churches and other faith community settings ideal for promoting health.
Model of advertising nad cournot competition : Consider the model of advertising nad cournot competition analyzed in this chapter. suppose the two firms could write an externally enforced contract that specifies an advertising level a and a monetary transfer m from firm 2 to firm 1.
Find the equivalent mass of the system : A simplified model of a petroleum pump is shown in Fig. 1.99, where the rotary motion of the crank is converted to the reciprocating motion of the piston. Find the equivalent mass, meq of the system at location A.
Municipal taxes increase to fund added services : Citizens spend less money repairing punctured and torn tires. Gas stations throughout the city reduce fuel prices. Municipal taxes increase to fund added services. Traffic flow in the city improves.

Reviews

Write a Review

Financial Management Questions & Answers

  Depreciation methods is evaluating capital budgeting project

Depreciation methods Kristin is evaluating a capital budgeting project that should last for 4 years. The project requires $675,000 of equipment. She is unsure what depreciation method to use in her analysis, straight-line or the 3-year MACRS accelera..

  What is the relevant refunding investment outlay

New Jersey Waster Co. (NJWC) is considering whether to refund a $50 million, 14 percent coupon, 30-year bond issue that was sold 5 years ago. It is amortizing $3 million of flotation costs on the 14 percent bonds over the 30-year life of that issue. ..

  How much timber to transport over each road

how much timber to transport over each road, so as to minimize cost while meeting the sawmill demands.- formulate the problem without conditional constraints and with a disjunctive linear constraint.

  What is initial cash flow of the butterfly spread strategy

Suppose you are creating a butterfly spread using 3 call options with different strike prices. Currently, the call price with strike price of $40 is $22.26, the call with strike price of $50 is $10.9, and the call with strike price of $60 is $5.58. W..

  Statements regarding mortgage pass-through bonds

Which of the following statements regarding mortgage pass-through bonds (MPTBs) is FALSE?

  Differences in top down and bottom up sales forecast methods

Describe the differences between the top down and the bottom up sales forecast methods. Describe advantages and disadvantages of each. Do you think one approach is likely to be more accurate than the other? Explain.

  Future decision to invest in dow jones index or companies

Based on your review of the Dow Jones Industrial Average performance trends from 1900 to the present, what conclusions can you draw and how may this impact your future decision to invest in the Dow Jones Index or companies.

  Estimated value of operation

EMC Corporation has never paid a dividend. Its current free cash flow of $400,000 is expected to grow at a constant rate of 5%. The weighted average cost of capital is WACC=12%. Calculate EMC's estimated value of operation.

  Firm been decreased by the expected bankruptcy costs

Custer's has bonds outstanding with a face value of $162,000 that are selling at par. It also has 10,000 shares of stock outstanding that are selling for $32.30 a share. The all-equity value of the firm is $455,000. The tax rate is 35 percent. By wha..

  Starbucks expansion is well documented in this case

Starbucks expansion is well documented in this case. Early in 2008 (and well before the widespread economic downturn) Starbucks began closing hundreds of stores across the U.S. Explain why you think this happened. Did Starbucks do anything “wrong” to..

  Firms reliance upon short-term debt or current liabilites

In general the greater a firms reliance upon short-term debt or current liabilites

  About the net present value method of selecting projects

For two mutually exclusive projects, the net present value and internal rate of return methods select different projects if the required rate of return is greater than the discount rate at which the two net present value profiles intersect. If projec..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd