Construct a cash budget for the next three months

Assignment Help Finance Basics
Reference no: EM131290130

Berlin Inc. expects sales of $300,000 during each of the next three months. It will make monthly purchases of $180,000 during this time. Wages and salaries total $30,000 per month plus 5 percent of monthly sales. The firm expects to make a tax payment of $60,000 in the first month and a $45,000 purchase of fixed assets in the second month and to receive $24,000 in cash from the sale of an asset in the third month. All sales and purchases are for cash. Beginning cash and the minimum cash balance equal zero.

a. Construct a cash budget for the next three months.

b. Berlin is unsure of the level of sales, but all other figures are certain. If the most pessimistic sales figure is $240,000 per month and the most optimistic is $360,000 per month, what are the monthly minimum and maximum ending cash balances that the firm can expect for each month?

c. Discuss how the financial manager can use the data in parts (a) and (b).

Reference no: EM131290130

Questions Cloud

Dental equipment corp sold equipment priced : On Sept 1, 2010, Dental Equipment Corp sold equipment priced at $350,000 in exchange for a six month note receivable with an annual interest rate of 16%, all due at maturity.
Define substantive strategy and reliance strategy : Define substantive strategy and reliance strategy and compare how the different strategies relate to internal control. Which strategy would best relate to a lower assessed control risk?
Some of the common security weaknesses inherent : What are some of the common security weaknesses inherent in Unix or Linux based systems and what techniques can be used to harden these systems against an attack?
X-ray equipment to einstein general : On September 1, 2015, Jefferson Corporation sold $265,000 of xray equipment to Einstein General who agreed to pay within 30 days. Additionally, if Einstein paid within 5 days they would receive a 2% discount.
Construct a cash budget for the next three months : Wages and salaries total $30,000 per month plus 5 percent of monthly sales. The firm expects to make a tax payment of $60,000 in the first month and a $45,000 purchase of fixed assets in the second month and to receive $24,000 in cash from the sal..
Explain several strategies of rolex wrist watch co : Find and explain several strategies of Rolex wrist watch Co for effective market penetration. I will accept both actual and your own strategies.
What kind of network configuration does nyc : What kind of network configuration does NYC's free Wi-Fi(LinkNYC) run on and what kind of network configuration diagram would represent this?
Comparative analysis of machine learning algorithms : Comparative Analysis of Machine Learning Algorithms for Audio Signal Classification. It is single paced & five pages.
How is the sales force at medtronic structured : How is the sales force at MedTronic structured?- Can you identify the selling process for MedTronic? Give an example of each step.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Calculate the decision rules for npv and irr

Jennifer executive board has asked you to change the decision model previously completed to reflect the following changes regarding increased leverage, WACC, and cash flows. It is your job to calculate the decision rules for NPV and IRR given the ..

  Examine the characteristics associated with children

Examine the characteristics associated with children who engage in serious school violence. Discuss the efforts being made to reduce school crime and their effectiveness.

  How does each of the given affect the money supply

How does each of the following affect the money supply? -  The Fed lowers the required reserve ratio.-  The Fed buys government securities.

  What is the relevance of the swap rate curve

Suppose that the one-year spot rate is 4.1% and the two-year spot rate is 4.6%. What is the one-year forward rate one year from now?

  Determine the dimensions of the cartons

Barry packs books for a bookstore. A new edition of a dictionary is ready to be boxed for shipment. Each dictionary measures 11inches x 8.5in. x 4in.

  Compare and contrast real estate

Compare and contrast real estate with other financial assets?

  What is happening to size of risk premium paid by investors

You have noticed that last year,private equity gourps were buying public companies at big premium ,what is the implication of this in term of changes in investor risk aversion, if any? what is happening to the size of risk premium paid by investor..

  Which of the following statements is correct

Which of the following statements is correct? A) all else equal, senior debt generally has a lower yield to maturity than subordinated b) an indenture is a bond that is less risky than a mortgage bond c) the expected return on a  corporate bond will ..

  A developer of a subdivision wants to preserve the open

a developer of a subdivision wants to preserve the open space and natural habitat that runs along the back portion of a

  What is the npv of the decision to purchase a new machine

a firm is considering an investment in a new machine with a price of 18 million to replace its existing machine. the

  A neighbor of your deposited 7500 in a local bank account

a neighbor of your deposited 7500 in a local bank account that pays 3.75 with daily compounding and a 360-day year.

  Npv of the higher npv project

Project A, a riskier-than-average project, will produce annual end of year cash flows of $ 90 . Project B, of less than average risk, will produce cash flows of $225 at the end of Years 3 and 4 only. List the NPV of the higher NPV project.

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