Baldwin Bicycle Company
Baldwin Bicycle Company
Baldwin Bicycle Company
COMPANY
By :
Amit Tarnekar : 32198
Arun Menon : 32175
Alok Ranjan : 32134
Mansoor Khan : 32172
Nikitta Tekriwal : 32145
Vezoto Theluo : 32300
EXECUTIVE SUMMARY
•Baldwin Bicycle Company (BBC) is a mid-
range full-line bicycle manufacturing company
with 40 years’ experience
• ** 5.5% of assets
Added estimate of monthly inventory cost to balance sheet info to estimate avg assets
2 months materials
(25000 bikes/12 mo x 2 mo inv) x 38.39 $ 165,833
WIP inv (1000 x 83.90) $ 83900
Finished Goods (500 x 83.90) $ 41950
_______
Increase to assets $ 291697
Present Current assets $ 8092000
Estimated Total Current Assets $ 8383697
Asset Costs (5.5%) per bike 8383697 x.055 461103/25000
$18.44
Cash Cycle
• Cash flow is a difficult situation currently for Baldwin
• It takes the inventory approximately 125 days to turn
and then another 46 days to get paid. This is a very
long time.
• The Challenger deal states that they would pay within
30 days. This would help with the current 46 day AR
turnover. The contract also keeps inventory days from
going over 120 for the Challenger bikes. Both of these
help turn assets into cash faster by at least 21 days
(approximately 16 + 5)
Direct Costs
• To produce Challenger there would be
two types of direct costs
1. one-time costs such as costs of
preparing drawings and arranging
sources that were not in current models
and
2. ongoing costs of producing bicycles
such as materials, wages, and
overhead
Indirect Costs
• Indirect costs would be asset-related
costs based on annual percentage of
dollar value of assets such as cost of
debt and book keeping of receivables
and inventories, insurance and state
property tax of inventory, etc
Impact on ratios
• Baldwin currently has about an 8% ROE,
which is well below the industry average
of 15%.
• By accepting the offer and using a 50%
tax rate the ROE is estimated to be
around 13%, which is significantly better
but still below the 15% industry average
STRATEGIC ANALYSIS
• No Clear Segmentation, but
they are probably trying to
Market cater to all customers by
Segmentation offering a full product in the
midrange Segment
OPORTUNITIES THREATS
Microsoft Office
Excel Worksheet