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

  Consider a zero coupon bond

Consider a zero coupon bond (one with zero interest payments). If the bond has a maturity value in seven years of $1000 and you would currently pay $850 for the bond, what is the yield to maturity?

  Good employee with a near perfect attendance record

A good employee with a near perfect attendance record has suddenly been missing 2-3 days of work per week. His supervisor has repeatedly told him he must be at work daily, or he will be fired. Now, the supervisor wants to fire him, but has come to as..

  About how much must be in your account when you retire

You believe you will spend $150,000 per year when you retire.  You expect to live 30 years. If your retirement account expects to earn 5% annual interest, about how much must be in your account when you retire?

  Analyzing stock market risk premiums over time

Assume you are analyzing stock market risk premiums over time. Which one of these would be the computation to use to compute the standard error of those premiums?

  Current yield of malko enterprises

Malko Enterprises's bonds currently sell for $1,050. They have a 6-year maturity, an annual coupon of $75, and a par value of $1,000. What is their current yield?

  Equivalent uniform annual cost analysis method

Two alternatives are suggested for improvement to a power generation plant. Alternative A costs $60,000 and provides yearly benefit of $16,000. Alternative B requires $84,000 of initial cost. However, it will yield benefits in the order of $22,000 pe..

  What is the projects free cash flow for year one

Racin scooters is introducing a new product and has an expected change in EBIT of $475,000. R.Scooters has a 34% marginal tax rate. With the project: 80,000 Accounts Payable without the project: 70,000; With the project: 94,000 What is the project's ..

  Initial cash flow of the project for this building

Your firm purchased a warehouse for $335,000 six years ago. Four years ago, repairs were made to the building which cost $60,000. The annual taxes on the property are $20,000. what value, if any, should be included in the initial cash flow of the pro..

  Home equity line of credit

A home equity line of credit (HELOC) is, loosely speaking, like a credit card for your home. You can borrow money by drawing down on the line of credit. But, because the borrowed money is for the purpose of your home, the interest is tax-deductible m..

  What is the current market price of this bond

A corporate bond, paying $65 interest at the end of each year for 6 years, has a face value of $1,000. If market rates on newly issued similarly rated corporate bonds are now 7.5%, what is the current market price of this bond?

  When using control chart-process is out of control

When using a control chart, what are some patterns that would indicate that the process is out of control? Additionally explain what might cause a process to be out of control. In your responses to other students, relate and identify to an example of..

  Calculate NPV and MIRR of pulley project

When considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent. The cash outlay for the truck is $17,400, and that for the pulley system is $20,200.

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