Prepare a monthly cash budget for the next three months

Assignment Help Financial Management

Reference no: EM131060022

In-tech Corporation’s sales and purchases for the last threemonths are as following:

Sales ($) Purchases ($)

October 100,000 80,000

November 90,000 100,000

December 120,000 75,000

For the next three months, it estimates sales and purchases to be as following:

Sales ($) Purchases ($)

January 90,000 70,000

February 80,000 70,000

March 80,000 70,000

It pays 40 percent of purchases in cash and gets a 4 percent discount. Another 40 percent of purchases are paid the next month, and the final 20 percent of purchases are paid in the second month after the purchase (for example, 40 percent of October purchases are paid in October, 40percent October purchases are paid in November, and 20percent October purchases are paid in December). Half of the sales are made in cash, and the balance is collected the next month. Cash sales are given a two percent discount, and five percent of credit sales end up as bad debt. The monthly operating expenses for In-tech Corporation’s are $10,000. In-tech expects to sell one of its machinery in March for $25,000. It will buy the replacement in April for $50,000. The cash balance as on December 31 was $50,000. In-tech has a target cash balance of $50,000. Prepare a monthly cash budget for the next three months.

Reference no: EM131060022

Questions Cloud

What is the angular momentum of the car : A 2000-kg car is traveling at 20 m/s around a curve with a radius of 100 m. What is the angular momentum of the car? (in kg"m2/s)

Find the thevenin equivalent circuit at given terminals : Find the Thevenin equivalent circuit at terminals (a,b). Also find the Norton equivalent circuit at terminals (a,b). Choose RL so that the current flowing through it is 0.8 A.

Calculate equity multiplier : Financial statement analysis. Suppose a firm's earnings growth rate is 5%, return on assets (ROA) is 22%, debt ratio is 45% and stock price is $50. Calculate equity multiplier.

Faraday law and induced current : Discuss Lenz's Law in terms of Faraday's Law and induced current. should include an in depth analysis and references.

Prepare a monthly cash budget for the next three months : It pays 40 percent of purchases in cash and gets a 4 percent discount. Another 40 percent of purchases are paid the next month, and the final 20 percent of purchases are paid in the second month after the purchase. Prepare a monthly cash budget for t..

Which is strength of the human resources theory of practice : Progressive external developments can provide _____ for change internally. One example is the emergence of new technologies offering benefits of better, safer and less expensive healthcare. Other examples include the availability of new funds and ..

An arbitrageur can borrow or lend money : The price of gold is currently $500 per ounce. Forward contracts are available to buy or sell gold at $700 for delivery in one year. An arbitrageur can borrow or lend money at 10% per annum. What should the arbitrageur do? Assume that the cost of sto..

Calculate the depreciation expense-sales-costs : Given the following information for O'Hara Marine Co., calculate the depreciation expense: sales = $42,000; costs = $21,300; addition to retained earnings = $7,250; dividends paid = $1,200; interest expense = $5,300; tax rate = 35 percent.

Distance between the generator and pulley : The distance between the generator and pulley is L = 0.67 m. Initially the 3rd harmonic wave pattern is formed. What is the wavelength of the wave?

User Account

All Pages