Question

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.18 million. The fixed asset will be depreciated straight- line to zero over its three-year tax life. The project is estimated to generate $1,730,000 in annual sales, with costs of $640,000. The project requires an initial investment in net working capital of $290,000, and the fixed asset will have a market value of $240,000 at the end of the project. a. If the tax rate is 24 percen, what is the project's Year O net cash flow? Year 1? Year 2? Year 3? (Do not round intermediate calculations and enter your answers in dollars, not millions of dollars, e.g., 1,234,567, A negative answer should be indicated by a minus sign.) b. If the required return is 12 percent, what is the project's NPV? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Year O cash flow Year 1 cash flow Year 2 cash flow Year 3 cash flow b. NPV

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

projects (Autosaved) (Autosaved) (Autosaved) Microsoft Excel Home nert Page Layout Formulas Data Review View dd-Ins Cut copy ▼ Format Painter E AutoSum ー E " ゴWrap Text B า 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 conditional Format . Cell Insert Delete Format Sort &Find & 2 ClearFe Select Edting Formatting, as Table w styles. ▼ ㆆ ▼ Clipboard Alignment Number RX290 RS RT RU RW RX RY RZ 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 YEAR 0 -2180000 290000 COST OF ASSET WORKING CAPITAL SALES COSTS DEPRECIATION INCOME BEFORE TAX TAX NET INCOME DEPRECIATION OPERATING CASH FLOW RECOVERY OF WORKING CAPITAL AFTER TAX SALVAGE VALUE OF ASSET NET CASH FLOW PV FACTOR AT 12% PV OF CFAT 1730000.00 1730000.00 1730000.00 640000.00640000.00 640000.00 726666.67 726666.67 726666.67 363333.33 363333.33 363333.33 87200.0O 276133.33 276133.33 276133.33 726666.67 726666.67 726666.67 2470000 1002800.00 1002800.00 1002800.00 90000.00 87200.00 87200.00 182400 240000 (1-0.24)) 2470000 1002800 1002800 0.7972 1475200 0.8929 0.7118 2470000 895357.143 799426.0204 1050018.22 274801.38 NPV NPV 274801.38 i RATIOS CASH BUDGET i wacc ' BOND EPS EBİT REPLACEMENT bond Sheet, Sheet1 STats | NPV! BETA LEVERED rences: DX15 0:12 01-11-2018