Ask Corporate Finance Expert

Toys-4-Kids manufactures plastic toys. Sales and production are highly seasonal. The following list of figures is a quarterly pro forma forecast indicating external financing needs for 2012. Assumptions are in parentheses.

Toys-4-Kids
2012 Quarterly Pro Forma Forecast
($ thousands)

 

Qtr 1 Qtr 2

Qtr 3

Qtr 4

Net sales $ 300 $ 375 $3,200 $5,000

Cost of sales (70% of sales)

    210

    263

  2,240

  3,500

Gross profit

90

113

960

1,500

Operating expenses

    560

    560

    560

    560

Profit before tax

(470)

(448)

400

940

Income taxes

   (188)

   (179)

    160

    376

Profit after tax

($ 282)

($ 269)

$ 240

$ 564

Cash (minimum balance = $200,000)

$1,235

$ 927

$ 200

$ 200

Accounts receivable (75% of quarterly sales)

225

281

2,400

3,750

Inventory (12/31/11 balance = $500,000)

    500

    500

    500

    500

Current assets

1,960

1,990

3,120

4,450

Net plant & equipment

  1,000

  1,000

  1,000

  1,000

Total assets

$ 2,960

$2,708

$4,100

$5,450

Accounts payable (10% of quarterly sales)

30

38

320

500

Accrued taxes (payments quarterly in arrears)

   (188)

   (179)

    160

    376

Current liabilities

(158)

(142)

480

876

Long-term debt

400

400

400

400

Equity (12/31/11 balance = $3,000,000)

  2,718

  2,450

  2,690

  3,254

Total liabilities and equity

$2,960

$2,708

$3,570

$4,530

External financing required

$     0

$     0

$ 530

$ 920

Continuing with Toys-4-Kids introduced in the above information, the company's production manager has argued for years that it is inef- ficient to produce on a seasonal basis. She believes the company should switch to level production throughout the year, building up finished goods inventory in the first two quarters to meet the peak selling needs in the last two. She believes the company can reduce its cost of goods sold from 70 to 65 percent with level production.

(Recall that production managers typically want to restrict produc- tion to left shoes only so as to reduce costs.)

a. Prepare a revised pro forma forecast assuming level production. In your forecast, assume that quarterly accounts payable under level production equal 10 percent of the average quarterly sales for the year. To estimate quarterly inventory, use the following two formulas.

Inventoryeoq = Inventoryboq + Quarterly production - Quarterly cost of sales

Quarterly production = Annual cost of sales/4

where eoq and boq refer to end of quarter and beginning of quarter, respectively. Please ignore the effect of increased external financing required on interest expense.

b. What is the effect of the switch from seasonal to level production on annual profits?

c. What effect does the switch have on the company's quarterly ending inventory? On the company's quarterly need for external financing?

d. Do you think the company will be able to borrow the amount of money required by level production? What obsolescence risks does the company incur by building up inventory in anticipation of future sales? Might this be a concern to lenders?

Corporate Finance, Finance

  • Category:- Corporate Finance
  • Reference No.:- M91566307
  • Price:- $40

Priced at Now at $40, Verified Solution

Have any Question?


Related Questions in Corporate Finance

Business finance case study assignment -instructions - you

BUSINESS FINANCE CASE STUDY ASSIGNMENT - Instructions - You must do Questions 1-5a, 8 and 10 on a spreadsheet. Eternal Youth Ltd (EY) is a New Zealand company which produces and sells cosmetics. Its financial year is 1 J ...

Q1 delta hedgingon sept 30th 2011 exxon mobil xom stock was

Q1 (Delta Hedging) On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is ...

Q1 delta hedgingon sept 30th 2011 exxon mobil xom stock was

Q1 (Delta Hedging) On Sept 30th, 2011, Exxon Mobil (XOM) stock was traded at $72.63 while the December XOM put option with $75 exercise price is traded at $5.00 and the December XOM call option with $70 exercise price is ...

Assignment -part a - saturn petcare australia and new

Assignment - Part A - Saturn Petcare Australia and New Zealand is Australia's largest manufacturer of pet care products. Saturn have been part of the Australian and New Zealand pet care landscape since opening their firs ...

Mini case assignment -problems - use internet to identify a

Mini Case Assignment - Problems - Use internet to identify a house or condo that you may be interested in investing as a rental property for 10+ years. (Suggested price range between $250k - $1 million) 1. Estimate the a ...

Descriptionstudents are required to study undertake

Description: Students are required to study, undertake research, analyse and conduct academic work within the areas of corporate finance. The assignment should examine the main issues, including underlying theories, impl ...

Corporate finance assignment - required this assessment

Corporate Finance Assignment - Required: This assessment task is a written report and analysis of the financial performance of a selected company in order to provide financial advice to a wealthy investor. It will be bas ...

Interest swap valueabc bank has agreed to receive 3-month

Interest swap value ABC bank has agreed to receive 3-month LIBOR and pay 8% per annum on a notional principal of $100 million. The swap has a remaining life of 11 months. The LIBOR spot rates for 2-month, 5-month, 8-mont ...

Graph an event study relationshipthe event in consideration

Graph an event study relationship. The event in consideration here is: "Environmental performance, being green, clean-tech, corporate sustainability, and many other "green" issues are on the forefront of the current econ ...

Question - assume that the average firm in your companys

Question - Assume that the average firm in your company's industry is expected to grow at aconstant rate of 6 percent and its dividend yield is 7 percent. Your company is about as risky as the average firm in the industr ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As