Question: I need some help with this excel sheet problem. The red numbers at are what the values are suppose to match. Here are the assumptions

I need some help with this excel sheet problem. The red numbers at are what the values are suppose to match. Here are the assumptions to use: WACC (nominal)=8%
Tax Rate =30%
A firm is considering a capital budgeting project with a projected fixed asset cost of $1,500,000.
The projected cost will be depreciated via the straight line method over 6 years.
The company has existing land they could use to develop this project, the land could be sold today for $50,000.
The project will last for a total of 8 years, and the equipment involved will be salvagable for $75,000 at the end of the 8 years.
In the first year, the firm projects sales of 6,000 units of the new product at a cost of $110 per unit. However, there will be a negative impact on the firm's existing products of 3,000 units and these units sell for $80 per unit.
Inflation on the sales price of both the existing and new product is expected to be 3%(starting in year 2).
Growth in quantity sold for the new product will be 10% for the first two years and 7% for the remainder of the project.
Quantity sold for the existing product was expected to grow at 3% each year.
The project will require an initial investment (year 0) in working capital equivalent to 9% of year 1 revenues (net of cannibalized sales).The ongoing working capital/revenue ratio will also be 9%.
All working capital will be recovered at the end of the project's life.
Variable expenses for both the new product and the existing product are 30% of revenue.
Fixed expenses in year 1 are anticipated to be $45,000 and zero afterwards.
I need some help with this excel sheet problem.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!