Solomons Electronics Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by a recently graduated BBA. The production line would be set up in unused space in Solomons' main plant. The machinerys invoice price would be approximately $190,000, another $12,000 in shipping charges would be required, and it would cost an additional $25,000 to install the equipment. The machinery has an economic life of 4 years, and Solomons has obtained a special tax ruling that places the equipment in the MACRS 3-year class. The machinery is expected to have a salvage value of $30,000 after 4 years of use. The new line would generate incremental sales of 1,350 units per year for 4 years at an incremental cost of $120 per unit in the first year, excluding depreciation. Each unit can be sold for $205 in the first year. The sales price and cost are both expected to increase by 4% per year due to inflation. Further, to handle the new line, the firms net working capital would have to increase by an amount equal to 13% of sales revenues. The firms tax rate is 35%, and its overall weighted average cost of capital, which is the risk-adjusted cost of capital for an average project (r), is 12%.

Clipboard 0 curation Format as Neutral Table Formatting Calculation Check Cell Font Insert Delete Form Alignment 2 Number fx Styles Cells A B D 8 E F G H 1 9 Og. Calculate the net cash flows for each year. Based on these cash flows and the average project cost of capital, what are the project's NPV, IRR, 1 MIRR, PI, and payback? Do these indicators suggest that the project should be undertaken? 2 3 Projected Net Cash Flows 24 Year 0 Year 1 Year 2 25 Year 3 Year 4 26 Investment Outlay: Long Term Assets (Depreciable Basis) 27 Net Operating Cash Flows 28 CF due to investment in NWC 29 Salvage Value Cash Flows 30 Net Cash Flows 31 32 NPV 33 IRR Answer: 34 PI 35 MIRR 36 137 38 Find Payback Years 139 0 2 3 4 140 Cash Flow 141 Cumulative Cash Flow for Payback 142 143 Payback = 144 145 1