Capital Budget Cash Flow Model in Excel

Описание: Capital Budgeting with a Cash Flow Model in Excel

Here are the topics of this video:
1 estimated sales, operating costs, depreciation and net income
2 estimated operating cash flows per year
3 investment in equipment and net working capital
4 net present value NPV
5 internal rate of return IRR
6 profitability index
7 payback period

__________

SEE ALSO

Capital Budgeting Playlist    • Chapter 24 Capital Budgeting  

The Ultimate Guide to Learn Financial Accounting https://finallylearn.com/ultimate-gui...

Accounting Basics playlist    • Financial Accounting Basics for Beginners  

__________

LEARN MORE

Please Like, Comment, and Subscribe to support our channel.

✅ Please Subscribe to Finally Learn https://www.youtube.com/finallylearn?...

Visit Finally Learn: https://finallylearn.com/

ACCOUNTING BASICS

The Ultimate Guide to Learn Financial Accounting https://finallylearn.com/ultimate-gui...

Accounting Basics Course for Beginners playlist    • Financial Accounting Basics for Beginners  

EXCEL BASICS

The Ultimate Guide to Learn Excel Basics https://finallylearn.com/ultimate-gui...

Excel Basics playlist:    • Excel Basics Playlist  

Time Value of Money Playlist:    • Time Value of Money  

Data Analysis With Excel Playlist:    • Data Analysis with Excel  

FINANCE BASICS

Time Value of Money Playlist:    • Time Value of Money  

INTERMEDIATE ACCOUNTING

Intermediate Accounting Study Guide https://finallylearn.com/intermediate...

Intermediate Accounting 1 Playlist:    • Intermediate Accounting 1  

Intermediate Accounting 2 Playlist:    • Intermediate Accounting 2  

__________

BOOKS I RECOMMEND

📕 The Little Book of Common Sense Investing (Jack Bogle is the father of index fund investing) https://amzn.to/3cOIHi2

📗 A Random Walk Down Wall Street (Burton Malkiel's book on why index funds beat the investing pros) https://amzn.to/3mt6OpX

📘 The Boglehead's Guide to the Three-Fund Portfolio (Simplifying your portfolio with just three funds) https://amzn.to/3cOeEas

__________

SAY HI ON SOCIAL

🖥 Website: https://www.finallylearn.com

📸 Instagram:   / finallylearn  

📰 Twitter:   / finallylearn  

🖥 YouTube:    / finallylearn  

__________

MY GEAR

🎙 My Favorite USB Microphone https://amzn.to/39Dd7Sm

💻 Laptop https://amzn.to/45WjGdT

💼 Laptop Backpack https://amzn.to/2OnqkHI

💵 The best Financial Calculator https://amzn.to/3duFvY0

🎧 My Earbuds https://amzn.to/2PzHNx9

📓 Favorite Journal https://amzn.to/3f4jrUX

🖊 Best Pens https://amzn.to/3tBHCiY


__________

CHAPTERS

00:00 Introduction to cash flow model
02:28 Income statement model
06:00 Operating cash flow
06:33 Initial cash outflows
08:00 Final cash inflows
09:10 Cost of capital NPV IRR
10:55 Profitability index and payback
13:24 NPV schedule

__________

ABOUT ME
My name is Jeff Mankin. I teach accounting, finance, and Excel. I started my website FinallyLearn.com and my channel to teach more people financial topics. I have a passion for teaching financial topics using Excel. I have articles and videos on many financial topics. My goal is to help you finally learn financial skills! Check out the playlists on accounting basics, time value of money, and Intermediate Accounting. I hope you join me on the Finally Learn channel!
__________

DISCLAIMERS & DISCLOSURES

This content is for education and entertainment purposes only. Finally Learn LLC does not provide accounting, tax, financial planning, or investment advice. The information is being presented without consideration of the investment objectives, risk tolerance, or financial circumstances of any specific investor and might not be suitable for all investors. Past performance is not indicative of future results. All investing involves risk, including the possible loss of principal.

This description contains affiliate links that allow you to find the items mentioned in this video and support the channel at no cost to you. Finally Learn is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. Thank you for your support!


#finallylearn #jeffmankin


3,792 Subscribers
11/26/2023

   • Capital Budget Cash Flow Model in Excel