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.

User Account

All Pages