[financeFreek]

So you are analyzing a project and here is what you know:
Operating Cash Flows After Tax: T=0 -26,355,875; T=1 +12,189,592; T=2 +9,883,453; T=3 +9,224,556; T=4 8,565,659
Unlevered Beta = 1.08; Risk free rate = 4.1%; Market Return= 9.1%; Straight Line Depreciation; Zero Salvage Value; Tax Rate=30%; Project Life =4 years; Capital Budget=$50 million; The Capital Structure uses 20% debt, and before tax cost of debt= 7%; WACC is to be used as discount & reinvestment rates... The question is to find Levered Beta, Cost of Equity, WACC, NPV, IRR, MIRR, and Net Income. I don't really understand how the 20% debt and 7% before tax cost of debt come into the problem especially with net income. Here is what I guessed, but please check my work!:
Levered Beta=1.269 1.08*(1+(1-30%)*(20%/80%)) Hamada Equation
Cost of Equity=10.45% 4.1%+(9.1%-4.1%)*1.269 CAPM
WACC=9.34% [20%*(7%*(1-30%))] + [80%*10.45%] WACC
NPV=$6,111,987.82 NPV(9.34%, -26355875,{12189592,9883453,9224556,8565659}) Ti-83 npv function(I, CF0,{CF1.. })
IRR=20.29% IRR(-26355875,{12189592,9883453,9224556,8565659}) Ti-83 irr function
MIRR=15.19% MIRR(-26355875,12189592,9883453,9224556,8565659) with 9.34% on Excel
Net Income=$5,600,623 12189592 + (-26355875/4)

Please Help!

[Just Looking]

I was hoping someone else might check this for you. It's been a while since my last finance class. :)

Thanks for showing your work!

I agree with the levered beta, cost of equity, WACC.

I have a slight difference on the NPV. I came up with the following NPV's:

t=0 -26,355,875
t=1 11,148,337
t=2 8,267,050
t=3 7,056,807
t=4 5,993,003

Total 6,109,323

If you agree with my numbers above, it will slightly change your IRR and MIRR, but they look like they are on the right track. The net income also has to take depreciation into account.

[financeFreek]

I don't know why but Excel and my TI-83 are giving me different answers than what you got and the financial calculators that are online. Any idea why? Also, you said the net income has to take depreciation into account, but isn't that what I did?

[Just Looking]

I did the NPV by hand. I'd double check your entry first. It's easy to mix up the numbers when inputting. If that isn't the difference, I'd go with your numbers. I can't think of a reason why they'd be different. I did check mine to be sure I didn't have any errors in my calcs, and they seemed okay.

You are only looking at the cash flow. Depreciation doesn't affect cash flow, but it will decrease net income.

[financeFreek]

Thanks for all your help! Really appreciated. One last little bit of confusion is still on the net income though. My calculation was $5,600,623=12189592 + (-26355875/4). Isn't the (-26355875/4) representing the depreciation? Thanks!

[Just Looking]

Oh, I see what you are saying. Sorry. That does seem right for the first year.

[financehelp]

What about at 0% leverage? Do you know? If WACC same as equity since percent leverage is 0?

[financehelp]

Also are MIRR and IRR all the same? :)