Reference no: EM131240219
The management estimates total sales for the period January through July based on actual sales from the immediate past quarter. The following assumptions are made:
Sales: PAST AND EXPECTED:
HISTORICAL:
October $300,000
November $350,000
December $400,000
FORECAST:
January $150,000
February $200,000
March $200,000
April $300,000
May $250,000
June $200,000
July $300,000
a. 25% of the Sales will be collected in the same month of the Sale. 60% of the Sales will be collected one month following the sale. 10% will be collected two months following the sale. The remainder will be collected three months following the sale. Bad debts are insignificant.
b. Purchases are 80% of sales and are paid in the same month.
c. Wages and salaries are as follows:
January $30,000
February $40,000
March $50,000
April $50,000
May $40,000
June $35,000
Wages and salaries are paid in the same month.
d. Rent is $10,000 per month. Rent is paid in the same month.
e. The company issued $500,000 bonds, paying annual coupon rate of 5%. Interest on these bonds is paid at the end of each calendar quarter. Hint: Firsts, calculate the coupon interest amount for each quarter. Then, this quarterly interest amount will be paid at the end of each calendar quarter.
f. A tax prepayment of $75,000 is paid in April.
g. Machinery worth $35,000 will be purchased in March.
h. Cash on hand on January 1st will amount to $100,000 and a minimum cash balance of $100,000 each month will be maintained throughout the period.
EXCEL MUST BE USED TO SHOW WORK FOR THE FOLLOWING:
1. Prepare cash budget from January to June.
2. Determine the cash surplus and shortages for each month from January to June.
|
Determine the magnitude and direction of the x and y
: Determine the magnitude and direction of the x and y components of the anchoring force required to hold in place the horizontal 180° elbow and nozzle combination shown in Fig. P12.19. Neglect gravity.
|
|
How does bens age affect his decision to get an mba
: How does Ben's age affect his decision to get an MBA? - What other, perhaps non-quantifiable factors affect Ben's decision to get an MBA?
|
|
Propose solutions for working with other personality types
: Propose solutions for working with other personality types using the information from the Big Five assessment and the underlying principles of trait theories. Describe how your results from the assessment compare to the 16 personality factors. Ex..
|
|
Find the horizontal component of force required
: A hole at the center of the plate results in a discharge jet of air having a velocity of 40 m/s and a diameter of 20 mm. Determine the horizontal component of force required to hold the plate stationary.
|
|
Determine the cash surplus and shortages for each month
: Prepare cash budget from January to June. Determine the cash surplus and shortages for each month from January to June.
|
|
What tensile force does the cable have to support
: Assuming the cable can only support a tensile force, would you connect it to the right or left side? What tensile force does the cable have to support? Assume the flow to be frictionless.
|
|
What are some specific personality traits
: Respond to the following questions in at least 350 words: What are some specific personality traits that you believe you have inherited? Why? Describe each individual trait, and provide an example of its manifestation in your life.
|
|
Determine the velocity at the exit
: Air flows into the atmosphere from a nozzle and strikes a vertical plate as shown in Fig. P12.7. A horizontal force of 9 N is required to hold the plate in place. Determine the velocity at the exit, V1, and the velocity within the pipe, V2.
|
|
What is the cross-rate of euros to swiss francs
: Suppose the exchange rate between U.S. dollars and Swiss francs is SF 1.0617 = $1.00, and the exchange rate between the U.S. dollar and the euro is $1.00 = 0.9631 euros. What is the cross-rate of euros to Swiss francs (Euro/SF)?
|