Estimate the operating cash flows

Assignment Help Financial Management

Reference no: EM132018227

Since East Coast Yachts is producing at full capacity, Larissa has decided to have Dan examine the feasibility of a new manufacturing plant. This expansion would represent a major capital outlay for the company. A preliminary analysis of the project has been conducted at a cost of $1.2 million. This analysis determined that the new plant will require an immediate outlay of $55 million and an additional outlay of $30 million in one year. The company has received a special tax dispensation that will allow the building and equipment to be depreciated on a 20-year MACRS schedule.

Because of the time necessary to build the new plant, no sales will be possible for the next year. Two years from now, the company will have partial-year sales of $18 million. Sales in the following four years will be $27 million, $35 million, $39 million, and $43 million. Because the new plant will be more efficient than East Coast Yachts’ current manufacturing facilities, variable costs are expected to be 60 percent of sales, and fixed costs will be $2.5 million per year. The new plant will also require net working capital amounting to 8 percent of following year’s.

Dan realizes that sales from the new plant will continue into the indefinite future. Because of this, he believes the cash flows after Year 5 will continue to grow at 3 percent indefinitely. The company’s tax rate is 40 percent and the required return is 11 percent.

Larissa would like Dan to analyze the financial viability of the new plant and calculate its profitability index, NPV, and IRR.

Task 1 Estimate the operating cash flows (OCF) of this project during the next five years (Year 1 – Year 5).

Guidelines:

1. Construct a table where you have revenue, variable costs, fixed costs, depreciation, earning before tax (EBT), tax, net income, and OCF in the first column.

2. Use the 20-year MACRS depreciation schedule that appears in a separate Excel file named “MACRS and Stock Prices.”

Reference no: EM132018227

Questions Cloud

Should corporate income be double-taxed : Should corporate income be double-taxed? Why or why not?

Develop an organizational profile : Visit the Web site of your organization. Develop an organizational profile that would prepare you for an interview with this organization.

Compute this project npv-pi and irr : Compute this project’s NPV, PI, and IRR. What should be Dan’s recommendation?

Estimate the cash flows of this project investments : Estimate the cash flows of this project’s investments (capital spending and changes in net working capital) during Year 0 – Year 5.

Estimate the operating cash flows : Estimate the operating cash flows (OCF) of this project during the next five years (Year 1 – Year 5).

Provide a clear description of what work or life balance is : Case Study Assignment - Provide a clear description of what Work/Life Balance is, its brief history and current issues for implementing it

What is the profit from transaction from finance perspective : What is the profit from the transaction from a finance perspective (adjusting for the TVM)?

Create a summary for your proposal : You will create a summary for your proposal that will be submitted this week as well as a part of the final project in Week 8. Attached is my week 1 proposal.

Insurer buy now to fully fund expected cash outflow : How much strips (in dollar amount) must the insurer buy now to fully fund the expected cash outflow (to the nearest dollar) in 8 years?

User Account

All Pages