Question: I need help solving this excel problem. These are the assumptions: WACC ( nominal ) = 8 % Tax Rate = 3 0 % A

I need help solving this excel problem. These are the assumptions:
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. \begin{tabular}{|r|}
\hline 4\\
\hline 44\\
\hline 45\\
\hline 46\\
\hline 47\\
\hline 48\\
\hline 49\\
\hline 50\\
\hline 51\\
\hline 52\\
\hline 53\\
\hline 54\\
\hline 55\\
\hline 56\\
\hline 57\\
\hline 58\\
\hline 59\\
\hline 60\\
\hline 61\\
\hline 62\\
\hline 63\\
\hline 64\\
\hline 65\\
\hline 66\\
\hline 67\\
\hline 68\\
\hline 69\\
\hline 70\\
\hline 71\\
\hline 72\\
\hline 73\\
\hline 74\\
\hline 75\\
\hline 76\\
\hline 77\\
\hline 78\\
\hline 79\\
\hline 80\\
\hline 81\\
\hline 82\\
\hline 83\\
\hline 84\\
\hline 85\\
\hline 86\\
\hline 87\\
\hline 88\\
\hline 89\\
\hline 90\\
\hline 91\\
\hline 92\\
\hline 93\\
\hline 94\\
\hline 95\\
\hline 96\\
\hline 97\\
\hline 98\\
\hline 99\\
\hline 100\\
\hline 101\\
\hline 102\\
\hline
\end{tabular}
I need help solving this excel problem. These are

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!