Determine the cash surplus and shortage each month

Assignment Help Financial Management

Reference no: EM132036823

This assignment will require you to prepare the cash budget and determine the cash surplus and shortage each month. The management estimates total sales for the period January through June based on actual sales from the immediate past s ix months . The following assumptions are made: Historical Sales July, 2016 $100,000 August, 2016 $125,000 September, 2016 $105,000 October, 2016 $155,000 November, 2016 $ 60,000 December, 2016 $ 70,000

Forecasted Sales January, 2017 $110,000 February, 2017 $ 90,000 March, 2017 $120,000 April, 2017 $ 80,000 May, 2017 $ 70,000 June, 2017 $ 60,000

a. 50% of the Sales are collected immediately . 30% of the Sales will be collected one month after the sale. 10% will be collected two months after the sale. 6% will be collected three months after the sale. The remainder will be collected four months after the sale. Bad debts are insignificant.

b. Purchases were $50,000 in July, 2016 and are expected to grow by 2% each month. The purchases will be paid in the s ame month.

c. Wages and salaries of $30,000 will be paid each month.

d. Depreciation expenses are $20,000 each month.

e. Rent of $15,000 will be paid at the end of each calendar quarter .

f. Machinery worth $150,000 will be purchased in March . Prepare the cash budg et from Jan uary to June. Determine the cash surplus and shortages for each month from January to June . Provide your analysis.

Reference no: EM132036823

Questions Cloud

What type of lease is this for child company : What type of lease is this for Child Company? How much rent expense should Child Company recognize in 2017?

What is the project npv : The IRR of this 20-year project is 11.41%. If the firm's WACC is 8%, what is the project's NPV?

Store owner be indifferent between the two leases : At what nominal WACC would the store owner be indifferent between the two leases?

Offers variety of marketing offerings to customers : Mesmerizing Marketers (MM) is a marketing company that offers a variety of marketing offerings to its customers.

Determine the cash surplus and shortage each month : This assignment will require you to prepare the cash budget and determine the cash surplus and shortage each month.

What is the annualized cost of forgoing the discount : If a firm buys on trade credit terms of 2/15, net 90 and decides to forgo trade credit discount, what is the annualized cost of forgoing the discount?

What are arithmetic-geometric average time-weighted rates : What are the arithmetic and geometric average time-weighted rates of return for the investor?

Calculate your rate of return : You purchased stock 13 years ago for $5,500 and incurred $100 in brokerage fees. Calculate your rate of return.

The effective rate if the compensating balance is doubled : What is the effective rate if the compensating balance is doubled to 20%?

User Account

All Pages