Financial Forecasting in Microsoft Excel
eBook - ePub

Financial Forecasting in Microsoft Excel

  1. English
  2. ePUB (mobile friendly)
  3. Available on iOS & Android
eBook - ePub

Financial Forecasting in Microsoft Excel

About this book

4 out of 5 businesses fail due to cash problems – needlessly. Every business owner has the tools to accurately forecast cash flow, they just don't know it. Financial Forecasting in Microsoft® Excel shows small- to medium-sized businesses how to achieve the same forecasting power as larger companies. Filled with a wealth of illustrations and how-to templates, the book is written to help you make better, more educated decisions that result in more stable, enduring companies. Author Jeff Prager shows you how to use Excel to run "if/then" scenarios, calculate cash flow projections, structure partnerships and financing, and test how changes in the market or pricing will affect the bottom line. Financial Forecasting in Microsoft Excel provides step-by-step instructions for creating financial forecasts with Microsoft Excel 2010 so you can: Assess project feasibility Fund company cash needs Determine financial feasibility of a project before committing Identify problems before they become major By following the guidelines presented in this book, you will give a potential funding source the necessary information to make an investment decision. And when they see the information they want to see, you'll hear the words you want to hear: "Here's your check." "Forecasts must be meaningful and explainable. Jeff Prager's financial mastery has allowed my companies to make profitable decisions, change course when necessary and maintain relevance in our industry for more than 20 years." —Joel Farkas, Principal Gateway American Resources Denver, CO

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Yes, you can access Financial Forecasting in Microsoft Excel by Jeffrey Kenneth Prager in PDF and/or ePUB format, as well as other popular books in Technology & Engineering & Accounting. We have over one million books available in our catalogue for you to explore.

Information

Table of contents

  1. Cover
  2. Title Page
  3. Copyright
  4. Contents
  5. List of Figures and Tables
  6. About the Author
  7. Preface
  8. Acknowledgments
  9. Introduction
  10. 1 Creating a Simple Spreadsheet
  11. 2 More Power with Functions and Formulas
  12. 3 Format of a Cash Flow Forecast
  13. 4 Your Sales Forecast
  14. 5 Scheduling Your Production Costs
  15. 6 Budgeting Overhead Costs
  16. 7 Deposits, Loans, Accounts Receivable
  17. 8 Expenditures Not on Your Income Statement
  18. 9 Equity Needs
  19. 10 Creating Financial Statements
  20. 11 Structuring a Deal
  21. 12 Sensitivity Analysis
  22. 13 The Complete Construction Projection
  23. 14 Working with Debt
  24. 15 Advanced Concepts
  25. 16 Final Thoughts Related to Forecasts
  26. Glossary