Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help writing a Memo with the Following information given below how would I write this Given the two project options, we can only afford

Need help writing a Memo with the Following information given below how would I write this

Given the two project options, we can only afford to undertake one of the investments. I look to you to provide an evaluation and recommendation as to which project we should proceed with. In addition, I would also like you to present any issues or concerns you see from your analysis of the projected cash budget and our current cash conversion cycle. Are there any recommended changes you would suggest to maximize the effectiveness of our working capital?

image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

Capital Expenditure Data for Target Cost of Capital 20% Plant Expansion Product Introduction Initial Investment ($3,500,000) ($500,000) Cash Inflows Year 1 Year2 Year 3 Year 4 1,500,000 2,000,000 2,500,000 2,750,000 $250,000 350,000 375,000 425,000 IRR 43.7% 52.3% Capital Expenditure Data for Simms Cost of Capital 20% Plant Expansion Product Introduction Initial Investment ($3,500,000) ($500,000) Cash Inflows Year 1 Year2 Year 3 Year 4 1,500,000 2,000,000 2,500,000 2,750,000 $250,000 350,000 375,000 425,000 NPV $1,911,844.14 $373,360.34 1.55 1.75 Capital Expenditure Data for Simms Cost of Capital 20% Plant Expansion Product Introduction Initial Investment ($3,500,000) ($500,000) Cash Inflows Year 1 Year2 Year 3 Year 4 Year 5 1,500,000 2,000,000 2,500,000 2,750,000 $250,000 350,000 375,000 425,000 NPV $1,911,844.14 $373,360.34 Simms Bakery Inc. Cash Budget (April - Dec) 2020 Month Sales April $ 300,000.00 May $ June $ 290,000.00 July $ 425,000.00 Aug $ Sep $ Oct $ Nov $ Dec $ 300,000.00 500,000.00 600,000.00 625,000.00 650,000.00 700,000.00 Cash sales 5% $ 15,000.00 $ 15,000.00 $ 14,500.00 $ 21,250.00 $ 25,000.00 $ 30,000.00 $ 31,250.00 $ 32,500.00 $ 35,000.00 $ 45,000.00 Collections of A/R: 1 month 15% 2 month 50% 3 month 30% Total cash receipts $ $ 45,000.00 150,000.00 $ 43,500.00 $ 150,000.00 $ 90,000.00 $ 304,750.00 $ $ $ $ 63,750.00 145,000.00 90,000.00 323,750.00 $ $ $ $ 75,000.00 212,500.00 87,000.00 404,500.00 $ $ $ $ 90,000.00 250,000.00 127,500.00 498,750.00 $ $ $ $ 93,750.00 300,000.00 150,000.00 576,250.00 $ $ $ $ 97,500.00 312,500.00 180,000.00 625,000.00 $ 15,000.00 $ 60,000.00 $ 209,500.00 $ 30,000.00 $ 18,000.00 $ 24,000.00 $ $ $ $ 210,000.00 210,000.00 30,000.00 18,000.00 24,000.00 $ $ $ $ $ 203,000.00 210,000.00 29,000.00 17,400.00 23,200.00 $ 297,500.00 $ 203,000.00 $ 42,500.00 $ 25,500.00 $ 34,000.00 $ $ $ $ $ $ 297,500.00 50,000.00 30,000.00 40,000.00 60,000.00 $ $ $ $ $ Purchases (.70 x sales) Raw Material Purchase Wages and Salary Lease Adversting R&D Insurance miscellaneous expense Taxes Total Cash Dispursement 350,000.00 60,000.00 36,000.00 48,000.00 72,000.00 $ $ $ $ $ 437,500.00 420,000.00 62,500.00 37,500.00 50,000.00 75,000.00 $ $ $ $ $ 455,000.00 437,500.00 65,000.00 39,000.00 52,000.00 $ $ $ $ $ 490,000.00 455,000.00 70,000.00 42,000.00 56,000.00 $ 15,000.00 $ 20,000.00 $ 30,000.00 $ 35,000.00 $ $ $ 25,000.00 40,000.00 631,000.00 $ $ $ $ 24,000.00 40,000.00 45,000.00 732,000.00 $ 282,000.00 $ 279,600.00 $ 320,000.00 $ 497,500.00 $ 675,000.00 $ 628,500.00 $ (222,000.00) $ Net cash flow Beginning cash Ending cash Minimum cash Required total financing Excess cash (70,100.00) $ (15,250.00) $ $ 15,000.00 $ $ (250.00) $ $ 15,000.00 $ $ (15,250.00) $ (173,750.00) $ (226,500.00) $ (250.00) $ (174,000.00) $ (174,000.00) $ (400,500.00) $ 15,000.00 $ 15,000.00 $ (189,000.00) $ (415,500.00) $ (176,250.00) $ (52,250.00) $ (400,500.00) $ (576,750.00) $ (576,750.00) $ (629,000.00) $ 15,000.00 $ 15,000.00 $ (591,750.00) $_(644,000.00) $ (107,000.00) (629,000.00) (736,000.00) 15,000.00 (751,000.00), Cash Conversion Cycle Cash Conversion Cycle (AAI + ACP) - APP AAI ACP APP 60 45 CCC 39

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Take The Trade A Floor Trade

Authors: Tony Wilson

1st Edition

979-8218195458

More Books

Students also viewed these Finance questions

Question

What is expertise? Provide an example.

Answered: 1 week ago

Question

How many new employees were added to the Employee_Listing file?

Answered: 1 week ago

Question

What is the coefficient for 2014?

Answered: 1 week ago