FinCal Inc. proposes to invest $18 million in a new calculator production plant. Fixed costs are estimated at $3.5 million a year, and the contribution margin per unit of each financial calculator will be approximately $ 15.00. If the plant lasts for 4 years and the cost of capital is 12%, what is the cash and financial break-even level? (Tax Rate=30%)

PLEASE USE THE EXCEL SHEET FORMAT TO ANSWER THE QUESTION

AutoSave On Fe 2 CABPBUD-STUD-I - Saved - Search Nay't Christie NC Ga File Data Review View Help Share Comments v Home Insert Draw Page Layout Formulas X Calibri 12 - A === BIU.BA a Wrap Text TI General 28 O 4 Insert * Delete Format Paste Merge & Center $ -% 8-98 Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Clipboard Font Alignment Number Cells Editing Analysis K12 f B F 6 H 1 J LMNO 4A 1 2 2 0 0 1 2 3 4 ICO 3 4 5 8 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 SALES PRICE UNITS SALES $ VAR COST GROSS PROFIT DEP FIXED COSTS EBT TAXES NI OCF K 12% TAX RATE 30% NPV IRR Use Goal Seek Function! XYZ REPLACE B&N B APPLE BEP Circular References: B1 + Type here to search H c 10 0 * ENG 23:41 27/1/2021