Question
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started