can you please show me how to do this in excel by reference how each cell was completed thank you

B EF G H 1 P13-8 Modified (changes from the text are in bold) 2 3 4 5 6 7 8 9 The Marvel Mfg. Company is considering whether to construct a new robotic production facility. The cost of this new facility is $900,000 and it is expected to have a six-year life with annual depreciation expense of $150,000 and no salvage value. Annual sales from the new facility are expected to be 2,500 units with a price of $800 per unit. Variable production costs are $600 per unit, while fixed cash expenses are $200,000 per year. a. Find the accounting and the cash break-even units of production. b. Will the plant make a profit based on its current expected level of operations? c. Will the plant contribute cash flow to the firm at the expected level of operations? 10 11 12 C D E F G H Given Current Level of Operations units P (per unit) * VC (per unit) 1 2 FC Depreciation 4 Fixed Cash Expenses 5 Total FC 6 7 a. Accounting Breakeven units 9 0 Cash Breakeven units 1 32 b. EBIT at Current level of operations (Partial Analytical Income Statement): 33 14 Sales 35 Less: Variable Costs 36 Revenue Before Fixed Costs (CM) 37 Less: Fixed Costs 38 EBIT (NOI) 40 C. Cash Flow at Current level of Operations 41 42 EBIT (NOI) 43 Plus: Depreciation 44 Cash Flow (ignoring taxes) 45 46