Monthly cash budget for the three months

Assignment Help Corporate Finance
Reference no: EM13328590

In-tech Corporation s sales and purchases for the last three months 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, 40 percent October purchases are paid in November, and 20 percent 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: EM13328590

Questions Cloud

What is the annual yield according to the discount method : A six-month $10,000 Treasury bill is selling for $9,844. What is the annual yield according to the discount method. Does this yield understate or overstate the true annual yield
Explain 3-methyl-2-butanone : 3-methylbut-1-ene ---->3-methyl-2-butanone. For the reagents I put, HBr, Tert butoxide, O3 and dms. I was wondering about the O3 and dms, im not sure if that part is right.
Describe actions in moral terms even when birds are acting : Bird and Waters argue that middle managers are reluctant to describe their actions in moral terms even when they are acting for moral reasons. Does their account of middle manager behavior match your experience.
Determine the net force acting on the ball : A ball is suspended by a string and moves in a horizontal circle. One such pendulum has a 100g ball at the end of a 1.5 meter long string and has an orbit of radius 30.0cm. Determine the net force acting on the ball and the acceleration
Monthly cash budget for the three months : 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 th..
A gas container with a fixed volume has a pressure of p atm : A gas container with a fixed volume has a pressure of p atm. Gas is then added to the container so that the number of gas particles is the container doubles. What happens inside the container
Find the magnitude of the turtles average velocity : A turtle ambles lesisurely- as turtles tend to do- when it moves from a location with position vector r1x = 1.07 m, find the magnitude of the turtle's average velocity
Explain the reaction between (r)-3-methylhexan-2-one : Draw the structure of the product(s) of the reaction between (R)-3-methylhexan-2-one and phenylmagnesium bromide, followed by acidification. Use wedge and dash bonds to indicate stereochemistry. If more than one stereoisomer is formed, draw them a..
What would be mass incs estimated cost of equity : Currently the company s cost of equity, which is based on the CAPM, is 12 percent and its tax rate is 40 percent. What would be Mass Inc's estimated cost of equity if it were to change its capital structure to 60 percent debt and 40 percent equity..

Reviews

Write a Review

Corporate Finance Questions & Answers

  How the budgeting process employed by springfield

Discuss how the budgeting process employed by Springfield Corporation contributes to its failure to achieve the president's sales and profit targets.

  Determine the receivables turnover

The Robinson Corporation has the following current assets & current liabilities for two years: Cash and marketable securities $ 50,000 for 2010 and 2011;

  Describes the impact on the financial statements

Which of the following properly describes the impact on the financial statements when a company reports wage expense of $7,500, of which $2,500 remains unpaid?

  Long forward hedge to offset short forward position

Suppose you are considering to enter into a long forward hedge to offset short forward position. If you select a futures agreement over a forward agreement.

  Data entry screen for an accounting system

what are some specific issues that need to be addressed when examining the trade-offs of the benefits of electric power production against the costs of increased health problems in portions of the population?

  What is your best estimate for the stock price per share

Multiple choice questions on stocks, derivatives and capital budgeting and what is your best estimate for the stock price per share?

  What is the required rate of return on stock

What is the required rate of return on stock and what is the stocks current price - What is the best estimate of the stocks current market value?

  Finding the discount rate and investment rate

We are buying a 28-day Treasury bill, during a normal year, & want to determine both discount rate & the investment rate. If we buy the bill for $998,

  What was the average annual rate of increase

Charlotte's firm had sales of $525,000 in the year 2001. By 2012, sales had increased to $1,200,000. What was the average annual rate of increase?

  Decision on the request for working capital finance

Identifies additional information that the bank is likely to require in order to make a decision on the request for working capital finance

  Proposal for finance dissertation using statistical tools

I am trying to make an overview proposal for a finance dissertation based upon using statistical tools for financial research and risk assessment or portfolio theory.

  Analysts at tabby fur storage predict

Analysts at Tabby Fur Storage predict that the net present value of a proposed new $10 million warehouse is $1 million. How should these findings be interpreted - the project should be rejected because the NPV is less than the cost of the warehouse..

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