Final Case

here is an Excel spreedsheet that I hope is correct. Basically we have our outlay of the project of both the 7.9M cost plus shipping, which is depreciated over 5 years. We are also given our Sales and Costs which are based on a variable and fixed basis. We use this plus our tax Rate to solve for Net Income. We get Sales =(Price x Units) then subtract our variable cost and fixed cost and less depreciation. We need remove taxes. To find Cash Flow we mush ADD back depcreciation since it is a NONCASH expense and reduce by working capital. Working capital is returned at the end of the project.

We then use our Excel function to solve for NPV and IRR.

a. Capital budgeting equations should always be looked at via Cash flows not accounting profits. Total cash Flow is what matters.

b. Depreciation is a NONCASH expense. It reduces taxable income, which reduces taxes and is added back to Cash Flow.

c. sunk cost are NOT looked at when examining a capital budeting project.

d. initial outlay is the cost of the plant, shipping costs and working capital outlay. This is equal to $8,100,000.

e. Cash flows are provided in the diagram.

f. Terminal Cash flow is just the last one, or 15,980,000

g. Not sure what this should look like, refer to your book i guess??

h. NPV is 13,269,202

i. IRR is 65.6%

j. You should accept this because NPV is positive.

k. refer to your book.

l. CAPM is only concerned with market risk, since project specific risk (in this case whether the CFs we forecast will come true) is something that a manager can diversify away by investing in multiple projects.

m. Simulation basically makes numerous assumptions on things like Sales growth, profit margins, tax rate, and various other inputs to estimate a large amount of potential outcomes. By doing this, the manager can simulate multiple scenarios and see how their investment might pan out.

n. Sensitivity analysis is when you hold ALL variables constant (say like sales growth, profits, etc.) and just change ONE variable a little at a time, and see how that affects the projects outcome. You see how sensitivity the project's outcome might be by changing one variable.

I know its not complete but hopefully its a start!