Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer. Describe the cash inflows and outflows expected in the operating stage of this project's life. Remember revenues, possible lost revenues, and all the

Please answer.

Describe the cash inflows and outflows expected in the operating stage of this project's life. Remember revenues, possible lost revenues, and all the cost, whether these costs are fixed or variable and what relationships they have with the driver, assumed income tax rate, depreciation, and any other relevant inputs.

Describe equipment type projects the equipment will wear out and there will be no deposition value, for building type projects (like drive-throughs and menu enhancements) there not be a disposition value but a continuing value.

image text in transcribedimage text in transcribed
Cash Flows for Chipotle 2. Share File Edit View Insert Format Data Tools Extensions Help @ 5 100% - $ .00 123 Defaul - 10 + B SA A1 fx Acquisition Stage and Working Capital Cash Flows B C D E F G H J K L M N 1 Acquisition Stage and Working Capital Cash Flows N w Assumptions or Cost Relationships 4 YEAR 0 1 2 3 4 5 6 7 8 Building Cost 350,000.00 O Construction Cost 330,000.00 Equipment Cos 300,000.00 Delivery & Testing 20,000.00 9 POS and Music System 40,000.00 + 10 Research & Development Costs 50,000.00 11 Initial Promotion 60,000.00 12 Employee Training 20,000.00 13 Additional Investment in Working Capital as Investment 7% 14 Working Capital Balance 40,000.00 15 16 Sales 2,500,000.00 3,400,393.97 3,631, 199.61 3,700,000.00 2,724, 121.11 2,767,764.93 3,079,953.75 3,794,680.41 17 COGS 2,075,000.00 2,822,327.00 3,013,895.68 3,071,000.00 2,261,020.52 2,297,244.89 2,556,361.61 3,149,584.74 18 19 Cash balance is 9% of revenue 9% 9% 9% 9% 9% 9% 9% 9% 9% 20 Inventory balance is 15% of COGS 15% 15% 15% 15% 15% 15% 15% 15% 15% 21 Accounts payable are 8% of COGS 8% 8% 8% 8% 3% 8% 8% 8% 22 Accrued expenses are 7% of revenues 7% 7% 7% 7% 7% 7% 7% 7% 7% 23 24 Acquisition Stage Cash Flows 25 YEAR 2 3 5 6 7 8 26 Cost of Building -350,000.00 27 Cost of Construction 330,000.00 28 Cost of Equipment -300,000.00 Working Capital: Cash Balance 225,000.00 306,035.46 326,807.96 333000.00 245170.90 249098.84 277195.84 341521.24 31 Inventory Balance 311,250.00 423,349.05 452,084.35 460650.00 339153.08 344586.73 383454.24 472437.71 32 Accounts Payable Balance 166,000.00 225,786.16 241, 111.65 245680.00 180881.64 183779.59 204508.93 251966.779 boooo 33 Accrued Expenses Balance 145,250.00 197,562.89 210,972.70 214970.00 158271.44 60807.14 178945.31 220470.932 34 Total Not Working Canital Balance 206 036 AG 206 807 06 232000 nn 246170 on 277106 84 241671 24 D + Acquisitos +

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

Step: 3

blur-text-image

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

Managerial Accounting The Cornerstone Of Business Decision Making

Authors: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

8th Edition

0357715349, 978-0357715345

More Books

Students also viewed these Accounting questions