Please show how to do the problem without using excel and show all work. Please explain how to go about solving the question

. when calcuna The Colorado Brewing Company is considering producing a new beverage. This beverage project requires an initial investment (i.e., at t=0) in equipment of $300,000. The company will borrow the money necessary to purchase the equipment; the annual rate of interest on the loan is 5%. At t=3, the company plans to sell the equipment for $5,000. The equipment can be depreciated according to the three year schedule, which allows depreciation of 33.33% at t-1, 44.45% at t=2, 14.81% at t-3, and 7.41% at t-4. Depreciation will be based solely on the initial cost of the equipment (i.e., when calculating depreciation, ignore any salvage value) This project is expected to produce sales revenue of $400,000 the first year (i.e., at t=1); this revenue will increase by 20% per year over the next two years (i.e., t=2 and t-3). Manufacturing costs are estimated to be 60% of sales. A key marketing study was completed last year; the cost of this study was $75,000. The project requires an investment in working capital. Specifically, at each point in time, working capital must be maintained at 10% of next year's forecasted sales revenue. for example, the working capital required at t-0 is 10% of t=1 revenue. Working capital will be fully recovered at t-3. The corporate tax rate is 25%. The company's tax situation is such that it can make use of all applicable tax shields and deductions. If the opportunity cost of capital is 16%, is this a good project or a bad project? So, The Colorado Brewing Company is considering producing a new beverage. This beverage project requires an initial investment (i.e., at t=0) in equipment of $300,000. The company will borrow the money necessary to purchase the equipment; the annual rate of interest on the loan is 5%. At t=3, the company plans to sell the equipment for $5,000. The equipment can be depreciated according to the three year schedule, which allows depreciation of 33.33% at t-l, 44.45% at t=2, 14.81% at t-3, and 7.41% at t=4. Depreciation will be based solely on the initial cost of the equipment (i.e., when calculating depreciation, ignore any salvage value). This project is expected to produce sales revenue of $400,000 the first year (1.e., at t=1); this revenue will increase by 20% per year over the next two years (i.e., t=2 and t-3). Manufacturing costs are estimated to be 60% of sales. A key marketing study was completed last year; the cost of this study was $75,000. The project requires an investment in working capital. Specifically, at each point in time, working capital must be maintained at 10% of next year's forecasted sales revenue. for example, the working capital required at t=0 is 10% of t=1 revenue. Working capital will be fully recovered at t-3. The corporate tax rate is 25%. The company's tax situation is such that it can make use of all applicable tax shields and deductions. If the opportunity cost of capital is 16%, is this a good project or a bad project? So