Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

United Pigpen is considering a proposal to manufacture high-protein hog feed. The project would make use of an existing warehouse, which is currently rented out

United Pigpen is considering a proposal to manufacture high-protein hog feed. The project would make use of an existing warehouse, which is currently rented out to a neighboring firm. The next year's rental charge on the warehouse is $110,000, and thereafter, the rent is expected to grow in line with inflation at 4% a year. In addition to using the warehouse, the proposal envisages an investment in plant and equipment of $1.26 million. This could be depreciated for tax purposes straight-line over 10 years. However, Pigpen expects to terminate the project at the end of 8 years and to resell the plant and equipment in year 8 for $420,000. Finally, the project requires an immediate investment in working capital of $360,000. Thereafter, working capital is forecasted to be 10% of sales in each of years 1 through 7. Year 1 sales of hog feed are expected to be $4.40 million, and thereafter, sales are forecasted to grow by 5% a year, slightly faster than the inflation rate. Manufacturing costs are expected to be 90% of sales, and profits are subject to tax at 21%. The cost of capital is 12%. What is the NPV of pigeons project? Please answer in excel

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Finance

Authors: Jeff Madura, Hardeep Singh Gill

3rd Canadian Edition

978-0133035575, 133035573, 978-0133970524, 133970523, 978-0134040042

More Books

Students also viewed these Finance questions

Question

1. Encourage students to set a small-step goal for one subject.

Answered: 1 week ago