ACCTG 455: Excel Finance Class 79: Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index

Download Excel File: people.highlin...
Download PowerPoints: people.highlin...
Highline College ACCTG 455 chapter 8: Net Present Value & Other Investment Criteria, and other calculations taught by Mike Girvin.
Investment Criteria: NPV, IRR, Payback, AAR, Profitability Index Comprehensive Example. See the Calculations for all, including NPV and IRR functions.

[@alexxgalindo8557]

I've been learning a lot thanks to you sir. You're awesome

[@excelisfun]

Glad you are learning a lot : ) : ) : )

[@stgard5295]

I have learned so much from watching your videos....They are great and you are appreciated!

[@freakstate]

You've just helped me loads with my CIM Marketing Diploma for Project Management. Wonderfully explained thank you!

[@jenniferskvorak702]

Thank you sooo much, I am an RN working on my MBA, I am reallly struggling!!! This is a GOD SEND!!!!

[@excelisfun]

Cash flows must show sign, and for the period must be net of cash in cash out and net of any tax implications. If you watch the series beginning to end I cover all this is great detail.

[@excelisfun]

You are welcome!

[@excelisfun]

I am glad that the videos help!

[@privat986]

I can't find the xls file on the website! Please write out the specific url! I could not find busn233ch08.xls that you are using in this video! Please write out the specific url link for the xls file. Please. Great video.

[@JW43758]

THANK YOU SO MUCH!!!! YOU JUST SAVED MY LIFE!!!!!!!!!! (COLLEGE STUDENT)

[@williamrivera162]

Congrats, very instructive and informatives videos with well explained lessons and spreadsheets. Thank you so much for share your knowlegdes.

[@Synthminator]

Awesome video, very clear. Saved me a lot of trouble!

[@tinominotoons]

Its great! its very clear and easy to understand. Thank you,

[@FaterThanAkIss180]

Thank you it was really easy to understand!!!

[@ahadalavi4973]

Thank you for the great videos

[@excelisfun]

Glad you like them!

[@TheChanmabelle]

this helps a lot! great tutorial

[@melipretzel4639]

excellent explanation, thank you!

[@raymondgdlima]

Great video! Thanks a lot.

[@shubhampawar8506]

❤️👌

[@excelisfun]

11 years old and still as good as ever. I love finance!!!

[@Yuki_Senpai.]

very clear! Thank you.

[@jjsf9378]

This is super helpful! If you're running projections over several years, would you have to discount the future cash flows before calculating payback, etc?

[@janetgethin7073]

Thank You

[@4evastudent]

Hey, love the videos. Great tools to brush up on the corp finance. When you refer to cash flows in these chapter 8 examples are you talking about the NET cash flow (ie cash in - cash out) for the paticular time period?

[@natifrance25]

great!!!

[@PerleenK]

Thank you, but i would like to know is for mutually exclusive perpetuity project or investment, what do we put in the period? How do we the Cross over rate since the IRR and NPV go in different directions?

[@awalgsm]

great

[@freakstate]

Actually I have a question, I'm working in months for Time. Do I need to make any necessary adjustments to the RRR or IRR at all? Is this an annual rate?

[@bariqallemyar7579]

Thank you. but how to calculate the irr for this problem. discount rate is 10% ( you have an investment of 100000$ (year 0 or base) and for 1st year cost 10000 , benefit 25000 . 2nd year cost 10000, benefit 50000. 3rd year cost 10000, benefit 50000.4th year cost 10000, benefit 50000. 5th year cost 10000, benefit 50000. thank you

[@gazzatan]

Payback period should be 3.1 years.

[@privat986]

I can't find the xls file on the website! Please write out the specific url! I could not find busn233ch08.xls

[@bsap8828]

Scroll to excel finance class series, Chapter 8 video

[@80AD]

Ctrl+F then: Finance&ExcelCh08