Final answer:
To calculate the net cash flows for each year of the project, we need to consider the annual sales, costs, and tax rate. The project's NPV can be calculated using the required return rate to discount the net cash flows from each year.
Step-by-step explanation:
To calculate the net cash flows for each year of the project, we need to consider the annual sales, costs, and tax rate. We also need to account for the initial investment in fixed assets and net working capital, as well as the market value of the fixed asset at the end of the project.
a. Year 0 net cash flow:
Initial fixed asset investment: -2,180,000
Initial net working capital investment: -290,000
Year 0 net cash flow = -2,180,000 + (-290,000) = -2,470,000
Year 1 net cash flow:
Annual sales: 1,730,000
Costs: -636,000
Taxable income = Annual sales - Costs = 1,730,000 - 636,000 = 1,094,000
Taxes = Taxable income * Tax rate = 1,094,000 * 0.24 = 262,560
Depreciation expense = Initial fixed asset investment * MACRS rate for Year 1 = 2,180,000 * 0.3333 = 726,206.40
Year 1 net cash flow = Annual sales - Costs - Taxes + Depreciation expense = 1,730,000 - 636,000 - 262,560 + 726,206.40 = 1,557,646.40
Year 2 net cash flow:
Annual sales: 1,730,000
Costs: -636,000
Taxable income = Annual sales - Costs = 1,730,000 - 636,000 = 1,094,000
Taxes = Taxable income * Tax rate = 1,094,000 * 0.24 = 262,560
Depreciation expense = Initial fixed asset investment * MACRS rate for Year 2 = 2,180,000 * 0.4445 = 968,690.00
Year 2 net cash flow = Annual sales - Costs - Taxes + Depreciation expense = 1,730,000 - 636,000 - 262,560 + 968,690.00 = 1,800,130.00
Year 3 net cash flow:
Annual sales: 1,730,000
Costs: -636,000
Taxable income = Annual sales - Costs = 1,730,000 - 636,000 = 1,094,000
Taxes = Taxable income * Tax rate = 1,094,000 * 0.24 = 262,560
Depreciation expense = Initial fixed asset investment * MACRS rate for Year 3 = 2,180,000 * 0.1481 = 322,548.00
Year 3 net cash flow = Annual sales - Costs - Taxes + Depreciation expense + Market value of fixed asset at the end of the project = 1,730,000 - 636,000 - 262,560 + 322,548.00 + 240,000 = 1,393,988.00
b. To calculate the project's NPV, we need to use the required return rate and discount the net cash flows from each year. The formula for NPV is:
NPV = C0 + (C1 / (1 + r1)) + (C2 / (1 + r2)^2) + (C3 / (1 + r3)^3)
Where C0, C1, C2, and C3 are the net cash flows for Year 0, Year 1, Year 2, and Year 3, respectively, and r1, r2, and r3 are the required return rates for Year 1, Year 2, and Year 3, respectively.
NPV = -2,470,000 + (1,557,646.40 / (1 + 0.12)) + (1,800,130.00 / (1 + 0.12)^2) + (1,393,988.00 / (1 + 0.12)^3) = 2,204,412.03