Determine the firms ending cash balance

Assignment Help Finance Basics
Reference no: EM1361606

Cash Budget for Higgins and Griffin Financial Planners

Higgins and Griffin Financial Planners have forecasted revenue for the first six months of 2005 as shown on the following table:

Month Nov. 2004 Dec-04 Jan-05 Feb Mar Apr May June

Revenue $48,000.00 $45,000.00 $25,000.00 $27,000.00 $30,000.00 $38,000.00 $40,000.00 $45,000.00

The firm collects 60% of its sales immediately, 39% one month after the sale, and 1% are written off as bad debts two months after the sale.

The firm assumes that wages and benefits paid to clerical personnel will be $7,000 per month while commissions to sales associates average 25% of collectible sales.

Each of the two partners is paid $5,000 per month. Commissions and partner salaries are paid one month after the revenue is earned.

Rent expense for their office space is $2,500 per month, and lease expense for office equipment is $800.

Utilities average $175 per month, except in May and June when they average only $100

The ending cash balance in December 2004 was $12,000

Create a cash budget for January to June 2005 and determine the firm's ending cash balance in each month assuming that the partners wish to maintain a minimum cash balance of $8,000.

 

Reference no: EM1361606

Questions Cloud

What is the overall magnification of microscope : What is the electric field at 9.4 cm from the central axis. What is the overall magnification of microscope.
Examine the process of forecasting financial statements : Examine the process of forecasting financial statements and make at least one recommendation for improving the accuracy of forecasts. Provide specific examples to support your response.
How companies can change your job : Can your company legally change your job responsibilities, reduce your salary, and/or assign you to a different department? How would a union situation address this issue?
Bling-bling orientation program development : When mall security were asked about Bling-Bling's Sales Associates work practices, they indicated that: "They're just kids. Like all kids they spend more time on the phone or playing games on their iPods than working."
Determine the firms ending cash balance : The Company suppose that wages and benefits paid to clerical personnel will be $7,000 per month while commissions to sales associates average 25 percent of collectible sales.
Cases of human infection : While a (H5N1) is considered an avian disease, there are cases of human infection. Is it true that risk factor for contracting the virus is handling of infected poultry, but transmission of the virus from infected birds to humans is inefficient.
How far will it coast before starting to roll back down : When placed 1.2 m apart, the force each exerts on the other is 12 N and is repulsive. What is the charge on each? What if the force were attractive.
Write c program which has parent process and child process : Write a C program that has a parent process, a child process, and a grandchild process. The parent process should print its id and the square or 5.
How two players simultaneously guess a number : All this is known to both players. Suppose both players behave according to the level-k thinking model discussed in class. Two players simultaneously guess a number.

Reviews

Write a Review

Finance Basics Questions & Answers

  Compute the break-even levels of ebit

Break Even EBIT and Leverage IBM Corporation is comparing two different capital structures. Plan I would result in 1,100 shares of stock and $16,500 in debt.

  Computation of present value of cash flows to make purchase

Computation of present value of cash flows to make purchase decision where demand is so high for Anderson Electric's products that the company cannot manufacture enough inventory to satisfy demand

  Bond refunding analysis for mullet technologies

Perform a complete bond refunding analysis. What is the bond refunding's NPV? What factors would influence Mullet's decision to refund now rather than later?

  Find degree of operating leverage

Trident Food Company generated th following income statement for the most recent fiscal year. Every item of inventory Trident Foods produces has a selling price of $20

  Calculation of stock price and required rate of return

Calculation of stock price and required rate of return and What is the required rate of return

  Calculate the present value

Calculate the present value of $1,000 to be received ten years from now if the required real rate of return is 3 percent compounded yearly and the expected rate of inflation is 5 percent compounded yearly?

  Computation of financial and operating levarages

Computation of financial and operating and combined levarages and Fastron has 1 million shares of common stock outstanding

  Determine the amount received by farmer

A farmer anticipates harvesting 50,000 bushels of wheat in September. How much money would the farmer earn from hedging by selling eight agreements of September.

  Calculate the monthly payment

Pretend that you are planning purchasing a car that costs $25,699. The car gets 23 miles per gallon in the city, and thirty miles per gallon on the highway.

  Determination of risky stock

Common stock A has an expected return of 10%, a standard deviation of future returns of 25%, and a beta of 1.25. Common stock B has an expected return of 12 percent, a standard deviation of future returns of 15 percent,

  Draft your financial analysis report of apple

Draft your financial analysis report of Apple Inc, including the given sections

  Capital structure and return on invested capital

Short-term liquidity Capital structure and solvency and return on invested capital

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